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 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.

CV_FMCO_LOG_FREIGHT_DUTIES

In this Calculation View, data from CV_FMCO_LOG_FREIGHT_FREIGHT and CV_FMCO_LOG_FREIGHT_DUTIES 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

Reporting (BW Query for Qlik)

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A