Skip to Content
avatar image
Former Member

Duplicating values in Qualified Tables.

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>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 20, 2008 at 04:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 20, 2008 at 05:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded