CE1S_CP

Template for Consumer Goods Industry | #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)
PERIO Period/Year
PAOBJNR Profitability Segment Number (CO-PA)
PASUBNR Profitability Segment Changes (CO-PA)
BELNR Document number of line item in Profitability Analysis
POSNR Item no. of CO-PA line item
Column Name Description
💲 Currency of the data record (REC_WAERS):
KWABFK Variance: Shipment Costs
KWABLG Lot Size Variance
KWABLK Idle-Capacity Costs
KWABMG Quantity Variance
KWABPR Price Variance
KWABSG Other variances
KWABST Resource-Usage Variance
KWAKRB Special Offer Discount
KWBONI Bonuses
KWBRUM Gross Sales
KWFKFX Fixed Manufacturing Costs
KWFKVA Variable Production Costs
KWFOEN Research and Development
KWKDRB Customer Discount
KWKLFK Accrued shipment costs
KWLOGI Logistics
KWMAEK Direct Material Costs
KWMAGK Material Overhead Costs
KWMARB Material discount
KWMGRB Quantity Discount
KWMKAD Advertising
KWMKDP Marketing Department
KWMKPR Promotion
KWSKTO Cash Discount
KWVERW Administration Costs
KWVKPV Sales Commission
KWVSEK Sales Special Direct Costs
KWVTAD Sales field service
KWVTID Sales office
Column Name Description
📏 Base Unit of Measure (KWSVME_ME):
KWSVME Sales Quantity
Column Name Description
HZDAT Date on which the record was created
WADAT Goods Issue Date
FADAT Invoice date (date created)
BUDAT Posting Date
Column Name Description
PLIKZ Plan/Actual Indicator Show values
COPA_BWZPT CO-PA Point of valuation Show values
REPROCESSING_STATUS_CODE Reprocessing status code Show values
Column Name Description Domain name
USNAM Created by USNAM
GJAHR Fiscal Year GJAHR
PERDE Period NUM3
ALTPERIO Period/year in alternative period type JAHRPER
PAPAOBJNR Partner profitability segment number (CO-PA) RKEOBJNR
PAPASUBNR Changes to partner profitability segments (CO-PA) RKESUBNR
KURSF Exchange rate KURSF
KURSBK Exchange rate for op.concern currency -> Co.code currency KURSF
KURSKZ Exchange rate op.concern currency -> group currency KURSF
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
STO_BELNR Canceled document BELNR
STO_POSNR Canceled document item RKE_POSNR
RKESTATU Update status for CO-PA line items RKESTATU
TIMESTMP Time created (Greenwich Meantime) RKE_TSTMP
COPA_AWTYP Reference procedure AWTYP
COPA_AWORG Reference Organizational Units AWORG
LOGSYS_SENDER Logical System of the Sender LOGSYS
ERKRS_SENDER Operating concern ERKRS
BELNR_SENDER Document number of line item in Profitability Analysis BELNR
POSNR_SENDER Item no. of CO-PA line item RKE_POSNR
VRGAR_SENDER Record Type VRGAR
BUKRS_SENDER Company Code BUKRS
KMVTNR Sales employee PERNR
Master Data Relations Join Conditions
Product
  • Product number
  • Client
  • CE1S_CP.ARTNR == MARA.MATNR
  • CE1S_CP.MANDT == MARA.MANDT
Company Code
  • CE1S_CP.MANDT == T001.MANDT
  • CE1S_CP.BUKRS == T001.BUKRS
Logical System CE1S_CP.COPA_AWSYS == TBDLS.LOGSYS
Cost center
  • ?
  • Cost center
  • Controlling Area
  • CE1S_CP.MANDT == CSKS.MANDT
  • CE1S_CP.[column in domain "DATBI"] == CSKS.DATBI
  • CE1S_CP.COPA_KOSTL == CSKS.KOSTL
  • CE1S_CP.KOKRS == CSKS.KOKRS
Billing Type
  • CE1S_CP.MANDT == TVFK.MANDT
  • CE1S_CP.FKART == TVFK.FKART
Functional Area
  • CE1S_CP.MANDT == TFKB.MANDT
  • CE1S_CP.FKBER == TFKB.FKBER
Foreign Currency
  • CE1S_CP.MANDT == TCURC.MANDT
  • CE1S_CP.FRWAE == TCURC.WAERS
Business Area
  • CE1S_CP.MANDT == TGSB.MANDT
  • CE1S_CP.GSBER == TGSB.GSBER
Brand
  • Brand
  • Client
  • CE1S_CP.KMBRND == T2249.KMBRND
  • CE1S_CP.MANDT == T2249.MANDT
Business field
  • CE1S_CP.MANDT == T2248.MANDT
  • CE1S_CP.KMCATG == T2248.KMCATG
CustomerHierarchy01
  • CE1S_CP.MANDT == KNA1.MANDT
  • CE1S_CP.KMHI01 == KNA1.KUNNR
CustomerHierarchy02
  • CE1S_CP.MANDT == KNA1.MANDT
  • CE1S_CP.KMHI02 == KNA1.KUNNR
CustomerHierarchy03
  • CE1S_CP.MANDT == KNA1.MANDT
  • CE1S_CP.KMHI03 == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • CE1S_CP.KMKDGR == T151.KDGRP
  • CE1S_CP.MANDT == T151.MANDT
Country
  • Country/Region Key
  • Client
  • CE1S_CP.KMLAND == T005.LAND1
  • CE1S_CP.MANDT == T005.MANDT
Material Group
  • CE1S_CP.MANDT == T023.MANDT
  • CE1S_CP.KMMAKL == T023.MATKL
Nielsen Indicator
  • CE1S_CP.MANDT == TNLS.MANDT
  • CE1S_CP.KMNIEL == TNLS.NIELS
Strategic Business Unit
  • Strategic Business Unit
  • Client
  • CE1S_CP.KMSTGE == T2247.KMSTGE
  • CE1S_CP.MANDT == T2247.MANDT
Sales Office
  • Sales office
  • Client
  • CE1S_CP.KMVKBU == TVBUR.VKBUR
  • CE1S_CP.MANDT == TVBUR.MANDT
Sales Group
  • CE1S_CP.MANDT == TVKGR.MANDT
  • CE1S_CP.KMVKGR == TVKGR.VKGRP
Customer
  • CE1S_CP.MANDT == KNA1.MANDT
  • CE1S_CP.KNDNR == KNA1.KUNNR
Controlling Area
  • CE1S_CP.MANDT == TKA01.MANDT
  • CE1S_CP.KOKRS == TKA01.KOKRS
Cost Element
  • ?
  • Cost Element
  • CE1S_CP.MANDT == CSKA.MANDT
  • CE1S_CP.[column in domain "KTOPL"] == CSKA.KTOPL
  • CE1S_CP.KSTAR == CSKA.KSTAR
Cost Object
  • Cost Object
  • ?
  • Client
  • CE1S_CP.KSTRG == CKPH.KSTRG
  • CE1S_CP.[column in domain "DATBI"] == CKPH.DATBI
  • CE1S_CP.MANDT == CKPH.MANDT
Base Unit of Measure
  • CE1S_CP.MANDT == T006.MANDT
  • CE1S_CP.KWSVME_ME == T006.MSEHI
Client CE1S_CP.MANDT == T000.MANDT
Currency Type
  • CE1S_CP.MANDT == TKEL.MANDT
  • CE1S_CP.PALEDGER == TKEL.PALEDGER
Partner Profit Ctr
  • ?
  • Controlling Area
  • Partner Profit Center
  • CE1S_CP.MANDT == CEPC.MANDT
  • CE1S_CP.[column in domain "DATBI"] == CEPC.DATBI
  • CE1S_CP.KOKRS == CEPC.KOKRS
  • CE1S_CP.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • CE1S_CP.MANDT == CEPC.MANDT
  • CE1S_CP.[column in domain "DATBI"] == CEPC.DATBI
  • CE1S_CP.KOKRS == CEPC.KOKRS
  • CE1S_CP.PRCTR == CEPC.PRCTR
Sender Bus. Process
  • Controlling Area
  • Sender Business Process
  • Client
  • ?
  • CE1S_CP.KOKRS == CBPR.KOKRS
  • CE1S_CP.PRZNR == CBPR.PRZNR
  • CE1S_CP.MANDT == CBPR.MANDT
  • CE1S_CP.[column in domain "DATBI"] == CBPR.DATBI
Record Currency
  • CE1S_CP.MANDT == TCURC.MANDT
  • CE1S_CP.REC_WAERS == TCURC.WAERS
Order
  • Order Number
  • Client
  • CE1S_CP.RKAUFNR == AUFK.AUFNR
  • CE1S_CP.MANDT == AUFK.MANDT
Segment for Segmental Reporting
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • CE1S_CP.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • CE1S_CP.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • CE1S_CP.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • CE1S_CP.MANDT == FCO_SRVDOC.MANDT
Service Document Type
Sender Cost Ctr
  • ?
  • Sender cost center
  • Controlling Area
  • CE1S_CP.MANDT == CSKS.MANDT
  • CE1S_CP.[column in domain "DATBI"] == CSKS.DATBI
  • CE1S_CP.SKOST == CSKS.KOSTL
  • CE1S_CP.KOKRS == CSKS.KOKRS
Division
  • CE1S_CP.MANDT == TSPA.MANDT
  • CE1S_CP.SPART == TSPA.SPART
Version
  • Plan version (CO-PA)
  • Client
  • CE1S_CP.VERSI == TKVS.VERSI
  • CE1S_CP.MANDT == TKVS.MANDT
Sales Organization
  • CE1S_CP.MANDT == TVKO.MANDT
  • CE1S_CP.VKORG == TVKO.VKORG
Record Type
  • CE1S_CP.MANDT == TVGA.MANDT
  • CE1S_CP.VRGAR == TVGA.VRGAR
Identification of a Provider Contract
Contract: Item Number
  • Identification of a Provider Contract
  • Contract: Item Number
Distribution Channel
  • Distribution Channel
  • Client
  • CE1S_CP.VTWEG == TVTW.VTWEG
  • CE1S_CP.MANDT == TVTW.MANDT
Plant
  • CE1S_CP.MANDT == T001W.MANDT
  • CE1S_CP.WERKS == T001W.WERKS