DEMMDM06 Import

[Former Member]

Hi Experts,

I have customer data in xml file(which is created by xi using demmdm idoc).

I want to import this xml data using MDM import manager.

Can I use standard xsd,map files provided with SP4 for this xml? or I should generate xsd from xi system?

In mapping,how to map lookup and qualified tables? What is the order for importing this?

sample XML file format is

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

- <DEBMDM06>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1">

<TABNAM>EDI_DC40</TABNAM>

<MANDT>100</MANDT>

<DOCNUM>0000000000010001</DOCNUM>

<DOCREL>640</DOCREL>

<STATUS>30</STATUS>

<DIRECT>1</DIRECT>

<OUTMOD>2</OUTMOD>

<IDOCTYP>DEBMDM06</IDOCTYP>

<MESTYP>DEBMDM</MESTYP>

<SNDPOR>SAPECC</SNDPOR>

<SNDPRT>LS</SNDPRT>

<SNDPRN>ECCCLNT100</SNDPRN>

<RCVPOR>P_XI_OUT</RCVPOR>

<RCVPRT>LS</RCVPRT>

<RCVPRN>WA1CLNT100</RCVPRN>

<CREDAT>20070118</CREDAT>

<CRETIM>112846</CRETIM>

<SERIAL>20070118112843</SERIAL>

</EDI_DC40>

- <E1KNA1M SEGMENT="1">

<MSGFN>005</MSGFN>

<KUNNR>0000000051</KUNNR>

<ANRED>Mr</ANRED>

<BBBNR>0000000</BBBNR>

<BBSNR>00000</BBSNR>

<BUBKZ>0</BUBKZ>

<KTOKD>0007</KTOKD>

<LAND1>DE</LAND1>

<NAME1>Goseph</NAME1>

<NAME2>G</NAME2>

<ORT01>Walldorf</ORT01>

<PSTLZ>69190</PSTLZ>

<REGIO>08</REGIO>

<SORTL>SALES</SORTL>

<SPRAS>E</SPRAS>

<STRAS>AIC</STRAS>

<UMJAH>0000</UMJAH>

<JMZAH>000000</JMZAH>

<JMJAH>0000</JMJAH>

<UMSA1>0</UMSA1>

<HZUOR>00</HZUOR>

<SPRAS_ISO>EN</SPRAS_ISO>

<E1KNA11 SEGMENT="1" />

- <E1ADRMAS SEGMENT="1">

<OBJ_TYPE>KNA1</OBJ_TYPE>

<OBJ_ID>0000000051</OBJ_ID>

<CONTEXT>0001</CONTEXT>

- <E1BPAD1VL SEGMENT="1">

<FROM_DATE>00010101</FROM_DATE>

<TO_DATE>99991231</TO_DATE>

<TITLE>0002</TITLE>

<NAME>Rama</NAME>

<NAME_2>Raju</NAME_2>

<CITY>Walldorf</CITY>

<POSTL_COD1>69190</POSTL_COD1>

<STREET>AIC</STREET>

<COUNTRY>DE</COUNTRY>

<COUNTRYISO>DE</COUNTRYISO>

<LANGU>E</LANGU>

<LANGU_ISO>EN</LANGU_ISO>

<REGION>08</REGION>

<SORT1>SALES</SORT1>

<TIME_ZONE>CET</TIME_ZONE>

- <E1BPAD1VL1 SEGMENT="1">

<LANGU_CR>E</LANGU_CR>

<LANGUCRISO>EN</LANGUCRISO>

<ADDR_GROUP>BP</ADDR_GROUP>

</E1BPAD1VL1>

</E1BPAD1VL>

</E1ADRMAS>

- <E1KNVVM SEGMENT="1">

<MSGFN>005</MSGFN>

<VKORG>0001</VKORG>

<VTWEG>01</VTWEG>

<SPART>01</SPART>

<AWAHR>000</AWAHR>

<ANTLF>0</ANTLF>

<LPRIO>00</LPRIO>

<UEBTO>0.0</UEBTO>

<UNTTO>0.0</UNTTO>

<PODTG>0</PODTG>

</E1KNVVM>

- <E1KNB1M SEGMENT="1">

<MSGFN>005</MSGFN>

<BUKRS>0001</BUKRS>

<ZINDT>00000000</ZINDT>

<ZINRT>00</ZINRT>

<VLIBB>0</VLIBB>

<VRSZL>0</VRSZL>

<VRSPR>0</VRSPR>

<VERDT>00000000</VERDT>

<WEBTR>0</WEBTR>

<DATLZ>00000000</DATLZ>

<KULTG>0</KULTG>

<PERNR>00000000</PERNR>

</E1KNB1M>

</E1KNA1M>

</IDOC>

</DEBMDM06>

[michael_theis]

Hi Joseph,

the MDM Customer repository contains an Import Map as well as the corresponding XSDs for import of DEBMDM Idocs. You may have a look at (or even use) this respository.

Kind regards

Michael

[Former Member]

Hi,

Thanks for your reply.

I am using mdm customer repository.

I used xsd and debmdm06.map for automated mappings.

but,i stuck in salas data mapping. How to map this qualified fields.

How to use this checked tables map?

Is there any order to follow for this mapping?I am bit confused in using this standard map files.please clarify.