on 12-30-2014 12:21 PM
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
Hi Hunny
Please refer SAP note
1573223 - Hierarchy Initial Load in Master Data Governance Financials
It is alternative for MDMGX
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.