Objective
The objective is to have Freights and Duties Costs query. This query will be used with Qlik.
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| 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 variables mandatory for the application.
| Authorization variables | 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 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
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
Variable Sequence
N/A
Filters
Key figures
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
N/A
Dependencies with other applications
There is a dependency from MVCOPA01 data flow.
Data loadings
Info providers and objects loaded
Infoproviders:
APCOPC05
Loading frequency
Daily
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.
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 |
Global properties
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| V_0LOGSYS_0001 | 0LOGSYS | SelectOption | No | |
| V_C_PLANT_0012 | C_PLANT | Authorization with input | No | |
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Authorization with input | No | |
| 0CALMONTH_0006 | 0CALMONTH | SelectOption | No | |
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA | Authorization | Yes | |
Variable Sequence
Filters
Key figures
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
N/A