cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

payload file and output xml file mismatch

Former Member

on ‎05-29-2007 4:15 PM

0 Kudos

my payload file contains 10 record but when i get my final xml file it contains only a sinlgle record

can any one help me out with this

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎06-07-2007 10:53 AM
0 Kudos

Answered

Show replies
Show replies
justin_santhanam
Active Contributor
‎05-29-2007 4:16 PM
0 Kudos

Bhawarlal,

Can you please paste the o/b and i/b structure, it will be helpful to anlayze further.

Best regards,

raj.

Show replies
Show replies
Former Member
‎05-29-2007 4:19 PM
0 Kudos

My Payload structure

<?xml version="1.0" encoding="UTF-8" ?>

- <ZSALES_IDOC_OUT>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1">

<TABNAM>EDI_DC40</TABNAM>

<MANDT>400</MANDT>

<DOCNUM>0000000000258273</DOCNUM>

<DOCREL>620</DOCREL>

<STATUS>30</STATUS>

<DIRECT>1</DIRECT>

<OUTMOD>2</OUTMOD>

<IDOCTYP>ZSALES_IDOC_OUT</IDOCTYP>

<MESTYP>ZSALES_MT_OUT</MESTYP>

<SNDPOR>SAPPRD</SNDPOR>

<SNDPRT>LS</SNDPRT>

<SNDPRN>PRDCLNT400</SNDPRN>

<RCVPOR>A000000017</RCVPOR>

<RCVPRT>LS</RCVPRT>

<RCVPRN>NXICLNT001</RCVPRN>

<CREDAT>20070529</CREDAT>

<CRETIM>203311</CRETIM>

<SERIAL>20070529203151</SERIAL>

</EDI_DC40>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>AL</DIVISION>

<DIV_NAME>Allergan</DIV_NAME>

<ORD_VAL>12472739.88</ORD_VAL>

<GROSS_VAL>13957207.3</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>13957207.3</SALE_VALUE>

<PEN_VALUE>0</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>AN</DIVISION>

<DIV_NAME>Feed</DIV_NAME>

<ORD_VAL>14705110</ORD_VAL>

<GROSS_VAL>15392404</GROSS_VAL>

<RETURN_VAL>569100</RETURN_VAL>

<SALE_VALUE>15961504</SALE_VALUE>

<PEN_VALUE>2902930</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>CM</DIVISION>

<DIV_NAME>Custom Mfg. Div.</DIV_NAME>

<ORD_VAL>118770135.23</ORD_VAL>

<GROSS_VAL>30802038.79</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>30802038.79</SALE_VALUE>

<PEN_VALUE>116748645.29</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>HN</DIVISION>

<DIV_NAME>Food</DIV_NAME>

<ORD_VAL>31541095.56</ORD_VAL>

<GROSS_VAL>27588750.5</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>27588750.5</SALE_VALUE>

<PEN_VALUE>19741667.21</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>IA</DIVISION>

<DIV_NAME>Inhalation</DIV_NAME>

<ORD_VAL>24866871.45</ORD_VAL>

<GROSS_VAL>26126041.57</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>26126041.57</SALE_VALUE>

<PEN_VALUE>16427621.13</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>IN</DIVISION>

<DIV_NAME>International Div.</DIV_NAME>

<ORD_VAL>18795262.61</ORD_VAL>

<GROSS_VAL>10451042.72</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>10451042.72</SALE_VALUE>

<PEN_VALUE>23821184.88</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>MB</DIVISION>

<DIV_NAME>Mktable Molecule</DIV_NAME>

<ORD_VAL>104417985.18</ORD_VAL>

<GROSS_VAL>55415607.92</GROSS_VAL>

<RETURN_VAL>718793.51</RETURN_VAL>

<SALE_VALUE>56134401.43</SALE_VALUE>

<PEN_VALUE>169642786.93</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>NV</DIVISION>

<DIV_NAME>Novartis</DIV_NAME>

<ORD_VAL>4368877.8</ORD_VAL>

<GROSS_VAL>3842671.2</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>3842671.2</SALE_VALUE>

<PEN_VALUE>946920.6</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>PD</DIVISION>

<DIV_NAME>Pharma Develop</DIV_NAME>

<ORD_VAL>16310965.69</ORD_VAL>

<GROSS_VAL>13223605.28</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>13223605.28</SALE_VALUE>

<PEN_VALUE>6769260</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>PF</DIVISION>

<DIV_NAME>Perfumery</DIV_NAME>

<ORD_VAL>36400</ORD_VAL>

<GROSS_VAL>36400</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>36400</SALE_VALUE>

<PEN_VALUE>41200</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>PM</DIVISION>

<DIV_NAME>Pharma</DIV_NAME>

<ORD_VAL>30196002.46</ORD_VAL>

<GROSS_VAL>25187366.52</GROSS_VAL>

<RETURN_VAL>1634664</RETURN_VAL>

<SALE_VALUE>26822030.52</SALE_VALUE>

<PEN_VALUE>11419851.38</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>PS</DIVISION>

<DIV_NAME>Pharma Manufacture</DIV_NAME>

<ORD_VAL>0</ORD_VAL>

<GROSS_VAL>0</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>0</SALE_VALUE>

<PEN_VALUE>71467915.92</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

- <ZSALES_SEGMENT_OUT SEGMENT="1">

<DIVISION>SO</DIVISION>

<DIV_NAME>Solvay</DIV_NAME>

<ORD_VAL>10226301.54</ORD_VAL>

<GROSS_VAL>10226301.54</GROSS_VAL>

<RETURN_VAL>0</RETURN_VAL>

<SALE_VALUE>10226301.54</SALE_VALUE>

<PEN_VALUE>0</PEN_VALUE>

<SESSION_ID>29052007084853257</SESSION_ID>

</ZSALES_SEGMENT_OUT>

</IDOC>

</ZSALES_IDOC_OUT>

My output xml file strucrture

<?xml version="1.0" encoding="UTF-8"?>

<ns0:zsales_mt_send xmlns:ns0="http://npil/p1/Sales/1.0/Sendtype400">

<record>

<type>DOMFM</type>

<start_date>01.04.2007</start_date>

<end_date>30.04.2007</end_date>

<session_id/>

</record>

</ns0:zsales_mt_send>

with regards

Bhawarlal

Former Member
‎05-29-2007 4:21 PM
0 Kudos

sorry that was my input xml file

here is my output xml file

<?xml version="1.0" encoding="UTF-8"?>

<ns0:zsales_mt_get xmlns:ns0="http://npil/p1/Sales/1.0/GetSalesSummary400"><reco

rd><division>AL</division><div_name>Allergan</div_name><ord_val> 12472739.88</or

d_val><gross_val> 13957207.3</gross_val><return_val> 0</return_val><s

ale_val> 13957207.3</sale_val><pen_val> 0</pen_val><session_id>290520

07084853257</session_id></record></ns0:zsales_mt_get>$

bhavesh_kantilal
Active Contributor
‎05-29-2007 4:21 PM
0 Kudos

What is the mapping created?

Did you map the ZSALES_SEGMENT to the Record is the target?

IS the occurence of the Record in the Target 0 to Unbounded?

Regards

Bhavesh

Former Member
‎05-29-2007 4:22 PM
0 Kudos

yes i did that

Regards

Bhawarlal

Former Member
‎05-29-2007 4:29 PM
0 Kudos

My problem is resolved i mapped my segment field of idoc to the datatype

that was the mistake

thanks to all of u for providing assistance

regards

Bhawarlal

Ask a Question