CE2S_GO

Quickstart Template | #template | Component: Profitability Analysis
Column Name Description
MANDT FK Client
PALEDGER FK Currency type for an operating concern
VRGAR FK Record Type
VERSI FK Plan version (CO-PA)
PAOBJNR Profitability Segment Number (CO-PA)
PASUBNR Profitability Segment Changes (CO-PA)
BELNR Document number of line item in Profitability Analysis
PERBL Fiscal year/period block
Column Name Description
💲 Currency of the data record (REC_WAERS):
KWBRUM001 Gross Sales
KWBONI001 Bonuses
KWKDRB001 Customer Discount
KWMGRB001 Quantity Discount
KWMARB001 Material discount
KWSKTO001 Cash Discount
KWVKPV001 Sales Commission
KWVSEK001 Sales Special Direct Costs
KWKLFK001 Accrued shipment costs
KWMAGK001 Material Overhead Costs
KWMAEK001 Direct Material Costs
KWFKFX001 Fixed Manufacturing Costs
KWFKVA001 Variable Production Costs
KWABMG001 Quantity Variance
KWABPR001 Price Variance
KWABSG001 Other variances
KWGOHD001 Administration Costs
KWMKDP001 Marketing Department
KWSOHD001 Sales Costs
KWFOEN001 Research and Development
KWSGEK001 Other Overhead
Column Name Description
📏 Base Unit of Measure (KWSVME_ME):
KWSVME001 Sales Quantity
Column Name Description
HZDAT Date on which the record was created
Column Name Description
Column Name Description Domain name
USNAM Created by USNAM
GJAHR Fiscal Year GJAHR
PAPAOBJNR Partner profitability segment number (CO-PA) RKEOBJNR
PAPASUBNR Changes to partner profitability segments (CO-PA) RKESUBNR
KAUFN Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
HRKFT Origins (CO-PA) RKEHERK
RBELN Reference document number for CO-PA line item BELNR
RPOSN Item number from reference document (CO-PA) RKE_POSNR
RKESTATU Update status for CO-PA line items RKESTATU
TIMESTMP Time created (Greenwich Meantime) RKE_TSTMP
KMVTNR Sales employee PERNR
Master Data Relations Join Conditions
Product
  • Product number
  • Client
  • CE2S_GO.ARTNR == MARA.MATNR
  • CE2S_GO.MANDT == MARA.MANDT
Industry Sector
  • Industry key
  • Client
  • CE2S_GO.BRSCH == T016.BRSCH
  • CE2S_GO.MANDT == T016.MANDT
Company Code
  • CE2S_GO.MANDT == T001.MANDT
  • CE2S_GO.BUKRS == T001.BUKRS
Sales District
  • CE2S_GO.MANDT == T171.MANDT
  • CE2S_GO.BZIRK == T171.BZIRK
Cost center
  • ?
  • Cost center
  • Controlling Area
  • CE2S_GO.MANDT == CSKS.MANDT
  • CE2S_GO.[column in domain "DATBI"] == CSKS.DATBI
  • CE2S_GO.COPA_KOSTL == CSKS.KOSTL
  • CE2S_GO.KOKRS == CSKS.KOKRS
Billing Type
  • CE2S_GO.MANDT == TVFK.MANDT
  • CE2S_GO.FKART == TVFK.FKART
Functional Area
  • CE2S_GO.MANDT == TFKB.MANDT
  • CE2S_GO.FKBER == TFKB.FKBER
Foreign Currency
  • CE2S_GO.MANDT == TCURC.MANDT
  • CE2S_GO.FRWAE == TCURC.WAERS
Business Area
  • CE2S_GO.MANDT == TGSB.MANDT
  • CE2S_GO.GSBER == TGSB.GSBER
Customer Group
  • Customer Group
  • Client
  • CE2S_GO.KDGRP == T151.KDGRP
  • CE2S_GO.MANDT == T151.MANDT
Sales Office
  • Sales office
  • Client
  • CE2S_GO.KMVKBU == TVBUR.VKBUR
  • CE2S_GO.MANDT == TVBUR.MANDT
Main Material Group
  • Main Material Group
  • Client
  • CE2S_GO.KMWNHG == T2246.KMWNHG
  • CE2S_GO.MANDT == T2246.MANDT
Customer
  • CE2S_GO.MANDT == KNA1.MANDT
  • CE2S_GO.KNDNR == KNA1.KUNNR
Controlling Area
  • CE2S_GO.MANDT == TKA01.MANDT
  • CE2S_GO.KOKRS == TKA01.KOKRS
Cost Element
  • ?
  • Cost Element
  • CE2S_GO.MANDT == CSKA.MANDT
  • CE2S_GO.[column in domain "KTOPL"] == CSKA.KTOPL
  • CE2S_GO.KSTAR == CSKA.KSTAR
Cost Object
  • Cost Object
  • ?
  • Client
  • CE2S_GO.KSTRG == CKPH.KSTRG
  • CE2S_GO.[column in domain "DATBI"] == CKPH.DATBI
  • CE2S_GO.MANDT == CKPH.MANDT
Base Unit of Measure
  • CE2S_GO.MANDT == T006.MANDT
  • CE2S_GO.KWSVME_ME == T006.MSEHI
Client CE2S_GO.MANDT == T000.MANDT
Material Group
  • CE2S_GO.MANDT == T023.MANDT
  • CE2S_GO.MATKL == T023.MATKL
Currency Type
  • CE2S_GO.MANDT == TKEL.MANDT
  • CE2S_GO.PALEDGER == TKEL.PALEDGER
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • CE2S_GO.MANDT == CEPC.MANDT
  • CE2S_GO.[column in domain "DATBI"] == CEPC.DATBI
  • CE2S_GO.KOKRS == CEPC.KOKRS
  • CE2S_GO.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • CE2S_GO.MANDT == CEPC.MANDT
  • CE2S_GO.[column in domain "DATBI"] == CEPC.DATBI
  • CE2S_GO.KOKRS == CEPC.KOKRS
  • CE2S_GO.PRCTR == CEPC.PRCTR
Sender Business Process
  • Controlling Area
  • Sender Business Process
  • Client
  • ?
  • CE2S_GO.KOKRS == CBPR.KOKRS
  • CE2S_GO.PRZNR == CBPR.PRZNR
  • CE2S_GO.MANDT == CBPR.MANDT
  • CE2S_GO.[column in domain "DATBI"] == CBPR.DATBI
Record Currency
  • CE2S_GO.MANDT == TCURC.MANDT
  • CE2S_GO.REC_WAERS == TCURC.WAERS
Order
  • Order Number
  • Client
  • CE2S_GO.RKAUFNR == AUFK.AUFNR
  • CE2S_GO.MANDT == AUFK.MANDT
Segment for Segmental Reporting
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • CE2S_GO.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • CE2S_GO.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • CE2S_GO.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • CE2S_GO.MANDT == FCO_SRVDOC.MANDT
Service Document Type
Sender Cost Center
  • ?
  • Sender cost center
  • Controlling Area
  • CE2S_GO.MANDT == CSKS.MANDT
  • CE2S_GO.[column in domain "DATBI"] == CSKS.DATBI
  • CE2S_GO.SKOST == CSKS.KOSTL
  • CE2S_GO.KOKRS == CSKS.KOKRS
Division
  • CE2S_GO.MANDT == TSPA.MANDT
  • CE2S_GO.SPART == TSPA.SPART
Version
  • Plan version (CO-PA)
  • Client
  • CE2S_GO.VERSI == TKVS.VERSI
  • CE2S_GO.MANDT == TKVS.MANDT
Sales Group
  • CE2S_GO.MANDT == TVKGR.MANDT
  • CE2S_GO.VKGRP == TVKGR.VKGRP
Sales Organization
  • CE2S_GO.MANDT == TVKO.MANDT
  • CE2S_GO.VKORG == TVKO.VKORG
Record Type
  • CE2S_GO.MANDT == TVGA.MANDT
  • CE2S_GO.VRGAR == TVGA.VRGAR
Identification of a Provider Contract
Contract: Item Number
  • Identification of a Provider Contract
  • Contract: Item Number
Distribution Channel
  • Distribution Channel
  • Client
  • CE2S_GO.VTWEG == TVTW.VTWEG
  • CE2S_GO.MANDT == TVTW.MANDT
Plant
  • CE2S_GO.MANDT == T001W.MANDT
  • CE2S_GO.WERKS == T001W.WERKS