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

BW - IMEP - GBU Conso view workbook WP1 (WB)

Technical Name

Workbook:

BW_WBK_CO_0018

Query:

BW_QRY_MVCOPP01_0008

IMEP - Manufacturing Consolidated Report (Core Query)

Application

IMEP

Info-provider

MVCOPP01

Usage type

Workbook Execution

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

Same properties for all sheets

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

FISCPER003

0FISCPER

SelectionOption/Mandatory/ManualEntry

Yes

 
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

Sheet Production Quantity

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Delivered QuantityDisplay Ration K_DELQTQCT_MATNR5 
Tot.Cst DelivDisplay Ratio K_TCSTDELCTK_CAR3FI 
Produced QuantityDisplay Ratio K_PRODQTQCT_MATNR5 

Sheet Production Cost

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments

Total Actual Qty

Display Ratio K_ACT_QTYQCT_MATNR5 

Produced costs

Display Ratio K_PRODCSCTK_CAR3FI 

Actual Qty in AI

Display Ratio K_AQTY_AIQCT_MATNR6 

Qty Produced in AI

Display Ratio K_QTYPRAIQCT_MATNR6 

Actual Costs

Display Ratio K_ACT_CSTCTK_CAR3FI 

Sheet Standards Consumptions Costs

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments

Std Qty SCE

Display Ratio K_STQTSCEQCT_MATNR5 

AUQ AI

BW_CKF_MVCOPP01_0012

DisplayCalculated

  

QUS

BW_CKF_MVCOPP01_0009

DisplayCalculated

  

QUR

BW_CKF_MVCOPP01_0008

 

DisplayCalculated

  

CUS

BW_CKF_MVCOPP01_0010

DisplayCalculated

  

CUR

BW_CKF_MVCOPP01_0011

DisplayCalculated

  

SUQ AI

BW_CKF_MVCOPP01_0013

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 

Sheet Target Qty&Cost vs VarFi

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Target Quantity SCE (&VT_U_UNITUM_0001&)Display Ratio K_TSCEQTYQCT_MATNR5 
Target Quantity PO (&VT_U_UNITUM_0001&)Display Ratio K_TPOQTYQCT_MATNR5 
Target Cost SCE (&VT_0CURRENCY_0001&)Display Ratio K_TSCECSTCTK_CAR3FI 
Target Cost PO (&VT_0CURRENCY_0001&)Display Ratio K_TPOCSTCTK_CAR3FI 
Material Ledger Cost (&VT_0CURRENCY_0001&)Display Ratio K_MLWRTCTK_CAR3FI 
VC PO Variance (&VT_0CURRENCY_0001&)Display Ratio K_V_VCPOCTK_CAR3FI 
FC PO Variance (&VT_0CURRENCY_0001&)Display Ratio K_V_FCPOCTK_CAR3FI 
DEP PO Variance (&VT_0CURRENCY_0001&)Display Ratio K_V_DEPPOCTK_CAR3FI 

Characteristics

Sheet Production Quantity

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/PeriodCountry of the customer
Row0LOGSYSSource System 
RowC_PLANTPlant 
RowC_MATNR2Material 
Row0UNITUnit of measure 
RowU_UNITUMUnit (local) 
RowC_INDEX1Index 1 
RowC_ORIGINOrigin 

Sheet Production Cost

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/PeriodCountry of the customer
Row0LOGSYSSource System 
RowC_PLANTPlant 
RowC_MATNR2Material 

Sheet Standards Consumptions Costs

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource System 
RowC_PLANTPlant 
RowC_MATNR2Material 
Row0UNITUnit of measure 
RowU_UNITUMUnit (local) 
RowC_INDEX1Index 1 
RowC_ORIGINOrigin 

Sheet Target Qty&Cost vs VarFi

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/PeriodCountry of the customer
Row0LOGSYSSource System 
RowC_PLANTPlant 
RowC_MATNR2Material 
Row0UNITUnit of measure 
RowU_UNITUMUnit (local) 
RowC_INDEX1Index 1 
RowC_ORIGINOrigin 

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