CE9S_CP_H

Template for Consumer Goods Industry | #template | Component: Profitability Analysis
Column Name Description
MANDT Client
BELNR Line Item Document Number
POSNR Item number line item
SUBNR Item subnumber of line item
Column Name Description
Column Name Description
Column Name Description
CPUDT Date Document Was Created
CPUTM Created at
BUDAT Posting Date
WADAT Goods Issue Date
FADAT Invoice date (date created)
Column Name Description
BWZPT CO-PA Point of valuation Show values
BILLED Indicator: billed Show values
Column Name Description Domain name
PERIO Period/Year JAHRPER
GJAHR Fiscal Year GJAHR
PERDE Period NUM3
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
USNAM Created by USNAM
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PERIO_BILLED Billing Period JAHRPER
AWTYP Reference procedure AWTYP
AWORG Reference Organizational Units AWORG
AWSYS Logical system of source document LOGSYS
RBELN Reference document number for CO-PA line item BELNR
RPOSN Item number from reference document (CO-PA) RKE_POSNR
RSUBN Reference Subitem number RKE_POSNR
STO_BELNR Canceled document BELNR
STO_POSNR Canceled document item RKE_POSNR
STO_SUBNR Canceled subnumber of line item RKE_POSNR
STO_RBELNR_I Deleted by document BELNR
STO_RPOSNR_I Deleted by item RKE_POSNR
STO_RBELNR_E Canceled by document BELNR
STO_RPOSNR_E Canceled document item RKE_POSNR
KDPOS Item number in Sales Order NUM06
LIEFPOS Delivery Item POSNR
FKBER Functional Area FKBER
SEGMENT Segment for Segmental Reporting FB_SEGMENT
COPA_KOSTL Cost center KOSTL
KMVTNR Sales employee PERNR
Master Data Relations Join Conditions
Product
  • Product number
  • Client
  • CE9S_CP_H.ARTNR == MARA.MATNR
  • CE9S_CP_H.MANDT == MARA.MANDT
Order
  • Order Number
  • Client
  • CE9S_CP_H.AUFNR == AUFK.AUFNR
  • CE9S_CP_H.MANDT == AUFK.MANDT
Company code
  • CE9S_CP_H.MANDT == T001.MANDT
  • CE9S_CP_H.BUKRS == T001.BUKRS
Billing Type
  • CE9S_CP_H.MANDT == TVFK.MANDT
  • CE9S_CP_H.FKART == TVFK.FKART
Business Area
  • CE9S_CP_H.MANDT == TGSB.MANDT
  • CE9S_CP_H.GSBER == TGSB.GSBER
Brand
  • Brand
  • Client
  • CE9S_CP_H.KMBRND == T2249.KMBRND
  • CE9S_CP_H.MANDT == T2249.MANDT
Business field
  • CE9S_CP_H.MANDT == T2248.MANDT
  • CE9S_CP_H.KMCATG == T2248.KMCATG
CustomerHierarchy01
  • CE9S_CP_H.MANDT == KNA1.MANDT
  • CE9S_CP_H.KMHI01 == KNA1.KUNNR
CustomerHierarchy02
  • CE9S_CP_H.MANDT == KNA1.MANDT
  • CE9S_CP_H.KMHI02 == KNA1.KUNNR
CustomerHierarchy03
  • CE9S_CP_H.MANDT == KNA1.MANDT
  • CE9S_CP_H.KMHI03 == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • CE9S_CP_H.KMKDGR == T151.KDGRP
  • CE9S_CP_H.MANDT == T151.MANDT
Ctry
  • Country/Region Key
  • Client
  • CE9S_CP_H.KMLAND == T005.LAND1
  • CE9S_CP_H.MANDT == T005.MANDT
Material Group
  • CE9S_CP_H.MANDT == T023.MANDT
  • CE9S_CP_H.KMMAKL == T023.MATKL
Nielsen indicator
  • CE9S_CP_H.MANDT == TNLS.MANDT
  • CE9S_CP_H.KMNIEL == TNLS.NIELS
Strategic Business Unit
  • Strategic Business Unit
  • Client
  • CE9S_CP_H.KMSTGE == T2247.KMSTGE
  • CE9S_CP_H.MANDT == T2247.MANDT
Sales Office
  • Sales office
  • Client
  • CE9S_CP_H.KMVKBU == TVBUR.VKBUR
  • CE9S_CP_H.MANDT == TVBUR.MANDT
Sales Group
  • CE9S_CP_H.MANDT == TVKGR.MANDT
  • CE9S_CP_H.KMVKGR == TVKGR.VKGRP
Customer
  • CE9S_CP_H.MANDT == KNA1.MANDT
  • CE9S_CP_H.KNDNR == KNA1.KUNNR
Controlling Area
  • CE9S_CP_H.MANDT == TKA01.MANDT
  • CE9S_CP_H.KOKRS == TKA01.KOKRS
Cost Object
  • Cost Object
  • ?
  • Client
  • CE9S_CP_H.KSTRG == CKPH.KSTRG
  • CE9S_CP_H.[column in domain "DATBI"] == CKPH.DATBI
  • CE9S_CP_H.MANDT == CKPH.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • CE9S_CP_H.MANDT == CEPC.MANDT
  • CE9S_CP_H.[column in domain "DATBI"] == CEPC.DATBI
  • CE9S_CP_H.KOKRS == CEPC.KOKRS
  • CE9S_CP_H.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • CE9S_CP_H.MANDT == CEPC.MANDT
  • CE9S_CP_H.[column in domain "DATBI"] == CEPC.DATBI
  • CE9S_CP_H.KOKRS == CEPC.KOKRS
  • CE9S_CP_H.PRCTR == CEPC.PRCTR
Sender Business Process
  • Controlling Area
  • Sender Business Process
  • Client
  • ?
  • CE9S_CP_H.KOKRS == CBPR.KOKRS
  • CE9S_CP_H.PRZNR == CBPR.PRZNR
  • CE9S_CP_H.MANDT == CBPR.MANDT
  • CE9S_CP_H.[column in domain "DATBI"] == CBPR.DATBI
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • CE9S_CP_H.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • CE9S_CP_H.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • CE9S_CP_H.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • CE9S_CP_H.MANDT == FCO_SRVDOC.MANDT
Service Document Type
Sender Cost Center
  • ?
  • Sender cost center
  • Controlling Area
  • CE9S_CP_H.MANDT == CSKS.MANDT
  • CE9S_CP_H.[column in domain "DATBI"] == CSKS.DATBI
  • CE9S_CP_H.SKOST == CSKS.KOSTL
  • CE9S_CP_H.KOKRS == CSKS.KOKRS
Division
  • CE9S_CP_H.MANDT == TSPA.MANDT
  • CE9S_CP_H.SPART == TSPA.SPART
Version
  • Plan version (CO-PA)
  • Client
  • CE9S_CP_H.VERSI == TKVS.VERSI
  • CE9S_CP_H.MANDT == TKVS.MANDT
Sales Organization
  • CE9S_CP_H.MANDT == TVKO.MANDT
  • CE9S_CP_H.VKORG == TVKO.VKORG
Transaction/Event Type
  • CE9S_CP_H.MANDT == TVGA.MANDT
  • CE9S_CP_H.VRGAR == TVGA.VRGAR
Identification of a Provider Contract
Contract: Item Number
  • Identification of a Provider Contract
  • Contract: Item Number
Distribution Channel
  • Distribution Channel
  • Client
  • CE9S_CP_H.VTWEG == TVTW.VTWEG
  • CE9S_CP_H.MANDT == TVTW.MANDT
Plant
  • CE9S_CP_H.MANDT == T001W.MANDT
  • CE9S_CP_H.WERKS == T001W.WERKS