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: 

Having issue in Integration Advisor MAG IDOC to EDIFACT

Ali_Sufiyan
Newcomer

2 weeks ago - last edited 2 weeks ago

0 Kudos

I have an IDOC payload with E1EDP01 SEGMENT I have to map it with the LIN item of EDIFACT, 
Sample Payload:

 

 

<E1EDP01 SEGMENT="1">
			<POSEX>00010</POSEX>
			<ACTION>001</ACTION>
			<PSTYP>0</PSTYP>
			<MENGE>3.000</MENGE>
			<MENEE>EA</MENEE>
			<BMNG2>3.000</BMNG2>
			<PMENE>EA</PMENE>
			<VPREI>3.45</VPREI>
			<PEINH>1</PEINH>
			<NETWR>10.35</NETWR>
			<GEWEI>KGM</GEWEI>
			<PREIS>3.80</PREIS>
			<MATKL>ASDFQWE</MATKL>
			<BPUMN>1</BPUMN>
			<BPUMZ>3</BPUMZ>
			<BRGEW>0.342</BRGEW>
			<WERKS>QVQEV</WERKS>
			<LGORT>0001</LGORT>
			<E1EDP05 SEGMENT="1">
				<ALCKZ>+</ALCKZ>
				<KSCHL>VQEF</KSCHL>
				<KOTXT>Gross Price</KOTXT>
				<BETRG>10.35</BETRG>
				<KRATE>3.45</KRATE>
				<UPRBS>       1</UPRBS>
				<MEAUN>EA</MEAUN>
				<KOEIN>USD</KOEIN>
			</E1EDP05>
			<E1EDP05 SEGMENT="1">
				<ALCKZ>+</ALCKZ>
				<KSCHL>QEVQ</KSCHL>
				<KOTXT>GST rate</KOTXT>
				<KPERC>10</KPERC>
			</E1EDP05>
			<E1EDP20 SEGMENT="1">
				<WMENG>3.000</WMENG>
				<AMENG>0.000</AMENG>
				<EDATU>23523422</EDATU>
				<EZEIT>153123</EZEIT>
			</E1EDP20>
			<E1EDP19 SEGMENT="1">
				<QUALF>002</QUALF>
				<IDTNR>VAV2342</IDTNR>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>001</QUALF>
				<IDTNR>CAER12341</IDTNR>
				<KTEXT>ATEL ACR PNT 80ML PRUS BE HUE</KTEXT>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>003</QUALF>
				<IDTNR>1234567890123</IDTNR>
				<KTEXT>235236526</KTEXT>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>1</POSEX>
			<UEPOS>00010</UEPOS>
			<MATNR>ADFGWQ35232</MATNR>
			<E1ADDI1 SEGMENT="1">
				<ADDIMATNR>ASVFQE</ADDIMATNR>
				<ADDINUMBER>3.000</ADDINUMBER>
				<ADDIVKME>EA</ADDIVKME>
				<ADDIFM>0005</ADDIFM>
				<ADDIFM_TXT>SLS Pre-packing</ADDIFM_TXT>
			</E1ADDI1>
			<E1EDP19 SEGMENT="1">
				<QUALF>017</QUALF>
				<IDTNR>0001</IDTNR>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>00011</POSEX>
			<ACTION>001</ACTION>
			<PSTYP>0</PSTYP>
			<MENGE>3.000</MENGE>
			<MENEE>EA</MENEE>
			<BMNG2>3.000</BMNG2>
			<PMENE>EA</PMENE>
			<PEINH>1</PEINH>
			<GEWEI>ASF</GEWEI>
			<MATKL>QAEVQ</MATKL>
			<UEPOS>00010</UEPOS>
			<BPUMN>1</BPUMN>
			<BPUMZ>3</BPUMZ>
			<BRGEW>0.342</BRGEW>
			<WERKS>W965</WERKS>
			<LGORT>0001</LGORT>
			<E1EDP20 SEGMENT="1">
				<WMENG>3.000</WMENG>
				<AMENG>0.000</AMENG>
				<EDATU>2341351</EDATU>
				<EZEIT>235234</EZEIT>
			</E1EDP20>
			<E1EDP19 SEGMENT="1">
				<QUALF>002</QUALF>
				<IDTNR>CASF12341</IDTNR>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>001</QUALF>
				<IDTNR>ASF121523</IDTNR>
				<KTEXT>ASDV EEF WEF WEG WG </KTEXT>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>003</QUALF>
				<IDTNR>1234567890123</IDTNR>
				<KTEXT>10084935</KTEXT>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>1</POSEX>
			<UEPOS>00011</UEPOS>
			<MATNR>CHRAI12040</MATNR>
			<E1ADDI1 SEGMENT="1">
				<ADDIMATNR>ADGQWEGWEV</ADDIMATNR>
				<ADDINUMBER>3.000</ADDINUMBER>
				<ADDIVKME>EA</ADDIVKME>
				<ADDIFM>0005</ADDIFM>
				<ADDIFM_TXT>QAEGWEG</ADDIFM_TXT>
			</E1ADDI1>
			<E1EDPA1 SEGMENT="1">
				<PARVW>SLS</PARVW>
				<PARTN>A235</PARTN>
				<NAME1>ASDFWQWEF</NAME1>
				<NAME4>A341</NAME4>
				<STRAS>ADSVAEF QWF QW</STRAS>
				<ORT01>ASFWEF</ORT01>
				<PSTLZ>6090</PSTLZ>
				<LAND1>US</LAND1>
				<SPRAS>E</SPRAS>
				<REGIO>WA</REGIO>
				<SPRAS_ISO>EN</SPRAS_ISO>
			</E1EDPA1>
			<E1EDP19 SEGMENT="1">
				<QUALF>017</QUALF>
				<IDTNR>0001</IDTNR>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>00020</POSEX>
			<ACTION>001</ACTION>
			<PSTYP>0</PSTYP>
			<MENGE>3.000</MENGE>
			<MENEE>EA</MENEE>
			<BMNG2>3.000</BMNG2>
			<PMENE>EA</PMENE>
			<VPREI>3.45</VPREI>
			<PEINH>1</PEINH>
			<NETWR>10.35</NETWR>
			<GEWEI>KGM</GEWEI>
			<PREIS>3.80</PREIS>
			<MATKL>ADFQWEQ</MATKL>
			<BPUMN>1</BPUMN>
			<BPUMZ>3</BPUMZ>
			<BRGEW>0.336</BRGEW>
			<WERKS>W134</WERKS>
			<LGORT>0001</LGORT>
			<E1EDP05 SEGMENT="1">
				<ALCKZ>+</ALCKZ>
				<KSCHL>ZPUR</KSCHL>
				<KOTXT>Gross Price</KOTXT>
				<BETRG>10.35</BETRG>
				<KRATE>3.45</KRATE>
				<UPRBS>       1</UPRBS>
				<MEAUN>EA</MEAUN>
				<KOEIN>USD</KOEIN>
			</E1EDP05>
			<E1EDP05 SEGMENT="1">
				<ALCKZ>+</ALCKZ>
				<KSCHL>ZGST</KSCHL>
				<KOTXT>GST rate</KOTXT>
				<KPERC>10</KPERC>
			</E1EDP05>
			<E1EDP20 SEGMENT="1">
				<WMENG>3.000</WMENG>
				<AMENG>0.000</AMENG>
				<EDATU>23523562</EDATU>
				<EZEIT>235232</EZEIT>
			</E1EDP20>
			<E1EDP19 SEGMENT="1">
				<QUALF>002</QUALF>
				<IDTNR>ASFD2352</IDTNR>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>001</QUALF>
				<IDTNR>ASF12341</IDTNR>
				<KTEXT>ASFQE QEG WG WEG W</KTEXT>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>003</QUALF>
				<IDTNR>1234567890123</IDTNR>
				<KTEXT>345234236</KTEXT>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>1</POSEX>
			<UEPOS>00020</UEPOS>
			<MATNR>CHRAI12400</MATNR>
			<E1ADDI1 SEGMENT="1">
				<ADDIMATNR>CROSSDOCK</ADDIMATNR>
				<ADDINUMBER>3.000</ADDINUMBER>
				<ADDIVKME>EA</ADDIVKME>
				<ADDIFM>0005</ADDIFM>
				<ADDIFM_TXT>ASDG WEG W GEW</ADDIFM_TXT>
			</E1ADDI1>
			<E1EDP19 SEGMENT="1">
				<QUALF>017</QUALF>
				<IDTNR>0001</IDTNR>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>00021</POSEX>
			<ACTION>001</ACTION>
			<PSTYP>0</PSTYP>
			<MENGE>3.000</MENGE>
			<MENEE>EA</MENEE>
			<BMNG2>3.000</BMNG2>
			<PMENE>EA</PMENE>
			<PEINH>1</PEINH>
			<GEWEI>KGM</GEWEI>
			<MATKL>OSPAPAI</MATKL>
			<UEPOS>00020</UEPOS>
			<BPUMN>1</BPUMN>
			<BPUMZ>3</BPUMZ>
			<BRGEW>0.336</BRGEW>
			<WERKS>W965</WERKS>
			<LGORT>0001</LGORT>
			<E1EDP20 SEGMENT="1">
				<WMENG>3.000</WMENG>
				<AMENG>0.000</AMENG>
				<EDATU>20240520</EDATU>
				<EZEIT>153123</EZEIT>
			</E1EDP20>
			<E1EDP19 SEGMENT="1">
				<QUALF>002</QUALF>
				<IDTNR>ASF13R42</IDTNR>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>001</QUALF>
				<IDTNR>ASF3R21323</IDTNR>
				<KTEXT>ADVGW WE GWE GWEG WGE</KTEXT>
			</E1EDP19>
			<E1EDP19 SEGMENT="1">
				<QUALF>003</QUALF>
				<IDTNR>726839375638</IDTNR>
				<KTEXT>235236</KTEXT>
			</E1EDP19>
		</E1EDP01>
		<E1EDP01 SEGMENT="1">
			<POSEX>1</POSEX>
			<UEPOS>00021</UEPOS>
			<MATNR>SADGQ23R2</MATNR>
			<E1ADDI1 SEGMENT="1">
				<ADDIMATNR>CROSSDOCK</ADDIMATNR>
				<ADDINUMBER>3.000</ADDINUMBER>
				<ADDIVKME>EA</ADDIVKME>
				<ADDIFM>0005</ADDIFM>
				<ADDIFM_TXT>SLS Pre-packing</ADDIFM_TXT>
			</E1ADDI1>
			<E1EDPA1 SEGMENT="1">
				<PARVW>SLS</PARVW>
				<PARTN>F2342</PARTN>
				<NAME1>ASEGDWEG2G23G 23 T2</NAME1>
				<NAME4>W621</NAME4>
				<STRAS>SDG WE GWG WG </STRAS>
				<ORT01>SEGSG</ORT01>
				<PSTLZ>6090</PSTLZ>
				<LAND1>US</LAND1>
				<SPRAS>E</SPRAS>
				<REGIO>WA</REGIO>
				<SPRAS_ISO>EN</SPRAS_ISO>
			</E1EDPA1>
			<E1EDP19 SEGMENT="1">
				<QUALF>017</QUALF>
				<IDTNR>0001</IDTNR>
			</E1EDP19>
		</E1EDP01>

 

 

 So the above payload is a single Line item as you can see POSEX 00010 The 2nd record is POSEX 1 where UEPOS 00010 and 3rd record is POSEX 00011 where UEPOS is 00010 and the 4th which is the last of the single line item is POSEX 1 where UEPOS is 00011, So I'm not able to map these with EDIFACT LIN because if I MAP E1EDP01 Segment with SG25 where My LIN is, it will have multiple nodes created like for POSEX 00010, POSEX 1, POSEX 00011 and POSEX 1. 
Please suggest to me the best practices how do I achieve this requirement.

I want to map 

E1EDP01/POSEX where its 00020 to LIN/1082 and E1EDP01/E1EDP19/IDTNR where E1EDP01/E1EDP19/QUALF is 003 to LIN/C212/7140, E1EDP01/MENGE to QTY/C186/6060 and so on.
So the main issue is I'm not able to map E1EDP01 records for this EDIFACT LIN Items.

Ali_Sufiyan_1-1715764608126.png

 

Ali_Sufiyan_2-1715764653464.png

 

Ali_Sufiyan_3-1715764686997.png

Ali_Sufiyan_4-1715764724655.png

After Correct Mapping, this EDIFACT should look like this

Ali_Sufiyan_5-1715764794840.png

Thanks.



Show replies
Show replies
Ryan-Crosby
Active Contributor
2 weeks ago
0 Kudos
You can use conditional mapping of nodes by including UEPOS in conjunction with exists( ).
Answer

Accepted Solutions (0)

Answers (0)

Ask a Question