| Table of Contents |
|---|
General presentation
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
...
Functional and Technical Rules
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
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
...
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 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_ |
| 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 |
Yes
| 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
Description
Calculation rule detail
Key Figures aggregated by Date of Lot Creation:
Key Figures aggregated by Master Inspection Characteristic:
Key Figures aggregated by Plant:
Key Figures aggregated by Material:
Characteristics
...
Key figures
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
N/A