Question Re: Forecasting scenario in Technology Q&A

Forecasting scenario

Former Member — Wed, 05 Jul 2006 15:44:32 GMT

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.

Re: Forecasting scenario

Former Member — Thu, 06 Jul 2006 13:43:33 GMT

Hi Prathibha,

If I understand your question properly, you need to create a start routine where you need to write your calculation logic. In this case, I feel you should have size as a field in the TS and CS. Otherwise, this process will create duplicate records. So, have one field for size in these structure, calculate the % according to your logic and add an extra line. Hope this helps.

Thanks and Regards

Subray Hegde

Re: Forecasting scenario

Former Member — Thu, 06 Jul 2006 13:53:46 GMT

Prathiba,

You will first have to create the necessary KFs for the 4 size% and then

in the transfer rule / routine , you can fill the same using simple code.

Hope this helps..

Arun

Assign points if useful

Re: Forecasting scenario

Former Member — Thu, 06 Jul 2006 15:39:21 GMT

Subray Hegde,

You understood my question exactly and I should create a start routine. Could u pls guide me thru the process and post me any sample code that u have to start with.

thanks,

Prathibha.

Re: Forecasting scenario

Former Member — Thu, 06 Jul 2006 16:02:14 GMT

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: hegdesp@gmail.com. I shall try to help you.

Thanks and Regards

Subray Hegde

Re: Forecasting scenario

Former Member — Thu, 06 Jul 2006 17:42:59 GMT

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,

Re: Forecasting scenario

Former Member — Thu, 06 Jul 2006 18:51:53 GMT

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.