Objective

The objective is to have Raw Material Costs in a Manufacturing query. This query will be used with Qlik Sense Dashboards.

Raw Material Forecast prices are confirmed by Business in a dedicated Workbook.

If a monthly forecast price is unconfirmed by Business, it is extrapolated from the first previous confirmed price at the time of pushing this Forecast into Manufacturing data flow.

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:

If a monthly forecast price is unconfirmed by Business, it is extrapolated from the first previous confirmed price at the time of pushing this Forecast into Manufacturing data flow.

This process takes place in the Transformation ABCOPC01 on itself.

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

Reporting

Two queries are available in the Workbook : the Query Overall and the Query Detail.

The first one allows to modify the value of the Forecasted Price and automatically filters the second one to a more detailed view.

• The Query Detail is the detailed view of the Raw Material per month with a Forecast quantity for a minimum of one year. All documents (Purchase Order, Contract, and Inventory) are available for each month as well as the forecast price calculated for the forecast quantity.
• The Query Overall is the global view of the Raw Material aggregated by month without the detail by documents. The Forecast price is calculated from the detail and aggregated by month and Raw Material. The Quantity Assigned for each document is available in columns.

Reporting Layer

Aggregation Level

ALCOPC01

Reporting (BW Query)

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A

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