The CE21000 table in SAP ERP or S/4HANA stores data. There are total 51 fields in CE21000 table. The table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CE21000 table. It is in Profitability Analysis: objects generated by the customer (KEG0) ABAP package and is part of the Profitability Analysis (CO-PA) module.
SAP CE21000 Table Fields
Following is the list of fields that are available in SAP CE21000 table. The primary key fields of the table are MANDT (Client), PALEDGER (Currency type for an operating concern), VRGAR (Record Type), VERSI (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).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| PALEDGER | Currency type for an operating concern | LEDBO | TKEL | CHAR (2) |
| VRGAR | Record Type | RKE_VRGAR | TVGA | CHAR (1) |
| VERSI | Plan version (CO-PA) | RKEVERSI | TKVS | CHAR (3) |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC (10) | |
| PASUBNR | Profitability Segment Changes (CO-PA) | RKESUBNR | NUMC (4) | |
| BELNR | Document number of line item in Profitability Analysis | RKE_BELNR | CHAR (10) | |
| PERBL | Fiscal year/period block | JAHRPERBL | NUMC (7) | |
| HZDAT | Date on which the record was created | ERDAT | DATS (8) | |
| USNAM | Created by | ERFASSER | CHAR (12) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| PAPAOBJNR | Partner profitability segment number (CO-PA) | RKEPOBJ | NUMC (10) | |
| PAPASUBNR | Changes to partner profitability segments (CO-PA) | RKEPSUBNR | NUMC (4) | |
| KNDNR | Customer | KUNDE_PA | KNA1 | CHAR (10) |
| ARTNR | Product number | ARTNR | MARA | CHAR (40) |
| FKART | Billing Type | FKART | TVFK | CHAR (4) |
| FRWAE | Foreign currency key | FRWAE | TCURC | CUKY (5) |
| REC_WAERS | Currency of the data record | RKE_REC_WAERS | TCURC | CUKY (5) |
| KAUFN | Sales Order Number | KDAUF | CHAR (10) | |
| KDPOS | Item number in Sales Order | KDPOS | NUMC (6) | |
| RKAUFNR | Order Number | AUFNR | AUFK | CHAR (12) |
| SKOST | Sender cost center | SKOST | CSKS | CHAR (10) |
| PRZNR | Sender Business Process | SEPRZ | CBPR | CHAR (12) |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR (4) |
| WERKS | Plant | WERKS_D | T001W | CHAR (4) |
| GSBER | Business Area | GSBER | TGSB | CHAR (4) |
| FKBER | Functional Area | FKBER | TFKB | CHAR (16) |
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | FAGL_SEGM | CHAR (10) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR (2) |
| SPART | Division | SPART | TSPA | CHAR (2) |
| HRKFT | Origins (CO-PA) | RKEHERK | CHAR (4) | |
| KSTAR | Cost Element | KSTAR | CSKA | CHAR (10) |
| PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC (8) |
| COPA_KOSTL | Cost center | COPA_KOSTL | CSKS | CHAR (10) |
| KSTRG | Cost Object | KSTRG | CKPH | CHAR (12) |
| RBELN | Reference document number for CO-PA line item | RKERFBELNR | CHAR (10) | |
| RPOSN | Item number from reference document (CO-PA) | RKERFPOSNR | CHAR (6) | |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR (10) |
| PPRCTR | Partner Profit Center | PPRCTR | CEPC | CHAR (10) |
| RKESTATU | Update status for CO-PA line items | RKESTATU | CHAR (10) | |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC (16) | |
| SERVICE_DOC_TYPE | Service Document Type | FCO_SRVDOC_TYPE | CRMC_PROC_TYPE | CHAR (4) |
| SERVICE_DOC_ID | Service Document ID | FCO_SRVDOC_ID | FCOV_SRVDOC_TYID | CHAR (10) |
| SERVICE_DOC_ITEM_ID | Service Document Item ID | FCO_SRVDOC_ITEM_ID | FCO_SRVDOC | NUMC (6) |
| SOLUTION_ORDER_ID | Solution Order ID | FCO_SOLUTION_ORDER_ID | CRMS4D_SERV_H | CHAR (10) |
| SOLUTION_ORDER_ITEM_ID | Solution Order Item ID | FCO_SOLUTION_ORDER_ITEM_ID | CRMS4D_SERV_I | NUMC (6) |
| KMHI01 | Customer hierarchy Level 1 | HIEZU01 | KNA1 | CHAR (10) |
| KMHI02 | Customer hierarchy Level 2 | HIEZU02 | KNA1 | CHAR (10) |
| KMHI03 | Customer hierarchy Level 3 | HIEZU03 | KNA1 | CHAR (10) |
