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 Query - Period Comparison

Technical NameBW_QRY_MVCOPA01_0006

Application

COPA

Info-provider

MVCOPA01

Usage type

Direct execution in Analyser

Expected users



Workbook/Query General Description

BW P&L Query - Period Comparison

General parameters

Global properties

TabScreenshotComment
Display


Rows/Columns


Value Display


Planning


Extended


Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

V_C_COMPCDE_C_AUTHMA_002

C_COMPCDE__C_AUTHMA

Selection Option

Yes

Explanation for the use of this variable

V_C_COMPCDE__C_MNGAREA_0003C_COMPCDE__C_MNGAREASelection OptionYes
V_COMPPRS_0006C_COMPCDE__C_COMPPRSSelection OptionYes
V_C_COMPCDE_0001C_COMPCDESelection OptionYes
V_C_PLANT_0010C_PLANTSelection OptionYes
V_CPFCTR1_2_0007C_TECMAT__CPFCTR1_2Selection OptionYes
V_CPFCTR2_2_0004C_TECMAT__CPFCTR2_2Selection OptionYes
V_0CALMONTH_00450CALMONTHIntervalYes
V_0CALMONTH_00490CALMONTHIntervalYes

Variable Sequence

Filters

ObjectFilter ValueExplanation
Ex : Status of the trading partner Ex : <> 1 Ex : Exclude intercompanies

Key figures

Key Figure 1

Description

Calculation rule detail

Quantity x Price

Text Replacement Variable

If relevant, add the text replacement rule used for the key figure

Currency Conversion

Exchange Rate Type : V_0RTYPE

Currency : V_0CURRENCY_0003

Time Reference : V_0DATE_0051

Unit Conversion

Unit : Variable or fixed unit

Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
ROWC_FIELDN__C_MGN_ACCBFC AccountCountry of the customer
ROWRCS_CKF_MVCOPA01_0962N8110 - Qty Sold (RU)
ROWRCS_CKF_MVCOPA01_0961N8110 - Qty Sold (RU) External
ROWRCS_CKF_MVCOPA01_0960N8110 - Qty Sold (RU) Internal
ROWRCS_CKF_MVCOPA01_0992N8110 - Qty Sold
ROWRCS_CKF_MVCOPA01_0990N8110 - Qty Sold External
ROWRCS_CKF_MVCOPA01_0991N8110 - Qty Sold Internal
ROWRCS_CKF_MVCOPA01_0002R10000 - Net sales
ROWRCS_CKF_MVCOPA01_0003R10600 - Received royalties according to sales
ROWRCS_CKF_MVCOPA01_0001ST-CA-PM Net sales (published)
ROWRCS_RKF_MVCOPA01_0004R11000 - Other revenue from activity
ROWRCS_RKF_MVCOPA01_0005R11200 - Other revenues on activities - Indust and Admin&Com
ROWRCS_RKF_MVCOPA01_0006R11300 - Other revenues on activities - Administrative & com
ROWRCS_RKF_MVCOPA01_0007R11400 - Other revenues on activities - Research
ROWRCS_RKF_MVCOPA01_0008R11500 - Other revenues on activities - Management Fees
ROWRCS_CKF_MVCOPA01_0002STOT-R110 Other revenues on activities
ROWRCS_CKF_MVCOPA01_0003ST-R111 Net sales & other revenues on activities
ROWRCS_RKF_MVCOPA01_0009R12600 - Royalties paid according to sales
ROWRCS_RKF_MVCOPA01_0003_IR10600 - Received royalties according to sales Internal
ROWRCS_RKF_MVCOPA01_0010R12700 - Received royalties according to sales
ROWRCS_RKF_MVCOPA01_0011R12900 - Other variable expenses on sales
ROWRCS_RKF_MVCOPA01_0012R12910 - Logistics costs - variable
ROWRCS_CKF_MVCOPA01_0004STOT-R120 Variable selling expenses
ROWRCS_RKF_MVCOPA01_0013R15400 - Variable costs of sales
ROWRCS_RKF_MVCOPA01_0014R15410 - Actual/Standard variance - Variable costs of sales
ROWRCS_RKF_MVCOPA01_0015R15430 - Elimination of margin in inventories
ROWRCS_RKF_MVCOPA01_0002_IR10000 - Internal sales
ROWRCS_CKF_MVCOPA01_0005STOT-R150 Variable costs of sales
ROWRCS_RKF_MVCOPA01_0016R26150 - Other costs on activities
ROWRCS_RKF_MVCOPA01_0004_IR11000 - Other revenue from activity Internal
ROWRCS_RKF_MVCOPA01_0017R26152 - Other costs on activities -  Indust and Admin&Com
ROWRCS_RKF_MVCOPA01_0005_IR11200 - Other revenue activities-Indust Admin&Com Internal
ROWRCS_RKF_MVCOPA01_0018R26153 - Other costs on activities - Admin&Com
ROWRCS_RKF_MVCOPA01_0006_IR11300 - Other revenues on activities - Admin&Com Internal
ROWRCS_RKF_MVCOPA01_0018R26154 - Other costs on activities - Research
ROWRCS_RKF_MVCOPA01_0007_IR11400 - Other revenues on activities - Research Internal
ROWRCS_RKF_MVCOPA01_0020R26155 - Other costs on activities - Management fees
ROWRCS_RKF_MVCOPA01_0008_IR11500 - Other revenues on activities - Mng Fees Internal
ROWRCS_CKF_MVCOPA01_0006STOT-R261 Other costs on activities
ROWRCS_RKF_MVCOPA01_0021R26250 - Non variable costs on other activities
ROWRCS_RKF_MVCOPA01_0022R26252 - Non variable costs on other activities - industrial
ROWRCS_RKF_MVCOPA01_0023R26253 - Non variable costs on other activities - Admin&Com
ROWRCS_RKF_MVCOPA01_0024R26254 - Non variable costs on other activities - research
ROWRCS_RKF_MVCOPA01_0025R26255 - Non variable costs on other activities - Mng Fees
ROWRCS_CKF_MVCOPA01_0007STOT-R262 Non Variable Costs on Other Products from Business
ROWRCS_CKF_MVCOPA01_0026TOT- Contribution Margin Trade
ROWRCS_CKF_MVCOPA01_0027TOT- Contribution Margin Other
ROWRCS_CKF_MVCOPA01_0008TOT- Contribution Margin
ROWRCS_RKF_MVCOPA01_0026R25000 - Production NVC - Actual
ROWRCS_RKF_MVCOPA01_0027R25410 - Actual/Std variance:Non-prop costs of prod-excl dep
ROWRCS_RKF_MVCOPA01_0028R25460 - Absor variance:Per. Non-Prop costs of prod-excl dep
ROWRCS_RKF_MVCOPA01_0029R25470 - Absor variance:Non-prop costs absor in inv-excl dep
ROWRCS_RKF_MVCOPA01_0030R25480 - Variance of non variable costs in inventories
ROWRCS_RKF_MVCOPA01_0031R25490 - Non-proportional costs of sales (excl depr)
ROWRCS_CKF_MVCOPA01_0009STOT-R254 Non-prop costs of sales excluding depreciation
ROWRCS_RKF_MVCOPA01_0032R25800 - Depreciation linked to production
ROWRCS_RKF_MVCOPA01_0033R25810 - Actual/Std variance: Non-prop depreciation of prod
ROWRCS_RKF_MVCOPA01_0034R25860 - Absor variance:Period non-prop depreciation of prod
ROWRCS_RKF_MVCOPA01_0035R25870 - Absor variance:Non-prop depreciation absor in inv
ROWRCS_RKF_MVCOPA01_0036R25880 - Variance of depreciation in inventories
ROWRCS_RKF_MVCOPA01_0037R25890 - Non-proportional depreciation costs of sales
ROWRCS_CKF_MVCOPA01_0010STOT-R258 Production depreciation
ROWRCS_RKF_MVCOPA01_0038R25200 - Variance of non variable costs&depreciation in inv
ROWRCS_CKF_MVCOPA01_0011TOT-R1210 Non proportional costs of sales
ROWRCS_RKF_MVCOPA01_0039R27000 - Depreciation services
ROWRCS_RKF_MVCOPA01_0040R27100 - Royalties for production & miscellaneous
ROWRCS_RKF_MVCOPA01_0041R27200 - Depreciation services and Miscellaneous
ROWRCS_RKF_MVCOPA01_0042R27600 - Paid royalties for production
ROWRCS_RKF_MVCOPA01_0043R27700 - Received royalties for production
ROWRCS_RKF_MVCOPA01_0044R27800 - Miscellaneous production depreciation
ROWRCS_RKF_MVCOPA01_0045R27900 - Miscellaneous production
ROWRCS_RKF_MVCOPA01_0046R25500 - Plant storage and loading costs
ROWRCS_RKF_MVCOPA01_0047R25510 - Logistics costs - non proportional
ROWRCS_RKF_MVCOPA01_0048R25600 - Write-downs on inventories
ROWRCS_CKF_MVCOPA01_0012STOT-R255    Other fixed cost and NPC
ROWRCS_CKF_MVCOPA01_0013TOT-R400 Gross Margin
ROWRCS_RKF_MVCOPA01_0049R33200 - Shared services function costs invoiced
ROWRCS_RKF_MVCOPA01_0050R33210 - GBU dedicated costs cross-charged
ROWRCS_RKF_MVCOPA01_0051R33300 - Specific administrative and commercial expenses
ROWRCS_RKF_MVCOPA01_0052R33310 - Administrative expenses (non functions)
ROWRCS_RKF_MVCOPA01_0053R33320 - Commercial expenses
ROWRCS_RKF_MVCOPA01_0054R33330 - Impairment on trade receivables
ROWRCS_RKF_MVCOPA01_0055R33400 - Shared service func expenses (func costs at origin)
ROWRCS_RKF_MVCOPA01_0056R33500 - SG&A
ROWRCS_RKF_MVCOPA01_0057R33800 - Administrative & commercial expenses depreciation
ROWRCS_CKF_MVCOPA01_0014STOT-R330 Administrative & commercial costs
ROWRCS_RKF_MVCOPA01_0058R36100 - Research & development - Gross
ROWRCS_RKF_MVCOPA01_0059R36200 - Research & development - Grants
ROWRCS_RKF_MVCOPA01_0060R36300 - Research & development - Depreciation
ROWRCS_RKF_MVCOPA01_0061R36400 - Research & development - Royalties
ROWRCS_RKF_MVCOPA01_0062R36500 - Research & Development
ROWRCS_CKF_MVCOPA01_0015STOT-R360 Research & Development
ROWRCS_RKF_MVCOPA01_0063R75000 - Net results from associate & JV (equity method)
ROWRCS_RKF_MVCOPA01_0064R38100 - Other recurring operating Income & Expenses
ROWRCS_RKF_MVCOPA01_0065R38210 - Study and start-up costs
ROWRCS_RKF_MVCOPA01_0066R38220 - Recovery plans
ROWRCS_RKF_MVCOPA01_0067R38300 - PPA (Purchase Price Alloc) depreciation expenses
ROWRCS_RKF_MVCOPA01_0068R38400 - Other recurring depreciation expenses
ROWRCS_CKF_MVCOPA01_0016STOT-R384 Other recurring operating income & expenses
ROWRCS_RKF_MVCOPA01_0069R48720 - Dividends received from non-consolidated companies
ROWRCS_RKF_MVCOPA01_0070R53620 - Other financial expenses related to operational
ROWRCS_RKF_MVCOPA01_0071R53720 - Other financial income related to operational
ROWRCS_RKF_MVCOPA01_0072R53900 - Finan risk provision&loans written off(operational)
ROWRCS_RKF_MVCOPA01_0073R53910 - Write-down of finan assets on non-conso companies
ROWRCS_CKF_MVCOPA01_0017STOT-R381    Financial items related to operational
ROWRCS_RKF_MVCOPA01_0074R48610 - Losses on intangible asset disposals
ROWRCS_RKF_MVCOPA01_0075R48630 - Losses on tangible asset disposals
ROWRCS_RKF_MVCOPA01_0076R48670 - Losses on asset disposals (recurring)
ROWRCS_RKF_MVCOPA01_0077R48710 - Gain on intangible asset disposals
ROWRCS_RKF_MVCOPA01_0078R48730 - Gain on tangible asset disposals
ROWRCS_RKF_MVCOPA01_0079R48770 - Gains on asset disposals (recurring)
ROWRCS_CKF_MVCOPA01_0018STOT-R382 +/- Value disposals of intangible&tangible assets
ROWRCS_RKF_MVCOPA01_0080R53800 - Operational FX result
ROWRCS_RKF_MVCOPA01_0081R53810 - Foreign operationnal Exch gains&losses - unrealized
ROWRCS_CKF_MVCOPA01_0019STOT-R383 Foreign operational exchange gains & losses
ROWRCS_CKF_MVCOPA01_0020STOT-R380    Other recurring operating gains & losses
ROWRCS_CKF_MVCOPA01_0021TOT-REBIT - REBIT- Recurring EBIT
ROWRCS_CKF_MVCOPA01_0022TOT-REBITDA - Recurring EBITDA
ROWRCS_RKF_MVCOPA01_0000RNA - Amount without BFC Account
FREE CHARC_WWSATActivity(OECD)_P
FREE CHARC_WWSAT__C_WWSATGPActivity(OECD) group_P
FREE CHAR0PROFIT_CTR__0MATL_GRP_1Industrial Origin
FREE CHARC_MATGR1Batch Origin_P
FREE CHARC_BILLTYPBilling type_P
FREE CHARC_MARKETAero: Market
FREE CHARC_PROGIDAero: Program
FREE CHARC_SPECIDMAero: Main Specifica
FREE CHAR0COSTELMNTCost Element
FREE CHARC_CUSTSA2__C_BILLTOBill-to party (Ship-to)
FREE CHAR0LOGSYSSource System
FREE CHARC_TECMAT__C_MAGNITUBFC Activity 1
FREE CHARC_COMPCDE__C_ZONEBFC Geography Zone
FREE CHARC_TECMAT__CPFCTR2_2BFC Group of activities
FREE CHARC_COMPCDE__C_COMPPRSPRS Company code
FREE CHARC_TECPARA__C_PACTIVBFC Partner Activity
FREE CHARC_TECPARA__CPFCTR1_2BFC Partner GBU
FREE CHARC_TECPARA__CPFCTR2_2BFC Partner Group Act
FREE CHAR0BUS_AREABusiness area
FREE CHAR0CALYEARCalendar Year
FREE CHARC_CUSTCOMCustomer w/ Company
FREE CHAR0CALMONTHCalendar Year/Month
FREE CHARC_MATNR2__C_PRODCommercial Product / Material Group
FREE CHARC_COMPCDECompany code
FREE CHAR0CO_AREAControlling area
FREE CHARC_SHIPID__0COUNTRYCountry of destination
FREE CHARC_COSTCTRCost Center
FREE CHAR0CURRENCYCurrency
FREE CHARC_DISTCHNDistribution Channel
FREE CHARC_CUSTSA2__C_FLGDISTDistributor flag Y/N (Ship-to)
FREE CHARC_CUSTSAL__C_FLGDISTDistributor flag Y/N (Sold-to)
FREE CHAR0MATL_GRP_5End Use_P
FREE CHAR0G_CWWE03ERP Group of activities_W
FREE CHAR0G_CWWE01__C_PFCTR1ERP Global Business Unit_W
FREE CHARC_CUST_UCFinal Consignee_P
FREE CHARC_TGBRC2__C_ZONEH2GBU Ship-to zone 2
FREE CHARC_TGBRC2__C_ZONEH1GBU Ship-to zone 1
FREE CHARC_TGBRC2__C_KEYACCGBR: Key Account (Ship To)
FREE CHARC_TGBRC3__C_GBR8GBR: GBU customer classificationt (Payer) Obsolete
FREE CHARC_TGBRC1__C_GBR8GBR: GBU customer classification (Sold-to) Obsolete
FREE CHARC_TGBRC2__C_GBR8GBR: GGBR: Customer Group (Ship-To)BU customer classification (Ship-to) Obsolete
FREE CHARC_TGBRC3__C_GBR6GBR: Customer Group (Payer)GBR: GBU End-Use
FREE CHARC_TGBRC2__C_GBR6GBR: Customer Group (Ship-To)
FREE CHARC_TGBRC1__C_GBR6GBR: Customer Group (Sold-To)
FREE CHARC_TGBRC3__C_GBR9GBR: Customer Sub-Group (Payer)
FREE CHARC_TGBRC2__C_GBR9GBR: Customer Sub-Group (Ship-To)
FREE CHARC_TGBRC1__C_GBR9GBR: Customer Sub-Group (Sold-To)
FREE CHARC_TGBRC2__C_GBR4GBR: GBU End-Use
FREE CHARC_TGBRC2__C_GBR3GBR End-Use (Segment)
FREE CHARC_TGBRC2__C_GBR2GBR End-Use (Market)
FREE CHARC_TGBRC2__C_GBR19GBR: GBU Material Group (Ship-to)
FREE CHARC_TGBRC2__C_GBR20GBR: GBU Material Sub-group (Ship-to)
FREE CHARC_TGBRC2__C_ENTSEG3GBR: GBU Segment
FREE CHARC_TGBRC2__C_GBR1GBR End-Use (Application)
FREE CHARC_MATNR2__C_HIER4Hierarchy 4_P
FREE CHAR0INFOPROVInfoProvider
FREE CHARC_INCOTRMIncoterms
FREE CHARC_INTGBU1__C_INTGBUFIntra GBU Flag
FREE CHAR0MATL_GRP_5__0MATL_GRP_4Market Segment_P
FREE CHARC_MATNR2Material
FREE CHARC_MATNR2__C_DIVISNMaterial Division
FREE CHARC_MATNR2__C_MAT_GRPMaterial Group
FREE CHARC_MATPNT2__C_PRPLANTProduction plant
FREE CHARC_COMPCDE__C_PMERBKMerged into PRS Company
FREE CHAR0G_CWWE10Movement type
FREE CHARC_ZZWWE41Origin Plant
FREE CHARC_MATPNT2__C_ASSGRPGBR Op. Asset group
FREE CHARC_MATPNT2__C_ASSSGRPGBR Op. Asset SubGrp
FREE CHARC_PLELMN2P&L Element
FREE CHARC_PLELMN2__C_MGN_ACCInitial Heading
FREE CHARC_PAYERPayer
FREE CHARC_PAYER__0COUNTRYPayer Country
FREE CHARC_PMNTRM2Payment Term_P
FREE CHARC_COSTCTR__C_RPLANTResponsible Plant
FREE CHARC_PLANTPlant
FREE CHAR0PROFIT_CTR__0PROD_HIERProduct Hierarchy PIF_P
FREE CHAR0PROFIT_CTRProfit Center
FREE CHARC_MATNR2__C_PRDHIERProduct Hier (LIP03)
FREE CHARC_MATNR2__0PROD_HIERMaterial Prod.hierarchy
FREE CHARC_COMPCDE__C_MNGAREABFC Gestion Area
FREE CHARC_PCOMPAN__C_PCOMPRSPRS Partner Company
FREE CHARC_CUSTID__C_CUSTPRSPRS Customer
FREE CHARC_CUSTSA2__C_SALEMPSales Employee (Ship-to)
FREE CHAR0DOC_CURRCYSales currency
FREE CHARC_SAL_ORGSales Organization
FREE CHARC_CUSTSAL__C_SALEMPSales Employee (Sold-to)
FREE CHARC_SHIPID__C_GRCUSTShip-To Group
FREE CHARC_SHIPIDShip-to party
FREE CHARC_CUSTID__C_GRCUSTSold-To Group
FREE CHARC_SOLDIDSold-to party
FREE CHARC_TECMAT__0G_CWWE01Sub-activity
FREE CHARC_PCOMPANTrading Partner
FREE CHAR0REC_TYPETransaction Type
FREE CHAR0G_UVVA01Unit Qty Invoiced
FREE CHARC_WBS_EL2WBS Element
FREE CHARC_SHIPCD2Shipping conditions_P
FREE CHARC_MATNR2__C_FMPRDProduct Family Code
FREE CHARC_MATNR2__C_LIP02Product line 02
FREE CHARC_MATNR2__C_LIP04Product line 04
FREE CHARC_CUSTSA2__0CUST_CLAABC class (Ship-to)
FREE CHARC_SHIPCOM__0COUNTRYShip-To/Company (Country)
FREE CHARC_SHIPCOM__C_GZONEShip-To/Company (GZo
FREE CHARC_SHIPCOM__C_ZONEShip-To/Company (Zone)

Cells

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

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement
Ex : Excl if <=10 Yes/No Sales Value Greater Than 10 Ex : All Independently






Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10