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 - Industrial Workbook WP1 (WB)

Technical Name

Workbook:

BW_WBK_CO_0015

Query:

BW_QRY_MVCOPP01_0002

IMEP - Manufacturing Local Report (Core Query)

Application

IMEP - Manufacturing

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

FISCP003

0FISCPERSelectionOption/Mandatory/ManualEntry

Yes

 
C_COMPCDE_04C_COMPCDESelectionOption/Optional/AuthorizationNo 
V_AUT_C_PLANT_0001C_PLANTSelectionOption/Optional/AuthorizationNo 
V_C_MAT_TYP_0001C_MAT_TYPESelectionOption/Optional/ManualEntryNo 
SOO_C_MATNR2_0001C_MATNR2SelectionOption/Optional/ManualEntryNo 
ZV_0PROFIT_CTR0PROFIT_CTRSelectionOption/Optional/ManualEntryNo 
DISPO_01C_DISPOSelectionOption/Optional/ManualEntryNo 
C_COSTCC_COSTCTRSelectionOption/Optional/ManualEntryNo 
V_C_COORDER_0001C_COORDERSelectionOption/Optional/ManualEntryNo 
C_COMPCDE__C_PZONE_0001C_COMPCDE__C_PZONESelectionOption/Optional/ManualEntryNo 
V_CORDTYP_0001C_CORDTYPSelectionOption/Optional/ManualEntryNo 
V_0ACTTYPE_00010ACTTYPESelectionOption/Optional/ManualEntryNo 
V_C_ORIGIN_0001C_ORIGINSelectionOption/Optional/ManualEntryNo 
V_0COSTELMNT_00010COSTELMNTSelectionOption/Optional/ManualEntryNo 
V_C_FEVOR_0001C_FEVORSelectionOption/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/AuthorizationNo 

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 Detailed Data

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Total Actual QtyDisplay Ratio K_ACT_QTY  
Std Qty SCEDisplay Ratio K_STQTSCE  
VarQtySCE/ActDisplay Ratio K_VQTSCEA  
Actual CostsDisplay Ratio K_ACT_CST  
VarCstPO/ActDisplay Ratio K_VCSPOA  
DeliveredQuantityDisplay Ratio K_DELQT  
Produced QuantityDisplay Ratio K_PRODQT  
Std Cost SCEDisplay Ratio K_STCSSCE  

QUS

BW_CKF_MVCOPP01_0009

 Calculated

  

QUR

BW_CKF_MVCOPP01_0008

DisplayCalculated

  

CUS

BW_CKF_MVCOPP01_0010

DisplayCalculated

  

CUR

BW_CKF_MVCOPP01_0011

DisplayCalculated

  
Target Quantity SCEDisplay Ratio K_TSCEQTY  
Target Quantity PODisplay Ratio K_TPOQTY  
VC PO VarianceDisplay Ratio K_V_VCPO  
FC PO VarianceDisplay Ratio K_V_FCPO  
DEP PO VarianceDisplay Ratio K_V_DEPPO  
Lot SizeDisplay Ratio 0LOTSIZE  
VarQtyPO/ActDisplay Ratio K_VQTPOA  
VarCstSCE/AcDisplay Ratio K_VCSSCEA  

Sheet Detailed Product Cost Local

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Total Actual QtyDisplay Ratio K_ACT_QTY  
Actual CostsDisplay Ratio K_ACT_CST  
Std Qty SCEDisplay Ratio K_STQTSCE  
Std Cost SCEDisplay Ratio K_STCSSCE  

QUS

BW_CKF_MVCOPP01_0009

 Calculated

  

QUR

BW_CKF_MVCOPP01_0008

DisplayCalculated

  

CUS

BW_CKF_MVCOPP01_0010

DisplayCalculated

  

CUR

BW_CKF_MVCOPP01_0011

DisplayCalculated

  
VC PO VarianceDisplay Ratio K_V_VCPO  
FC PO VarianceDisplay Ratio K_V_FCPO  
DEP PO VarianceDisplay Ratio K_V_DEPPO  
VarCstSCE/AcDisplay Ratio K_VCSSCEA  
YTD Total Actual QtyDisplay 

  
YTD Actual CostsDisplay 

  
YTD Std Qty SCEDisplay 

  
YTD Std Cost SCEDisplay 

  
YTD QUSDisplay 

  
YTD QURDisplay 

  
YTD CUSDisplay 

  
YTD CURDisplay 

  
YTD VC PO VarianceDisplay 

  
YTD FC PO VarianceDisplay 

  
YTD DEP PO VarianceDisplay 

  
YTD VarQtySCE/ActDisplay 

  

Sheet Detailed Product Cost Local REP

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Total Actual QtyDisplay Ratio K_ACT_QTY  
Actual CostsDisplay Ratio K_ACT_CST  
Std Qty SCEDisplay Ratio K_STQTSCE  
Std Cost SCEDisplay Ratio K_STCSSCE  

QUS

BW_CKF_MVCOPP01_0009

 Calculated

  

QUR

BW_CKF_MVCOPP01_0008

DisplayCalculated

  

CUS

BW_CKF_MVCOPP01_0010

DisplayCalculated

  

CUR

BW_CKF_MVCOPP01_0011

DisplayCalculated

  
VC PO VarianceDisplay Ratio K_V_VCPO  
FC PO VarianceDisplay Ratio K_V_FCPO  
DEP PO VarianceDisplay Ratio K_V_DEPPO  
VarCstSCE/AcDisplay Ratio K_VCSSCEA  

Sheet Origin Consumption

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Total Actual QtyDisplay Ratio K_ACT_QTY  
Actual CostsDisplay Ratio K_ACT_CST  
Std Qty SCEDisplay Ratio K_STQTSCE  
Std Cost SCEDisplay Ratio K_STCSSCE  

QUS

BW_CKF_MVCOPP01_0009

 Calculated

  

QUR

BW_CKF_MVCOPP01_0008

DisplayCalculated

  

CUS

BW_CKF_MVCOPP01_0010

DisplayCalculated

  

CUR

BW_CKF_MVCOPP01_0011

DisplayCalculated

  
VarQtySCE/ActDisplay Ratio K_VQTSCEA  
VarCstSCE/AcDisplay Ratio K_VCSSCEA  

Characteristics

Sheet Detailed Data

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource SystemCountry of the customer
RowC_PLANTPlant 
RowC_COSTCTRCost Center 
Row0PROFIT_CTRProfit Center 
RowC_MATNR2Material 
RowC_VALCLASValuation class 
Row0COSTELMNTCost Element 
RowC_COKSNBCO key subnumber 
RowC_DISPOMRP controller 
Row0CCOMPGRPCost Component Group 
Row0COSTCOMPCost Component (initial) 
RowC_MATPNT2__C_LIP0GRLIP00 product group 
RowC_INDEX1Index 1 
Row0UNITUnit of measure 
RowC_MDV01Production line 
RowC_MATPNT2__C_PRODGRProduct group 
Row0ACTTYPEActivity Type 
RowC_COORDEROrder number 
RowC_ORIGINOrigin 
Row0CURRENCYCurrency 
RowC_PRVERPOProduction Version P 
RowC_PVERSCEProduction version S 
RowC_MATNR2__C_MAT_TYPMaterial type 

Sheet Detailed Product Cost Local

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource SystemCountry of the customer
RowC_PLANTPlant 
RowC_MATNR2Material 
RowC_INDEX1Index 1 
RowC_ORIGINOrigin 
Column0FISCPERFiscal Year/Period 

Sheet Detailed Product Cost Local REP

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource SystemCountry of the customer
RowC_PLANTPlant 
RowC_MATNR2Material 
RowC_INDEX1Index 1 
RowC_ORIGINOrigin 
Column0FISCPERFiscal Year/Period 

Sheet Origin Consumption

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource SystemCountry of the customer
RowC_PLANTPlant 
RowC_MATNR2Material 
Row0UNITUnit of measure 
RowC_COORDEROrder number 
RowC_ORIGINOrigin 
Row0CURRENCYCurrency 
RowC_PRVERPOProduction Version P 
RowC_PVERSCEProduction version S 

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