we want to distribute one key figure in particuclar year in 4-4-5 weeks

[Former Member]

Hi All,

we want to split one particular year in 4-4-5

weeks in planning book,

quantities are not splitting correctly ,

how we can proceed,

please advice

thanks

DEV

[Former Member]

HI Dev,

If you are a technical guy, you can create a BADI implementation for that macro and manipulate the matrix data like the way you want.

the procedure to implement a BADI is

1.SPRO --> SAP SCM - Implementation Guide --> Advanced Planning and Optimization --> Supply Chain Planning --> Demand Planning (DP) --> Business Add-Ins (BAdIs) --> MacroBuilder --> Additional Functions for Macros.

create a new implementation by copying the class for the BADI defenition '/SAPAPO/ADVX' and write your own code in the method '/SAPAPO/IF_EX_ADVX~USER_EXIT_MACRO '. There is a sample code and proceedure explaining how to handle the data in the internal tables C_T_TAB and C_T_TAB_OLD. the calculations can be made with help of I_T_LINES, I_T_COLS which are rows and columns tables.

find out the the row and columns of the grid to be read and do calculation and then put the result in the desired cell.

Please let me know if you need further assistance.

Regards,

Srini.

[Former Member]

Hi Dev,

Too few details to answer the question.

But anyway,

1. When you mean "uantities are not splitting correctly", what do you mean?

check the [Time based disaggregation|http://help.sap.com/saphelp_scm50/helpdata/en/73/3e1167347111d398290000e8a49608/frameset.htm] in sap help. See if you are conceptually right.

2. I am guessing you are disaggregating from month or year to weeks. I would try doing that step by step and analyze the problem. When I mean step by step, just have one month data in a simulation version and see how it is diaggregating to weeks.

3. If you are using multiple periodicities, see the note 992236

4. If you are using a timestream, deinitialize your planning area and try regenerating the timestream. This is your last option.