On-Time Delivery of ASN (Customer Overview)

Query Query: 2O0SNC_SPM_DLV/0SNC_DPA_ASN_CUS_DAT

You can use this query for direct performance analysis in SAP Supply Network Collaboration (SAP SNC) to display the ratio of accurate ASN items determined by on-time deliveries as defined by the on-time delivery rating criteria. In direct performance analysis, the queries always display the ratio as a percentage figure. For more information, see On-Time Delivery.

To use direct performance analysis, you must activate the business function Supply Network Collaboration 2 (SCM_SNC_GEN_2).

Structure

Free Characteristics
Object Type	Name	Technical Name
Characteristic	ASN Item	`2O0SNC_SPM_DLV-DISP_ASN_ITE`
Characteristic	ASN Number	`2O0SNC_SPM_DLV-DISP_DLV`
Characteristic	Bill-To Party	`2O0SNC_SPM_DLV-DISP_BLP`
Characteristic	Changed On	`2O0SNC_SPM_DLV-DATI_REC_CHN`
Characteristic	Customer	`2O0SNC_SPM_DLV-DISP_BPA`
Characteristic	Customer Location	`2O0SNC_SPM_DLV-DISP_SPT`
Characteristic	Delivery Date/Time	`2O0SNC_SPM_DLV-DATI_PRO_REC`
Characteristic	Document Creation Time	`2O0SNC_SPM_DLV-DATI_DOC_REC`
Characteristic	Goods Receipt	`2O0SNC_SPM_DLV-DISP_BPG`
Characteristic	Means of Transport	`2O0SNC_SPM_DLV-DISP_PRO_TRA`
Characteristic	Product	`2O0SNC_SPM_DLV-DISP_PRO`
Characteristic	Purchase Order Item Number	`2O0SNC_SPM_DLV-DISP_POR_ITE`
Characteristic	Release Number	`2O0SNC_SPM_DLV-DISP_SCH_ITE`
Characteristic	Sales Order Item	`2O0SNC_SPM_DLV-DISP_SOR_ITE`
Characteristic	Sales Order Number	`2O0SNC_SPM_DLV-DISP_SOR`
Characteristic	Scheduling Agreement	`2O0SNC_SPM_DLV-DISP_SCA`
Characteristic	Scheduling Agreement Item	`2O0SNC_SPM_DLV-DISP_SCA_ITE`
Characteristic	Ship-From Location	`2O0SNC_SPM_DLV-DISP_SUL`
Characteristic	Ship-To Location	`2O0SNC_SPM_DLV-DISP_GRL`
Characteristic	Shipping Date/Time	`2O0SNC_SPM_DLV-DATI_PRO_SHI`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Reporting Period	`2O0SNC_SPM_DLV-DISP_REF_NC6`	—
Characteristic	Supplier	`2O0SNC_SPM_DLV-DISP_SUP`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Ratio of Accurate ASNs (On-Time Delivery)		This key figure displays the ratio of accurate ASN items determined by on-time deliveries. SAP SNC calculates the ratio of accurate ASN items using data from the key figures Number of Accurate ASNs (On-Time Delivery) and Total Number of ASNs. SAP SNC uses the formula number of accurate ASNs / total number of ASNs.
Key Figure	Number of Accurate ASNs (On-Time Delivery)	`20-TYPE_ACC_O_N-INT4`
Key Figure	Total Number of ASNs	`2O-TYPE_HIIN_N-INT4`
Key Figure	Ratio of Quantity Delivered On Time		This key figure displays the ratio of quantities delivered on time. SAP SNC calculates the on-time quantities using data from the key figures Total Quantity (2O-QUAN_PRO-QUAN_PRO_UNI) and Quantity Delivered On Time (2O-QUAN_ONTI-QUAN_PRO_UN2). SAP SNC uses the formula quantities delivered on time / total quantity.
Key Figure	Quantity Delivered On Time	`2O-QUAN_ONTI-QUAN_PRO_UN2`
Key Figure	Ratio of Quantity Delivered Early		This key figure displays the ratio of quantities delivered early. SAP SNC calculates the ratio of quantities delivered early using data from the key figures Total Quantity (2O-QUAN_PRO-QUAN_PRO_UNI) and Quantity Delivered Early. SAP SNC uses the formula quantities delivered early / total quantity.
Key Figure	Quantity Delivered Early		This key figure displays the quantities delivered early. SAP SNC calculates the quantities delivered early by summing the key figures Quantity Delivered Early (Current Period) (2O-QUAN_EACP-QUAN_PRO_UN2) and Quantity Delivered Early (Future Period) (2O-QUAN_EAFP-QUAN_PRO_UN2).
Key Figure	Ratio of Quantity Delivered Late		This key figure displays the ratio of quantities delivered late. SAP SNC calculates the ratio of quantities delivered late using data from the key figures Total Quantity (2O-QUAN_PRO-QUAN_PRO_UNI) and Quantity Delivered Late. SAP SNC uses the formula quantities delivered late / total quantity.
Key Figure	Quantity Delivered Late		This key figure displays the quantities delivered late. SAP SNC calculates the quantities delivered late by summing the key figures Quantity Delivered Late (Current Period) (2O-QUAN_LACP-QUAN_PRO_UN2) and Quantity Delivered Late (Past Period) (2O-QUAN_LAPP-QUAN_PRO_UN2).
Key Figure	Ratio of Overdelivered Quantity		This key figure displays the ratio of overdelivered quantities. SAP SNC calculates the ratio of overdelivered quantities using data from the key figures Total Quantity (2O-QUAN_PRO-QUAN_PRO_UNI) and Overdelivered Quantity (2O-QUAN_OVER-QUAN_PRO_UN2). SAP SNC uses the formula overdelivered quantities / total quantity.
Key Figure	Overdelivered Quantity	`2O-QUAN_OVER-QUAN_PRO_UN2`
Key Figure	Total Quantity	`2O-QUAN_PRO-QUAN_PRO_UNIT`