cancel
Showing results for 
Search instead for 
Did you mean: 

MDMGX issue

Former Member
0 Kudos

Hi all,

I am configuring MDMGX transaction for Customer Master Check Tables in ECC 6.0. I am able to extract data from single tables.

I have trouble extracting data from joins, for e.g., in case of Customer Account Groups, I need to extract data from T077D and T077X Tables. Please suggest me what's wrong from the following config:

for Table, T077D:

NONLANG FIELDS: KTOKD=Key

LINK INFO: KTOKD(T077X:KTOKD)

for Table, T077X:

LANG FIELDS: SPRAS=LANGKEY,TXT30=Name

MDM Port Code for both of the tables: LT_Test

Error message: Invalid SQL semantics for extraction for port LT_Test

Thank you so much in advance,

Maari

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks Michal.

What is the wrong with the above configuration, trying to correct the above method of extraction instead of going with the Function Modules. Can anybody please help resolving this issue.

Thanks,

Maari

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

at first compare your entries with some predefined like:

CRM BusinessPartner LT_Countries T005

CRM BusinessPartner LT_Countries T005T

if you have exactly like there you can always go for function module

extraction with mdmgx

there are two examples:

MDM_COMM_REGIONS_EXTR or MDM_ERP_REGIONS_EXTR

you can also have a look at this thread in which mdmgx is described in detalis

apart from this standard pdf link:

https://websmp110.sap-ag.de/~sapidb/012006153200000394732006E/MDM554_GenericExtactor.pdf

Regards,

michal