Versions Compared

Old Version 4

changes.mady.by.user Gaetan Beurrier

Saved on

compared with

New Version Current

changes.mady.by.user Gaetan Beurrier

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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


Table of Contents
maxLevel3

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