SAP table CEST4 (Segment table (CO-PA))

SAP table CEST4 has 4 primary key fields being MANDT,AKTBO,PAOBJNR,PASUBNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AKTBO Current profitability segment (CO-PA) CHAR 1 0 AKTBO
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) NUMC 4 0 RKESUBNR
BISDAT Valid To DATS 8 0 AUFDATBI
KNT_FRM_KZ Indicator for use in account-based Profitability Analysis NUMC 1 0 RKE_KNTFRM
0 Cannot be used in account-based Profitability Analysis
1 Use in account-based Profitability Analysis
UNUSED_CE3 Flag: NOT Posted to Costing-Based Profitability Analysis CHAR 1 0 COPA_UNUSED_CE3
Posted to costing-based CO-PA (CE3xxxx)
X Not posted to costing-based CO-PA (CE3xxxx)
FROZEN Flag: No Check / Update of PAOBJNR CHAR 1 0 RKE_FROZEN
Result Object Can Be Checked or Updated
X Result Object Is Not Checked or Updated
KNDNR Customer CHAR 10 0 KNA1 KUNDE_PA
ARTNR Product number CHAR 40 0 MARA ARTNR
FKART Billing Type CHAR 4 0 TVFK FKART
KAUFN Sales Order Number CHAR 10 0 VBAK KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
AUFNR Order Number CHAR 12 0 AUFK AUFNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
WERKS Plant CHAR 4 0 T001W WERKS_D
GSBER Business Area CHAR 4 0 TGSB GSBER
FKBER Functional Area CHAR 16 0 TFKB FKBER
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
PPRCTR Partner Profit Center CHAR 10 0 CEPC PPRCTR
KSTRG Cost Object CHAR 12 0 CKPH KSTRG
PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
COPA_KOSTL Cost center CHAR 10 0 CSKS COPA_KOSTL
MEINH Unit of Measure UNIT 3 0 T006 CO_MEINH
QUNIT1 Additional Unit of Measure 1 UNIT 3 0 T006 FCO_QUNIT1
QUNIT2 Additional Unit of Measure 2 UNIT 3 0 T006 FCO_QUNIT2
QUNIT3 Additional Unit of Measure 3 UNIT 3 0 T006 FCO_QUNIT3
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 CRMC_PROC_TYPE FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCOV_SRVDOC_TYID FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC FCO_SRVDOC_ITEM_ID
SOLUTION_ORDER_ID Solution Order ID CHAR 10 0 CRMS4D_SERV_H FCO_SOLUTION_ORDER_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item ID NUMC 6 0 CRMS4D_SERV_I FCO_SOLUTION_ORDER_ITEM_ID
VTKEY Identification of a Provider Contract CHAR 20 0 DFKK_VT_H VTKEY_KK
VTPOS Contract: Item Number NUMC 6 0 DFKK_VT_I VTPOS_KK

CEST4 foreign key relationships

Table Field Check Table Check Field
0 CEST4 ARTNR MARA General Material Data MANDT
0 CEST4 ARTNR MARA General Material Data MATNR
1 CEST4 AUFNR AUFK Order master data AUFNR
0 CEST4 BUKRS T001 Company Codes BUKRS
1 CEST4 COPA_KOSTL CSKS Cost Center Master Record MANDT
1 CEST4 COPA_KOSTL CSKS Cost Center Master Record KOKRS
1 CEST4 COPA_KOSTL CSKS Cost Center Master Record DATBI
0 CEST4 FKART TVFK Billing: Document Types MANDT
0 CEST4 FKART TVFK Billing: Document Types FKART
1 CEST4 FKBER TFKB Functional areas FKBER
0 CEST4 GSBER TGSB Business Areas MANDT
0 CEST4 GSBER TGSB Business Areas GSBER
1 CEST4 KAUFN VBAK Sales Document: Header Data MANDT
1 CEST4 KAUFN VBAK Sales Document: Header Data VBELN
0 CEST4 KNDNR KNA1 General Data in Customer Master MANDT
0 CEST4 KNDNR KNA1 General Data in Customer Master KUNNR
1 CEST4 KOKRS TKA01 Controlling Areas MANDT
0 CEST4 KSTRG CKPH Master Record: Cost Object ID Number MANDT
0 CEST4 KSTRG CKPH Master Record: Cost Object ID Number KSTRG
0 CEST4 KSTRG CKPH Master Record: Cost Object ID Number DATBI
1 CEST4 MANDT T000 Clients MANDT
0 CEST4 MEINH T006 Units of Measurement MANDT
0 CEST4 MEINH T006 Units of Measurement MSEHI
1 CEST4 PPRCTR CEPC Profit Center Master Data Table PRCTR
1 CEST4 PPRCTR CEPC Profit Center Master Data Table DATBI
1 CEST4 PPRCTR CEPC Profit Center Master Data Table KOKRS
0 CEST4 PRCTR CEPC Profit Center Master Data Table PRCTR
0 CEST4 PRCTR CEPC Profit Center Master Data Table DATBI
0 CEST4 PRCTR CEPC Profit Center Master Data Table KOKRS
1 CEST4 PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 CEST4 PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 CEST4 QUNIT1 T006 Units of Measurement MANDT
1 CEST4 QUNIT2 T006 Units of Measurement MANDT
0 CEST4 QUNIT3 T006 Units of Measurement MANDT
1 CEST4 SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 CEST4 SERVICE_DOC_ID FCOV_SRVDOC_TYID Generated Table for View MANDT
0 CEST4 SERVICE_DOC_ID FCOV_SRVDOC_TYID Generated Table for View SERVICE_DOC_ID
1 CEST4 SERVICE_DOC_ITEM_ID FCO_SRVDOC Financials View of Service Document MANDT
1 CEST4 SERVICE_DOC_ITEM_ID FCO_SRVDOC Financials View of Service Document SERVICE_DOC_ID
1 CEST4 SERVICE_DOC_ITEM_ID FCO_SRVDOC Financials View of Service Document SERVICE_DOC_ITEM_ID
0 CEST4 SOLUTION_ORDER_ID CRMS4D_SERV_H Header of service transactions .INCLUDE
1 CEST4 SOLUTION_ORDER_ITEM_ID CRMS4D_SERV_I Items of service transactions .INCLUDE
1 CEST4 SOLUTION_ORDER_ITEM_ID CRMS4D_SERV_I Items of service transactions .INCLUDE
0 CEST4 SPART TSPA Organizational Unit: Sales Divisions MANDT
0 CEST4 SPART TSPA Organizational Unit: Sales Divisions SPART
1 CEST4 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 CEST4 VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 CEST4 VTKEY DFKK_VT_H CT: Header Data of Provider Contract MANDT
0 CEST4 VTKEY DFKK_VT_H CT: Header Data of Provider Contract VTKEY
1 CEST4 VTPOS DFKK_VT_I CT: Items of Provider Contract MANDT
1 CEST4 VTPOS DFKK_VT_I CT: Items of Provider Contract VTKEY
1 CEST4 VTPOS DFKK_VT_I CT: Items of Provider Contract VTPOS
0 CEST4 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 CEST4 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
1 CEST4 WERKS T001W Plants/Branches WERKS