The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description

IMEP - Manufacturing Consolidated Report (Core Query)

Technical NameBW_QRY_MVCOPP01_0008

Application

IMEP - Manufacturing

Info-provider

MVCOPP01

Usage type

Execution in workbook

Expected users

Ex: GBU zone and WW controllers

Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

TabScreenshotComment
Display

 
Rows/Columns

 
Value Display

 
Planning

 
Extended

 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

FISCPER003

0FISCPER

SelectionOption/Mandatory/ManualEntry

Yes

Explanation for the use of this variable

V_0CCURENCY_00020CURRENCYSingleValue/Mandatory/ManualEntryYes 
VBASE_UOM_050BASE_UOMSingleValue/Mandatory/ManualEntryYesDefault value = TO
V_U_AIUNIT_0001U_AIUNITSingleValue/Mandatory/ManualEntryYes 
V_AUT_C_PLANT_0001C_PLANTSelectionOption/Optional/AuthorizationNo 
V_C_COORDER_0001C_COORDERSelectionOption/Optional/ManualEntryNo 
V_C_ORIGIN_0001C_ORIGINSelectionOption/Optional/ManualEntryNo 
V_0COSTELMNT_00010COSTELMNTSelectionOption/Optional/ManualEntryNo 
DISPO_01C_DISPOSelectionOption/Optional/ManualEntryNo 
V_C_FEVOR_0001C_FEVORSelectionOption/Optional/ManualEntryNo 
ZV_0PROFIT_CTR0PROFIT_CTRSelectionOption/Optional/ManualEntryNo 
C_COSTCC_COSTCTRSelectionOption/Optional/ManualEntryNo 
V_0ACTTYPE_00010ACTTYPESelectionOption/Optional/ManualEntryNo 
V_CORDTYP_0001C_CORDTYPSelectionOption/Optional/ManualEntryNo 
V_C_MAT_TYP_0001C_MAT_TYPESelectionOption/Optional/ManualEntryNo 
C_COMPCDE_04C_COMPCDESelectionOption/Optional/AuthorizationNo 
C_COMPCDE__C_PZONE_0001C_COMPCDE__C_PZONESelectionOption/Optional/ManualEntryNo 
SOO_C_MATNR2_0001C_MATNR2SelectionOption/Optional/ManualEntryNo 
V_C_ZZRCSIT_0001C_ZZRCSITSelectionOption/Optional/ManualEntryNo 
V_C_KSTRG2_0001C_KSTRG2SelectionOption/Optional/ManualEntryNo 
V_CPFCTR1_2_0008CPFCTR1_2SelectionOption/Optional/AuthorizationNo 
V_C_EXACBMO_0001C_EXACBMOSingleValue/Optional/ManualEntryNo 

Variable Sequence

Filters

ObjectFilter ValueExplanation
Fiscal Year Variant (0FISCVARNT)Calendar year, 4 spec. periods (K4)Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

 

DescriptionType

Restricted

or

Calculated KeyFigure

Calculation RuleConversionComments

Delivered Quantity (&VT_U_UNITUM_0001&)

Display Ratio K_DELQTQCT_MATNR5 

Tot.Cst Deliv. (&VT_0CURRENCY_0001&)

Display Ratio K_TCSTDELCTK_CAR3FI 

Produced Quantity (&VT_U_UNITUM_0001&)

Display Ratio K_PRODQTQCT_MATNR5 

Total Order Qty (&VT_U_UNITUM_0001&)

Display Ratio K_PO_QTYQCT_MATNR5 

Total Actual Qty (&VT_U_UNITUM_0001&)

Display Ratio K_ACT_QTYQCT_MATNR5 

Produced costs (&VT_0CURRENCY_0001&)

Display Ratio K_PRODCSCTK_CAR3FI 

Actual Qty in AI (&VT_U_AIUNIT_0001&)

Display Ratio K_AQTY_AIQCT_MATNR6 

Qty Produced in AI (&VT_U_AIUNIT_0001&)

Display Ratio K_QTYPRAIQCT_MATNR6 

Actual Costs (&VT_0CURRENCY_0001&)

Display Ratio K_ACT_CSTCTK_CAR3FI 

Std Qty SCE (&VT_U_UNITUM_0001&)

Display Ratio K_STQTSCEQCT_MATNR5 

Std Cost SCE (&VT_0CURRENCY_0001&)

Display

 Ratio K_STCSSCECTK_CAR3FI 

QUS

BW_CKF_MVCOPP01_0009

DisplayCalculated

  

QUR

BW_CKF_MVCOPP01_0008

 

DisplayCalculated

  

CUS

BW_CKF_MVCOPP01_0010

DisplayCalculated

  

CUR

BW_CKF_MVCOPP01_0011

DisplayCalculated

  

AUQ AI

BW_CKF_MVCOPP01_0012

DisplayCalculated

  

SUQ AI

BW_CKF_MVCOPP01_0013

DisplayCalculated

  

ML Pr UR

BW_CKF_MVCOPP01_0014

DisplayCalculated

  

ML Pu UR

BW_CKF_MVCOPP01_0015

DisplayCalculated

  

ML Cost

BW_CKF_MVCOPP01_0016

DisplayCalculated

  

ML Price

BW_CKF_MVCOPP01_0017

DisplayCalculated

  
SCE StdQ.AI (&VT_U_AIUNIT_0001&)Display Ratio K_SCEQ_AIQCT_MATNR6 
SCE Theo. Qty in AI (&VT_U_AIUNIT_0001&)Display Ratio K_SCETQAIQCT_MATNR6 
Target Quantity SCE (&VT_U_UNITUM_0001&)Display K_TSCEQTYQCT_MATNR5 
Target Quantity PO (&VT_U_UNITUM_0001&)Display K_TPOQTYQCT_MATNR5 
Target Cost SCE (&VT_0CURRENCY_0001&)Display K_TSCECSTCTK_CAR3FI 
Target Cost PO (&VT_0CURRENCY_0001&)Display K_TPOCSTCTK_CAR3FI 
Material Ledger Cost (&VT_0CURRENCY_0001&)Display K_MLWRTCTK_CAR3FI 
VC PO Variance (&VT_0CURRENCY_0001&)Display K_V_VCPOCTK_CAR3FI 
FC PO Variance (&VT_0CURRENCY_0001&)Display K_V_FCPOCTK_CAR3FI 
DEP PO Variance (&VT_0CURRENCY_0001&)Display K_V_DEPPOCTK_CAR3FI 
DEP F01 Variance (&VT_0CURRENCY_0001&)Display K_V_DEPF1CTK_CAR3FI 
Lot SizeDisplay 0LOTSIZE  
      
      
      
      

Key Figure 1

Description

Text/name of the variable and explanation

Calculation rule detail

Quantity x Price

Text Replacement Variable

If relevant, add the text replacement rule used for the key figure

Currency Conversion

Exchange Rate Type : Ex ZRH0

Currency : Variable, or fixed currency used

Time Reference : Current date / Based on infoobject X / Variable

Unit Conversion

Unit : Variable or fixed unit

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
Free/Row/Column 0COUNTRY Country Country of the customer
    
    

Cells

If you have 2 structures and special cells calculations, explain here.

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
Ex : Excl if <=10 Yes/No Sales Value Greater Than 10 Ex : All Independently
      

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10