SAP Purchasing DemoCube (SAP Library

SAP Purchasing DemoCube

The SAP Purchasing Demo Cube offers you, for example, analysis – scenarios that allow you to measure and assess the business process, as far as materials procurement within a company is concerned.

You can assess this procurement process with the help of so-called Key Performance Indicators. These are key figures that reveal the processes crucial to the success of the company, so that you can measure and control them. Examples of this are purchase order quantity, quantity of goods received and invoice receipt quantity.

The workbooks, queries and data that are also delivered show extracts of how a decision-maker would analyze the various profit-making factors in his/her area of responsibility.

Elements of the SAP Purchasing DemoCube

Source system: SAP_DEMO

InfoSource: 0D_MMRUR_C01_TD

Application component: 0D_MM

Characteristics:

InfoObject	Description	Attributes
0D_PLANT	Plant (SAP Demo)	No
0D_PUR_ORG	Purchasing organization (SAP Demo)	No
0D_VENDOR	Vendor number (SAP Demo)	No
0D_VERSION	Version (SAP Demo)	No
0D_VTYPE	Value type for reporting (SAP Demo)	No
0D_MTLGROUP	Material group (SAP Demo)	No
0D_MATERIAL	Material (SAP Demo)	No
0D_COUNTRY	Country (SAP Demo)	No

Time-characteristics:

InfoObject	Description
0CALYEAR	Calendar year
0CALMONTH	Calendar year/month
0FISCVARNT	Fiscal year variant

Key Figures:

InfoObject	Description	Units - InfoObject	Aggregation process
0D_DELIVERY	Number of deliveries (SAP Demo)		Summation
0D_PO_QTY	Purchase order quantity (SAP Demo)	0BASE_UOM	Summation
0D_GR_QTY	Quantity of goods received (SAP Demo)	0BASE_UOM	Summation
0D_INVRCQTY	Invoice receipt quantity for posting date (SAP Demo)	0BASE_UOM	Summation
0D_WTDLTIME	Weighted total delivery time (SAP Demo)		Summation
0D_TODLTIME	Delivery time total in days (SAP Demo)		Summation

Units:

InfoObject	Description	Type
0BASE_UOM	Base unit of measure	Base UM

Queries

The queries described here are examples. In addition to the completed queries delivered by SAP, you can, of course, create queries that are based on the SAP Purchasing DemoCube and the corresponding data.

Delivered queries: Technical name:

Average delivery time - vendor (0D_PU_C01_Q001)
Fulfillment rate - deliveries (0D_SD_C03_Q003)
Purchase order quantities (0D_PU_C01_Q011)

Workbooks

Assigning the delivered workbooks

	(A) Purchasing Manager
(1) Short-term profit	Fulfillment rate - deliveries
(2) Determining profit for the period	Purchase order quantities
(3) Early-warning information	Average delivery time - vendor

Purchasing Manager

Short-term profit: (A1) The workbook Fulfillment rate – deliveries shows the Purchasing Manager how the purchase order quantity and the quantity of goods received have behaved over a certain period. In addition, each vendor can determine the fulfillment rate of his/her deliveries. The selection takes place on a monthly basis and uses the value type (actual).

Profit for the period: (A2) The workbook Purchase order quantity contains details on order-, goods receipt-, and invoice receipt quantities. From these values, you can calculate the percentage of the total purchase order quantity that was taken into account, as well as the percentage of the total purchase order quantity that was received. The selection takes place on a monthly basis and uses the value type (actual).

Early-warning information: (A3) The workbook Average delivery time – vendor provides the Purchasing Manager and others with information on the total delivery time between the purchase order and the invoice. The selection takes place on a monthly basis and uses the value type (actual).