Actions

How to upload Finance data in MDG – Hub

December 11, 2013 | 390 Views |
 datafinanceinloadmdgmdgfprocess
Follow

SAP has provided a note to load initial data in MDG from FI but while implementing MDG, I found many points needs to be added in the note.

Prepared a detail step by step document which will be useful for loading the finance data from ECC to MDG.

Attaching the document – Reference is – SAP note – 0001573223_initial_load – added various steps in the document and how to work on some of the errors which one may come across while loading the data.

Added the program name as well and table names.

Kiran Bapat

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Sanjay Shah

    Hi Kiran

    Thank you for sharing useful information.I need some clarification for below points

    For Time depentdent CO objects (Cost Center/Profit Center/Cost Element) there is validity period against each value.

    Example: Suppose I Have 2 CC in ECC with validity dates as 01.01.2013 to 31.12.2013 for C1 and 01.01.2014 to 31.12.2014 for C2. For File upload process

    1. Can I use edition with validity 01.06.2014 to 31.12.9999 or do I need to consider from date of C1 and have to create new edition as 01.01.2013 to 31.12.2014 and carry upload process? Same applicable for Hierchy structure also?
    2. Suppose there is edition with validity 01.01.2013 to 31.12.2014 but with replication timing is After Final Approval Of Change Request. In this case is uploaded data replicated back into ECC (Suppose there is internal number range then in this case duplicate records are created,correct?)
    (0) 
    1. Kiran Bapat Post author

      Hello Sanjay

      1. You have to analyze your data first. Take all the cost centers and its validity date. Depending upon the date, create the edition.

      2. In your example, take all the CC valid from 01.01.13 to 31.12.13. Load the data. Release the edition. Create new one with 01.01.2014…..and so on

      On your 2nd query – Uploaded data won’t get replicated in ECC unless you change it. If you are loading the data then please de-activate the replication model. Activate it once data load is complete.

      Kiran

      (0) 
      2. Sanjay Shah

        Hi Kiran

        Needed one more.

        CCTRH is time indepdent but for that also we have to consider controlling area validity for defining edition, is this correct? Then what about CCTRG?

        For intitial load of CCTR I am facing ABAP dump Message USMD1A 000 (Program error)

        My ECC CCTR validities range from 01.01.2013 upto 31.12.9999 so I created edition with Validity 01.0.2010 to 31.12.9999. But in excuting upload it gives ABAP Dump.

        Should I delete completed CCTR in ECC?

        (0) 
        1. Kiran Bapat Post author

          Start date won’t be much issue. The dump you are getting is due to some other reason. What exactly is the message? Please check and let me know.

          Kiran

          (0) 
          1. Sanjay Shah

            Hi Kiran

            In this blog for intial data upload for CC/PC you mentioned that

            • Create the file structure in MDG – NWBC for CC and PC
            • Create a layout and save it as variant in NWBC which will be used in the upload program

            Can you explain how to do this as I tried with File Download but can’t see any structure in generated file?

            • Create similar variant in ECC (same as your NWBC variant as we may not have all the fields in MDG) and take the dump in excel

            Can you explain me as tried to do by generating batach varaint in SE16N under EXTRA tab and but able to save in Excel as no option for Export as Spreadsheet?

            (0) 
  2. Dharamveer Gaur

    Hi Kiran,

    I have separate box for MDG and ERP ECC. So program KBAS_MDGF_SET_DOWNLOAD for hierarchy download is not available in ERP ECC system.

    Kindly let me know if any other way for hierarchy download.

    Thanks,

    Dharamveer

    (0) 
  3. Zubin SHAH

    Kiran Bapat Thanks for sharing this document.

    But I presume this document is only useful when we have MDG Hub scenario?

    How do we import finance data from ECC to MDG if the same instance is used?

    Is there a standard program for this initial load?

    Thanks.

    (0) 
    1. Kiran Bapat Post author

      Hello Zubin

      Since MDG-F is based on Flex mode, you have to use same method to upload the data in MDG tables. Finance data is stored first in MDG tables and then transferred to ECC – though its same instance.

      Kiran

      (0) 
      1. Zubin SHAH

        Hi Kiran,

        1. How does the upload functionality work in MDG-F to do the initial load of GL, Cost Centers?

        2. I assume that master data is first created in ECC and this is used (SKA1, SKB1) to do the load into MDG-F (?)

        Thanks.

        (0) 
        1. Kiran Bapat Post author

          Hello Zubin

          1. You can load GL / CC using MDMGX or downloading the data in file and uploading in MDG. MDMGX is the best tool you can explore for GL / CC and PC

          2. For hierarchy you can’t use MDMGX. You have to load the data in file from ECC and upload it in MDG.

          3. Before MDG-F implementation, the master data is created in ECC and then you need to load the data in MDG. Once MDG is implemented then you can use MDG and replicate the data to ECC.

          Kiran

          (0) 
  4. Aruna Katakamsetti

    Hi Kiran,

    We are using the File Upload method to do mass change.

    Changes happened successfully but Date of Creation of Cost Center is changed to Mass upload change date and has overwritten the old date.

    Can you please confirm, if we are missing something here.

    We have used the Overwrite Attributes option while uploading.
    Thanks and Regards
    Karan Arya

    (0) 

Leave a Reply