The CE29999 table in SAP ERP or S/4HANA stores data. There are total 76 fields in CE29999 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 CE29999 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 CE29999 Table Fields
Following is the list of fields that are available in SAP CE29999 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) | |
| BONUS | Volume rebate group | BONUS | TVBO | CHAR (2) |
| BRSCH | Industry key | BRSCH | T016 | CHAR (4) |
| BZIRK | Sales District | BZIRK | T171 | CHAR (6) |
| COPA_PRZNR | Business Process | CO_PRZNR | CBPR | CHAR (12) |
| CRMCSTY | CRM Cost Element | RKECRMCSTY | CSKA | CHAR (10) |
| EFORM | Form of manufacture | RKEG_EFORM | T2513 | CHAR (5) |
| GEBIE | Area | RKEG_GEBIE | T2538 | CHAR (4) |
| KDGRP | Customer Group | KDGRP | T151 | CHAR (2) |
| KMATYP | Aircraft Type | RKESKMATYP | T2209 | NUMC (2) |
| KMBRND | Brand | RKESKMBRND | T2249 | NUMC (2) |
| KMDEST | Destination | RKESKMDEST | T2211 | CHAR (5) |
| KMFLTN | Flight Number | RKESKMFLTN | T2215 | CHAR (6) |
| KMFLTY | Flight Type | RKESKMFLTY | T2216 | CHAR (4) |
| KMHI01 | Customer hierarchy Level 1 | HIEZU01 | KNA1 | CHAR (10) |
| KMIATA | IATA Season | RKESKMIATA | T2207 | CHAR (5) |
| KMLAND | Country Key | LAND1_GP | T005 | CHAR (3) |
| KMLEGS | Route Segment | RKESKMLEGS | T2213 | CHAR (7) |
| KMMAKL | Material Group | MATKL | T023 | CHAR (9) |
| KMOPDY | Day of Operation | RKESKMOPDY | T2208 | CHAR (2) |
| KMORIG | Departure Location | RKESKMORIG | T2212 | CHAR (5) |
| KMROUT | Rotation | RKESKMROUT | T2210 | CHAR (5) |
| KMSTGE | Strategic Business Unit | RKESKMSTGE | T2247 | NUMC (2) |
| KMVKBU | Sales office | VKBUR | TVBUR | CHAR (4) |
| KMVKGR | Sales group | VKGRP | TVKGR | CHAR (3) |
| KMVTNR | Sales employee | VRTNR | NUMC (8) | |
| KMWNHG | Main Material Group | RKESKMWNHG | T2246 | NUMC (2) |
| KMZONE | Zone | RKESKMZONE | T2214 | CHAR (5) |
| KUNWE | Ship-to party | KUNWE | KNA1 | CHAR (10) |
| PAPH1 | Prod.hierarchy01-1 | RKEG_PAPH1 | CHAR (5) | |
| PRODH | Product hierarchy | PRODH_D | T179 | CHAR (18) |
| WWACT | Activity | RKEG_WWACT | T2500 | CHAR (2) |
| WWERM | Shipping Point / Receiving Point | VSTEL | TVST | CHAR (4) |
| WWTES | Test Partner | RKEG_WWTES | CHAR (10) |
