Importing Check tables using extractor programs

[Former Member]

Hi everyone,

I am new to MDM and hence am confused about certain steps in importing data. I am on MDM 5.5 SP3. I have the following requirement:

a. Using IDOCs via XI, i would extract customer data onto XML file.

b. I want to import this data using import manager.

My question is:

1. Is uploading check tables a pre-requiste to importing customer records? If yes, can this can be done using the ZMDME...extractor programs (given in OSS note 830864)provided by SAP and how?

2. Also when I try to use the standard maps provided i.e 03_Account_Groups_R3, I get the message "Account groupss cannot be loaded as it is not a source". I get this message even though I have selected the correct client.

Any pointers to the 2 questions mentioned above would be of great help.

Thanks,

Shruti

[Former Member · Accepted solution]

Hi Shruti,

1. Yes uploading check tables is a pre-requiste to impoeting the Customer(Main Table) records.

Yes this can be done using program ZMDME_EXTRACT_CUSTOMERS_552 provided by SAP.

For this go to transaction SE38, select the program and execute it. You will get all the check tables as XML. Now use this XMLs to load the data in MDM lookup tables.

2. For the second problem may be you have not selected the correct table in your source and destination hierarchy in Import Manager.

Hope this helps.

Regards,

Pooja

[Former Member]

The same note has all the extractor programs

ZMDME_EXTRACT_CUSTOMERS_553

ZMDME_EXTRACT_BANKS_553

ZMDME_EXTRACT_MATERIALS_553

ZMDME_EXTRACT_VENDORS_553

Though the correction instructions in note only mentions ZMDME_EXTRACT_EMPLOYEES_<version>

[Former Member]

Hi Pooja,

Thanks for replying.

OSS note 830864 has the extractor program only for 'Employee'.

Where do i get the ZMDME_EXTRACT_CUSTOMERS_552 from?

Thanks,

Shruti

[Former Member]

Hi Shruti,

As i explained, Go to transaction SE38 in SAP R/3. Here in the input help list for program you will get the program ZMDME_EXTRACT_CUSTOMERS_552.

Hope this helps.

Regards,

Pooja

[Former Member]

Hi,

For check table extraction programs. A note need to be applied in R/3 to get the ZPrograms.

ZPrograms are available for all 4 standard repositories.

The naming convention for the programs is

ZMDME_EXTRACT_<standardrepositoryname>_55<servicepackno>.

Thanks and Regards

Subbu