CC\PC Hierarchy loading in MDG

[former_member600236]

Hi,

I am facing an issue in uploading the CC/PC hierarchies.

Reason being, ECC and MDG hierarchy not matching 100%.

I am doing this with the report program which I found from post in SCN.

Report Name: KBAS_MDGF_SET_DOWNLOAD

My question is, what is the value which I need to enter for the mentioned tabs:

1: Hierarchy Entity Types

2: Download to File

Kindly assist.

Best regards,

kaustubh

[former_member206605]

Hello Kaustubh

For hierarchy download, give following parameters -

1, Set class - 0101 - CC group / 0106 - PC group

2. Set name - is your topmost hierarchy value. If hierarchy is say 1000 then give 1000

3. Controlling area

4. Leading Field - COAREA - for cost center and PC

5. Hierarchy name - CCTRH

6. Node - CCTRG

7. Leaf - CCTR

File name - you can specify the file name according to the hierarchy name / node. After executing the program, 3 files will be generated. You can use them to upload in MDG. Go through the documentation for further details.

Kiran

[rlm1]

I have followed the same step

,1.Set class - 0101 - CC group / 0106 - PC group

2. Set name - is your topmost hierarchy value. If p0001

3. Controlling area-0001

4. Leading Field - COAREA - for cost center and PC-0001

5. Hierarchy name - P0001

6. Node - P0001-1

7. Leaf - Testpctr

i have made 3 blank files in .csv format. but am not able to download.while executing am getting dump.

Please suggest

[former_member206605]

Can you analyze the dump? You should not get the error if file path and other details are fine. What is the file name you are giving?

Kiran

[rlm1]

Hi,

Please find the attached dump.

We are using blank .CSV file.

Kindly help.

st22.d.txt.zip

[former_member206605]

Please check file path. Make sure all the FI and CO settings are proper.

Kiran

[former_member600236]

Hi Kiran,

Can you provide any documentation for CO & FI settings?

-Kaustubh

[rlm1]

I have downloaded the all the 3 file. Am able to download the files, when I
assign the leading field as an top most hierarchy(not co area)

1. 1.PCTRH
2. 2.PCTRG
3. 3.Assignment

   1.Profit
center upload with entity PCTR

1. 2.Profit
   center group upload PCTRG
2. 3.Profit
   center hierarchy upload PCTRH

  Profit Center Assignment I have used PCCCASS but the uploading  file structure is not matching with downloaded structure?

Please guide relevant to assignment entity

Downloaded structure:

            *HLVL_TPGROUP     HLVL_TESTLEVEL1  HLVL_TESTPCTRG   LLVL_TPGROUP            LLVL_TESTPCTRG    LLVL_100101 LLVL_100101_TO

Uploadedstructure:

            Coarea Profit center companycode      postable

[former_member206605]

Hello Rama

The files you get after executing the program are -

1. Hierarchy - Top most node of hierarchy of PC and CC

2. Group - List of all the CC or PC groups

3. Assignments - Assignment - i.e Cost center to group and group to hierarchy....

The sequence of loading the file is -

.1. First download entire master data for CC and PC from respective tables in tab deliminated file.

2. Create a layout for CC and PC to load the data

3. Load master data first in MDG.

4. Then load hierarchy file - where you have only 1 record

5. Then load the group file

6. The last file is your assignment file. Before loading assignment, you have all your master data in the tables. Program checks for each record and upload it in MDG. If a single PC or CC or group is missing then you get error.

Try these steps and the data will be loaded without any issue in MDG. Be careful on your edition.

Kiran

[rlm1]

Hi  Kiran

In step 6.Uploading the assignment file

Program:USMD_DATA_TRANSFER_BACKEND

Data model:0G

Entity Type: PCCCASS(is it right?)

Edition:MDG_PF8

Data Transfer Variant:ASSVARI

Type of Transfer:A

File Name:C:\Users\cg-ramalakshmi\Desktop\100101.csv

Error: due to the Mismatch in file structure

Characteristic Company Code : The value is too long (7 is greater than 4 )

Characteristic CO Area : The value is too long (10 is greater than 4 )

Characteristic CO Area : The value is too long (10 is greater than 4 )

Characteristic CO Area : The value is too long (10 is greater than 4 )

Characteristic CO Area : The value is too long (9 is greater than 4 )

Assignments of Profit Centers : Part of the key TESTLEVEL1 contains an initialized value

In the file I have the data about assignment(PCTRH&PCTRG).but due to the selection of entity PCCCASS it is mapping the value with Company code &CO area

Required correct Entity type for assignment of PCTRH &PCTRG

[former_member206605]

Hi

First load - PCTR then PCTRH then PCTRG - here you have 2 options i.e 2 different layout. In NWBC when you select Profit center group you need to select attribute and hierarchy. When you select attribute its group details. When you select hierarchy then you have to use the assignment file.

PCTRACC is the entity type used to assign company codes to Profit center and this is last activity.

Kiran

[rlm1]

i have checked controlling area settings...am able to download profit center hierarchy for one controlling  but not able to download for cost center hierarchy and other controlling areas.