Search by table name, fields

SAP CE1S_CP Table – Template for Consumer Goods Industry

The CE1S_CP table in SAP ERP or S/4HANA stores Template for Consumer Goods Industry data. There are total 100 fields in CE1S_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 CE1S_CP table. It is in Profitability Analysis: Generated Objects (Transportable) (KEG2) ABAP package and is part of the Profitability Analysis (CO-PA) module.

SAP CE1S_CP Table Fields

Following is the list of fields that are available in SAP CE1S_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)), PERIO (Period/Year), PAOBJNR (Profitability Segment Number (CO-PA)), PASUBNR (Profitability Segment Changes (CO-PA)), BELNR (Document number of line item in Profitability Analysis), POSNR (Item no. of CO-PA line item).

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)
PERIO Period/Year JAHRPER NUMC (7)
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)
POSNR Item no. of CO-PA line item RKE_POSNR CHAR (6)
HZDAT Date on which the record was created ERDAT DATS (8)
USNAM Created by ERFASSER CHAR (12)
GJAHR Fiscal Year GJAHR NUMC (4)
PERDE Period PERIODE NUMC (3)
WADAT Goods Issue Date WADAT DATS (8)
FADAT Invoice date (date created) FADAT DATS (8)
BUDAT Posting Date DAERF DATS (8)
ALTPERIO Period/year in alternative period type JAHRPERALT NUMC (7)
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)
KURSF Exchange rate KURSF DEC (9)
KURSBK Exchange rate for op.concern currency -> Co.code currency KURSBK DEC (9)
KURSKZ Exchange rate op.concern currency -> group currency KURSKZ DEC (9)
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)
PLIKZ Plan/Actual Indicator PLIKZ CHAR (1)
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)
STO_BELNR Canceled document RKE_STO_BELNR CHAR (10)
STO_POSNR Canceled document item RKE_STO_POSNR 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)
COPA_AWTYP Reference procedure AWTYP CHAR (5)
COPA_AWORG Reference Organizational Units AWORG CHAR (10)
COPA_BWZPT CO-PA Point of valuation BWZPT CHAR (1)
COPA_AWSYS Logical system of source document AWSYS TBDLS CHAR (10)
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)
KWABFK Variance: Shipment Costs RKESKWABFK CURR (23)
KWABLG Lot Size Variance RKESKWABLG CURR (23)
KWABLK Idle-Capacity Costs RKESKWABLK CURR (23)
KWABMG Quantity Variance RKESKWABMG CURR (23)
KWABPR Price Variance RKESKWABPR CURR (23)
KWABSG Other variances RKESKWABSG CURR (23)
KWABST Resource-Usage Variance RKESKWABST CURR (23)
KWAKRB Spec. offer discount RKESKWAKRB CURR (23)
KWBONI Bonuses RKESKWBONI CURR (23)
KWBRUM Gross Sales RKESKWBRUM CURR (23)
KWFKFX Fixed Manufacturing Costs RKESKWFKFX CURR (23)
KWFKVA Variable Production Costs RKESKWFKVA CURR (23)
KWFOEN Research and Development RKESKWFOEN CURR (23)
KWKDRB Customer Discount RKESKWKDRB CURR (23)
KWKLFK Accrued shipment costs RKESKWKLFK CURR (23)
KWLOGI Logistics RKESKWLOGI CURR (23)
KWMAEK Direct Material Costs RKESKWMAEK CURR (23)
KWMAGK Material Overhead Costs RKESKWMAGK CURR (23)
KWMARB Material discount RKESKWMARB CURR (23)
KWMGRB Quantity Discount RKESKWMGRB CURR (23)
KWMKAD Advertising RKESKWMKAD CURR (23)
KWMKDP Marketing Department RKESKWMKDP CURR (23)
KWMKPR Promotion RKESKWMKPR CURR (23)
KWSKTO Cash Discount RKESKWSKTO CURR (23)
KWVERW Administration Costs RKESKWVERW CURR (23)
KWVKPV Sales Commission RKESKWVKPV CURR (23)
KWVSEK Sales Special Direct Costs RKESKWVSEK CURR (23)
KWVTAD Sales field service RKESKWVTAD CURR (23)
KWVTID Sales office RKESKWVTID CURR (23)
KWSVME Sales Quantity RKESKWSVME QUAN (15)