Attribute Transformation in SAP IBP

[former_member415082]

Hi Team,

I am just trying a simple scenario for Attribute transformation.

I have values for product "F_BIS" at DC_101 which I want to transfer to "F_DOU_BIS" at same location.

I have done the below setting .

Created new planning level "WKPRODLOCNEWAVGINVEN" which is copy of "WKPRODOC" . Created new KF "NEWAVGINVPOS" as below but getting error

"Calculation NEWAVGINVPOS@REQUEST: NEWAVGINVPOS@WKPRODLOCNEWAVGINVEN must be stored, or a calculation must exist.

"

I am checking with "

https://blogs.sap.com/2018/03/27/sap-ibp-attribute-transformation-simplified-use-case/

" blog .Could you please check and help.

Thanks,

krishna

[lingaiahvanam · Accepted solution]

Hi Krishna,

Adjust the attribute transformation key figure as per below,

• An attribute that is used in a calculation must belong to the planning level of at least one of the inputs to the calculation.
• An attribute cannot be used in a calculation if all the inputs are specified at calculation level.
• If you use a constant in an expression, you must use two (!) single quotation marks before the attribute value and two (!) single quotation marks after the attribute value (for example, ''constant'').

Please note that a double quotation mark (") won't work, even though it looks similar to a combination of two single quotation marks.

screenshot-1.png

Best Regards,

Lingaiah

[lingaiahvanam]

Hi,

NEWAVGINVPOS@WKPRODLOC = "IOAVGINVENTORYPOSITION@WKPRDLOC" if the input key figure is stored mark input as stored.

screenshot-2.png

Activate the planning area.

Best Regards,

Lingaiah

[lingaiahvanam]

Hi Naveen,

Problem with NEWAVGINVPOS@REQUEST calculation. Can you check once again planning level of WKPRODLOCNEWAVGINVEN and WKPRODOC both are same?

Please confirm "IOAVGINVENTORYPOSITION@WKPRODLOC" is stored or calculated key figure.

Best Regards,

Lingaiah

[former_member415082]

Hi,

Thanks for the help.

I did the change as you suggested.

Attribute transformation is as below.

Input key figure

Now while checking the planning area i am getting below error

"Calculation PRDID@WKPRODLOCNEWAVGINVEN: NEWAVGINVPOS@WKPRODLOC must be stored, or a calculation must exist."

Thanks,

Krishna

[former_member415082]

Hi,

Any help on this?

Thanks,

Krishna

[former_member242371]

Hello Krishna,

Attribute value should be put in two 'single' quotes.

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/1805/en-US/00d82d554c95743ce10000000a17...

Thanks,

Rohit

[former_member415082]

Hi Lingaiah,

As you said I added this as well in the key figure calculation.

Planning levels:

Attribute transformation:

Input key figure: Didn't mark this as stored as added the calculation now as per your reply

Now while activation the planning area I am getting below error:

[lingaiahvanam]

Hi Naveen,

Can you share your key figures and planning levels screenshots?

Did you check this point?

NEWAVGINVPOS@WKPRODLOC = "IOAVGINVENTORYPOSITION@WKPRDLOC" if the input key figure is stored mark input as stored.

Best Regards,

Lingaiah

[former_member415082]

Hi Lingaiah,

planning level of WKPRODLOCNEWAVGINVEN and WKPRODOC are same as its a copy of WKPRODLOC.

As per Irmhild suggestion , I have changed the below .

NEWAVGINVPOS@WKPRODOC = IO...@WKPRODOC

with

NEWAVGINVPOS@WKPRODLOCNEWAVGINVEN = IO...@WKPRODOC

after which the below error got solved

"

"Calculation NEWAVGINVPOS@REQUEST: NEWAVGINVPOS@WKPRODLOCNEWAVGINVEN must be stored, or a calculation must exist.

"

Now after the attribute transformation , I am getting another error which I have mentioned earlier as well(below).

"Calculation PRDID@WKPRODLOCNEWAVGINVEN: NEWAVGINVPOS@WKPRODLOC must be stored, or a calculation must exist."

Thanks,

Krishna

[Irmi_Kuntze]

From your screenshots, I cannot see any attribute transformation (yet)

However, you do not have any calculation for the input on request level, there is no calculation on level

WKPRODLOCNEWAVGINVEN

You may succeed by exchanging

NEWAVGINVPOS@WKPRODOC = IO...@WKPRODOC

with

NEWAVGINVPOS@WKPRODLOCNEWAVGINVEN = IO...@WKPRODOC

But I cannot promise that you don't have any other issue somewhere, especially as you don't show your attribute calculation