SAP IBP keyfigire calculation

[Former Member]

Hi Everyone,

I have a requirement, where I want to write a calculation to calculate the value for a keyfigure either to be 0 or 1, based on the validity dates maintained in attribute of a product.

Example:

MDT : PRODUCT has attributes Validfrom and Validto where I can populate the dates like 21070601 and 20171231

Now I have Keyfigure TEST@PERPRODLOC.

I want to write a calculation for the keyfigure TEST@PEPRODLOC to populate 1 between the Validfrom and Validto dates otherwise Zero.

Can you please let me if any one have written any thing similar to it.

Thanks,

Sarath

[former_member242371 · Accepted solution]

Hi Sarath,

The product validity(from/to) should be validated with PERIODID to populate the key figure within that range.

This can only be done if validfrom and validto attribute holds PERIODID values instead of time stamp value. If the attribute value is NVARCHAR type, you may try putting periodid in these attributes(by referring the time profile) and then define the calculation of key figure.

Thanks,

Rohit

[Former Member]

Hi Venkat,

Thanks for your reply.

But looks my question was not clear to you.

On Product Master I have two custom attributes Validfrom and Validto which holds the validity dates of the product

Now I wanted to write a calculation for a keyfigure ( say test@PERPRODLOC ), where I want to populate test keyfigure with value 1 where periodid is between the validfrom and Validto dates otherwise 0.

Thanks,

Sarath

[Former Member]

1) Create a custom attribute

2) add that attroibute to the product master data

3) mark that attribute as "Key Figure" in the planning are Configuration

We can list that attribute on Excel Planning views and can be made as editable and also can be used for key figure caluclations