...
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
...
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 |
...
Info providers and objects loaded
Infoproviders:
APCOPC05
Loading frequency
Daily
Virtual Layer
...
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.
CV_FMCO_LOG_FREIGHT_DUTIES
...
In this Calculation View, data from CV_FMCO_LOG_FREIGHT_FREIGHT and CV_FMCO_LOG_FREIGHT_DUTIES 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
Reporting (BW Query for Qlik)
...
Description | FL - Logistic Cost |
|---|---|
| Technical Name | QV_BW_QRY_CPCOPC09_0001 |
Application | COPC |
Info-provider | CPCOPC09 |
Usage type | Qlik Source |
Expected users |
...
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| V_0LOGSYS_0001 | 0LOGSYS | SelectOption | No | |
| V_C_PLANT_PLANT020012 | C_PLANT | SelectOptionAuthorization with input | No | |
| V_CPFCTR1_2_00010006 | CPFCTR1_2 | SelectOptionAuthorization with input | No | |
| 0CALMONTH_0006 | 0CALMONTH | SelectOption | No | |
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA | Authorization | Yes | |
Variable Sequence
Filters
Key figures
Characteristics
...