in XMLoutput stage more than one repeat element

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Me happy most of all, as I was the "keeper" of this particular copy and finally ask Kim if he could host it so I didn't end up emailing it around for eternity. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

I got xml best parcties last year from KIMS site.It is very worth.

Any way I found the way to resolve it.But in that some what difficult is their I am generating all segments individualy and funneling all segments into one sequential file from this I am generating the required xml.

The only problem is while I am appending all segments into sequential file it is appending row by row while reading also it is doing like that when I delete the spaces in the sequential file it is reading as a single row and generating into sigle IDOC.

Pelase provide me if any one having the ideas to remove the spacess in the sequential file between the rows.

Thanks,
Praveen.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Please define what you mean by spaces....are they just "spaces" in the final document that you construct?

(such as....)

<element1>value</element1>

[some number of blank lines]

<element2>value</element2>

?

If so, it will be fine (provided that the receiver is an application that truly respects and understands xml). Spaces and blanks in XML are "noise". A few extra will add to the size of your messages or whatever the shipment protocol is, but shouldn't cause a problem.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

eostic wrote:Please define what you mean by spaces....are they just "spaces" in the final document that you construct?

(such as....)

<element1>value</element1>

[some number of blank lines]

<element2>value</element2>

?

If so, it will be fine (provided that the receiver is an application that truly respects and understands xml). Spaces and blanks in XML are "noise". A few extra will add to the size of your messages or whatever the shipment protocol is, but shouldn't cause a problem.

Ernie
Hi Ernie,

Exactly how you defined in the example same I am getting in sequential file.But my problem is when I am generating 12 segments individualy and finally I am funneling these segments and loading into sequential file as a single column like
<segment1><tag1/><tag2/></segment1><segment1><tag1/><tag2/></segment1><segment1><tag1/><tag2/></segment1>
<segment2><tag1/><tag2/></segment2>
<segment3><tag1/><tag2/></segment3><segment3><tag1/><tag2/></segment3><segment3><tag1/><tag2/></segment3>


above defined sequential file I am sending to xml output stage it is reading as a three rows but I want to read entire sequential file as a one row then only I can achive the solution to get all segments in single IDOC xml document.Is it possible to read as a single row?Could you please clarify me?

Thanks,
Praveen.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Any reason you are placing the info (the xml chunk) into an intermediate sequential file? Just pass it along downstream in the job. If you persist it to disk, then yes, you will have a variety of issues trying to read it, unless you use a Server Job and read it with the Folder Stage. I find that EE has difficulty reading variable length flat files where the ends of rows are 100% unpredictable.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

eostic wrote:Any reason you are placing the info (the xml chunk) into an intermediate sequential file? Just pass it along downstream in the job. If you persist it to disk, then yes, you will have a variety of issues trying to read it, unless you use a Server Job and read it with the Folder Stage. I find that EE has difficulty reading variable length flat files where the ends of rows are 100% unpredictable.

Ernie
If I send the data directly into xml output stage it will not generate the single IDOC document, it will repeat more number of times.That is the reason I am landing the data on disk then sending as a single row into xml outputstage.

Thanks,
Praveen.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Let's put our attention over there, then, at your XMLOutput. With aggregation, most scenarios should allow XMLOutput to produce one single output string. Are you using XMLOutput to do your i/o? This thread is getting long --- not sure if we've discussed it already, but just put a single column on an output link. Give it a single "/" in the Description property...... your whole XML document will go into that column and then you can write it anywhere you want.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

eostic wrote:Let's put our attention over there, then, at your XMLOutput. With aggregation, most scenarios should allow XMLOutput to produce one single output string. Are you using XMLOutput to do your i/o? This thread is getting long --- not sure if we've discussed it already, but just put a single column on an output link. Give it a single "/" in the Description property...... your whole XML document will go into that column and then you can write it anywhere you want.

Ernie
Hi Ernie,

I am generating xml as you specified.But the problem is output xml is not comming as required.It is generating multiple IDOCs insted of single IDOC.

Thanks for your support.

Cheers,
Praveen.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

what does "multiple idocs" mean? Forget IDOCS for a moment...

For your testing, have one output link from xmlOutput. On it, put one column. Name it xmlStuff. LongVarchar and say, 99999 as the length. Put a single slash in the Description property. Use "Aggregate" option.

Send it to a sequential target. No formatting. No quotes, no delimiters.

One row should go to the file in the DS stats.

If there are more then one row going there, let me know. There shouldn't be, if you are using aggregate.

Now...on to IDOCS. Tell us more here. How are you sending the info to SAP? If the test above ensures that we have just one row, then the concern is not with XML, but with the process creating the IDOC. Is it SAP pack, or something else? Is the IDOC having issues with an XML document that has spaces or blank lines? If so, then that process is (ultimately) buggy, because such things are perfectly valid in XML. However --- no sense beating down that tree --- just send the xml content (xmlStuff up above) thru a transformer and remove any blanks or spaces or CRLFs or other offending characters.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

eostic wrote:what does "multiple idocs" mean? Forget IDOCS for a moment...

For your testing, have one output link from xmlOutput. On it, put one column. Name it xmlStuff. LongVarchar and say, 99999 as the length. Put a single slash in the Description property. Use "Aggregate" option.

Send it to a sequential target. No formatting. No quotes, no delimiters.

One row should go to the file in the DS stats.

If there are more then one row going there, let me know. There shouldn't be, if you are using aggregate.

Now...on to IDOCS. Tell us more here. How are you sending the info to SAP? If the test above ensures that we have just one row, then the concern is not with XML, but with the process creating the IDOC. Is it SAP pack, or something else? Is the IDOC having issues with an XML document that has spaces or blank lines? If so, then that process is (ultimately) buggy, because such things are perfectly valid in XML. However --- no sense beating down that tree --- just send the xml content (xmlStuff up above) thru a transformer and remove any blanks or spaces or CRLFs or other offending characters.

Ernie
Hi Ernie,

My expected out is:

- <IDOC BEGIN="1">
- <EDI_DC40 SEGMENT="1">
<IDOCTYP>PRICECATALOGUE02</IDOCTYP>
<SNDPRN>GBODEV</SNDPRN>
<REFINT>IRDE020</REFINT>
</EDI_DC40>
- <E1BPPRICATHEADER SEGMENT="1">
<ILN_SENDER>MSUK</ILN_SENDER>
<DATE_MESSAGE>20090327</DATE_MESSAGE>
<TIME_MESSAGE>124010</TIME_MESSAGE>
<CURRENCY_SENDER>GBP</CURRENCY_SENDER>
</E1BPPRICATHEADER>
- <E1BPPRODUCTLINE SEGMENT="1">
<EAN_UPC_BASE>00133838</EAN_UPC_BASE>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_BASE>20090327</VALIDITY_BASE>
<PUR_GROUP>MF1</PUR_GROUP>
<MATL_CAT>00</MATL_CAT>
<TEMP_CONDS>03</TEMP_CONDS>
<BATCH_MGMT>X</BATCH_MGMT>
<SHELF_LIFE>25</SHELF_LIFE>
<CONT_UNIT>KG</CONT_UNIT>
<CONT_UNIT_ISO>KGM</CONT_UNIT_ISO>
<NET_CONT>0.5</NET_CONT>
<STATEINDICATOR>1</STATEINDICATOR>
</E1BPPRODUCTLINE>
- <E1BPPRODUCTADDS SEGMENT="1">
<EAN_UPC_BASE>00133838</EAN_UPC_BASE>
<ALCOHOL_PERC_VOL>0</ALCOHOL_PERC_VOL>
<KEEP_FROZEN>Yes</KEEP_FROZEN>
<KEEP_DRY>Yes</KEEP_DRY>
<HEAT_SENSITIVE>Yes</HEAT_SENSITIVE>
<VALIDITY_BASE>20090327</VALIDITY_BASE>
</E1BPPRODUCTADDS>
- <E1BPPRODUNITTEXT SEGMENT="1">
<EAN_UPC_ALTUNIT>00133838</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>A</TEXTTYP>
<TEXT_LINE>SLICED RUNNER BEANS</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITTEXT SEGMENT="1">
<EAN_UPC_ALTUNIT>00133838</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>E</TEXTTYP>
<TEXT_LINE>SLICED/BEANS</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITPRICE SEGMENT="1">
<EAN_UPC_ALTUNIT>00133838</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<COND_QUALIFIER>VK</COND_QUALIFIER>
<COND_TYPE>ZUKP</COND_TYPE>
<CONDITION_VALUE>1.49</CONDITION_VALUE>
<CURRENCY>GBP</CURRENCY>
<CONDITION_BASE>EA</CONDITION_BASE>
<CONDITION_UNIT>EA</CONDITION_UNIT>
<COND_VALID_FROM>20080331</COND_VALID_FROM>
<COND_VALID_TO>99991231</COND_VALID_TO>
</E1BPPRODUNITPRICE>
- <E1BPPRODUNITS SEGMENT="1">
<EAN_UPC_ALTUNIT>00133838</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00133838</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>1</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>1</QUANTITY_UNIT>
<ALT_UNIT_ISO>EA</ALT_UNIT_ISO>
<NUMERATOR>1</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
</E1BPPRODUNITS>
- <E1BPPRODUNITS SEGMENT="1">
<EAN_UPC_ALTUNIT>00133838</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00133838</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>24</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>24</QUANTITY_UNIT>
<ALT_UNIT_ISO>CAR</ALT_UNIT_ISO>
<NUMERATOR>24</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
<LENGTH>284</LENGTH>
<WIDTH>385</WIDTH>
<HEIGHT>384</HEIGHT>
<UNIT_LENGTH>MM</UNIT_LENGTH>
<UNIT_LENGTH_ISO>MMT</UNIT_LENGTH_ISO>
<UNIT_WIDTH>MM</UNIT_WIDTH>
<UNIT_WIDTH_ISO>MMT</UNIT_WIDTH_ISO>
<UNIT_HEIGHT>MM</UNIT_HEIGHT>
<UNIT_HEIGHT_ISO>MMT</UNIT_HEIGHT_ISO>
<VOLUME>0.04</VOLUME>
<VOLUMEUNIT>M3</VOLUMEUNIT>
<VOLUMEUNIT_ISO>MTQ</VOLUMEUNIT_ISO>
<GROSS_WT>0.5</GROSS_WT>
<UNIT_OF_WT>KG</UNIT_OF_WT>
<UNIT_OF_WT_ISO>KGM</UNIT_OF_WT_ISO>
<NET_WEIGHT>0.5</NET_WEIGHT>
<UNIT_OF_NET>KG</UNIT_OF_NET>
<UNIT_OF_NET_ISO>KGM</UNIT_OF_NET_ISO>
</E1BPPRODUNITS>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K003</STRUCTURE>
<VALUEPART2>00133838 20090327F02F0 MS</VALUEPART2>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>WRF_PRICAT_K003_EXT_STY</STRUCTURE>
<VALUEPART1>00133838 20090327 MSFS5847</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270019EKPPB0011.1100GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270013EKPPB0013.1700GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270041EKPPB0011.8700GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903276101EKPPB0010.0000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270014EKPPB0013.1700GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270027EKPPB0012.0000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270015EKPPB0012.2900GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270035EKPPB0012.0000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270016EKPPB0011.6000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00133838 200903270001EKPPB0012.2500GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPRODUCTLINE SEGMENT="1">
<EAN_UPC_BASE>00208352</EAN_UPC_BASE>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_BASE>20090327</VALIDITY_BASE>
<PUR_GROUP>MF1</PUR_GROUP>
<MATL_CAT>00</MATL_CAT>
<TEMP_CONDS>03</TEMP_CONDS>
<BATCH_MGMT>X</BATCH_MGMT>
<SHELF_LIFE>25</SHELF_LIFE>
<CONT_UNIT>KG</CONT_UNIT>
<CONT_UNIT_ISO>KGM</CONT_UNIT_ISO>
<NET_CONT>0.5</NET_CONT>
<STATEINDICATOR>1</STATEINDICATOR>
</E1BPPRODUCTLINE>
- <E1BPPRODUCTADDS SEGMENT="1">
<EAN_UPC_BASE>00208352</EAN_UPC_BASE>
<ALCOHOL_PERC_VOL>0</ALCOHOL_PERC_VOL>
<KEEP_FROZEN>Yes</KEEP_FROZEN>
<KEEP_DRY>Yes</KEEP_DRY>
<HEAT_SENSITIVE>Yes</HEAT_SENSITIVE>
<VALIDITY_BASE>20090327</VALIDITY_BASE>
</E1BPPRODUCTADDS>
- <E1BPPRODUNITTEXT SEGMENT="1">
<EAN_UPC_ALTUNIT>00208352</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>A</TEXTTYP>
<TEXT_LINE>SWEETCORN</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITTEXT SEGMENT="1">
<EAN_UPC_ALTUNIT>00208352</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>E</TEXTTYP>
<TEXT_LINE>SWEETCORN</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITPRICE SEGMENT="1">
<EAN_UPC_ALTUNIT>00208352</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<COND_QUALIFIER>VK</COND_QUALIFIER>
<COND_TYPE>ZUKP</COND_TYPE>
<CONDITION_VALUE>1.09</CONDITION_VALUE>
<CURRENCY>GBP</CURRENCY>
<CONDITION_BASE>EA</CONDITION_BASE>
<CONDITION_UNIT>EA</CONDITION_UNIT>
<COND_VALID_FROM>20080331</COND_VALID_FROM>
<COND_VALID_TO>99991231</COND_VALID_TO>
</E1BPPRODUNITPRICE>
- <E1BPPRODUNITS SEGMENT="1">
<EAN_UPC_ALTUNIT>00208352</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00208352</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>1</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>1</QUANTITY_UNIT>
<ALT_UNIT_ISO>EA</ALT_UNIT_ISO>
<NUMERATOR>1</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
</E1BPPRODUNITS>
- <E1BPPRODUNITS SEGMENT="1">
<EAN_UPC_ALTUNIT>00208352</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00208352</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>36</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>36</QUANTITY_UNIT>
<ALT_UNIT_ISO>CAR</ALT_UNIT_ISO>
<NUMERATOR>36</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
<LENGTH>384</LENGTH>
<WIDTH>284</WIDTH>
<HEIGHT>300</HEIGHT>
<UNIT_LENGTH>MM</UNIT_LENGTH>
<UNIT_LENGTH_ISO>MMT</UNIT_LENGTH_ISO>
<UNIT_WIDTH>MM</UNIT_WIDTH>
<UNIT_WIDTH_ISO>MMT</UNIT_WIDTH_ISO>
<UNIT_HEIGHT>MM</UNIT_HEIGHT>
<UNIT_HEIGHT_ISO>MMT</UNIT_HEIGHT_ISO>
<VOLUME>0.03</VOLUME>
<VOLUMEUNIT>M3</VOLUMEUNIT>
<VOLUMEUNIT_ISO>MTQ</VOLUMEUNIT_ISO>
<GROSS_WT>0.5</GROSS_WT>
<UNIT_OF_WT>KG</UNIT_OF_WT>
<UNIT_OF_WT_ISO>KGM</UNIT_OF_WT_ISO>
<NET_WEIGHT>0.5</NET_WEIGHT>
<UNIT_OF_NET>KG</UNIT_OF_NET>
<UNIT_OF_NET_ISO>KGM</UNIT_OF_NET_ISO>
</E1BPPRODUNITS>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K003</STRUCTURE>
<VALUEPART2>00208352 20090327F02F0 MS</VALUEPART2>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>WRF_PRICAT_K003_EXT_STY</STRUCTURE>
<VALUEPART1>00208352 20090327 MSFS5847</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270001EKPPB0012.2500GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270041EKPPB0011.8700GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270027EKPPB0012.0000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270019EKPPB0011.1100GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903276101EKPPB0010.0000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270013EKPPB0013.1700GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270035EKPPB0012.0000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270014EKPPB0013.1700GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270016EKPPB0011.6000GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00208352 200903270015EKPPB0012.2900GBPGBP CAR CT 2009032799991231</VALUEPART1>
</E1BPPAREX>


Actula output Comming:

- <IDOC BEGIN="1">
- <EDI_DC40 SEGMENT="1">
<TABNAM />
<MANDT />
<DOCNUM />
<DOCREL />
<STATUS />
<DIRECT />
<OUTMOD />
<EXPRSS />
<TEST />
<IDOCTYP>PRICECATALOGUE02</IDOCTYP>
<CIMTYP />
<MESTYP />
<MESCOD />
<MESFCT />
<STD />
<STDVRS />
<STDMES />
<SNDPOR />
<SNDPRT />
<SNDPFC />
<SNDPRN>GBO_FOOD=DEV</SNDPRN>
<SNDSAD />
<SNDLAD />
<RCVPOR />
<RCVPRT />
<RCVPFC />
<RCVPRN />
<RCVSAD />
<RCVLAD />
<CREDAT />
<CRETIM />
<REFINT>IRDE020</REFINT>
<REFGRP />
<REFMES />
<ARCKEY />
<SERIAL />
</EDI_DC40>
- <E1BPPRICATHEADER SEGMENT="1">
<ILN_SENDER>MSUK</ILN_SENDER>
<UNIQUE_REFERENCE />
<TEST_INDICATOR />
<ILN_RECIPIENT />
<DATE_MESSAGE>20090327</DATE_MESSAGE>
<TIME_MESSAGE>124010</TIME_MESSAGE>
<SYNTAX_IDENT />
<SYNTAX_VERSION />
<PASSWORD_RECIP />
<ILN_PARTY_ID />
<CURRENCY_SENDER>GBP</CURRENCY_SENDER>
<CURRENCY_RECIP />
</E1BPPRICATHEADER>
- <E1BPPRODGRPINFO SEGMENT="">
<PRODUCTGROUP />
<PRODGROUP_TEXT />
</E1BPPRODGRPINFO>
- <E1BPPRODUCTLINE SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_BASE>00075428</EAN_UPC_BASE>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_BASE>20090327</VALIDITY_BASE>
<PUR_GROUP>MF1</PUR_GROUP>
<MATERIAL_GROUP>BMC012</MATERIAL_GROUP>
<MAT_ID_SENDER />
<SHELF_LIFE_MSG />
<SHELF_LIFE_QUAL />
<COMPOSITION />
<MATL_TYPE>Z005</MATL_TYPE>
<MATL_CAT>00</MATL_CAT>
<DEL_FLAG />
<CONTAINER />
<STOR_CONDS />
<TEMP_CONDS>03</TEMP_CONDS>
<HAZ_MAT_NO />
<DIVISION />
<SEASON />
<ALLOWED_WT />
<PACK_WT_UN />
<PACK_WT_UN_ISO />
<ALLWD_VOL />
<PACK_VO_UN />
<PACK_VO_UN_ISO />
<VAR_ORD_UN />
<BATCH_MGMT>X</BATCH_MGMT>
<SH_MAT_TYP />
<FILL_LEVEL />
<STACK_FACT />
<MAT_GRP_SM />
<MINREMLIFE />
<SHELF_LIFE>0</SHELF_LIFE>
<STOR_PCT />
<SAESON_YR />
<PRICE_BAND />
<EMPTIESBOM />
<EXTMATLGRP />
<CONT_UNIT>KG</CONT_UNIT>
<CONT_UNIT_ISO>KGM</CONT_UNIT_ISO>
<NET_CONT>0.25</NET_CONT>
<COMPPRUNIT />
<GROSS_CONT />
<ENVT_RLVT />
<SEASMATCAT />
<HAZMATPROF />
<HIGH_VISC />
<LOOSEORLIQ />
<CLOSED_BOX />
<APPD_B_REC />
<PERIOD_IND_EXPIRATION_DATE />
<ROUND_UP_RULE_EXPIRATION_DATE />
<PROD_COMPOSITION_ON_PACKAGING />
<SALES_UNIT />
<SALES_UNIT_ISO />
<ISSUE_UNIT />
<ISSUE_UNIT_ISO />
<COUNTRYORI />
<COUNTRYORI_ISO />
<REGIONORIG />
<COMM_CODE />
<HAZ_MAT_NO_EXTERNAL />
<HAZ_MAT_NO_GUID />
<HAZ_MAT_NO_VERSION />
<STATEINDICATOR>1</STATEINDICATOR>
</E1BPPRODUCTLINE>
- <E1BPPRODUCTADDS SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_BASE>00075428</EAN_UPC_BASE>
<SIZE_DIM />
<BASIC_MATL />
<STD_DESCR />
<DSN_OFFICE />
<COMPETITOR />
<MANUFACTUR />
<GENETIC_INFO />
<ALCOHOL_PERC_VOL>0</ALCOHOL_PERC_VOL>
<FAT_CONTENT />
<KEEP_REFRIG />
<KEEP_FROZEN>Yes</KEEP_FROZEN>
<GREEN_DOT />
<EXPIR_MARKING />
<PRICE_MARKING />
<KEEP_DRY>Yes</KEEP_DRY>
<HEAT_SENSITIVE>Yes</HEAT_SENSITIVE>
<COMM_CODE />
<PREDECES_MAT_ID />
<FOLLOW_UP />
<HAZARD_CLASS />
<HAZARD_DESCRIPT />
<HAZARD_DESCR_2 />
<HAZARD_DESCR_3 />
<SAISON_PERIOD />
<VALIDITY_BASE>20090327</VALIDITY_BASE>
<FOLLOW_UP_EXTERNAL />
<FOLLOW_UP_GUID />
<FOLLOW_UP_VERSION />
</E1BPPRODUCTADDS>
- <E1BPPRODCHARACT SEGMENT="">
<PRODUCTGROUP />
<EAN_UPC_BASE />
<VALIDITY_BASE />
<CHARACTERISTIC />
<DESCRIPTION />
</E1BPPRODCHARACT>
- <E1BPPRODCOMPONENT SEGMENT="">
<PRODUCTGROUP />
<EAN_UPC_BASE />
<VALIDITY_BASE />
<EAN_UPC_SUBLINE />
<QUANTITY_SUBLINE />
</E1BPPRODCOMPONENT>
- <E1BPPRODUNITPRICE SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00075428</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<COND_QUALIFIER>VK</COND_QUALIFIER>
<COND_TYPE>ZUKP</COND_TYPE>
<CONDITION_VALUE>1.49</CONDITION_VALUE>
<CURRENCY>GBP</CURRENCY>
<CURRENCY_ISO />
<CONDITION_BASE>EA</CONDITION_BASE>
<CONDITION_UNIT>EA</CONDITION_UNIT>
<COND_VALID_FROM>20080331</COND_VALID_FROM>
<COND_VALID_TO>99991231</COND_VALID_TO>
<TAXFLAG />
</E1BPPRODUNITPRICE>
- <E1BPPRODUNITPRICESCALES SEGMENT="">
<PRODUCTGROUP />
<EAN_UPC_ALTUNIT />
<VALIDITY_UNIT />
<COND_QUALIFIER />
<COND_TYPE />
<LINE_NUMBER />
<SCALE_TYPE />
<BASIS_INDICATOR />
<SCALE_QUANT />
<QUAN_UNIT />
<QUAN_UNIT_ISO />
<SCALE_VALUE />
<SCALE_CURRENCY />
<SCALE_CURR_ISO />
<CONDITION_VALUE />
<CURRENCY />
<CURRENCY_ISO />
</E1BPPRODUNITPRICESCALES>
- <E1BPPRODUNITTEXT SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00075428</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>A</TEXTTYP>
<TEXT_LINE>PLAICE CRUMB 250G</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITTEXT SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00075428</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>E</TEXTTYP>
<TEXT_LINE>PLAICE CRMB 250</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITS SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00075428</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00075428</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>1</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>1</QUANTITY_UNIT>
<ALT_UNIT_ISO>EA</ALT_UNIT_ISO>
<NUMERATOR>1</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
<LENGTH />
<WIDTH />
<HEIGHT />
<UNIT_LENGTH />
<UNIT_LENGTH_ISO />
<UNIT_WIDTH />
<UNIT_WIDTH_ISO />
<UNIT_HEIGHT />
<UNIT_HEIGHT_ISO />
<VOLUME />
<VOLUMEUNIT />
<VOLUMEUNIT_ISO />
<GROSS_WT />
<UNIT_OF_WT />
<UNIT_OF_WT_ISO />
<NET_WEIGHT />
<UNIT_OF_NET />
<UNIT_OF_NET_ISO />
<HAZARD_LIMIT />
<BARCODE_ID />
<PALLET_HANDL />
<PALLET_TYPE />
<PALLET_LAYER />
<PALLET_UNITS />
<PALLET_HIGHT />
<UNIT_PALHT_ISO />
<PALLET_STACK />
<NON_PUBLIC_ILN />
<NON_PUBLIC_ILN2 />
<NON_PUBLIC_ILN3 />
<NON_PUBLIC_ILN4 />
<NON_PUBLIC_ILN5 />
</E1BPPRODUNITS>
- <E1BPPRODUNITS SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00075428</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00075428</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>28</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>28</QUANTITY_UNIT>
<ALT_UNIT_ISO>CAR</ALT_UNIT_ISO>
<NUMERATOR>28</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
<LENGTH>210</LENGTH>
<WIDTH>545</WIDTH>
<HEIGHT>310</HEIGHT>
<UNIT_LENGTH>MM</UNIT_LENGTH>
<UNIT_LENGTH_ISO>MMT</UNIT_LENGTH_ISO>
<UNIT_WIDTH>MM</UNIT_WIDTH>
<UNIT_WIDTH_ISO>MMT</UNIT_WIDTH_ISO>
<UNIT_HEIGHT>MM</UNIT_HEIGHT>
<UNIT_HEIGHT_ISO>MMT</UNIT_HEIGHT_ISO>
<VOLUME>0.04</VOLUME>
<VOLUMEUNIT>M3</VOLUMEUNIT>
<VOLUMEUNIT_ISO>MTQ</VOLUMEUNIT_ISO>
<GROSS_WT>0.25</GROSS_WT>
<UNIT_OF_WT>KG</UNIT_OF_WT>
<UNIT_OF_WT_ISO>KGM</UNIT_OF_WT_ISO>
<NET_WEIGHT>0.25</NET_WEIGHT>
<UNIT_OF_NET>KG</UNIT_OF_NET>
<UNIT_OF_NET_ISO>KGM</UNIT_OF_NET_ISO>
<HAZARD_LIMIT />
<BARCODE_ID />
<PALLET_HANDL />
<PALLET_TYPE />
<PALLET_LAYER />
<PALLET_UNITS />
<PALLET_HIGHT />
<UNIT_PALHT_ISO />
<PALLET_STACK />
<NON_PUBLIC_ILN />
<NON_PUBLIC_ILN2 />
<NON_PUBLIC_ILN3 />
<NON_PUBLIC_ILN4 />
<NON_PUBLIC_ILN5 />
</E1BPPRODUNITS>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>WRF_PRICAT_K003_EXT_STY</STRUCTURE>
<VALUEPART1>BMC012 00075428 20090327 MSFS5849</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00075428 200903270001EKPPB0012.2500GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
</IDOC>
- <IDOC BEGIN="1">
- <EDI_DC40 SEGMENT="1">
<TABNAM />
<MANDT />
<DOCNUM />
<DOCREL />
<STATUS />
<DIRECT />
<OUTMOD />
<EXPRSS />
<TEST />
<IDOCTYP>PRICECATALOGUE02</IDOCTYP>
<CIMTYP />
<MESTYP />
<MESCOD />
<MESFCT />
<STD />
<STDVRS />
<STDMES />
<SNDPOR />
<SNDPRT />
<SNDPFC />
<SNDPRN>GBO_FOOD=DEV</SNDPRN>
<SNDSAD />
<SNDLAD />
<RCVPOR />
<RCVPRT />
<RCVPFC />
<RCVPRN />
<RCVSAD />
<RCVLAD />
<CREDAT />
<CRETIM />
<REFINT>IRDE020</REFINT>
<REFGRP />
<REFMES />
<ARCKEY />
<SERIAL />
</EDI_DC40>
- <E1BPPRICATHEADER SEGMENT="1">
<ILN_SENDER>MSUK</ILN_SENDER>
<UNIQUE_REFERENCE />
<TEST_INDICATOR />
<ILN_RECIPIENT />
<DATE_MESSAGE>20090327</DATE_MESSAGE>
<TIME_MESSAGE>124010</TIME_MESSAGE>
<SYNTAX_IDENT />
<SYNTAX_VERSION />
<PASSWORD_RECIP />
<ILN_PARTY_ID />
<CURRENCY_SENDER>GBP</CURRENCY_SENDER>
<CURRENCY_RECIP />
</E1BPPRICATHEADER>
- <E1BPPRODGRPINFO SEGMENT="">
<PRODUCTGROUP />
<PRODGROUP_TEXT />
</E1BPPRODGRPINFO>
- <E1BPPRODUCTLINE SEGMENT="1">
<PRODUCTGROUP>BMC015</PRODUCTGROUP>
<EAN_UPC_BASE>00087490</EAN_UPC_BASE>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_BASE>20090327</VALIDITY_BASE>
<PUR_GROUP>MF1</PUR_GROUP>
<MATERIAL_GROUP>BMC015</MATERIAL_GROUP>
<MAT_ID_SENDER />
<SHELF_LIFE_MSG />
<SHELF_LIFE_QUAL />
<COMPOSITION />
<MATL_TYPE>Z005</MATL_TYPE>
<MATL_CAT>00</MATL_CAT>
<DEL_FLAG />
<CONTAINER />
<STOR_CONDS />
<TEMP_CONDS>03</TEMP_CONDS>
<HAZ_MAT_NO />
<DIVISION />
<SEASON />
<ALLOWED_WT />
<PACK_WT_UN />
<PACK_WT_UN_ISO />
<ALLWD_VOL />
<PACK_VO_UN />
<PACK_VO_UN_ISO />
<VAR_ORD_UN />
<BATCH_MGMT>X</BATCH_MGMT>
<SH_MAT_TYP />
<FILL_LEVEL />
<STACK_FACT />
<MAT_GRP_SM />
<MINREMLIFE />
<SHELF_LIFE>34</SHELF_LIFE>
<STOR_PCT />
<SAESON_YR />
<PRICE_BAND />
<EMPTIESBOM />
<EXTMATLGRP />
<CONT_UNIT>KG</CONT_UNIT>
<CONT_UNIT_ISO>KGM</CONT_UNIT_ISO>
<NET_CONT>0.34</NET_CONT>
<COMPPRUNIT />
<GROSS_CONT />
<ENVT_RLVT />
<SEASMATCAT />
<HAZMATPROF />
<HIGH_VISC />
<LOOSEORLIQ />
<CLOSED_BOX />
<APPD_B_REC />
<PERIOD_IND_EXPIRATION_DATE />
<ROUND_UP_RULE_EXPIRATION_DATE />
<PROD_COMPOSITION_ON_PACKAGING />
<SALES_UNIT />
<SALES_UNIT_ISO />
<ISSUE_UNIT />
<ISSUE_UNIT_ISO />
<COUNTRYORI />
<COUNTRYORI_ISO />
<REGIONORIG />
<COMM_CODE />
<HAZ_MAT_NO_EXTERNAL />
<HAZ_MAT_NO_GUID />
<HAZ_MAT_NO_VERSION />
<STATEINDICATOR>1</STATEINDICATOR>
</E1BPPRODUCTLINE>
- <E1BPPRODUCTADDS SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_BASE>00087490</EAN_UPC_BASE>
<SIZE_DIM />
<BASIC_MATL />
<STD_DESCR />
<DSN_OFFICE />
<COMPETITOR />
<MANUFACTUR />
<GENETIC_INFO />
<ALCOHOL_PERC_VOL>0</ALCOHOL_PERC_VOL>
<FAT_CONTENT />
<KEEP_REFRIG />
<KEEP_FROZEN>Yes</KEEP_FROZEN>
<GREEN_DOT />
<EXPIR_MARKING />
<PRICE_MARKING />
<KEEP_DRY>Yes</KEEP_DRY>
<HEAT_SENSITIVE>Yes</HEAT_SENSITIVE>
<COMM_CODE />
<PREDECES_MAT_ID />
<FOLLOW_UP />
<HAZARD_CLASS />
<HAZARD_DESCRIPT />
<HAZARD_DESCR_2 />
<HAZARD_DESCR_3 />
<SAISON_PERIOD />
<VALIDITY_BASE>20090327</VALIDITY_BASE>
<FOLLOW_UP_EXTERNAL />
<FOLLOW_UP_GUID />
<FOLLOW_UP_VERSION />
</E1BPPRODUCTADDS>
- <E1BPPRODCHARACT SEGMENT="">
<PRODUCTGROUP />
<EAN_UPC_BASE />
<VALIDITY_BASE />
<CHARACTERISTIC />
<DESCRIPTION />
</E1BPPRODCHARACT>
- <E1BPPRODCOMPONENT SEGMENT="">
<PRODUCTGROUP />
<EAN_UPC_BASE />
<VALIDITY_BASE />
<EAN_UPC_SUBLINE />
<QUANTITY_SUBLINE />
</E1BPPRODCOMPONENT>
- <E1BPPRODUNITPRICE SEGMENT="1">
<PRODUCTGROUP>BMC012</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00087490</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<COND_QUALIFIER>VK</COND_QUALIFIER>
<COND_TYPE>ZUKP</COND_TYPE>
<CONDITION_VALUE>1.49</CONDITION_VALUE>
<CURRENCY>GBP</CURRENCY>
<CURRENCY_ISO />
<CONDITION_BASE>EA</CONDITION_BASE>
<CONDITION_UNIT>EA</CONDITION_UNIT>
<COND_VALID_FROM>20080331</COND_VALID_FROM>
<COND_VALID_TO>99991231</COND_VALID_TO>
<TAXFLAG />
</E1BPPRODUNITPRICE>
- <E1BPPRODUNITPRICESCALES SEGMENT="">
<PRODUCTGROUP />
<EAN_UPC_ALTUNIT />
<VALIDITY_UNIT />
<COND_QUALIFIER />
<COND_TYPE />
<LINE_NUMBER />
<SCALE_TYPE />
<BASIS_INDICATOR />
<SCALE_QUANT />
<QUAN_UNIT />
<QUAN_UNIT_ISO />
<SCALE_VALUE />
<SCALE_CURRENCY />
<SCALE_CURR_ISO />
<CONDITION_VALUE />
<CURRENCY />
<CURRENCY_ISO />
</E1BPPRODUNITPRICESCALES>
- <E1BPPRODUNITTEXT SEGMENT="1">
<PRODUCTGROUP>BMC015</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00087490</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>A</TEXTTYP>
<TEXT_LINE>PORK SAGE&ONION STUFFING</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITTEXT SEGMENT="1">
<PRODUCTGROUP>BMC015</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00087490</EAN_UPC_ALTUNIT>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<LANGU_ISO>EN</LANGU_ISO>
<TEXTTYP>E</TEXTTYP>
<TEXT_LINE>PORK SAGE STUF</TEXT_LINE>
</E1BPPRODUNITTEXT>
- <E1BPPRODUNITS SEGMENT="1">
<PRODUCTGROUP>BMC015</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00087490</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00087490</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>1</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>1</QUANTITY_UNIT>
<ALT_UNIT_ISO>EA</ALT_UNIT_ISO>
<NUMERATOR>1</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
<LENGTH />
<WIDTH />
<HEIGHT />
<UNIT_LENGTH />
<UNIT_LENGTH_ISO />
<UNIT_WIDTH />
<UNIT_WIDTH_ISO />
<UNIT_HEIGHT />
<UNIT_HEIGHT_ISO />
<VOLUME />
<VOLUMEUNIT />
<VOLUMEUNIT_ISO />
<GROSS_WT />
<UNIT_OF_WT />
<UNIT_OF_WT_ISO />
<NET_WEIGHT />
<UNIT_OF_NET />
<UNIT_OF_NET_ISO />
<HAZARD_LIMIT />
<BARCODE_ID />
<PALLET_HANDL />
<PALLET_TYPE />
<PALLET_LAYER />
<PALLET_UNITS />
<PALLET_HIGHT />
<UNIT_PALHT_ISO />
<PALLET_STACK />
<NON_PUBLIC_ILN />
<NON_PUBLIC_ILN2 />
<NON_PUBLIC_ILN3 />
<NON_PUBLIC_ILN4 />
<NON_PUBLIC_ILN5 />
</E1BPPRODUNITS>
- <E1BPPRODUNITS SEGMENT="1">
<PRODUCTGROUP>BMC015</PRODUCTGROUP>
<EAN_UPC_ALTUNIT>00087490</EAN_UPC_ALTUNIT>
<EAN_UPC_TYPE>Z1</EAN_UPC_TYPE>
<VALIDITY_UNIT>20090327</VALIDITY_UNIT>
<VALIDITY_BASE>124010</VALIDITY_BASE>
<EAN_UPC_BASE>00087490</EAN_UPC_BASE>
<EAN_UPC_SUBLINE>36</EAN_UPC_SUBLINE>
<QUANTITY_SUBLINE>1</QUANTITY_SUBLINE>
<QUANTITY_UNIT>36</QUANTITY_UNIT>
<ALT_UNIT_ISO>CAR</ALT_UNIT_ISO>
<NUMERATOR>36</NUMERATOR>
<DENOMINATR>1</DENOMINATR>
<LENGTH>380</LENGTH>
<WIDTH>430</WIDTH>
<HEIGHT>240</HEIGHT>
<UNIT_LENGTH>MM</UNIT_LENGTH>
<UNIT_LENGTH_ISO>MMT</UNIT_LENGTH_ISO>
<UNIT_WIDTH>MM</UNIT_WIDTH>
<UNIT_WIDTH_ISO>MMT</UNIT_WIDTH_ISO>
<UNIT_HEIGHT>MM</UNIT_HEIGHT>
<UNIT_HEIGHT_ISO>MMT</UNIT_HEIGHT_ISO>
<VOLUME>0.04</VOLUME>
<VOLUMEUNIT>M3</VOLUMEUNIT>
<VOLUMEUNIT_ISO>MTQ</VOLUMEUNIT_ISO>
<GROSS_WT>0.34</GROSS_WT>
<UNIT_OF_WT>KG</UNIT_OF_WT>
<UNIT_OF_WT_ISO>KGM</UNIT_OF_WT_ISO>
<NET_WEIGHT>0.34</NET_WEIGHT>
<UNIT_OF_NET>KG</UNIT_OF_NET>
<UNIT_OF_NET_ISO>KGM</UNIT_OF_NET_ISO>
<HAZARD_LIMIT />
<BARCODE_ID />
<PALLET_HANDL />
<PALLET_TYPE />
<PALLET_LAYER />
<PALLET_UNITS />
<PALLET_HIGHT />
<UNIT_PALHT_ISO />
<PALLET_STACK />
<NON_PUBLIC_ILN />
<NON_PUBLIC_ILN2 />
<NON_PUBLIC_ILN3 />
<NON_PUBLIC_ILN4 />
<NON_PUBLIC_ILN5 />
</E1BPPRODUNITS>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>WRF_PRICAT_K003_EXT_STY</STRUCTURE>
<VALUEPART1>BMC015 00087490 20090327 MSFS</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270035EKPPB0056.5700GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270001EKPPB0057.7800GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903276101EKPPB0047.1600GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270013EKPPB0062.0900GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270014EKPPB0062.0900GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270016EKPPB0054.6900GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270027EKPPB0056.5700GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270041EKPPB0055.9600GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270019EKPPB0052.4000GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270007EKPPB0052.3700GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
- <E1BPPAREX SEGMENT="1">
<STRUCTURE>ZZPRICAT_K008</STRUCTURE>
<VALUEPART1>BMC01 00087490 200903270015EKPPB0057.9800GBPGBP CAR CT 2009032799991231</VALUEPART1>
<VALUEPART2 />
<VALUEPART3 />
<VALUEPART4 />
</E1BPPAREX>
</IDOC>

In actual output I am getting 2 IDOC segments but in the required out put
I have only one IDOC.

Could you please suggest me for getting the required format?

Thanks,
Praveen
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

It's hard to say by just looking at the output, but it certainly looks like it has to do with the fact that this is a truly multi-path, multi-node hierarchy whose sibling nodes repeat independent of each other.

You have to build each node independently, and then aggregate them all under the IDOC node or other higher level node. This means (see the best practices document) that you have to build independent nodes in prior xmlOutput Stages, with xpath that only describes that one node, and then bring them together for higher level nodes.

If I were going to attack this systematically, I'd start small and then grow larger until I found which columns were causing the problem (or if the technique being used is wrong, and the condition happens on all columns all the time). Start with just the header node, and see how it goes...then add the productinfo node and see how it goes...etc.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
dwh.com
Participant
Posts: 22
Joined: Sat Jun 28, 2008 12:38 pm

Post by dwh.com »

in your xml output
for columns give xpath like this,

Hi

<IDOC>/<PROD_HEADER>/@value
<IDOC>/<PROD>/@value
<IDOC>/<DETAIL>/@value
<IDOC>/<PROD2>/@value
<IDOC>/<DETAIL2>/@value
<IDOC>/<PROD3>/@value
<IDOC>/<DETAIL3>/@value


once output.xml file is generated , you can call the same .xml file using seuential file stage,viewdata in single column, replace PROD2&PROD3 TO PROD ,DETAIL2 & DETAIL3 to DETAIL using ereplace function and write it in another sequential file stage with output1.xml

you will get everything in single tag.

hope this will work..if not will try to give you another solution.
Post Reply