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 |
|---|---|
| C_AUTHMA | |
Dataflow overview
Source Layer
As showed in the data flow above the data source is a Main Calculation View CV_FMCO_QTY_SLS_FRC.
Below are the Calculation Views that make up the Main Calculation View CV_FMCO_QTY_SLS_FRC:
Dependencies with other applications
There is dependency on the following data flows: CRDYN11, AACOPC01, AACOPC04 and CRSDSO02.
Propagation Layer
Data Loading:
Infoprovider AACOPC05:
Loading frequency
Daily
Business Layer
Data Loading:
Infoprovider ABCOPC07:
Loading frequency
Daily
Virtual Layer
Composite Providers
CPCOPC07
Reporting (BW Query for Qlik)
Description | Sales Revenues Forecast Snapshot |
|---|---|
| Technical Name | QV_BW_QRY_CPCOPC07_0001 |
Application | COPC |
Info-provider | CPCOPC07 |
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