how to aggregate demand for products on a monthly basis for diff location

[Former Member]

Total Demand (Key Figure DMDTO):

I will use BAPI_PBSRVAPS_GETDETAIL to extract total demand (key figure DMDTO) from planning book.

parameters: planning book name , data view, selection , group by, characteristics name.

1>should i group by location only or location or material ?

2> I am getting time series item value in date time format like period_beg period_end & resulting quantity.

how I will aggregate monthly demand for materials in all location.

very urgent

[somnath_manna]

Create a data view with TimeBucket Profile in months. That way the data in keyfigure will be aggregated at monthly level and will help in extraction using BAPI.

You need to Group by location and material to get the total demand for all materials at a particular location.

Thanks,

Somnath

[Former Member]

Debadrita Sarkar,

You will have to group by material only. This will aggregate quantities for that material from all the locations.

Rgds,

Sarah.