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

The Calculation View CV_FMCO_CS_RAW_MAT is composed by:

CV_FMCO_SP_RAW_MAT

The Calculation View CV_FMCO_SP_RAW_MAT is composed by:

Dependencies with other applications

There is a dependency from data flows: 

InfoObjects: C_COMPCDE, C_PLANT, C_PO_ITM, C_SUBACT2, C_AGRITM and C_FLRMAT.

Infoproviders: DB_PUHD1, DB_PUHD2, DB_PUSL1, DB_PUSL2 and AAMMIM02S.

Propagation Layer

Data Loading:

Infoprovider APCOPC02:

Loading frequency

Daily

Business Layer

Data Loading:

Infoproviders ABCOPC01, ABCOPC02 and ABCOPC08:

Loading frequency

Daily

Virtual Layer

Composite Providers

CPCOPC01

Reporting (BW Query)

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A