on 03-23-2018 11:41 AM
Hi,
I have requirement IDOC to JDBC scenario.
IDOC structure is some what typical.
In coming payload from ECC there are different substructures.
Ex. For one schedule agreement number there are different line items, and for every line item there are different rates and valid dates.
the agreement num and line item numbers should be update/insert in database for every different unit rates and valid dates.
I have used use_one_as_many for line item it is working fine and coming for every unit rate but for shedule agreement number not coming properly. if multiple line items with single unit rates then its working fine, but if multiple line items with multiple unit rates shedule agreement field is not coming.
So Please help me how to map this . I am attaching payload for your reference.
Regards,
Ramu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Sorry I forgot to attach payload and mapping. Please find sample payload structure and mapping.
capture8.pngcapture1.pngcapture2.png
Thanks & regards,
Ramu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ramu,
Could you please attach the mapping screenshot. And payload is missing so please attach the sample message payload as well.
thanks and regards,
Praveen T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
Please find sample payload and mapping screen shots.
<?xml version="1.0"?>
-<ZORDERS05>
-<IDOC BEGIN="1">
-<EDI_DC40 SEGMENT="1">
<TABNAM>ED</TABNAM>
<MANDT>1</MANDT>
<DOCNUM>000000000</DOCNUM>
<DOCREL>7</DOCREL>
<STATUS>3</STATUS>
<DIRECT>1</DIRECT>
<OUTMOD>2</OUTMOD>
<IDOCTYP>ORDERS05</IDOCTYP>
<CIMTYP>ZORDERS05</CIMTYP>
<MESTYP>ORDERS</MESTYP>
<STDMES>ORDERS</STDMES>
<SNDPOR>SA</SNDPOR>
<SNDPRT>LS</SNDPRT>
<SNDPRN>S</SNDPRN>
<RCVPOR>SA</RCVPOR>
<RCVPRT>LI</RCVPRT>
<RCVPFC>LF</RCVPFC>
<RCVPRN>5</RCVPRN>
<CREDAT>20</CREDAT>
<CRETIM>10</CRETIM>
<SERIAL>20</SERIAL>
< /EDI_DC40>
-<E1EDK01 SEGMENT="1">
<CURCY>INR</CURCY>
<HWAER>INR</HWAER>
<WKURS>1</WKURS>
<ZTERM>00</ZTERM>
<BSART>Z</BSART>
<BELNR>000068</BELNR> (Shedule agreement number)
<RECIPNT_NO>5</RECIPNT_NO>
</E1EDK01>
-<E1EDK14 SEGMENT="1">
<QUALF>0</QUALF>
<ORGID>H</ORGID>
< / E1EDK14>
-<E1EDK14 SEGMENT="1">
<QUALF>0</QUALF>
<ORGID>101</ORGID>
</E1EDK14>
-<E1EDK14 SEGMENT="1">
<QUALF>03</QUALF>
<ORGID>Z</ORGID>
</E1EDK14>
-<E1EDK14 SEGMENT="1">
<QUALF>01</QUALF>
<ORGID>5</ORGID>
</E1EDK14>
-<E1EDK03 SEGMENT="1">
<IDDAT>01</IDDAT>
<DATUM>2013</DATUM>
</E1EDK03>
-<E1EDK03 SEGMENT="1">
<IDDAT>01</IDDAT>
<DATUM>2013</DATUM>
</E1EDK03>
-<E1EDK03 SEGMENT="1">
<IDDAT>01</IDDAT>
<DATUM>201</DATUM>
</E1EDK03>
-<E1EDK03 SEGMENT="1">
<IDDAT>00</IDDAT>
<DATUM>9999</DATUM>
</E1EDK03>
-<E1EDKA1 SEGMENT="1">
<PARVW>A</PARVW>
<PARTN>H</PARTN>
<BNAME>Eng</BNAME>
<PAORG>H</PAORG>
<ORGTX>H</ORGTX>
<PAGRU>1</PAGRU>
</E1EDKA1>
-<E1EDKA1 SEGMENT="1">
<PARVW>LF</PARVW>
<PARTN>0005M42</PARTN>
<SPRAS>E</SPRAS>
<SPRAS_ISO>EN</SPRAS_ISO>
</E1EDKA1>
-<E1EDKA1 SEGMENT="1">
<PARVW>H</PARVW>
<LIFNR>M</LIFNR>
<NAME1>H</NAME1>
<NAME2>Ltd.</NAME2>
<STRAS>Pl</STRAS>
<ORT01>Distt</ORT01>
<PSTLZ>122050</PSTLZ>
<LAND1>IN</LAND1>
<TELF1>012</TELF1>
<TELFX>01</TELFX>
<SPRAS>E</SPRAS>
<ANRED>Company</ANRED>
<REGIO>07</REGIO>
<SPRAS_ISO>EN</SPRAS_ISO>
</E1EDKA1>
-<E1EDK02 SEGMENT="1">
<QUALF>001</QUALF>
<BELNR>000068</BELNR>
<DATUM>20</DATUM>
<UZEIT>10</UZEIT>
</E1EDK02>
-<E1EDK17 SEGMENT="1">
<QUALF>001</QUALF>
<LKOND>F</LKOND>
<LKTEXT>G</LKTEXT>
</E1EDK17>
-<E1EDK17 SEGMENT="1">
<QUALF>002</QUALF>
<LKTEXT>L</LKTEXT>
</E1EDK17>
-<E1EDP01 SEGMENT="1">
<POSEX>00010</POSEX> (line item number)
<ACTION>001</ACTION>
<PSTYP>0</PSTYP>
<MENGE>10000.000</MENGE>
<MENEE>P</MENEE>
<BMNG2>100</BMNG2>
<PMENE>PCE</PMENE>
<VPREI>100</VPREI>
<PEINH>1</PEINH>
<GEWEI>KGM</GEWEI>
<MATKL>90</MATKL>
<BPUMN>1</BPUMN>
<BPUMZ>1</BPUMZ>
<WERKS>M</WERKS>
< LGORT>M</LGORT>
-<E1EDP05 SEGMENT="1">
<ALCKZ>+</ALCKZ>
<KSCHL>P</KSCHL>
<KOTXT>Basic Price</KOTXT>
<BETRG>551.13</BETRG>
<KRATE>551.13</KRATE>
<UPRBS> 1</UPRBS>
<MEAUN>P</MEAUN>
<KOEIN>INR</KOEIN>
-<Z1EDP05 SEGMENT="1"> (Unit rates and valid dates)
<ZVALIDFROM>20</ZVALIDFROM>
<ZVALIDTO>20</ZVALIDTO>
<ZRATE>00</ZRATE>
</Z1EDP05>
-<Z1EDP05 SEGMENT="1"> (Unit rates and valid dates)
<ZVALIDFROM>20</ZVALIDFROM>
<ZVALIDTO>99</ZVALIDTO>
<ZRATE>000</ZRATE>
</Z1EDP05>
</E1EDP05>
-<E1EDP19 SEGMENT="1">
<QUALF>0</QUALF>
<IDTNR>4</IDTNR>
<KTEXT>T</KTEXT>
</E1EDP19>
</E1EDP01>
</IDOC></ZORDERS05>
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.