APO SNP MACRO EXIT CALCULATION for initial column

[ibmpayel]

I need to show the initial column value of key figure 9ADFCST into a zkeyfigure in initial column.As per my analysis in C_T_TAB the initial value from standard is getting populated in row(Z) - 8 and col(C) - 1 in Value(V) column.So in the same way I tried to pass the initial value in value(V) in the required row and col(C) - 1.

But it is not showing the initial value in screen.Attaching the screen shot as well.

If anyone have any suggestion for this issue would be really helpful

[rupesh_brahmankar]

Hello,

I think screen shot is missing.

If a KeyFigure value is change with the macro function VALUE_OF_ROW_CHANGED

Make sure the Key Figure setting has its parameter "zero allowed" set

If initial are not reflecting then make sure SAP note 1877871 - Initial value is changed into zero is implemented in your system.

Best Regards,

R.Brahmankar

[ibmpayel]

Hi

Thanks for you response.

I am using /SAPAPO/IF_EX_ADVX to update MACRO custom keyfigures.For all time buckets data I am able to see the required quantity but for initial it is not anyway showing in screen though we pass it in C_T_TAB table.

For bringing value in initial column for custom keyfigures 'Zero Allowed' parameter - is it some config or how do we do it?If you can help on this.

[rupesh_brahmankar]

Hello,

You can define it at keyfigure level in planning area.

/SAPAPO/MSDP_ADMIN - Administration of Demand Planning and Supply Network Planning

Also refer SAP KAB - 2492583 - BAdI /SAPAPO/ADVX does not change values'

Make sure to fill the NEW value into internal table C_T_TAB and to fill the OLD value (as it is before BAdI) into table C_T_TAB_OLD. Example: you want to change a key-figure value from "8" to "5". Fill "5" into table C_T_TAB and "8" into C_T_TAB_OLD. Later in SAP standard coding the decision to update a key-figure value is based on the two tables and if a difference was found. In case you have updated value "5" in C_T_TAB and CT_TAB_OLD no change will be visible in the planning book.

.

Best Regards,

R.Brahmankar

[former_member762873]

Hi

First of all thanks for your suggestions but still the issue is not solved.

As we are using BADI /SAPAPO/IF_EX_ADVX to add new custom keyfields data in MACRO so we are not modifying any existing data for that MACRO.In this below SS see I am able to populate data for custom keyfigures like forecast - local and Forecast - XDO but only that initial column for those keyfigures are not coming any way even I try to pass data in that exact cell of C_T_TAB and corresponding cell for C_T_TAB_OLD also I am passing.

If you have any idea kindly suggest.

[rupesh_brahmankar]

Hello,

The initial data are aggregated from the past, in your case check if you have values in past period

There are some KF function that can add the initial column can be populated data using a macro.

The initial column for Time Series keyfigure is not filled by default, it is filled by a customized macro.

Just use 'SUM ()' the values for all the historical buckets of the Time series keyfigure and put the results in the 'initial' column

Best Regards,

R.Brahmankar

[former_member762873]

Hi

I really thank you for your constant support.

Does that mean for showing the initial value for custom keyfigure I need to use other BADI or some configuration is needed.Is there any configuration possible from Functional side for this particular issue.

In the previous SS you can see that there are values for past periods and in standard keyfigure like 'Forecast' it is populating the value in the MACRO but for custom keyfigures only I am not able to populate anyway the initial column.

Looking for assistance.

Is it really possible to show initial values in the same MACRO for custom keyfigures.

Thanks

Payel

[rupesh_brahmankar]

Hello,

Please consult your functional consultant on it. Initial column values display should work for custom key figure too same as like standard key figure whether it is time series or order series. And there are two different way to display it one by the past data with a time bucket profile and another in macro.

If it is just a sum of past bucket simple macro would be enough without a BAdI.

For more details please refer SAP knowledge base article

2227718 - Initial Column does not show the initial value for Time Series keyfigures

The initial column for Time Series keyfigure is not filled by default, it is filled by a customized macro.

If the current week is within a rolling horizon schedule moved to the past next week, then time series key figures will have no entry in the initial column. If you want to have data from the past visible, then you have to define a TBprofileID(history) in the data view of the planning book.

To do this, there are two options:

1.Display the weeks in the past in the interactive planning grid by choosing a visible TBprofileID Do not display the data from the past, but use an additional calculation in a macro where you copy all data for the time series key figure in the initial column (It can be defined in a customized macro).

As for which macro function to use, just use 'SUM ()' the values for all the historical buckets of the Time series keyfigure and put the results in the 'initial' column. So in second case, use macro to populate the values in initial column.

Best Regards,

R.Brahmankar

[former_member762873]

Hi rupesh.brahmankar3,

Thank you for all your suggestions which helps us to make decisions on this.

Finally FO suggested to add all past days quantities into the current days in MACRO BADI.

Thank a lot.

Regards

Payel

[rupesh_brahmankar]

Hello,

Thanks for the updated info, if your question is answered then please close it.

Best Regards,

R.Brahmankar