Duplicating values in Qualified Tables.

[Former Member]

Hi all

We're using a vendor repository that contains a qualified table about company code information. We use the standard xsd file (CREMDM) for export the master data to R3, but we want to duplicate the information (segment E1LFB1M) as many times as neccesary according to a relation between company and purchasing organization:

Ej.

Purchasing Organization Company

ABMX 126

ABMX 127

ABMX 128

ABMX 129

When the record is created, the user only create it for one Purchasing organization and one company (qualified), and we need the same information entered by the user to be repeated for all the companies. Is there anyway to do this trhu syndication map or data manager formula?

Idoc looks like:

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

- <CREMDM04>

- <IDOC BEGIN="1">

- <E1LFA1M SEGMENT="1">

<MSGFN>005</MSGFN>

<LIFNR>0010001000</LIFNR>

<ANRED>/</ANRED>

<BRSCH>SEJ</BRSCH>

<DATLT>/</DATLT>

<DTAWS>/</DTAWS>

<ERDAT>/</ERDAT>

<ERNAM>/</ERNAM>

<KTOKK>VPRN</KTOKK>

<KUNNR>/</KUNNR>

<LAND1>/</LAND1>

<LNRZA>/</LNRZA>

<NAME1>/</NAME1>

<NAME2>/</NAME2>

<NAME3>/</NAME3>

<NAME4>/</NAME4>

<ORT01>/</ORT01>

<ORT02>/</ORT02>

<PFACH>/</PFACH>

<PSTL2>/</PSTL2>

<PSTLZ>/</PSTLZ>

<REGIO>/</REGIO>

<SORTL>/</SORTL>

<SPRAS>/</SPRAS>

<STCD1>BBQ030122SEO</STCD1>

<STKZU>X</STKZU>

<STRAS>/</STRAS>

<TELBX>/</TELBX>

<TELF1>/</TELF1>

<TELF2>/</TELF2>

<TELFX>/</TELFX>

<TELTX>/</TELTX>

<TELX1>/</TELX1>

<XCPDK>/</XCPDK>

<VBUND>/</VBUND>

<FISKN>/</FISKN>

<ADRNR>/</ADRNR>

<MCOD1>/</MCOD1>

<MCOD2>/</MCOD2>

<MCOD3>/</MCOD3>

<REVDB>/</REVDB>

<KTOCK>/</KTOCK>

<PFORT>/</PFORT>

<WERKS>/</WERKS>

<LTSNA>/</LTSNA>

<WERKR>/</WERKR>

<PLKAL>/</PLKAL>

<DUEFL>/</DUEFL>

<TXJCD>/</TXJCD>

<FITYP>03</FITYP>

<STCDT>04</STCDT>

<ACTSS>PG</ACTSS>

+ <E1LFA1A SEGMENT="">

+ <E1ADRMAS SEGMENT="1">

+ <E1BPAD1VL SEGMENT="1">

+ <E1BPAD1VL1 SEGMENT="1">

+ <E1BPADTEL SEGMENT="1">

- <E1LFB1M SEGMENT="">

<MSGFN>005</MSGFN>

<LIFNR>0010001000</LIFNR>

<BUKRS>102</BUKRS>

<AKONT>0021051001</AKONT>

<ZWELS>C</ZWELS>

<ZTERM>Z000</ZTERM>

<FDGRV>A1</FDGRV>

<REPRF>X</REPRF>

<HBKID>BNMX</HBKID>

<ALTKN>62058</ALTKN>

</E1LFB1M>+ <E1LFM1M SEGMENT="">

+ <E1WYT3M SEGMENT="">

<MSGFN>005</MSGFN>

<LIFNR>0010001000</LIFNR>

<EKORG>ABMX</EKORG>

<PARVW>PR</PARVW>

</E1WYT3M>

</E1LFM1M>

+ <E1LFBKM SEGMENT="1">

+ <E1LFASM SEGMENT="1">

</E1LFA1M>

</IDOC>

</CREMDM04>

[Former Member]

Hi Jose,

In the syndicator, after opening the XSD, go to the destination properties,

Select the segment - E1LFB1M and in the properties pane, Tick the property - Repeatable XMl Node in the second column.

I hope this will solve your problem.

Thanks and Regards

Nitin Jain

[Former Member]

Hi,

Just check whether the Segment E1LFB1M is repeatable i.e. it should have a flower kind of symbol attached to it at the time of mapping. If it is not then open the XSD into the notepad, search the segment E1LFB1M and set its attribute maxoccurs=unbounded and then use this XSD into the Syndication map.

Regards,

Jitesh Talreja