SD-DLV: Service Level Overview - /IMO/SD_D52

DataStore object: /IMO/SD_D52

This DataStore object enables you to perform evaluations with respect to the service level at the order header and order items level. As a result, analyses such as order quantities delivered too late as a proportion of the total number of orders/order items are possible.

Data Sources

This DSO is updated by the following data sources:

DataStore object SD-DLV: Order Items /IMO/SD_D50
DataStore object SD-DLV: Orders (Header) /IMO/SD_D51
InfoSource Sales Items: Returns /IMO/SD_IS111

Transformation

Data Store Object: SD-DLV: Order Items /IMO/SD_D50

Start Routine
The start routine creates internal tables which are used in field routines to derive the Product Category 0PROD_CATEG from the corresponding Product Hierarchy 0PROD_HIER and the BP: Business Partner Group 0BP_GRP.

Field Routines

Name Target InfoObject	Technical Name of Target InfoObject	Transformation Rule
Cumulated Order Processing Time for All Document Items	0CUML_TME	Calculation based on the creation date of the item and the last goods issue date.
Delivered early/late according to req. delivery date	0DLVIELCR	Calculation of items which were delivered early/late according to requested delivery date.
Delivered early/late according to schedule line date	0DLVIELSC	Calculation of items which were delivered early/late according to schedule line date.
Delivered early acc. req. delivery date	0DLVIEYCR	Calculation of items which were delivered early according to requested delivery date.
Delivered early acc. schedule line date	0DLVIEYSC	Calculation of items which were delivered early according to schedule line date.
Delivered late acc. req. delivery date	0DLVILECR	Calculation of items which were delivered late according to requested delivery date.
Delivered late acc. schedule line date	0DLVILESC	Calculation of items which were delivered late according to schedule line date.
More Delivered than Requested	0DLVIOVER	Calculation of items for which more was delivered than requested.
Less Delivered than Requested	0DLVIUNDR	Calculation of items for which less was delivered than requested.
Value delivered early/ late acc. req. delivery date	0DLVVELCR	Calculation of value for items which were delivered early/late according to requested delivery date.
Value of early/late deliveries acc. schedule line date	0DLVVELSC	Calculation of value for items which were delivered early/late according to schedule line date.
Value delivered early acc. req. delivery date	0DLVVEYCR	Calculation of value for items which were delivered early according to requested delivery date.
Value of early deliveries acc. schedule line date	0DLVVEYSC	Calculation of value for items which were delivered early according to schedule line date.
Value of late deliveries acc. req. delivery date	0DLVVLECR	Calculation of value for items which were delivered late according to requested delivery date.
Value of late deliveries acc. schedule line date	0DLVVLESC	Calculation of value for items which were delivered late according to schedule line date.
Value Delivered more Than Requested	0DLVVOVER	Calculation of value for items for which more was delivered than requested.
Less than Requested Delivery Value	0DLVVUNDR	Calculation of value for items for which less was delivered than requested.
Number of Document Items	0DOC_ITEMS	Calculation of number of document items.
Confirmed as Requested	0ICOASREQ	Calculation of items for which the requested quantity corresponds to the confirmed quantity.
Value Confirmed as Requested	0VCOASREQ	Calculation of value for items for which the requested quantity corresponds to the confirmed quantity.
Delivery from Warehouse	0ISHP_STCK	Calculation of items which are delivered from warehouse
Value with Delivery from Warehouse	0VSHP_STCK	Calculation of value for items which are delivered from warehouse
Value with Delivery Within 24 Hours	0VAL_24	Calculation of value for items which were delivered within 24 hours
Delivery Within 24 Hours	0DLV_24	Calculation of items which were delivered within 24 hours
Net value of the order item in document currency	0NET_VALUE	Calculation of Net Value for the confirmed quantity.
Actual Delivered Value	0DLV_VAL	Calculation of value of goods delivered.
Requested Delivery Value	0REQU_VAL	Calculation of value of goods requested.
Confirmed value	0CONF_VAL	Calculation of value of confirmed goods.
Completely Delivered Quantity	0QTYDLVCMPL	Calculation of completely delivered quantity
Value of Completely Delivered Quantities	0VALDLVCMPL	Calculation of value for completely delivered quantity.
Product	0CRM_PROD	Read from attribute value of 0MATERIAL Master Data.
BP: Business Partner Group (from Hierarchy)	0BP_GRP	Filled via Lookup Routine for 0BP_GRP Master Data.
Category	0CP_CATEG	Read from attribute value of 0MATL_GROUP Master Date.
Product Category	0PROD_CATEG	Filled via Lookup Routine for 0PROD_CATEG Master Data.

Data Store Object: SD-DLV: Orders (Header) /IMO/SD_D51

Field Routines

Name Target InfoObject	Technical Name of Target InfoObject	Transformation Rule
Delivered Complete	0STS_DLV_C	Check whether sales document has been delivered as requested.
Number of orders	0ORDERS	Determination of sales document counter considering deleted sales orders.
Perfect Order Fulfillment (Number)	0DLVIPOF	Counter for perfect orders, i. e. orders without early or late deliveries, confirmed items correspond to number of document items and without returns.
Perfect Order Fulfillment (Value)	0DLVVPOF	Calculations of values for perfect orders, i. e. orders without early or late deliveries, without returns, with items that were confirmed as requested.

Info Source: Sales Item: Returns /IMO/SD_IS111

Start Routine
The start routine for the updates ensures that reverse images (RECORDMODE = “R”) are converted to after images (RECORDMODE = “ ”).

Field Routines

Name Target InfoObject	Technical Name of Target InfoObject	Transformation Rule
Value of Returns	0VAL_RET	Calculation of returns value based on return quantity and net price per sales unit.

Structure

Delta Update

The following delta update is supported for this DataStore object:

Delta update: ABR: Complete Delta with deletion flag Via Delta Queue (Cube-Comp)
DataSource: –

Data Modeling

Key Fields
Object Type	Name	Technical Name
Characteristic	Sales document	0DOC_NUMBER
Characteristic	Sales document item	0S_ORD_ITEM

Data Fields
Object Type	Name	Technical Name
Characteristic	Batch number	0BATCH
Characteristic	BP: Business Partner Group (from Hierarchy)	0BP_GRP
Time characteristic	Calendar Day	0CALDAY
Time characteristic	Calendar Year/Month	0CALMONTH
Time characteristic	Calendar Year/Week	0CALWEEK
Characteristic	Company code	0COMP_CODE
Key figure	Confirmed quantity	0CONF_QTY
Key figure	Confirmed value	0CONF_VAL
Characteristic	Category	0CP_CATEG
Characteristic	Date on which the record was created	0CREATEDON
Characteristic	Product	0CRM_PROD
Key figure	Cumulated Order Processing Time for All Document Items	0CUML_TME
Characteristic	Customer Group	0CUST_GROUP
Characteristic	Customer Group 1	0CUST_GRP1
Characteristic	Customer Group 2	0CUST_GRP2
Characteristic	Customer Group 3	0CUST_GRP3
Characteristic	Customer Group 4	0CUST_GRP4
Characteristic	Customer Group 5	0CUST_GRP5
Characteristic	Distribution Channel	0DISTR_CHAN
Key figure	Returns	0DITM_RET
Characteristic	Division	0DIVISION
Key figure	Delivered early/late according to req. delivery date	0DLVIELCR
Key figure	Delivered early/late according to schedule line date	0DLVIELSC
Key figure	Delivered early acc. req. delivery date	0DLVIEYCR
Key figure	Delivered early acc. schedule line date	0DLVIEYSC
Key figure	Delivered late acc. req. delivery date	0DLVILECR
Key figure	Delivered late acc. schedule line date	0DLVILESC
Key figure	More Delivered than Requested	0DLVIOVER
Key figure	Perfect Order Fulfillment (Number)	0DLVIPOF
Key figure	Less Delivered than Requested	0DLVIUNDR
Key figure	Quantity delivered early acc. req. delivery date	0DLVQEYCR
Key figure	Quantity Delivered Early acc. Schedule Line Date	0DLVQEYSC
Key figure	Quantity delivered late acc. req. delivery date	0DLVQLECR
Key figure	Quantity delivered late acc. schedule line date	0DLVQLESC
Key figure	Value delivered early/ late acc. req. delivery date	0DLVVELCR
Key figure	Value of early/late deliveries acc. schedule line date	0DLVVELSC
Key figure	Value delivered early acc. req. delivery date	0DLVVEYCR
Key figure	Value of early deliveries acc. schedule line date	0DLVVEYSC
Key figure	Value of late deliveries acc. req. delivery date	0DLVVLECR
Key figure	Value of late deliveries acc. schedule line date	0DLVVLESC
Key figure	Value Delivered more Than Requested	0DLVVOVER
Key figure	Perfect Order Fulfillment (Value)	0DLVVPOF
Key figure	Less than Requested Delivery Value	0DLVVUNDR
Key figure	Delivery Within 24 Hours	0DLV_24
Key figure	Actual quantity delivered (in sales units)	0DLV_QTY
Characteristic	Delivery Status	0DLV_STS
Characteristic	Overall delivery status of the item	0DLV_STSO
Characteristic	Overall Delivery Status of All Items	0DLV_STSOI
Key figure	Actual Delivered Value	0DLV_VAL
Unit of measurement	Document currency	0DOC_CURRCY
Key figure	Number of Document Items	0DOC_ITEMS
Time characteristic	Fiscal year / period	0FISCPER
Time characteristic	Fiscal year variant	0FISCVARNT
Characteristic	Forw.Agent	0FORWAGENT
Characteristic	Sales Category	0GN_CAT_SAL
Characteristic	Customer	0GN_CUSTOM
Characteristic	Location	0GN_LOCATIO
Characteristic	Source System for R/3 Entity	0GN_R3_SSY
Key figure	Confirmed as Requested	0ICOASREQ
Key figure	Delivery from Warehouse	0ISHP_STCK
Characteristic	Material	0MATERIAL
Characteristic	Material group	0MATL_GROUP
Characteristic	Material group 1	0MATL_GRP_1
Characteristic	Material group 2	0MATL_GRP_2
Characteristic	Material group 3	0MATL_GRP_3
Characteristic	Material group 4	0MATL_GRP_4
Characteristic	Material group 5	0MATL_GRP_5
Key figure	Net value of the order item in document currency	0NET_VALUE
Key figure	Net value of the order in document currency	0NET_VAL_HD
Key figure	Number of Orders	0ORDERS
Characteristic	Payer	0PAYER
Characteristic	Plant	0PLANT
Characteristic	Product	0PRODUCT
Characteristic	Product Category	0PROD_CATEG
Characteristic	Product hierarchy	0PROD_HIER
Key figure	Quantity Confirmed as Requested	0QCOASREQ
Key figure	Completely Delivered Quantity	0QTYDLVCMPL
Key figure	Return Quantities	0QTY_RET
Data packet characteristic	BW Delta Process: Update Mode	0RECORDMODE
Key figure	Desired Delivery Quantity	0REQU_QTY
Key figure	Requested Delivery Value	0REQU_VAL
Characteristic	Sales Representative	0SALESEMPLY
Characteristic	Sales Organization	0SALESORG
Characteristic	Sales group	0SALES_GRP
Characteristic	Sales Office	0SALES_OFF
Unit of measurement	Sales unit	0SALES_UNIT
Characteristic	Shipping Point	0SHIP_POINT
Characteristic	Ship-To Party	0SHIP_TO
Characteristic	Sold-to party	0SOLD_TO
Characteristic	Delivered Complete	0STS_DLV_C
Characteristic	Update Date	0UPD_DATE
Key figure	Value of Completely Delivered Quantities	0VALDLVCMPL
Key figure	Value with Delivery Within 24 Hours	0VAL_24
Key figure	Value of Returns	0VAL_RET
Key figure	Value Confirmed as Requested	0VCOASREQ
Key figure	Value with Delivery from Warehouse	0VSHP_STCK