Functionality to import some cost object attribute assignment into PCM model

[janata]

Hello,

We have a question regarding PCM import functionality.

The business case is next:
We need to change product attributes hierarchy in PCM model. Products itself are stored under Cost Object 1 dimension. Product attributes hierarchy you can find in the model: Dimensions -> Outputs -> Product.

Here you can see two sections:

• Main Hierarchy (ID/ParentID relations for this section are stored in database table PP_COSTOBJECT1) and
• Assign Attributes section (ID/ParentID relations are stored in PP_AT_COSTOBJECT1 table).

Our web books reporting is built not upon main hierarchy, but upon attributes hierarchy, and in case it has to be changed, business users should do remapping manually in „Assign Attribute“ tab. In case of huge attributes hierarchy changes the task is very time-consuming.

The question is:
Is there any way to import attribute consolidation hierarchy into PCM model instead of doing remapping manually? Maybe Data Bridge? Maybe some other option?

Thank you in advance!

P.S.
NB! Note that table names are taken from MSSQL database for PCM.

[Former Member · Accepted solution]

Yes it's possible using DataBridge, or in SQL background using Data Loader and PP_LOAD tables, or through SAP FIM.

You need to set the 'AttributeFlag' setting to:

- 10 for loading main hierarchy

- 12 for attribute hierarchy assignments (main item to attribute)

- 15 for attribute hierrarchy itself

I would advise you first to create an export file to look at the required structured you need to upload.

For more of these details, check the PCM documentation on help.sap.com