IBP - Same attribute as key and non-key field for compound md type

[peter_casper]

Dear community,

in abscence of system access at the moment I need to ask a (hopefully) fairly simple question. Is it possible to assign one attribute twice to a compound master data type as key and non-key field?

Use case:

LOCPROD with keys LOCID / PRODID and LOCID once more supposed to represent the delivering plant

LOCID key = production plant

LOCID non-key = delivering plant (DC)

Ideally also the description of the attribute can be changed to make both LOCIDs and what they represent more transparent.

Thanks in advance folks.

cheers Peter.

[piyush_parekh · Accepted solution]

Hi Peter,

You cannot add same attribute twice in a master data type. If the design intent is to avoid maintaining all location IDs and relevant details twice, you can use "Location Source" compound MDT which is a combination of Location, Product and Location From MDT. (Location From attribute is marked as root though)

Location From MDT is a reference MDT which maps attributes e.g. LOCFR to LOCID in Location MDT. In Location Source MDT, you can maintain following record:

LOCID: delivering plant (DC)

LOCFR: production plant

Refer below link for more details on location source MDT.

https://help.sap.com/viewer/feae3cea3cc549aaa9d9de7d363a83e6/1905/en-US/a0fc7055d806797ae10000000a42...

If you are simply looking for a placeholder attribute (non-root) to maintain delivering plant (DC) locations, create a new NVARCHAR attribute, add it in Location Product MDT and in relevant planning levels.

Regards,

Piyush

[peter_casper · Accepted solution]

Hi Piyush,

thanks for your explanation. That made the foundational design idea clear now.

I assume that I can use this attribute for demand planning purpose as well and that it isn't dedicatedly designed for supply planning only.

I will adjust the design accordingly.

Cheers Peter