Versions Compared

Old Version 4

changes.mady.by.user GIRAUD-ext, Mickael

Saved on

compared with

New Version Current

changes.mady.by.user GIRAUD-ext, Mickael

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description

QV - BW P&L & Integrated Margin Query (CAR3)

Technical NameQVSBS_BW_QRY_CPCOPA03_0001

Application

P&L

Info-provider

CPCOPA03

Usage type

Qlikview source

Expected users

Table of Contents
maxLevel3

Workbook/Query General Description

(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

QVSBS_BW_QRY_CPCOPA03_0001 - QV - BW P&L & Integrated Margin Query (CAR3)

Please update the doc there and no longer here.

(warning)    (warning)     (warning)     (warning)


Description

QV - BW P&L & Integrated Margin Query (CAR3)

Technical NameQVSBS_BW_QRY_CPCOPA03_0001

Application

P&L

Info-provider

CPCOPA03

Usage type

Qlikview source

Expected users


Table of Contents
maxLevel3

Workbook/Query General Description


Qlikview query for P&L by sales order.

General parameters

Global properties

TabScreenshotComment
Display

Image Modified


Rows/Columns

Image Modified


Value Display

Image Modified


Planning

Image Modified


Extended

Image Modified


Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

V_CONSOV_0001

Conso. view? (1=Yes/0=No)

1FORMULASingle ValueMandatory with initial

0I_CMNTH

Calendar year/month

0CALMONTHIntervalMandatory with initial

V_CPFCTR1_2_0007

BFC GBU (Selection Option, Optional)

CPFCTR1_2Selection OptionOptional

V_TECM_PFCT2_2_0001

BFC Group of Activities (Select Options, Optional)

4CPCOPA03-TECM_PFCT2_2Selection OptionOptional

V_CCDE_MNGAREA_0001

BFC Gestion Area

4CPCOPA03-CCDE_MNGAREASelection OptionOptional

V_COMPPRS_0006

PRS Company code (Selection option, Optional)

C_COMPPRSAuthorizationOptional

V_C_COMPCDE_0001

Company code (Selection option)

C_COMPCDESelection OptionOptional

V_0RTYPE

Echange rate type

0RTYPESingle valueMandatory with initial

V_0CURRENCY_0003

Target Currency

0CURRENCYSingle ValueOptional

V_0UNIT_0001

Qty conv. unit (Single value)

0UNITSingle ValueOptional

Variable Sequence

Image Modified

Filters

ObjectFilter ValueExplanation

Version

C_VERSN2

= 000

= 0


Plant

C_PLANT

<> 8335

Key figures

Embedded Google Drive File
docid1O_aC4KmHuFjV0YYJ0cn2nUhn9c_IUTfsm19NjqZoDC4

Currency Conversion

Exchange Rate Type :  Variable   Variable (V_0RTYPE)

Currency type:  CTK  CTK_CAR3_E

Time Reference : V_0DATE_0002 (End of the month of 0CALMONTH)

Image ModifiedImage ModifiedImage Modified

Currency type:  CTK  CTK_CAR3_U

Time Reference : V_0DATE_0002 (End of the month of 0CALMONTH)

Image ModifiedImage ModifiedImage Modified


Unit Conversion

Conversion type: QCT_MATNR3

Unit : Variable V_0UNIT_0001

Image ModifiedImage Modified

Characteristics

Free:

Image Modified

Image Modified

Rows:

Image Modified

Image Modified


Columns:

Image Modified

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement






Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No