Skip to Content
avatar image
Former Member

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

Initial Load.png (41.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 31, 2014 at 07:33 AM

    Hi Hunny

    Please refer SAP note

    1573223 - Hierarchy Initial Load in Master Data Governance Financials

    It is alternative for MDMGX

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 01, 2015 at 06:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Jan 02, 2015 at 07:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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