SAP Import Map for MATMAS05 doesn' work

[Former Member]

Hi,

I want to send Materials as Idoc MATMAS05 from ECC to MDM 5.5 SP05 via XI.

I have set the Import Port to "Manual".

The XML Message from XI correctly arrived in the ...\Ready Folder and I connected to the XML file with the Import Manager and imported the Import Map MATMAS05 delivered from SAP.

The thing is, that when I open the Import Map MATMAS05 delivered from SAP I get the Error Message "The map cannot be loaded because table 'E1MARAM! is not a source.

Any of you have a clue why this happends?

Thanks!!

BR,

Mircea

[Former Member]

Hi,

I got the exact cause of your problem.When you are opening the Standard map MATMAS05 it searches for the E1MARAM segment which is not present in the source when you import the XML but it exists in the XML file.

Now use the file below for importing

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

<MATMAS05>

<IDOC BEGIN="1">

<EDI_DC40 SEGMENT="1"/>

<E1MARAM SEGMENT="1">

<MSGFN>005</MSGFN>

<MATNR>886_ZT8_224</MATNR>

<ERSDA>20080424</ERSDA>

<ERNAM>XICO_MDM_AST</ERNAM>

<LAEDA>20080424</LAEDA>

<AENAM>PRECU01</AENAM>

<PSTAT>EVK</PSTAT>

<MTART>FGTR</MTART>

<MBRSH>1</MBRSH>

<MATKL>01</MATKL>

<MEINS>PCE</MEINS>

<BLANZ>000</BLANZ>

<BRGEW>92.000</BRGEW>

<NTGEW>50.000</NTGEW>

<GEWEI>GRM</GEWEI>

<VOLUM>0.781</VOLUM>

<VOLEH>DMQ</VOLEH>

<WESCH>0.000</WESCH>

<EAN11>4029973691004</EAN11>

<NUMTP>HE</NUMTP>

<LAENG>66.000</LAENG>

<BREIT>160.000</BREIT>

<HOEHE>74.000</HOEHE>

<MEABM>MMT</MEABM>

<ERGEW>0.000</ERGEW>

<ERVOL>0.000</ERVOL>

<GEWTO>0.0</GEWTO>

<VOLTO>0.0</VOLTO>

<FUELG>0</FUELG>

<STFAK>0</STFAK>

<MHDRZ>0</MHDRZ>

<MHDHB>0</MHDHB>

<MHDLP>0</MHDLP>

<VPSTA>EVK</VPSTA>

<MSTDE>00000000</MSTDE>

<MSTDV>00000000</MSTDV>

<COMPL>00</COMPL>

<GEWTO_NEW>0.0</GEWTO_NEW>

<VOLTO_NEW>0.0</VOLTO_NEW>

<E1MAKTM SEGMENT="1">

<MSGFN>005</MSGFN>

<SPRAS>D</SPRAS>

<MAKTX>TRANSFAIR TEEMISCHUNG 50G FS 25X2G 224_M</MAKTX>

<SPRAS_ISO>DE</SPRAS_ISO>

</E1MAKTM>

<E1MARMM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>CT</MEINH>

<UMREZ>12</UMREZ>

<UMREN>1</UMREN>

<EAN11>4029973691028</EAN11>

<NUMTP>HE</NUMTP>

<LAENG>402.000</LAENG>

<BREIT>166.000</BREIT>

<HOEHE>154.000</HOEHE>

<MEABM>MMT</MEABM>

<VOLUM>10.277</VOLUM>

<VOLEH>DMQ</VOLEH>

<BRGEW>1247.000</BRGEW>

<GEWEI>GRM</GEWEI>

<E1MEANM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>CT</MEINH>

<LFNUM>00001</LFNUM>

<EAN11>4029973691028</EAN11>

<EANTP>HE</EANTP>

<HPEAN>X</HPEAN>

</E1MEANM>

</E1MARMM>

<E1MARMM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>PCE</MEINH>

<UMREZ>1</UMREZ>

<UMREN>1</UMREN>

<EAN11>4029973691004</EAN11>

<NUMTP>HE</NUMTP>

<LAENG>66.000</LAENG>

<BREIT>160.000</BREIT>

<HOEHE>74.000</HOEHE>

<MEABM>MMT</MEABM>

<VOLUM>0.781</VOLUM>

<VOLEH>DMQ</VOLEH>

<BRGEW>92.000</BRGEW>

<GEWEI>GRM</GEWEI>

<E1MEANM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>PCE</MEINH>

<LFNUM>00001</LFNUM>

<EAN11>4029973691004</EAN11>

<EANTP>HE</EANTP>

<HPEAN>X</HPEAN>

</E1MEANM>

</E1MARMM>

</E1MARAM>

<E1MARAM SEGMENT="1">

</E1MARAM>

</IDOC>

</MATMAS05>

The conclusion i found out is - Only the segments that occurs more than once will be visible in the source drop down of Import manager.

Please try opening the map using above XML and kindly let us know the output.

Regards,

Jitesh Talreja

[Former Member]

Hi Jitesh,

Thanks! The MATMAS05 Import Map works now. The Validation against the MATMAS.MATMAS05 xsd Schema still doesn't.

The File I gave you was produced by XI according to the SAP Business Content. Is there something wrong? Or have I made a mistake somewhere?

BR,

Mircea

[Former Member]

Hi,

When you send data out from R/3 only the segments that contains some data will appear in the output so we have to identify the Mandatory segments in the structure and put some dummy data into it.

Try putting some data in all the segments then use that XML for importing.Hope it will work.

Regards,

Jitesh Talreja

[Former Member]

Hi,

in the File was a Material with his mandatory data. It was sent out of a ECC system.

BR,

Mircea

[Former Member]

Hi,

Error Message : Element cannot be empty according to DTD/Schema

This occurs when there exists some mandatory element with no data in it.Since you are using Material Master you should enter the value in the element MATNR which I think you might have missed out.

As I suggested previously find out the mandatory segements and pass some data into them.Your query will be solved.

Regards,

Jitesh Talreja

[Former Member]

Select E1MARAM segment as source from file in import manager from your file and then try to open the map.

or please paste your xml file here, i will try and let you know..

BR,

Alok

[Former Member]

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

<MATMAS05>

<IDOC BEGIN="1">

<EDI_DC40 SEGMENT="1"/>

<E1MARAM SEGMENT="1">

<MSGFN>005</MSGFN>

<MATNR>886_ZT8_224</MATNR>

<ERSDA>20080424</ERSDA>

<ERNAM>XICO_MDM_AST</ERNAM>

<LAEDA>20080424</LAEDA>

<AENAM>PRECU01</AENAM>

<PSTAT>EVK</PSTAT>

<MTART>FGTR</MTART>

<MBRSH>1</MBRSH>

<MATKL>01</MATKL>

<MEINS>PCE</MEINS>

<BLANZ>000</BLANZ>

<BRGEW>92.000</BRGEW>

<NTGEW>50.000</NTGEW>

<GEWEI>GRM</GEWEI>

<VOLUM>0.781</VOLUM>

<VOLEH>DMQ</VOLEH>

<WESCH>0.000</WESCH>

<EAN11>4029973691004</EAN11>

<NUMTP>HE</NUMTP>

<LAENG>66.000</LAENG>

<BREIT>160.000</BREIT>

<HOEHE>74.000</HOEHE>

<MEABM>MMT</MEABM>

<ERGEW>0.000</ERGEW>

<ERVOL>0.000</ERVOL>

<GEWTO>0.0</GEWTO>

<VOLTO>0.0</VOLTO>

<FUELG>0</FUELG>

<STFAK>0</STFAK>

<MHDRZ>0</MHDRZ>

<MHDHB>0</MHDHB>

<MHDLP>0</MHDLP>

<VPSTA>EVK</VPSTA>

<MSTDE>00000000</MSTDE>

<MSTDV>00000000</MSTDV>

<COMPL>00</COMPL>

<GEWTO_NEW>0.0</GEWTO_NEW>

<VOLTO_NEW>0.0</VOLTO_NEW>

<E1MAKTM SEGMENT="1">

<MSGFN>005</MSGFN>

<SPRAS>D</SPRAS>

<MAKTX>TRANSFAIR TEEMISCHUNG 50G FS 25X2G 224_M</MAKTX>

<SPRAS_ISO>DE</SPRAS_ISO>

</E1MAKTM>

<E1MARMM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>CT</MEINH>

<UMREZ>12</UMREZ>

<UMREN>1</UMREN>

<EAN11>4029973691028</EAN11>

<NUMTP>HE</NUMTP>

<LAENG>402.000</LAENG>

<BREIT>166.000</BREIT>

<HOEHE>154.000</HOEHE>

<MEABM>MMT</MEABM>

<VOLUM>10.277</VOLUM>

<VOLEH>DMQ</VOLEH>

<BRGEW>1247.000</BRGEW>

<GEWEI>GRM</GEWEI>

<E1MEANM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>CT</MEINH>

<LFNUM>00001</LFNUM>

<EAN11>4029973691028</EAN11>

<EANTP>HE</EANTP>

<HPEAN>X</HPEAN>

</E1MEANM>

</E1MARMM>

<E1MARMM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>PCE</MEINH>

<UMREZ>1</UMREZ>

<UMREN>1</UMREN>

<EAN11>4029973691004</EAN11>

<NUMTP>HE</NUMTP>

<LAENG>66.000</LAENG>

<BREIT>160.000</BREIT>

<HOEHE>74.000</HOEHE>

<MEABM>MMT</MEABM>

<VOLUM>0.781</VOLUM>

<VOLEH>DMQ</VOLEH>

<BRGEW>92.000</BRGEW>

<GEWEI>GRM</GEWEI>

<E1MEANM SEGMENT="1">

<MSGFN>005</MSGFN>

<MEINH>PCE</MEINH>

<LFNUM>00001</LFNUM>

<EAN11>4029973691004</EAN11>

<EANTP>HE</EANTP>

<HPEAN>X</HPEAN>

</E1MEANM>

</E1MARMM>

</E1MARAM>

</IDOC>

</MATMAS05>

[Former Member]

Hi,

Set the maximum attribute of E1MARAM to unbounded and then use the IDOC.

Hope it helps.

Regards,

Jitesh Talreja

[Former Member]

Hi,

where schould I set the Atributte? In XI?

Thanks,

Mircea

[Former Member]

First open this file with notepad, and change the E1MARAM segment occurence to Unbounded and save it.

When you load this xml file in Import manager, you will see two source structures:

1. E1MARMM

2. MATMAS05

then try to open that map.

BR,

Alok

[Former Member]

Hi,

Open the Idoc file in the notepad ,Search the segment E1MARAM and set or write the attribute maximum=unbounded.

Because MDM needs this segment to be repeatable and it treats the segment with maximum=unbounded as repeatable.

You can open the standard map in the Syndicator to view the occurance of every segment.

Regards,

Jitesh talreja

[Former Member]

Hi,

I did what you told - edited the message and changed to

<E1MARAM SEGMENT="UNBOUNDED">.

But still no change...I get the same Error Message.

Mircea

[Former Member]

Hi,

Check the syntax

<E1MARAM maximum="unbounded">

Regards,

Jitesh Talreja

[Former Member]

It looks like this

<MATMAS05>

<IDOC BEGIN="1">

<EDI_DC40 SEGMENT="1"/>

<E1MARAM SEGMENT="UNBOUNDED">

<MSGFN>005</MSGFN>

<MATNR>886_ZT8_224</MATNR>

[Former Member]

Hi,

Sorry one more correction its maxoccurs not the maximum and the syntax should be as shown below

<MATMAS05>

<IDOC BEGIN="1">

<EDI_DC40 SEGMENT="1"/>

<E1MARAM maxoccurs="UNBOUNDED"><MSGFN>005</MSGFN>

<MATNR>886_ZT8_224</MATNR>

Regards,

Jitesh Talreja

[Former Member]

Hi,

I changed it, but it still doesn't works...

BR,

Mircea

[michael_theis]

Hi Mircea,

try deleting the <EDI_DC40 SEGMENT="1"/> segment. And please reset the changes you've made for the E1MARAM segement.

BR Michael

[Former Member]

Hi Michael,

I changed it but it still doesn't work.

<MATMAS05>

<IDOC BEGIN="1">

<E1MARAM SEGMENT="1">

<MSGFN>005</MSGFN>

<MATNR>886_ZT8_224</MATNR>

<ERSDA>20080424</ERSDA>

<ERNAM>XICO_MDM_AST</ERNAM>

<LAEDA>20080424</LAEDA>

But this is a File out of XI. Even if changing this one file would work, this doesn't solve the general Problem.

BR,

Mircea

[michael_theis]

Hi Mircea,

do you use the SAP delivered content without any changes? If yes, which MDM Version do you use for a) the MDM Server, Clients, and so on and b) for the MDM Business Content? Which MDM repository do you use? Product or Material? Have you applied the delivered XI content on you XI system as well?

Best regards

Michael

[Former Member]

Hi Michael,

I use the SAP Content without changes.

a) MDM 5.5 SP05 for Server&Clients ( 5.5.42.98) .

b) MDM Business Content für XI 5.5 700

c) Repository Material

d) Yes, I applied the content in XI

When I connect to the Inbound Port, I get the Message "failed to parse xml file.....element cannot be empty according to the dtd/schema).

Sending Idocs from MDM to ECC with the installed XI content works fine.

Thank you!

Best Regards,

Mircea

[Former Member]

See the error "failed to parse xml file.....element cannot be empty according to the dtd/schema". I think you are using schema for the xml file in console, Open the schema file in notepad and Set the occurences for E1MARAM segment in schema from 9999 to unbounded. and then try to import that file. Remember set occurences in Schema and save again in console and try to import that xml against new schema....

Hope it will help you.

BR,

Alok

[Former Member]

Hello Alok,

I could do that, but it wouldn' solve the fact that the MATMAS05 Import Map from SAP doesn't work, so I still won't be able to import the Data in MDM.

Thanks!

BR,

Mircea

[Former Member]

Hi,

One more suggession directly use the XML file by selecting only the type=XML and not the XML Schema while importing.

Regards,

Jitesh Talreja

[Former Member]

Hi,

this is exactly how I select the source type in Import Manager.

Thanks!

BR,

Mircea

[Former Member]

Hi Mircea,

If you are trying to do the Importing through the Port, then

Kindly configure the following steps:

1. Create 1 remote system and a port of Type-Inbound

2. Configure the Import map- MATMAS05 in the port properties

3. Also mention the XML Schema that you are using in the Port Details- MATMAS05.

4. Now place the File in the Inbound Ready.

5. Hope you have already done the config for Automatic Syndication.

I think it is just a configuration problem.

Hope it helps.

Thanks and Regards

Nitin jain

[Former Member]

Hi Nitin,

not the Configuration is the problem...

Thanks,

Mircea

[Former Member]

Hi Michael,

could you find any problem with the Versions of the Server/Business Content?

Thanks and Best Regard,

Mircea

[Former Member]

It is because the source file used in standard map and the file you are using does not match with each other. Please use the same file name.

Saved maps works when source structure and target structure matches with each other. Check for the same..

BR,

Alok

[Former Member]

Hi Alok,

thanks for your answer!

The structure should be the same - the Idoc Structure MATMAS05 as XML generated from XI.

The name is also generated by XI.

BR,

Mircea

Edited by: Mircea Precup on Apr 24, 2008 2:30 PM

Edited by: Mircea Precup on Apr 24, 2008 2:31 PM