Start of Content Area

Query Delivery Date Variance  Locate the document in its SAP Library structure

Technical name: 0PUR_C01_Q0009

Based on InfoCube: 0PUR_C01

Use

This query enables you to examine the percentage variances between desired and actual delivery dates.

Delivery date variances are rated with the aid of a grid consisting of various windows (time intervals). The latter are defined by setting interval limits in Customizing for the Logistics Information System (LIS) (Logistics Data Warehouse ® Updating ® Updating Control ® Settings for Purchasing ® Change Period Split for On-Time Delivery Performance). You can define a total of four interval limits, so that altogether five classes are available for rating purposes. The grid is defined in dependence on the purchasing organization.

Note

If you wish to compare delivery date variances on a cross-purchasing-organization basis, you must have previously defined the grid in Customizing in exactly the same way for each of the individual purchasing organizations concerned.

Filter

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0VTYPE

Value type (=ACTUAL)

Free Characteristics

InfoObject

Description

0CALMONTH

Calendar year/month

0MATERIAL

Material

0PLANT

Plant

Rows

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0VENDOR

Vendor

Columns

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0DELDATER1_%

Proportion delivery date variance 1

0DELDATER2_%

Proportion delivery date variance 2

0DELDATER3_%

Proportion delivery date variance 3

0DELDATER4_%

Proportion delivery date variance 4

0DELDATER5_%

Proportion delivery date variance 5

0DEL_DT_VR1

Delivery date variance 1

0DEL_DT_VR2

Delivery date variance 2

0DEL_DT_VR3

Delivery date variance 3

0DEL_DT_VR4

Delivery date variance 4

0DEL_DT_VR5

Delivery date variance 5

 

The following additional queries are available for purchasing data: