How to Compare KF values of different attributes ?

[Former Member]

Hello Team,

We got a sweet & simple requirement for our Utility industry IBP implementation. During production, We consume(raw materials) and produce(finished goods). Now we want to know the contribution ratio i.e contribution of raw materials to One finished good.

KF involved: Material Consumed - Base planning level - Day Product Location. For Raw Materials. On Day 1, in the Plant 1, we consumed 20 & 30 quantities of products Chemical 1 & 2.

KF Involved: Material Produced - Base planning level - Day product Location - For Finished Good. On Day 1, in the Plant 1, we produced Finished good of 100

Now the requirement is to compute the Contribution Ratio which is nothing but the division of every product (raw material) with product (finished good) i.e 100 / 20 and 100 / 30

How can i achieve this ?

How can i use the KF value of one attribute and compare it with other KF

Please help

[former_member242371 · Accepted solution]

Hello venkat,

I assume you have created component coefficient and output coefficient to represent material consumed and material produced respectively in IBP system. If not, you can refer these attributes in SAP4 sample model. These are decimal type attributes and hence also available as key key figure. Using these attribute you can defined a calculation to calculate contribution ratio at product-location level.

THanks,

Rohit

[Former Member · Accepted solution]

Thanks Ranjan for writing back.

Actually, the above example is to explain the problem that we are facing in the key figure calulcation. But thats not exactly our problem.

Problem:

i) We want to use 1 attribute key figure value as a base to compute other attribute key figure value

ii) Using the "Finished Good" product attribute key figure value and use that as a base to compute the "raw material" product attribute key figure value

Using the attributes in the Key figure calculations

Can you please throw some help on that.

https://answers.sap.com/questions/185392/index.html

I raised another question on the same in a different light

Note: We can't use the BOM Component Coefficient for caluclation, as they are Actuals data coming from S4 and they wont follow BOM pattern. They vary every time and not constant

Please take ur time and reply back ranjan 🙂

[Irmi_Kuntze · Accepted solution]

Not sure if this is still open?

How would you use an ATTRIBUTE? Which?

If you don't follow Rohit's recommendation but want to calculate on your own, you cannot go via master data connection as there is none I can see - except the BOM

So you would need to calculate the result of product x by dividing KF value of product x by product y

Cross-planning - combination calculation is somewhat limited if you don't have master data connections between each other

Theoretical you could go via aggregation, e.g. if the FG is the attribute towards the RAWs. Then you could work with different planning levels and defined FG as aggregated level of the two RAWs

Unfortunately I never saw a company for which that was a 1:n connection as usually a RAW can be used in several FG! And here we are turning back in circles, as for this purpose we have the BOM 🙂

But I would love to get contradicted by someone else with a great idea!!!

[former_member367912]

Hello Venkat,

Were you able to find solution for your query.

Cheers,

Akki