cancel
Showing results for 
Search instead for 
Did you mean: 

MDG -F Initial Load

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Hunny

Please refer SAP note

1573223 - Hierarchy Initial Load in Master Data Governance Financials

It is alternative for MDMGX

michael_theis
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Michael

Thank you for clarification!

Answers (2)

Answers (2)

michael_theis
Active Contributor
0 Kudos

Hi Hunny,

we recommend loading one company code after the other. Otherwise you might get files that are much to big for a reasonable import using DIF.

Best regards

Michael

former_member206605
Active Contributor
0 Kudos

Thanks Michael and wish you a very happy new year...DIF takes longer time as compare to BC sets. I used BC sets to move company codes and its quite fast. In one single set you can move the company codes. Would like to know which approach one should use for loading the data?

Thanks

Kiran

Former Member
0 Kudos

Hi Kiran,

looks like hunny is only trying to extract GL master-SKB1 segment.

Hunny- as Michael suggested There is no point in extracting data for all company codes into single xml file, as anyway DTIMPORT does not support that kind of volumes.

you should probably extract looking at volumes u have per company code in SKB1.

Former Member
0 Kudos

Hi Michael,

So what you are suggesting is I should extract the data for different company codes using one or two at a time depending upon volume.In this approach I have to change the configuration to new company code each time I switch to extract the G/L account specific to that company code. Pleae correct if I am wrong.

Thanks.

former_member206605
Active Contributor
0 Kudos

Hello Hunny

If you want to extend your GL accounts to company code then use the file upload method through NWBC. With this you can extend the GL for multiple company codes. Copy the entire data in excel file and then create layout through NWBC. Use multiple processing to load the data.

Kiran

former_member206605
Active Contributor
0 Kudos

Hello Hunny

Company code is configuration and I doubt whether you will able to use MDMGX. I have used BC set option to move the company codes. Other way is to transport all the config in MDG through ECC.

Kiran

michael_theis
Active Contributor
0 Kudos

Hi Kiran,

Hunny tries to extract data from table SKB1 using the pre-defined content for MDMGX. This is surely supported...

Best regards

Michael

Former Member
0 Kudos

Hi Kiran,

Wishing you a happy and successful new year ahead.

Please let me know the procedure to be followed to extract G/L account based on company code from SKB1. As you have suggested that it is possible via BC set, requesting you to please share teh steps to be followed/config to be done.Will be thankful if you share some doc if you ave any on the same.

Thanks.