Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MDG -F Initial Load

Hi Experts,

Hope you all are doing fine.

Reaching out to you for your assistance on an issue I am facing while doing the configuration in MDMGX in order to extract the already present finance objects in ECC.

Issue: While doing the config under Maintain Ports and Check Tables and giving system type as R3, for the extraction of B segments in G/L accounts I am using the table SKB1 and field BUKRS.

We have 17 company codes in number and may be in future it will become more than that. While defining them in where clause using the below syntax( not able to put all the company codes due to length limited of the where clause field is 255).

SKB1~BUKRS = 'BE11' OR SKB1~BUKRS = 'BEFS' OR SKB1~BUKRS ='GB13' OR SKB1~BUKRS = 'GB17' OR SKB1~BUKRS = 'GB18' OR   SKB1~BUKRS = 'GBFS' OR SKB1~BUKRS = 'GV02' OR SKB1~BUKRS = 'GV03' OR SK -------Not able to enter values after it.

Requesting you to please tell what exact syntax should be used to take into accouny aal company codes based on which accounts can be extracted.

Waiting for your valuable reply on the same.

Thanks

Hunny

Former Member
replied

Hi Sanjay,

the mentioned note is NOT an alternative for MDMGX. The note contains an extractor for hierarchies. This does not help Hunny to extract accounts in company codes from table SKB1.

Best regards

Michael

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question