Versions Compared

Old Version 2

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.

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

The new wiki link for this data flow is here:

BW RTR - Profit and Loss by sales order (P&L)

Please update the doc there and no longer here.

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

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

BW P&L Integrated Margin CM/GM Query

Technical NameBW_QRY_CPCOPA03_0001

Application

P&L

Info-provider

CPCOPA03

Usage type

Direct usage in Analyser

Expected users


Table of Contents
maxLevel3

Workbook/Query General Description


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

The new wiki link for this data flow is here:

BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query

Please update the doc there and no longer here.

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


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_CCDE_AUTHMA_0001

Auth Scope on Company Code (Auth with input)

4CPCOPA03-CCDE_AUTHMA

Selection Option

Optional

Authorization variable

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_C_PLANT_0010

Plant (Selection Option, Optional)

C_PLANTSelection 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

Key figures

Structure STR_CPCOP03_0001 documentation:

Embedded Google Drive File
docid1Aqb0GGjyxZe2eVBlbJTVqbXAaZgG5LD9

Currency Conversion

Exchange Rate Type : Variable (V_0RTYPE)

Currency : Variable (V_0CURRENCY_0003)

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

Image ModifiedImage ModifiedImage Modified

Unit Conversion

Unit : Variable V_0UNIT_0001

Quantity conversion type: QCT_MATNR3

Image ModifiedImage Modified

Characteristics

Columns

Image Modified

Row


Image Modified

Image Modified

Image Modified

Image Added

LocationInfo-object NameInfo-object TextExplanation (if needed)


Free characteristicss:

Image Added

Image Added

Image Added



If you have 2 structures and special cells calculations, explain here.Cells

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement

Image Added

Image Added


Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No