How to enter Attribute on aggregated level to get it then populated to detailed in SAP IBP?

[contovhal]

Hi Experts,

is there an option in SAP IBP for the user to enter the value for the attribute on aggregated level?

lets say user wants to fill in attribute (AaKF) of Location product of same value for different locations, so for location 101 all values of attr are 500, for location 102 all values are 300 etc

so what he needs to enter is only two values:

LOCID       DESIREDATTR

101           500

102           300

All prod-loc combinations of location 101 should get 500. All prod-loc combinationsof location 102 should get 300.

Is there any way for that? 

Thank you!

BR, Halyna

[rahulmohnot]

Hi BR, Halyna,

There are two ways to accomplish what you want, 

Option1:  Through "Manage Rules for Master Data" app-

Step1: You create an attribute for example "LOCPRODDESIREDATTR" in LOCATIONPRODUCT master data

Step2: Create a Rule for LOCATIONPRODUCT master data with Filter condition on LOCATION master attribute "DESIREDATTR" >=0 

Step3: Create join condition between Location and LocationProduct master data.

Step4: LOCPRODDESIREDATTR = DESIREDATTR

if you are new to this please use link : https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/feae3cea3cc549aaa9d9de7d363a83e6/ee1f6ace...

Option2:  Through Attribute as Key figure and using indirect input at LOCPROD level to extend the Location level value to LocationProduct level

Step1 : Create attribute as key figure for DESIREDATTR@WKLOC level

Step2: Create additional calculation in same Key Figure DESIREDATTR@WKLOCPROD using indirect input as any key figure Like: IndependentDemand, DependentDemand which is at the same planning level and you are sure that it will have planning object generated during the planning process.

You can use this additional calculation in another Key figure with same planning level with equal operator or in calculation wherever you want.

Hope this helps,

-Rahul Mohnot

[contovhal]

Hi Rahul Mohnot. Thanx a lot!

[contovhal]

Hi Rahul Mohnot. Thanx a lot. Though that is not an attribute at Location MD. This is attribute at Location Product. The question is how to set up flexible editing by the user not to make him change all prod-loc combinations if we know that all products of the same location inherit the change