Objective

The objective is to have Raw Material 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

Data Flow 1:

Data Flow 2:

Source Layer

As showed in the data flow 2 above the data source is the Main Calculation View CV_FMCO_RAW_MAT:

The Main Calculation View above is composed by CV_FMCO_CS_RAW_MAT and CV_FMCO_SP_RAW_MAT:

CV_FMCO_CS_RAW_MAT

CV_FMCO_SP_RAW_MAT

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