Business Content for the Purchasing Scenario

[Former Member]

Hi SDN,

In our project we are required to have a DSO before the cube. In the SAP documentation, 0PUR_C01 is shown to be serviced by 2LIS_02_ITM, etc. which was the old style of loading (direct from the data sources into the cube), at least that is what I think.

1. Does anyone have a BI-7 layout of purchasing BI standard content showing the data flow from the source system to data sources and then into DOS's and cubes.

2. How do you find out the documentation telling you which standard DSO feeds which cube in purchasing?

3. Is there a documentation on the transformation from the ECC tables to data sources, to DSO's (if any) and then onto the cubes?

I always award the points.

Thanks.

Shahid

[Former Member]

Check this:

http://help.sap.com/saphelp_nw70/helpdata/EN/c9/0373f54e49754b99686a0af91efdc2/frameset.htm

This DSO feeds to Service Level u2013 Purchase Orders cube, Technical Name: 0PUR_C09.

Purchase Order Items

Technical Name: 0PUR_O01

Use

This DataStore Object integrates data on purchase order items based on the purchase order items from the InfoSource 2LIS_02_ITM and from the allocation structures 2LIS_02_SGR (allocation schedule line with goods receipt), 2LIS_02_CGR (allocation confirmation with goods receipt) and 2LIS_02_SCN (allocation schedule line with confirmation).

InfoSources

2LIS_02_ITM: Purchase Order Items

2LIS_02_SGR: Allocation - Schedule Line with Goods Receipt

2LIS_02_CGR: Allocation - Confirmation with Goods Receipt

2LIS_02_SCN: Allocation Schedule Line with Confirmation

Order Schedule Lines

Technical name: 0PUR_DS03

Use

The ODS object Order Schedule Lines consolidates data from the InfoSources Purchasing Data (Document Schedule Line Level) (2LIS_02_SCL) and Allocation Schedule Line with Goods Receipt (2LIS_02_SGR). This is basically information relating to the delivery completed indicator, open quantity and planned delivery date or requested delivery date, which are important for later evaluations and calculations in the InfoCube Backlogged Order Schedule Lines (0PUR_C10).

Thanks...

Shambhu

[Former Member]

Hi Shahid,

The BI architecture using a DSO to store the data from your source and than onwards to your cube is theory that has not yet been implemented by SAP in the Business Content (all content is still based on 3.x). No standards DSO exists, but you can use your datasource as template for your DSO and into subsequent objects.

I use the following setup:

Datasource - DSO - InfoSource - Cube - Multiprovider

The links are formed by transformations. It's a generic method, that you can apply to most areas (an exception is the stock initialization BX-datasource).

Documentation that explains every transformation in detail is hard to get, you should use the BC as an example and build your own.

Good luck!

Hayo