Forecasting scenario

[#1]

Hi Friends,

How ya'all?In one of scenario, we wanted to apply size % to the forecast data. For example if material M1 is forecasted to say 100 nos in May. Then after applying size %(Small 20%, Medium 40%, Large 20%, Extra Large 20%), we wanted to have 4 records against one single record that is coming in the info package.

could somebody explain me in more detail about this scenario and how this can be achieved.

thanks,

Prathibha.

[Former Member]

Hi Prathibha,

Can you please give me some more info on the scenario. This involves a little bit of ABAP coding and I can not do that unless I know the fields in the TS. I also want to know what kind of data target will this load go into (ODS or cube). Also, I would like to know if you have any delta loads. Please send me the details to my id: [email protected]. I shall try to help you.

Thanks and Regards

Subray Hegde

[Former Member]

hi,

the start routine will work only if you want to split the records evenly everytime... In the sence in you example you said you are going to do in 20, 40, 20 & 20%... Is this the standard split?

Normally this is how the start routinr works...assuming you have size and quantity fields.

Loop at DATA_PACKAGE.

temp_quan = DATA_PACKAGE-size

DATA_PACKAGE-quantity = ( temp_quan * 20 ) / 100.

DATA_PACKAGE-size = 'SMALL'.

Modify Data_Package.

clear DATA_PACKAGE-quantity.

clear DATA_PACKAGE-size.

DATA_PACKAGE-quantity = ( temp_quan * 40 ) / 100.

DATA_PACKAGE-size = 'MEDIUM'.

append DATA_PACKAGE.

clear DATA_PACKAGE-quantity.

clear DATA_PACKAGE-size.

DATA_PACKAGE-quantity = ( temp_quan * 20 ) / 100.

DATA_PACKAGE-size = 'LARGE'.

append DATA_PACKAGE.

clear DATA_PACKAGE-quantity.

clear DATA_PACKAGE-size.

DATA_PACKAGE-quantity = ( temp_quan * 20 ) / 100.

DATA_PACKAGE-size = 'XTRA LARGE'.

append DATA_PACKAGE.

clear DATA_PACKAGE-quantity.

clear DATA_PACKAGE-size.

endloop.

Something like this with bit more tuning.

Regards,

[Former Member]

Hi Subray Hedge, SK,

Thanks very much for the input.I wrote a start routine as told by u guys and the problem seems to be resolved.Will contact you again if i am struck.

Prathibha.