Backlog Overview in Production (SAP Library

Backlog Overview in Production

Technical name: 0PP_C15_Q0002

Use

This query provides information about backorders of the previous week.

The backorders (in days) are analyzed, as well as an explicit counter-based assignment of backlogged orders within

one day
seven days
30 days
and greater than 30 days

The initial status of this query first aggregates across all backlogged orders of the period restricted in the SAP-Exit-Variable (variable Previous Week to characteristic Calendar day (0CALDAY)). Further characteristics, if required, can be added to the drilldown.

Because a daily snapshot of the current backlog situation is loaded into the InfoCube as full update, the key figures must be defined with an exception aggregation via the reference characteristic Calendar day. In this way, for example, you can replace the calendar day in the query with the calendar month and then the latest backlog information of the selected month is displayed.

Free Characteristics

InfoObject	Description
0MATERIAL	Material
0PLANT	Plant
0MATERIAL_0MATL_GROUP	Material group
0MATERIAL_0MATL_TYPE	Material type

Variables Used

Variable	Description
0DAT 0DAT-7	Current calendar day Period of the previous seven days
0S_MAT	Material
0S_MATTP	Material type
0S_PLANT	Plant
0S_MATG	Material group

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CALDAY	Calendar day

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0BACKLOG	Backlog in days Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Period between the planned goods receipt date and the loading date of the InfoCube.
0BACKLOG1	Backlog within one day Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Contains the number of orders whose period between the planned goods receipt date and the loading date of the InfoCube lies within one day.
0BACKLOG2	Backlog within seven days Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Contains the number of orders whose period between the planned goods receipt date and the loading date of the InfoCube lies within seven days.
0BACKLOG3	Backlog within 30 days Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Contains the number of orders whose period between the planned goods receipt date and the loading date of the InfoCube lies within 30 days.
0BACKLOG4	Backlog greater than 30 days Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Contains the number of orders whose period between the planned goods receipt date and the loading date of the InfoCube is greater than 30 days.