Is it possible to extract data from Order Series to BI cubes

[Former Member]

Hi,

Is it possible to extract data from Order Series to BI cubes .

We want to extract the data from requirement view (/SAPAPO/RRP1) into BI cube .

Can this functional module be used to extract the data . /SAPAPO/TS_DM_EXTRACT_DATA .

Regards ,

Jennya

[Former Member · Accepted solution]

/SAPAPO/OM_ORDER_GET_DATA is used to read the Order Details from LiveCache by giving OrderKeys(GUID) as an input to this FM.This will give you all the pegging details also for a particular order.but i am not sure about the Week Number.

Try this FM /SAPAPO/OM_ORDER_GET_TIMES- Gets Time-Related Key Figures for Orders

But if you are passing Material-Location combination then I would suggest go with standard BAPIs.

If you have all the OrderIds then try this FM /SAPAPO/RRP_LC_ORDER_GET_DATA.

Thanks,

Saurabh

[Former Member · Accepted solution]

Thanks Saurabh for your valuable information .

We are extracting 9APSHIP Distribution Receipt (Planned) and 9ADMDDI Distribution Demand (Planned) from planning area to cube in weeks .

The datasource we are using is 9AMALA_SNP02 with fields 0CALWEEK, 9AMATNR, 9ATRNAME (Transportation Lane) , 9ALOCFROM (APO Start Location) , 9ALOCTO (APO Destinatn Loc.) , 9ATTYPE (APO Means of Transpt) , 9AVERSION (APO Planning Version) , 9ADMDDI (Distr. Demand (Plnd)) and 9APSHIP (Distr.Receipt (Plnd)) .

Users want 0calday to be there in the cube too for a report . I am planning to use the Function Module in BI Transformation (routine) for 0calday . What do you think is the best Function Module to use to extract date the from livecache . What are the characteristics you think I can use to extract the date . We are not using Order information .

The requirement is we should not change the data flow , we cannot use ODS . The storage bucket profile is in weeks . We cannot change the Storage bucket profile .

Thanks a lot again for your help .

[Former Member]

Hi,

I am not sure which date you want in 0CALDAY.If you have 0CALWEEK then you can not split that data in to day bucket in BI.

What you can do is, you can calculate first day of calweek and last day of calweek using standard function modules available in BI and display first day in your report in 0CALDAY column.But I think this will not solve your purpose. unless and untill you have some additional information to get 0calday.

regards,

saurabh

[Former Member]

Thanks a lot Saurabh . We are already using 'WEEK_GET_FIRST_DAY' to calculate the first day of the week into 0calday . But it doesnt pickup hoildays and non working days . So users want data just as in /SAPAPO/RRP1 . That is reason we are looking for other options .

Thanks a lot again for your prompt reply .

[Former Member]

Is it possible to use any of these FM without Order number or PEGID because we dont have that information at datasource

[aparna_ranganathan]

Yes Jennya it is very much possible to extract order series data to BI cubes. But why you want to extract data from /n/sapapo/rrp3 ?.

What we did was , pretty standard. We used the data in planning book. We created a data source at aggregate level product -location (MALO) and used this data source to extract the data for required key figures (both time series and order series). It is a straightforward process for a BW person and no custom development is required. Take help from you BI team for the same

Thanks

Aparna

[Former Member]

Thanks a lot Aparna for Prompt reply .

We are already extracting the data using the standard data source from planning area and feeding into cube . But the storage bucket profile for it is in weeks . (our planning area is a copy of 9ASNP02) . There is a requirement from users that they want a report in days . We dont want to change the storge bucket profile for the planning area from weeks to days .

So we are planning to extract Date from livecache directly and feed into the cube . Use a Function module in BI routine to extract the Date (as you see in /SAPAPO/RRP3) and load it in 0calday .

I am confused which function module to use to extract the Date from livecache .

I found a FM SAPAPO/OM_ORDER_GET_DATA , I dont know whether it is sufficient to extract the Date . I am planning to extract the date from livecache based on week number , product and location combination .

Thanks again .

[aparna_ranganathan]

Oh ok , understood your requirement now. Iam not very sure which FM you can use. I hope one of the experts will provide an answer. Good luck

[Former Member]

Thanks a lot Aparna for reply . Hopefully some expert will help me out .