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 PF1 (WB)

Technical Name

Workbook:

BW_WBK_CO_0017

Query:

BW_QRY_MVCOPP01_0008

IMEP - Manufacturing Consolidated Report (Core Query)

Application

IMEP

Info-provider

MVCOPP01

Usage type

Workbook Execution

Expected users


Workbook/Query General Description

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)

Key figures

Sheet Product Quantity

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Produced QuantityDisplay Ratio K_PRODQTQCT_MATNR5 

Sheet Product Costs

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Material Ledger Cost (EUR)Display Ratio K_MLWRTCTK_CAR3FI 

Sheet Detail Costs

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Material Ledger Cost (EUR)Display Ratio K_MLWRTCTK_CAR3FI 

Sheet Var Fix Dep

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
VC PO Variance Display Ratio K_V_VCPOCTK_CAR3FI 
FC PO Variance Display Ratio K_V_FCPOCTK_CAR3FI 
DEP PO Variance Display Ratio K_V_DEPPOCTK_CAR3FI 

Sheet Profit Center

Description
Type

Restricted

or

Calculated KeyFigure

Calculation Rule
Conversion
Comments
Produced QuantityDisplay Ratio K_PRODQTQCT_MATNR5 
Material Ledger Cost (EUR)Display Ratio K_MLWRTCTK_CAR3FI 

Characteristics

Sheet Product Quantity

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/Period 
ColumnCPFCTR1_2BFC Global Business Unit 
ColumnC_INDEX1Index 1Filter : Produced Material
RowC_PLANTPlant 
RowC_EDITICode edition 

Sheet Product Costs

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/Period 
ColumnCPFCTR1_2BFC Global Business Unit 
ColumnC_INDEX1Index 1Filter : Produced Material
RowC_PLANTPlant 
RowC_EDITICode edition 

Sheet Detail Costs

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/Period 
ColumnCPFCTR1_2BFC Global Business Unit 
FilterC_INDEX1Index 1

Filter :

BOM Component

Subcontracting

Activity Type

SFK/direct Posting

RowC_PLANTPlant 
RowC_EDITICode edition 
RowC_KSTRG3Cost Price Code 

Sheet Var Fix Dep

LocationInfo-object NameInfo-object TextExplanation (if needed)
Column0FISCPERFiscal Year/Period 
ColumnCPFCTR1_2BFC Global Business Unit 
FilterC_INDEX1Index 1

Filter :

BOM Component

Subcontracting

Activity Type

SFK/direct Posting

RowC_PLANTPlant 
RowC_EDITICode edition 
RowC_KSTRG3Cost Price Code 
RowC_MATNR2Material 

Sheet Profit Center

LocationInfo-object NameInfo-object TextExplanation (if needed)
ColumnCPFCTR1_2BFC Global Business Unit
ColumnC_INDEX1Index 1Filter : Produced Material
Row0PROFIT_CTRProfit Center 

Cells

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
      

Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No 
      
  • No labels