The CE2S_CP table in SAP ERP or S/4HANA stores Template for Consumer Goods Industry data. There are total 84 fields in CE2S_CP table. The Template for Consumer Goods Industry 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 CE2S_CP table. It is in Profitability Analysis: Generated Objects (Transportable) (KEG2) ABAP package and is part of the Profitability Analysis (CO-PA) module.
SAP CE2S_CP Table Fields
Following is the list of fields that are available in SAP CE2S_CP table. The primary key fields of Template for Consumer Goods Industry table in SAP 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) |
| 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) |
| 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) | |
| KMBRND | Brand | RKESKMBRND | T2249 | NUMC (2) |
| KMCATG | Business field | RKESKMCATG | T2248 | NUMC (2) |
| 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) |
| KMKDGR | Customer Group | KDGRP | T151 | CHAR (2) |
| KMLAND | Country Key | LAND1_GP | T005 | CHAR (3) |
| KMMAKL | Material Group | MATKL | T023 | CHAR (9) |
| KMNIEL | Nielsen ID | NIELS | TNLS | CHAR (2) |
| 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) | |
| KWSVME_ME | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| 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) | |
| KWAKRB001 | Spec. offer discount | RKESKWAKRB | CURR (23) | |
| KWBONI001 | Bonuses | RKESKWBONI | 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) | |
| KWKDRB001 | Customer Discount | RKESKWKDRB | CURR (23) | |
| KWKLFK001 | Accrued shipment costs | RKESKWKLFK | CURR (23) | |
| KWLOGI001 | Logistics | RKESKWLOGI | CURR (23) | |
| KWMAEK001 | Direct Material Costs | RKESKWMAEK | CURR (23) | |
| KWMAGK001 | Material Overhead Costs | RKESKWMAGK | CURR (23) | |
| KWMARB001 | Material discount | RKESKWMARB | CURR (23) | |
| KWMGRB001 | Quantity Discount | RKESKWMGRB | CURR (23) | |
| KWMKAD001 | Advertising | RKESKWMKAD | CURR (23) | |
| KWMKDP001 | Marketing Department | RKESKWMKDP | CURR (23) | |
| KWMKPR001 | Promotion | RKESKWMKPR | CURR (23) | |
| KWSKTO001 | Cash Discount | RKESKWSKTO | CURR (23) | |
| KWVERW001 | Administration Costs | RKESKWVERW | CURR (23) | |
| KWVKPV001 | Sales Commission | RKESKWVKPV | CURR (23) | |
| KWVSEK001 | Sales Special Direct Costs | RKESKWVSEK | CURR (23) | |
| KWVTAD001 | Sales field service | RKESKWVTAD | CURR (23) | |
| KWVTID001 | Sales office | RKESKWVTID | CURR (23) | |
| KWSVME001 | Sales Quantity | RKESKWSVME | QUAN (15) |
