| Table of Contents |
|---|
Objective
...
The objective is to have Freights and Duties Costs query. This query will be used with Qlik.
Roles & Access
Roles and access
...
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M80 | Forward Looking ICM - Logistic Cost | Role Menu |
| ZBI_RCS_CO_A08 | Forward Looking ICM - Logistic Cost | Authorization objects |
Authorization variables
List of authorization objects variables mandatory for the application.
| Authorization objectExplanationvariables | Object |
|---|---|
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA |
| V_C_PLANT_0012 | C_PLANT |
| V_CPFCTR1_2_0006 | CPFCTR1_2 |
Dataflow overview
...
Source Layer
As showed in the data flow above the data source data is a BW Query BW_QRY_MVCOPA01_0010 - FL ICM Freight and Duties.
Description | FL |
|---|
ICM Freight and duties (core query) |
| Technical Name |
|---|
| BW_ |
| QRY_ |
| MVCOPA01_ |
| 0010 | |
Application | COPC |
|---|---|
Info-provider |
MVCOPA01 |
Usage type |
|---|
Data Source | |
Expected users |
|---|
Global properties
xxxxxxx
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|
V_C_PLANT_C_AUTHMA_002
Authorization
Yes
Variable Sequence
Filters
...
Variable Sequence
N/A
Filters
Key figures
...
...
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
...
Info providers and objects loaded
Infoproviders:
APCOPC05
ABCOPC06
Loading frequency
...
Virtual Layer
Calculation Views
CV_FMCO_LOG_FREIGHT
In this Calculation View, data from the Infoprovider APCOPC05 are extracted the Freight costs for last 3, 6, 9 and 12 months.
At each projection step (PJ_3M, PJ_6M, PJ_9M, PJ_12M), a value for the "SOURCE" field is attributed: F03, F06, F09 or F12.
All these values are aggregated into the last semantic layer of FREIGHT
...
.
CV_FMCO_LOG_DUTIES
In this Calculation View, data from the Infoprovider APCOPC05 are extracted the Duties costs for last 3, 6, 9 and 12 months.
At each projection step (PJ_3M, PJ_6M, PJ_9M, PJ_12M), a value for the "SOURCE" field is attributed: D03, D06, D09 or D12.
All these values are aggregated into the last semantic layer of DUTIES.xxxxxxxx
CV_FMCO_LOG_FREIGHT_DUTIES
xxxxxxxx
In this Calculation View, data from CV_FMCO_LOG_FREIGHT_FREIGHT and CV_FMCO_LOG_FREIGHT_DUTIES
...
xxxxxxxx
Composite Providers
are united into UN_FRT_FUT step.
In Join_1 step is to identify the reference month of the snapshot, because based on it we will repeat the costs 12 months ahead in order to make a forecast
In JO_PROJECT step indicates the number of months ahead that need to be projected.
In FREIGHT_DUTIES step all these values are aggregated into the last semantic layer of FREIGHT_DUTIES.
Composite Providers
CPCOPC09
CPCOPC07
Reporting (BW Query for
...
Qlik)
Description | FL - Logistic Cost |
|---|---|
| Technical Name | QV_WBW_QRY_CPCOPC09_0001 |
Application | COPC |
Info-provider | CPCOPC07CPCOPC09 |
Usage type | Qlikview Qlik Source |
Expected users |
Global properties
xxxxxx
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| V_C_PLANT0LOGSYS_0001 | 0LOGSYS | SelectOption | No | ||||||||||
| V_C_ | AUTHMAPLANT_ | 0020012 | C_PLANT__C_AUTHMA | Authorization with input | Yes | No | |||||||
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Authorization with input | ZINSPLOT | 0INSP_LOT | SelectOption | No | |||||||
| 0CALMONTH_0006 | 0CALMONTH | V_C_MATNR2_0010 | C_MATNR2 | SelectOption | No | ||||||||
| V_C_PLANTAUTHMA_370001 | C_PLANT | SelectOption | No | ENSTE_01 | __C_ENSTEHDAUTHMA | SelectOptionAuthorization | No | ZPLNNR | 0PLNNR | SelectOption | No | Yes | |
Variable Sequence
...
Filters
...
Key figures
Characteristics
...
Cells
N/A
Conditions
N/A
Exceptions
...