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.

Authorization objects

List of authorization objects mandatory for the application.

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.

Global properties

Variables

Definitions

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 for calculating the average Freight costs for last 3, 6, 9 and 12 months.
At each aggregation step, 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 for calculating the average Duties costs for last 3, 6, 9 and 12 months.
At each aggregation step, 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

Composite Providers

CPCOPC09

Reporting (BW Query for Qlik)

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A