No need, done in adso ABCOMS01 with conversion type CTK_MODELS (Exchange rate type M, currency target from C_COMPCDE, time ref = end of month 0CALMONTH).

No need, done in adso ABCOMS01 with conversion type CTK_MODELS (Exchange rate type M, currency target from C_COMPCDE, time ref = end of month 0CALMONTH).



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

Stock Margin Elimination report 2 (Core Query)

Technical NameBW_QRY_CPCOMS01_0002

Application

RTR - MS

Info-provider

CPCOMS01

Usage type

Workbook BW_WB_MS_0001

Expected users

 

Workbook/Query General Description

Display tock margin elimination calculated in ADSO ABCOMS01.

General parameters

Global properties

TabScreenshotComment
Display


Rows/Columns


Value Display



Planning


Extended


Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

0I_CMNTH

0CALMONTH

Manual Input - Interval

Yes


V_C_COMPCDE_C_AUTHMA_002C_COMPCDE_C_AUTHMAAuthorization - Selection OptionNo
V_COMPPRS_0006C_COMPPRSAuthorization - Selection OptionNo
V_C_COMPCDE__C_MNGAREA_0006C_COMPCDE__C_MNGAREAAuthorization - Selection OptionNo
V_C_COMPCDE_0001C_COMPCDEManual Input - Selection OptionNo
C_PLANT02C_PLANTManual Input - Selection OptionNo
SOO_C_MATNR2_0001C_MATNR2Manual Input - Selection OptionNo
V_LOGSYS_00060LOGSYSManual Input - Selection OptionNo

Variable Sequence

Filters

ObjectFilter ValueExplanation
Material Type

<> ZHIB

<> ZRES

<> ZERS


InfoProvider

= ABCOMS01

= ABCOMS02

= ABCOMS03

= ABCOMS04


Add screenshot if relevant

Key figures

The majority of key figures are already calculated in ADSO ABCOMS01 (see details here).

Key Figures

Details for key figures calculated in composite provider and used in query.

Key FigureTextFormula
BW_RKF_CPCOMS01_0004Counter Logistic

BW_RKF_CPCOMS01_0005Counter Transit

BW_CKF_CPCOMS01_0060Reference Month Logistic"[V_CALMON_SHI_L] Reference Month Logistic"
BW_CKF_CPCOMS01_0062Reference Month Transit"[V_CALMON_SHI_W] V_CALMON_SHI_W"
BW_CKF_CPCOMS01_0086CP IM ManPlant LogisticNDIV0('4CPCOMS01-K_CP_LOG_MP' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0085CP IM Plant LogisticNDIV0('4CPCOMS01-K_CP_LOG_P' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0084CNP IM ManPlant LogisticNDIV0('4CPCOMS01-K_CNP_LOG_MP' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0083CNP IM Plant LogisticNDIV0('4CPCOMS01-K_CNP_LOG_P' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0082AMO IM ManPlant LogisticNDIV0('4CPCOMS01-K_AMO_LOG_MP' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0081AMO IM Plant LogisticNDIV0('4CPCOMS01-K_AMO_LOG_P' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0080CP IM ManPlant TransitNDIV0('4CPCOMS01-K_CP_TRA_MP' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0079CP IM Plant TransitNDIV0('4CPCOMS01-K_CP_TRA_P' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0078CNP IM ManPlant TransitNDIV0('4CPCOMS01-K_CNP_TRA_MP' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0077CNP IM Plant TransitNDIV0('4CPCOMS01-K_CNP_TRA_P' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0076AMO IM ManPlant TransitNDIV0('4CPCOMS01-K_AMO_TRA_MP' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0075AMO IM Plant TransitNDIV0('4CPCOMS01-K_AMO_TRA_P' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0074Freight - ManPlant - LogisticNDIV0('4CPCOMS01-K_FRG_LOG_MP' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0073Freight - Plant - LogisticNDIV0('4CPCOMS01-K_FRG_LOG_P' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0072Freight - ManPlant - TransitNDIV0('4CPCOMS01-K_FRG_TRA_MP' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0071Freight - Plant - TransitNDIV0('4CPCOMS01-K_FRG_TRA_P' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0070Duty - ManPlant - LogisticNDIV0('4CPCOMS01-K_DUT_LOG_MP' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0069Duty - Plant - LogisticNDIV0('4CPCOMS01-K_DUT_LOG_P' / "[BW_RKF_CPCOMS01_0004] Counter Logistic")
BW_CKF_CPCOMS01_0068Duty - Plant - TransitNDIV0('4CPCOMS01-K_DUT_TRA_P' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0067Duty - ManPlant - TransitNDIV0('4CPCOMS01-K_DUT_TRA_MP' / "[BW_RKF_CPCOMS01_0005] Counter Transit")
BW_CKF_CPCOMS01_0066LotSize (Plant)'4CPCOMS01-LOTSIZE_IT_P' / 'K_COUNTER'
BW_CKF_CPCOMS01_0065LotSize (ManPlant)'4CPCOMS01-LOTSIZE_IT' / 'K_COUNTER'


Text Replacement Variable

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

Currency Conversion

No need, done in adso ABCOMS01 with conversion type CTK_MODELS (Exchange rate type M, currency target from C_COMPCDE, time ref = end of month 0CALMONTH).

Unit Conversion

No need, done in adso ABCOMS01 with conversion type UOM_MATNR2.

Characteristics

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