1. Home
  2. Resources
  3. SAP Tables
  4. CE1S_CP - Template for Consumer Goods Industry

SAP Table CE1S_CP

Template for Consumer Goods Industry

CE1S_CP (Template for Consumer Goods Industry) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CE1S_CP to other SAP tables.

CE1S_CP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PALEDGER Currency type for an operating concern LEDBO TKEL CHAR 2 0
VRGAR Record Type RKE_VRGAR TVGA CHAR 1 0
VERSI Plan version (CO-PA) RKEVERSI TKVS CHAR 3 0
PERIO Period/year JAHRPER NUMC 7 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PASUBNR Profitability segment changes (CO-PA) RKESUBNR NUMC 4 0
BELNR Document number of line item in Profitability Analysis RKE_BELNR CHAR 10 0
POSNR Item no. of CO-PA line item RKE_POSNR CHAR 6 0
HZDAT Date on Which Record Was Created ERDAT DATS 8 0
USNAM Created by ERFASSER CHAR 12 0
GJAHR Fiscal Year GJAHR NUMC 4 0
PERDE Period PERIODE NUMC 3 0
WADAT Goods Issue Date WADAT DATS 8 0
FADAT Invoice date (date created) FADAT DATS 8 0
BUDAT Posting Date DAERF DATS 8 0
ALTPERIO Period/year in alternative period type JAHRPERALT NUMC 7 0
PAPAOBJNR Partner profitability segment number (CO-PA) RKEPOBJ NUMC 10 0
PAPASUBNR Changes to partner profitability segments (CO-PA) RKEPSUBNR NUMC 4 0
KNDNR Customer KUNDE_PA KNA1 CHAR 10 0
ARTNR Product number ARTNR MARA CHAR 18 0
FKART Billing Type FKART TVFK CHAR 4 0
FRWAE Foreign currency key FRWAE TCURC CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
KURSBK Exchange rate for op.concern currency -> Co.code currency KURSBK DEC 9 5
KURSKZ Exchange rate op.concern currency -> group currency KURSKZ DEC 9 5
REC_WAERS Currency of the data record RKE_REC_WAERS TCURC CUKY 5 0
KAUFN Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
RKAUFNR Order Number AUFNR AUFK CHAR 12 0
SKOST Sender cost center SKOST CSKS CHAR 10 0
PRZNR Sender Business Process SEPRZ CBPR CHAR 12 0
BUKRS Company Code BUKRS T001 CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
WERKS Plant WERKS_D T001W CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
HRKFT Origins (CO-PA) RKEHERK CHAR 4 0
PLIKZ Plan/Actual Indicator PLIKZ CHAR 1 0
0 Actual data
1 Planning data
KSTAR Cost Element KSTAR CSKA CHAR 10 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
KSTRG Cost Object KSTRG CKPH CHAR 12 0
RBELN Reference document number for CO-PA line item RKERFBELNR CHAR 10 0
RPOSN Item number from reference document (CO-PA) RKERFPOSNR CHAR 6 0
STO_BELNR Canceled document RKE_STO_BELNR CHAR 10 0
STO_POSNR Canceled document item RKE_STO_POSNR CHAR 6 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
PPRCTR Partner Profit Center PPRCTR CEPC CHAR 10 0
RKESTATU Update status for CO-PA line items RKESTATU CHAR 10 0
TIMESTMP Time created (Greenwich Meantime) RKE_HZSTMP DEC 16 0
COPA_AWTYP Reference Transaction AWTYP CHAR 5 0
COPA_AWORG Reference Organizational Units AWORG CHAR 10 0
COPA_BWZPT CO-PA Point of valuation BWZPT CHAR 1 0
0 Activity-related valuation
1 Periodic valuation
COPA_AWSYS Logical system of source document AWSYS TBDLS CHAR 10 0
KMBRND Brand RKESKMBRND T2249 NUMC 2 0
KMCATG Business field RKESKMCATG T2248 NUMC 2 0
KMHI01 Customer hierarchy Level 1 HIEZU01 KNA1 CHAR 10 0
KMHI02 Customer hierarchy Level 2 HIEZU02 KNA1 CHAR 10 0
KMHI03 Customer hierarchy Level 3 HIEZU03 KNA1 CHAR 10 0
KMKDGR Customer group KDGRP T151 CHAR 2 0
KMLAND Country Key LAND1_GP T005 CHAR 3 0
KMMAKL Material Group MATKL T023 CHAR 9 0
KMNIEL Nielsen ID NIELS TNLS CHAR 2 0
KMSTGE Strategic Business Unit RKESKMSTGE T2247 NUMC 2 0
KMVKBU Sales Office VKBUR TVBUR CHAR 4 0
KMVKGR Sales Group VKGRP TVKGR CHAR 3 0
KMVTNR Sales employee VRTNR NUMC 8 0
KWSVME_ME Base Unit of Measure MEINS T006 UNIT 3 0
KWABFK Variance: Shipment Costs RKESKWABFK CURR 15 2
KWABLG Lot size variance RKESKWABLG CURR 15 2
KWABLK Idle-Capacity Costs RKESKWABLK CURR 15 2
KWABMG Quantity Variance RKESKWABMG CURR 15 2
KWABPR Price Variance RKESKWABPR CURR 15 2
KWABSG Other variances RKESKWABSG CURR 15 2
KWABST Resource-Usage Variance RKESKWABST CURR 15 2
KWAKRB Spec. offer discount RKESKWAKRB CURR 15 2
KWBONI Bonuses RKESKWBONI CURR 15 2
KWBRUM Gross sales RKESKWBRUM CURR 15 2
KWFKFX Fixed Manufacturing Costs RKESKWFKFX CURR 15 2
KWFKVA Variable Production Costs RKESKWFKVA CURR 15 2
KWFOEN Research and Development RKESKWFOEN CURR 15 2
KWKDRB Customer Discount RKESKWKDRB CURR 15 2
KWKLFK Accrued shipment costs RKESKWKLFK CURR 15 2
KWLOGI Logistics RKESKWLOGI CURR 15 2
KWMAEK Direct Material Costs RKESKWMAEK CURR 15 2
KWMAGK Material overhead costs RKESKWMAGK CURR 15 2
KWMARB Material discount RKESKWMARB CURR 15 2
KWMGRB Quantity discount RKESKWMGRB CURR 15 2
KWMKAD Advertising RKESKWMKAD CURR 15 2
KWMKDP Marketing Department RKESKWMKDP CURR 15 2
KWMKPR Promotion RKESKWMKPR CURR 15 2
KWSKTO Cash discount RKESKWSKTO CURR 15 2
KWVERW Administration Costs RKESKWVERW CURR 15 2
KWVKPV Sales commission RKESKWVKPV CURR 15 2
KWVSEK Sales Special Direct Costs RKESKWVSEK CURR 15 2
KWVTAD Sales field service RKESKWVTAD CURR 15 2
KWVTID Sales office RKESKWVTID CURR 15 2
KWSVME Sales quantity RKESKWSVME QUAN 15 3

CE1S_CP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CE1S_CP ARTNR CE1S_CP ARTNR MARA General Material Data MATNR
CE1S_CP ARTNR CE1S_CP MANDT MARA General Material Data MANDT
CE1S_CP BUKRS CE1S_CP BUKRS T001 Company Codes BUKRS
CE1S_CP BUKRS CE1S_CP MANDT T001 Company Codes MANDT
CE1S_CP COPA_AWSYS CE1S_CP COPA_AWSYS TBDLS Logical system LOGSYS
CE1S_CP FKART CE1S_CP MANDT TVFK Billing: Document Types MANDT
CE1S_CP FKART CE1S_CP FKART TVFK Billing: Document Types FKART
CE1S_CP FRWAE CE1S_CP MANDT TCURC Currency Codes MANDT
CE1S_CP FRWAE CE1S_CP FRWAE TCURC Currency Codes WAERS
CE1S_CP GSBER CE1S_CP MANDT TGSB Business Areas MANDT
CE1S_CP GSBER CE1S_CP GSBER TGSB Business Areas GSBER
CE1S_CP KAUFN CE1S_CP MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CE1S_CP KAUFN CE1S_CP KAUFN VBUK Sales Document: Header Status and Administrative Data VBELN
CE1S_CP KMBRND CE1S_CP KMBRND T2249 Values for Characteristic "Brand " KMBRND
CE1S_CP KMBRND CE1S_CP MANDT T2249 Values for Characteristic "Brand " MANDT
CE1S_CP KMCATG CE1S_CP MANDT T2248 Values for Characteristic "Category " MANDT
CE1S_CP KMCATG CE1S_CP KMCATG T2248 Values for Characteristic "Category " KMCATG
CE1S_CP KMHI01 CE1S_CP MANDT KNA1 General Data in Customer Master MANDT
CE1S_CP KMHI01 CE1S_CP KMHI01 KNA1 General Data in Customer Master KUNNR
CE1S_CP KMHI02 CE1S_CP MANDT KNA1 General Data in Customer Master MANDT
CE1S_CP KMHI02 CE1S_CP KMHI02 KNA1 General Data in Customer Master KUNNR
CE1S_CP KMHI03 CE1S_CP MANDT KNA1 General Data in Customer Master MANDT
CE1S_CP KMHI03 CE1S_CP KMHI03 KNA1 General Data in Customer Master KUNNR
CE1S_CP KMKDGR CE1S_CP MANDT T151 Customers: Customer Groups MANDT
CE1S_CP KMKDGR CE1S_CP KMKDGR T151 Customers: Customer Groups KDGRP
CE1S_CP KMLAND CE1S_CP MANDT T005 Countries MANDT
CE1S_CP KMLAND CE1S_CP KMLAND T005 Countries LAND1
CE1S_CP KMMAKL CE1S_CP MANDT T023 Material Groups MANDT
CE1S_CP KMMAKL CE1S_CP KMMAKL T023 Material Groups MATKL
CE1S_CP KMNIEL CE1S_CP MANDT TNLS Nielsen ID MANDT
CE1S_CP KMNIEL CE1S_CP KMNIEL TNLS Nielsen ID NIELS
CE1S_CP KMSTGE CE1S_CP MANDT T2247 Values for Characteristic "Strategy Business Unit." MANDT
CE1S_CP KMSTGE CE1S_CP KMSTGE T2247 Values for Characteristic "Strategy Business Unit." KMSTGE
CE1S_CP KMVKBU CE1S_CP MANDT TVBUR Organizational Unit: Sales Offices MANDT
CE1S_CP KMVKBU CE1S_CP KMVKBU TVBUR Organizational Unit: Sales Offices VKBUR
CE1S_CP KMVKGR CE1S_CP MANDT TVKGR Organizational Unit: Sales Groups MANDT
CE1S_CP KMVKGR CE1S_CP KMVKGR TVKGR Organizational Unit: Sales Groups VKGRP
CE1S_CP KNDNR CE1S_CP MANDT KNA1 General Data in Customer Master MANDT
CE1S_CP KNDNR CE1S_CP KNDNR KNA1 General Data in Customer Master KUNNR
CE1S_CP KOKRS CE1S_CP MANDT TKA01 Controlling Areas MANDT
CE1S_CP KOKRS CE1S_CP KOKRS TKA01 Controlling Areas KOKRS
CE1S_CP KSTAR CE1S_CP MANDT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
CE1S_CP KSTAR * CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
CE1S_CP KSTAR CE1S_CP KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KSTAR
CE1S_CP KSTRG CE1S_CP MANDT CKPH Master Record: Cost Object ID Number MANDT
CE1S_CP KSTRG CE1S_CP KSTRG CKPH Master Record: Cost Object ID Number KSTRG
CE1S_CP KSTRG * CKPH Master Record: Cost Object ID Number DATBI
CE1S_CP KWSVME_ME CE1S_CP KWSVME_ME T006 Units of Measurement MSEHI
CE1S_CP KWSVME_ME CE1S_CP MANDT T006 Units of Measurement MANDT
CE1S_CP MANDT CE1S_CP MANDT T000 Clients MANDT
CE1S_CP PALEDGER CE1S_CP PALEDGER TKEL CO-PA ledger PALEDGER
CE1S_CP PALEDGER CE1S_CP MANDT TKEL CO-PA ledger MANDT
CE1S_CP PPRCTR CE1S_CP MANDT CEPC Profit Center Master Data Table MANDT
CE1S_CP PPRCTR CE1S_CP PPRCTR CEPC Profit Center Master Data Table PRCTR
CE1S_CP PPRCTR * CEPC Profit Center Master Data Table DATBI
CE1S_CP PPRCTR CE1S_CP KOKRS CEPC Profit Center Master Data Table KOKRS
CE1S_CP PRCTR * CEPC Profit Center Master Data Table DATBI
CE1S_CP PRCTR CE1S_CP KOKRS CEPC Profit Center Master Data Table KOKRS
CE1S_CP PRCTR CE1S_CP MANDT CEPC Profit Center Master Data Table MANDT
CE1S_CP PRCTR CE1S_CP PRCTR CEPC Profit Center Master Data Table PRCTR
CE1S_CP PRZNR CE1S_CP MANDT CBPR CO-ABC: Activity Master Table MANDT
CE1S_CP PRZNR CE1S_CP KOKRS CBPR CO-ABC: Activity Master Table KOKRS
CE1S_CP PRZNR CE1S_CP PRZNR CBPR CO-ABC: Activity Master Table PRZNR
CE1S_CP PRZNR * CBPR CO-ABC: Activity Master Table DATBI
CE1S_CP PSPNR CE1S_CP MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
CE1S_CP PSPNR CE1S_CP PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
CE1S_CP REC_WAERS CE1S_CP MANDT TCURC Currency Codes MANDT
CE1S_CP REC_WAERS CE1S_CP REC_WAERS TCURC Currency Codes WAERS
CE1S_CP RKAUFNR CE1S_CP RKAUFNR AUFK Order master data AUFNR
CE1S_CP RKAUFNR CE1S_CP MANDT AUFK Order master data MANDT
CE1S_CP SKOST CE1S_CP SKOST CSKS Cost Center Master Data KOSTL
CE1S_CP SKOST * CSKS Cost Center Master Data DATBI
CE1S_CP SKOST CE1S_CP MANDT CSKS Cost Center Master Data MANDT
CE1S_CP SKOST CE1S_CP KOKRS CSKS Cost Center Master Data KOKRS
CE1S_CP SPART CE1S_CP MANDT TSPA Organizational Unit: Sales Divisions MANDT
CE1S_CP SPART CE1S_CP SPART TSPA Organizational Unit: Sales Divisions SPART
CE1S_CP VERSI CE1S_CP MANDT TKVS CO Versions MANDT
CE1S_CP VERSI CE1S_CP VERSI TKVS CO Versions VERSI
CE1S_CP VKORG CE1S_CP VKORG TVKO Organizational Unit: Sales Organizations VKORG
CE1S_CP VKORG CE1S_CP MANDT TVKO Organizational Unit: Sales Organizations MANDT
CE1S_CP VRGAR CE1S_CP MANDT TVGA Record types for CO-PA MANDT
CE1S_CP VRGAR CE1S_CP VRGAR TVGA Record types for CO-PA VRGAR
CE1S_CP VTWEG CE1S_CP MANDT TVTW Organizational Unit: Distribution Channels MANDT
CE1S_CP VTWEG CE1S_CP VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
CE1S_CP WERKS CE1S_CP MANDT T001W Plants/Branches MANDT
CE1S_CP WERKS CE1S_CP WERKS T001W Plants/Branches WERKS