The CE3ALDO table in SAP ERP or S/4HANA stores ALDO data. There are total 44 fields in CE3ALDO table. The ALDO 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 CE3ALDO 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 CE3ALDO Table Fields
Following is the list of fields that are available in SAP CE3ALDO table. The primary key fields of the table are MANDT (Client), PAOBJNR (Profitability Segment Number (CO-PA)), PALEDGER (Currency type for an operating concern), VRGAR (Record Type), PLIKZ (Plan/Actual Indicator), VERSI (Plan version (CO-PA)), PERBL (Fiscal year/period block), PASUBNR (Profitability Segment Changes (CO-PA)), PAPAOBJNR (Partner profitability segment number (CO-PA)), PAPASUBNR (Changes to partner profitability segments (CO-PA)), HRKFT (Origins (CO-PA)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC (10) | |
| PALEDGER | Currency type for an operating concern | LEDBO | TKEL | CHAR (2) |
| VRGAR | Record Type | RKE_VRGAR | TVGA | CHAR (1) |
| PLIKZ | Plan/Actual Indicator | PLIKZ | CHAR (1) | |
| VERSI | Plan version (CO-PA) | RKEVERSI | TKVS | CHAR (3) |
| PERBL | Fiscal year/period block | JAHRPERBL | NUMC (7) | |
| PASUBNR | Profitability Segment Changes (CO-PA) | RKESUBNR | NUMC (4) | |
| PAPAOBJNR | Partner profitability segment number (CO-PA) | RKEPOBJ | NUMC (10) | |
| PAPASUBNR | Changes to partner profitability segments (CO-PA) | RKEPSUBNR | NUMC (4) | |
| HRKFT | Origins (CO-PA) | RKEHERK | CHAR (4) | |
| UPDAT | Date of Last Change | LAEDA | DATS (8) | |
| USNAM | Last Changed By | AENNM | CHAR (12) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| REC_WAERS | Currency of the data record | RKE_REC_WAERS | CUKY (5) | |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC (16) | |
| ABSMG001 | Sales quantity | RKE2_ABSMG | QUAN (15) | |
| AUSFR001 | OutgoingFreight | RKE2_AUSFR | CURR (23) | |
| ERLOS001 | Revenue | RKE2_ERLOS | CURR (23) | |
| KWABFK001 | Variance: Shipment Costs | RKESKWABFK | CURR (23) | |
| KWABLG001 | Lot Size Variance | RKESKWABLG | CURR (23) | |
| KWABLK001 | Idle-Capacity Costs | RKESKWABLK | CURR (23) | |
| KWABMG001 | Quantity Variance | RKESKWABMG | CURR (23) | |
| KWABPR001 | Price Variance | RKESKWABPR | CURR (23) | |
| KWABSG001 | Other variances | RKESKWABSG | CURR (23) | |
| KWABST001 | Resource-Usage Variance | RKESKWABST | CURR (23) | |
| KWBRUM001 | Gross Sales | RKESKWBRUM | CURR (23) | |
| KWFKFX001 | Fixed Manufacturing Costs | RKESKWFKFX | CURR (23) | |
| KWFKVA001 | Variable Production Costs | RKESKWFKVA | CURR (23) | |
| KWFOEN001 | Research and Development | RKESKWFOEN | CURR (23) | |
| KWFRGR001 | Freight | RKESKWFRGR | CURR (23) | |
| KWGOHD001 | Administration Costs | RKESKWGOHD | CURR (23) | |
| KWINSR001 | Insurance | RKESKWINSR | CURR (23) | |
| KWKDRB001 | Customer Discount | RKESKWKDRB | CURR (23) | |
| KWMAEK001 | Direct Material Costs | RKESKWMAEK | CURR (23) | |
| KWMAGK001 | Material Overhead Costs | RKESKWMAGK | CURR (23) | |
| KWMKAD001 | Advertising | RKESKWMKAD | CURR (23) | |
| KWMKDP001 | Marketing Department | RKESKWMKDP | CURR (23) | |
| KWSKTO001 | Cash Discount | RKESKWSKTO | CURR (23) | |
| KWVERW001 | Administration Costs | RKESKWVERW | CURR (23) | |
| KWVKPV001 | Sales Commission | RKESKWVKPV | CURR (23) | |
| ROHST001 | Raw materials | RKE2_ROHST | CURR (23) | |
| STDPR001 | Standard price | RKE2_STDPR | CURR (23) | |
| VRPRS001 | Stock Value | RKE2_VRPRS | CURR (23) |
