Objective of the application
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 source data is a BW Query BW_QRY_MVCOPA01_0010 - FL ICM Freight and Duties.
Description | FL - Logistic Cost |
|---|---|
| Technical Name | QV_W_QRY_CPCOPC09_0001 |
Application | COPC |
Info-provider | CPCOPC07 |
Usage type | Qlikview Source |
Expected users |
Global properties
xxxxxxx
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
V_C_PLANT_C_AUTHMA_002 | C_PLANT__C_AUTHMA | Authorization | Yes | |
| ZINSPLOT | 0INSP_LOT | SelectOption | No | |
| V_C_MATNR2_0010 | C_MATNR2 | SelectOption | No | |
| V_C_PLANT_37 | C_PLANT | SelectOption | No | |
| ENSTE_01 | C_ENSTEHD | SelectOption | No | |
| ZPLNNR | 0PLNNR | SelectOption | No |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
Key figures
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
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
ABCOPC06
Loading frequency
Daily
Virtual Layer
Calculation Views
CV_FMCO_LOG_FREIGHT
xxxxxxxx
CV_FMCO_LOG_DUTIES
xxxxxxxx
CV_FMCO_LOG_FREIGHT_DUTIES
xxxxxxxx
Composite Providers
CPCOPC07
Reporting (BW Query for Qlikview)
Description | FL - Logistic Cost |
|---|---|
| Technical Name | QV_W_QRY_CPCOPC09_0001 |
Application | COPC |
Info-provider | CPCOPC07 |
Usage type | Qlikview Source |
Expected users |
Global properties
xxxxxx
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
V_C_PLANT_C_AUTHMA_002 | C_PLANT__C_AUTHMA | Authorization | Yes | |
| ZINSPLOT | 0INSP_LOT | SelectOption | No | |
| V_C_MATNR2_0010 | C_MATNR2 | SelectOption | No | |
| V_C_PLANT_37 | C_PLANT | SelectOption | No | |
| ENSTE_01 | C_ENSTEHD | SelectOption | No | |
| ZPLNNR | 0PLNNR | SelectOption | No |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
Key figures
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Cells
N/A
Conditions
N/A
Exceptions
N/A