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

Screen - Logistic Costs (QV)

Technical NameQV_BW_QRY_CPCOCT02_0001

Application

Screen Logistic

Info-provider

CPCOCT02

Usage type

Qlik

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

TabScreenshotComment
Display


Rows/Columns


Value DisplayInsert screenshot
Planning


Extended

Variables

Definitions



Variable Name

Info-object

Selection Type

Required

Description/Explanation

V_IPFISCPERFR

0FISCPER

Single

Yes

Input parameter Fiscper From propagated till the bottom of the calculation view flow (filter in projections)

V_IPFISCPERTO

0FISCPER

Single

Yes

Input parameter Fiscper to propagated till the bottom of the calculation view flow (filter in projections)

V_C_MGN_ACC_0005C_MGN_ACCSelect OptionNoBFC Account
V_C_CTMCPKG_0001C_CTMCPKGSelect OptionNoTaxonomie Macro Package
V_C_CTPKG_0001C_CTPKGSelect OptionNoTaxonomie Package

Auth. Scope based on Comp. Code

V_C_COMPCDE__C_AUTHMA_0001

C_COMPCDE__C_AUTHMA

Select Option

No

Authorization

V_IP_EXCH_RATE_0020RTYPESingleYesInput parameter Exchange Rate used in the semantic layer of the calculation views connected to coimposite provider
V_IP_TGT_CURR_0020CURRENCYSingleYesInput parameter Target currency used in the semantic layer of the calculation views connected to coimposite provider
C_COMPCDE_06C_COMPCDESelect OptionNoInput parameter Company Code propagated till the bottom of the calculation view flow (filter in projections)

BFC GBU

V_CPFCTR1_2_0023

CPFCTR1_2

Select Option

No

Authorization BFC GBU

V_C_CTOFLOW_0002C_CTOFLOWMultiple Single ValuesNoScreen source flow


Variable Sequence

Add screenshot

Filters

ObjectFilter ValueExplanation
C_COMPCDEExclusion : 6354this company leads to data issue
4CPCOCT02-IP_STREAMEqual to : FMCO_CO_CTIP parameter Stream value for global filter accesses


Key figures


AMOUNTLCIF("[V_CONSOV_0001] Conso. view? (1=Yes/0=No)" ==
1; "[4CPCOCT02-CK_LOC_CONS] Actual Origin - Conso view (Local)"; "[4CPCOCT02-AMOUNT] Actual Origin - Legal view (Local)")
AMOUNTGTIF("[V_CONSOV_0001] Conso. view? (1=Yes/0=No)" ==
1; "[4CPCOCT02-CK_TGT_CONS] Actual Origin - Conso view (Conv)"; "[4CPCOCT02-CK_TGT_CURR] Actual Origin - Legal view (Conv)")
BW_CKF_CPCOCT02_0001'4CPCOCT02-CK_SAL_QTY' with conversion type CNV_MATNR5 target unit = VKG
BW_CKF_CPCOCT02_0011'4CPCOCT02-CK_SAL_QTY_P' with conversion type CNV_MATNR5 target unit = VKG

BW_CKF_CPCOCT02_0004

BW_CKF_CPCOCT02_0002

BW_CKF_CPCOCT02_0008


Embedded Exception of aggregation in order to count properly  'K_GRWTVKG' Gross Weight

BW_CKF_CPCOCT02_0007

BW_CKF_CPCOCT02_0006

BW_CKF_CPCOCT02_0005

BW_CKF_CPCOCT02_0009

Embedded Exception of aggregation in order to count properly  'K_NTWTVKG' Gross Weight

C

Currency Conversion


Unit Conversion

Unit : Variable or fixed unit

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