CE4S_CP_ACCT

Template for Consumer Goods Industry | #template | Component: Profitability Analysis
Column Name Description
MANDT FK Client
AKTBO Current profitability segment (CO-PA)
PAOBJNR Profitability Segment Number (CO-PA)
PASUBNR Profitability Segment Changes (CO-PA)
Column Name Description
Column Name Description
Column Name Description
BISDAT Valid To
ACCT_BUDAT Posting Date
Column Name Description
FROZEN Flag: No Check / Update of PAOBJNR Show values
Column Name Description Domain name
KAUFN Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
PRCTR Profit Center PRCTR
PPRCTR Partner Profit Center PRCTR
CE4KEY Assignment Object Key for CO-PA Data Basis (CE4xxxx) RKEOBJNR
ACCT_VRGNG Business Transaction J_VORGANG
KMVTNR Sales employee PERNR
Master Data Relations Join Conditions
Product
  • Product number
  • Client
  • CE4S_CP_ACCT.ARTNR == MARA.MATNR
  • CE4S_CP_ACCT.MANDT == MARA.MANDT
Order
  • Order Number
  • Client
  • CE4S_CP_ACCT.AUFNR == AUFK.AUFNR
  • CE4S_CP_ACCT.MANDT == AUFK.MANDT
Company Code
  • CE4S_CP_ACCT.MANDT == T001.MANDT
  • CE4S_CP_ACCT.BUKRS == T001.BUKRS
Cost center
  • ?
  • Cost center
  • Controlling Area
  • CE4S_CP_ACCT.MANDT == CSKS.MANDT
  • CE4S_CP_ACCT.[column in domain "DATBI"] == CSKS.DATBI
  • CE4S_CP_ACCT.COPA_KOSTL == CSKS.KOSTL
  • CE4S_CP_ACCT.KOKRS == CSKS.KOKRS
Billing Type
  • CE4S_CP_ACCT.MANDT == TVFK.MANDT
  • CE4S_CP_ACCT.FKART == TVFK.FKART
Functional Area
  • CE4S_CP_ACCT.MANDT == TFKB.MANDT
  • CE4S_CP_ACCT.FKBER == TFKB.FKBER
Business Area
  • CE4S_CP_ACCT.MANDT == TGSB.MANDT
  • CE4S_CP_ACCT.GSBER == TGSB.GSBER
Brand
  • Brand
  • Client
  • CE4S_CP_ACCT.KMBRND == T2249.KMBRND
  • CE4S_CP_ACCT.MANDT == T2249.MANDT
Business field
  • CE4S_CP_ACCT.MANDT == T2248.MANDT
  • CE4S_CP_ACCT.KMCATG == T2248.KMCATG
CustomerHierarchy01
  • CE4S_CP_ACCT.MANDT == KNA1.MANDT
  • CE4S_CP_ACCT.KMHI01 == KNA1.KUNNR
CustomerHierarchy02
  • CE4S_CP_ACCT.MANDT == KNA1.MANDT
  • CE4S_CP_ACCT.KMHI02 == KNA1.KUNNR
CustomerHierarchy03
  • CE4S_CP_ACCT.MANDT == KNA1.MANDT
  • CE4S_CP_ACCT.KMHI03 == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • CE4S_CP_ACCT.KMKDGR == T151.KDGRP
  • CE4S_CP_ACCT.MANDT == T151.MANDT
Country
  • Country/Region Key
  • Client
  • CE4S_CP_ACCT.KMLAND == T005.LAND1
  • CE4S_CP_ACCT.MANDT == T005.MANDT
Material Group
  • CE4S_CP_ACCT.MANDT == T023.MANDT
  • CE4S_CP_ACCT.KMMAKL == T023.MATKL
Nielsen Indicator
  • CE4S_CP_ACCT.MANDT == TNLS.MANDT
  • CE4S_CP_ACCT.KMNIEL == TNLS.NIELS
Strategic Business Unit
  • Strategic Business Unit
  • Client
  • CE4S_CP_ACCT.KMSTGE == T2247.KMSTGE
  • CE4S_CP_ACCT.MANDT == T2247.MANDT
Sales Office
  • Sales office
  • Client
  • CE4S_CP_ACCT.KMVKBU == TVBUR.VKBUR
  • CE4S_CP_ACCT.MANDT == TVBUR.MANDT
Sales Group
  • CE4S_CP_ACCT.MANDT == TVKGR.MANDT
  • CE4S_CP_ACCT.KMVKGR == TVKGR.VKGRP
Customer
  • CE4S_CP_ACCT.MANDT == KNA1.MANDT
  • CE4S_CP_ACCT.KNDNR == KNA1.KUNNR
Controlling Area
  • CE4S_CP_ACCT.MANDT == TKA01.MANDT
  • CE4S_CP_ACCT.KOKRS == TKA01.KOKRS
Cost Object
  • Cost Object
  • Valid To
  • Client
  • CE4S_CP_ACCT.KSTRG == CKPH.KSTRG
  • CE4S_CP_ACCT.BISDAT == CKPH.DATBI
  • CE4S_CP_ACCT.MANDT == CKPH.MANDT
Base Unit of Measure
  • CE4S_CP_ACCT.MANDT == T006.MANDT
  • CE4S_CP_ACCT.KWSVME_ME == T006.MSEHI
Client CE4S_CP_ACCT.MANDT == T000.MANDT
Unit of Measure
  • CE4S_CP_ACCT.MANDT == T006.MANDT
  • CE4S_CP_ACCT.MEINH == T006.MSEHI
Segment for Segmental Reporting
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Service Document ID
  • Client
  • CE4S_CP_ACCT.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • CE4S_CP_ACCT.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • CE4S_CP_ACCT.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID
  • CE4S_CP_ACCT.MANDT == FCO_SRVDOC.MANDT
Service Document Type
Division
  • CE4S_CP_ACCT.MANDT == TSPA.MANDT
  • CE4S_CP_ACCT.SPART == TSPA.SPART
Sales Organization
  • CE4S_CP_ACCT.MANDT == TVKO.MANDT
  • CE4S_CP_ACCT.VKORG == TVKO.VKORG
Identification of a Provider Contract
Contract: Item Number
  • Identification of a Provider Contract
  • Contract: Item Number
Distribution Channel
  • Distribution Channel
  • Client
  • CE4S_CP_ACCT.VTWEG == TVTW.VTWEG
  • CE4S_CP_ACCT.MANDT == TVTW.MANDT
Plant
  • CE4S_CP_ACCT.MANDT == T001W.MANDT
  • CE4S_CP_ACCT.WERKS == T001W.WERKS