Open Production Order Stock from the Previous Week
Open Production Order Stock from the Previous Week
Technical name: 0PP_C01_Q0001
Use
This query provides information about the backlogged order quantities and values of the previous seven days.
Analysed are the open quantities (in base unit of measure) and the open value (in local currency). 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 |
Current calendar day – 7 days until current calendar day |
|
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) |
|
0BO_QTY |
Open quantity Unit InfoObjekt: 0BASE_UOM Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Displays the open quantity of the backorders. |
|
0BO_VAL |
Open value Unit InfoObject: 0LOC_CURRCY Aggregational behavior: Summation Exception aggregation: Last value Reference characteristic: 0CALDAY Displays the open value of the backorders. |