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.

Role CodeRole DescriptionExplanation









Authorization objects

List of authorization objects mandatory for the application.

Authorization objectExplanation
C_AUTHMA




Dataflow overview

Source Layer

As showed in the data flow above the data source is a Main Calculation View CV_FMCO_QTY_SLS_FRC.


Below are the Calculation Views that make up the Main Calculation View CV_FMCO_QTY_SLS_FRC:


Dependencies with other applications

There is dependency on the following data flows: CRDYN11, AACOPC01, AACOPC04 and CRSDSO02.

Propagation Layer

Data Loading:

Infoprovider AACOPC05:

Loading frequency

Daily

Business Layer

Data Loading:

Infoprovider ABCOPC07:

Loading frequency

Daily

Virtual Layer

Composite Providers

CPCOPC07

Reporting (BW Query for Qlik)


Description

Sales Revenues Forecast Snapshot

Technical NameQV_BW_QRY_CPCOPC07_0001

Application

COPC

Info-provider

CPCOPC07

Usage type

Qlik Source

Expected users


Global properties

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

V_0LOGSYS_00010LOGSYSSelectOptionNo
C_PLANT02C_PLANTSelectOptionNo
CPFCTR1_2_0001CPFCTR1_2SelectOptionNo
0CALMONTH_00060CALMONTHSelectOptionNo










Variable Sequence

Filters

Key figures

Characteristics

Cells

N/A

Conditions

N/A

Exceptions

N/A