Fulfillment Using Deliveries (SAP Library - Sales Scheduling Agreement Processing)

Fulfillment Using Deliveries

Technical name: 0CDS_C02_Q0001

Use

The query analyzes the relative and absolute fulfillment of requested or confirmed quantities through deliveries. It allows you to analyze the under or overdelivery.

Free Characteristics

InfoObject	Description
0COMP_CODE	Company code
0PLANT	Plant
0SHIP_POINT	Shipping point
0SALES_GRP	Sales group
0DIVISION	Division
0SALESORG	Sales organization
0CUST_GROUP	Customer group
0DISTR_CHAN	Distribution channel
0MATL_GROUP	Material group

Variables Used

Variable	Description
0P_PER	Evaluation period Requirements and confirmed requirements with a delivery date that lies within the evaluation period are taken into account. Requirements and confirmed requirements are taken into account if the delivery date lies within the evaluation period.
0I_MATER	Material
0I_CUSTO	Sold-to party

Exceptions

Exceptions, which have different priorities, are used in this query.

Defined Exceptions

Exception	Description
0F_LTOLE	Tolerated underdelivery (request)
0F_UTOLE	Tolerated overdelivery (request)
0F_LTOLC	Tolerated underdelivery (confirmation)
0F_UTOLC	Tolerated overdelivery (confirmation)

Example

You can use exceptions to quickly determine extraordinary deviations in the fulfillment of the requested or confirmed quantities.

If you deliver too much or too little the system issues alerts.

Fulfillment using deliveries in the case of the underdelivery

Requested or confirmed quantity	Delivered quantity	Priority/Alert Level of Deviation
In the evaluation period, your customer requests 100 navigation systems.	You deliver 99 navigation systems.	The result of the evaluation is the alert level (medium), because the delivered quantity does not correspond to the quantity to be delivered; however a deviation of 1% is still within the defined tolerance limit.
	You deliver 89 navigation systems.	The result of the evaluation is the alert level (bad), because the delivery quantity is more than 10% under the quantity to be delivered.

Fulfillment using deliveries in the case of the overdelivery

Requested or confirmed quantity	Delivered quantity	Priority/Alert Level of Deviation
In the evaluation period, your customer requests 100 navigation systems.	You deliver 105 navigation systems.	The result of the evaluation is the alert level (medium), because the delivery quantity does not correspond to the quantity to be delivered; however a deviation of 5% is still below the defined tolerance limit.
	You deliver 125 navigation systems.	The result of the evaluation is the alert level (bad), because the delivered quantity is 25% above the quantity to be delivered, exceeding the tolerated 10%.

For more information about exceptions see Exception Reporting.

For more information about Alert Management and the universal worklist, see the SAP Library for SAP NetWeaver under Using Universal Worklist.

Rows

InfoObject	Description of the InfoObject (or restriction or calculation formulas)
0SOLD_TO	Sold-to party
0MATERIAL	Material
0CALDAY	Calendar day

Columns

InfoObject	Description of the InfoObject (or restriction or calculation formulas)
Relative over/underdelivery of the confirmation	Calculation: 0APO_DELQTY (Delivery quantity) = ¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾ 0APO_ORCON (Original confirmed quantity)
Absolute over/underdelivery of the confirmation	= 0APO_DELQTY ‑ 0APO_ORCON (Delivery quantity minus original confirmed quantity)
Absolute over/underdelivery of the requirement	= 0APO_DELQTY – 0APO_ORREQ (Delivery quantity minus original requested quantity)
Relative over/underdelivery of the requirement	0APO_DELQTY (Delivery quantity) = ¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾¾ 0APO_ORREQ (Original requested quantity)

Background documentation

Note that the columns can only contain cumulated values. The values are cumulated using the property Cumulated of the characteristic Calendar Day.

Example

You can find an example in the analysis scenario Sales Scheduling Agreement Processing.