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 |
|---|---|---|
Authorization objects
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
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
CV_FMCO_LOG_DUTIES
CV_FMCO_LOG_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 | |
| C_PLANT02 | C_PLANT | SelectOption | No | |
| CPFCTR1_2_0001 | CPFCTR1_2 | SelectOption | No | |
| 0CALMONTH_0006 | 0CALMONTH | SelectOption | No | |
Variable Sequence
Filters
Key figures
Characteristics
Cells
N/A
Conditions
N/A
Exceptions
N/A