SAP Table CE1S001

Sample operating concern

CE1S001 (Sample operating concern) 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 CE1S001 to other SAP tables.

CE1S001 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 Sales Document Item POSNR_VA 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
KDGRP Customer group KDGRP T151 CHAR 2 0
BZIRK Sales district BZIRK T171 CHAR 6 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
BRSCH Industry key BRSCH T016 CHAR 4 0
LAND1 Country Key LAND1_GP T005 CHAR 3 0
STO_BELNR Canceled document RKE_STO_BELNR CHAR 10 0
STO_POSNR Canceled document item RKE_STO_POSNR CHAR 6 0
MATKL Material Group MATKL T023 CHAR 9 0
MAABC ABC Indicator MAABC TMABC CHAR 1 0
BONUS Volume rebate group BONUS TVBO CHAR 2 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
EFORM Form of manufacture RKEG_EFORM T2513 CHAR 5 0
GEBIE Area RKEG_GEBIE T2538 CHAR 4 0
ABSMG_ME Base Unit of Measure MEINS T006 UNIT 3 0
COPA_AWSYS Logical system of source document AWSYS TBDLS CHAR 10 0
ABSMG Sales quantity RKE2_ABSMG QUAN 15 3
ERLOS Revenue RKE2_ERLOS CURR 15 2
MRABA Qty discount RKE2_MRABA CURR 15 2
PRABA Price reduction RKE2_PRABA CURR 15 2
RABAT Other discounts RKE2_RABAT CURR 15 2
AUSFR OutgoingFreight RKE2_AUSFR CURR 15 2
VSVP DispatchPackag. RKE2_VSVP CURR 15 2
UMSLZ Licensing Fees RKE2_UMSLZ CURR 15 2
PROVV Ext. Commission RKE2_PROVV CURR 15 2
VWGK Administration Overhead Costs RKE2_VWGK CURR 15 2
VTRGK Sales Overhead RKE2_VTRGK CURR 15 2
VRPRS Stock Value RKE2_VRPRS CURR 15 2
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
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

CE1S001 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CE1S001 ABSMG_ME CE1S001 ABSMG_ME T006 Units of Measurement MSEHI
CE1S001 ABSMG_ME CE1S001 MANDT T006 Units of Measurement MANDT
CE1S001 ARTNR CE1S001 ARTNR MARA General Material Data MATNR
CE1S001 ARTNR CE1S001 MANDT MARA General Material Data MANDT
CE1S001 BONUS CE1S001 MANDT TVBO Sales Rebate Groups MANDT
CE1S001 BONUS CE1S001 BONUS TVBO Sales Rebate Groups BONUS
CE1S001 BRSCH CE1S001 MANDT T016 Industries MANDT
CE1S001 BRSCH CE1S001 BRSCH T016 Industries BRSCH
CE1S001 BUKRS CE1S001 BUKRS T001 Company Codes BUKRS
CE1S001 BUKRS CE1S001 MANDT T001 Company Codes MANDT
CE1S001 BZIRK CE1S001 MANDT T171 Customers: Sales Districts MANDT
CE1S001 BZIRK CE1S001 BZIRK T171 Customers: Sales Districts BZIRK
CE1S001 COPA_AWSYS CE1S001 COPA_AWSYS TBDLS Logical system LOGSYS
CE1S001 EFORM CE1S001 EFORM T2513 Table of Characteristic Values EFORM
CE1S001 EFORM CE1S001 MANDT T2513 Table of Characteristic Values MANDT
CE1S001 FKART CE1S001 MANDT TVFK Billing: Document Types MANDT
CE1S001 FKART CE1S001 FKART TVFK Billing: Document Types FKART
CE1S001 FRWAE CE1S001 MANDT TCURC Currency Codes MANDT
CE1S001 FRWAE CE1S001 FRWAE TCURC Currency Codes WAERS
CE1S001 GEBIE CE1S001 MANDT T2538 Table of Characteristic Values MANDT
CE1S001 GEBIE CE1S001 GEBIE T2538 Table of Characteristic Values GEBIE
CE1S001 GSBER CE1S001 MANDT TGSB Business Areas MANDT
CE1S001 GSBER CE1S001 GSBER TGSB Business Areas GSBER
CE1S001 KAUFN CE1S001 MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CE1S001 KAUFN CE1S001 KAUFN VBUK Sales Document: Header Status and Administrative Data VBELN
CE1S001 KDGRP CE1S001 MANDT T151 Customers: Customer Groups MANDT
CE1S001 KDGRP CE1S001 KDGRP T151 Customers: Customer Groups KDGRP
CE1S001 KNDNR CE1S001 MANDT KNA1 General Data in Customer Master MANDT
CE1S001 KNDNR CE1S001 KNDNR KNA1 General Data in Customer Master KUNNR
CE1S001 KOKRS CE1S001 KOKRS TKA01 Controlling Areas KOKRS
CE1S001 KOKRS CE1S001 MANDT TKA01 Controlling Areas MANDT
CE1S001 KSTAR CE1S001 MANDT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
CE1S001 KSTAR * CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
CE1S001 KSTAR CE1S001 KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KSTAR
CE1S001 KSTRG * CKPH Master Record: Cost Object ID Number DATBI
CE1S001 KSTRG CE1S001 MANDT CKPH Master Record: Cost Object ID Number MANDT
CE1S001 KSTRG CE1S001 KSTRG CKPH Master Record: Cost Object ID Number KSTRG
CE1S001 LAND1 CE1S001 MANDT T005 Countries MANDT
CE1S001 LAND1 CE1S001 LAND1 T005 Countries LAND1
CE1S001 MAABC CE1S001 MANDT TMABC Values Table for the ABC Indicator for Materials MANDT
CE1S001 MAABC CE1S001 MAABC TMABC Values Table for the ABC Indicator for Materials MAABC
CE1S001 MANDT CE1S001 MANDT T000 Clients MANDT
CE1S001 MATKL CE1S001 MANDT T023 Material Groups MANDT
CE1S001 MATKL CE1S001 MATKL T023 Material Groups MATKL
CE1S001 PALEDGER CE1S001 MANDT TKEL CO-PA ledger MANDT
CE1S001 PALEDGER CE1S001 PALEDGER TKEL CO-PA ledger PALEDGER
CE1S001 PPRCTR CE1S001 MANDT CEPC Profit Center Master Data Table MANDT
CE1S001 PPRCTR CE1S001 PPRCTR CEPC Profit Center Master Data Table PRCTR
CE1S001 PPRCTR * CEPC Profit Center Master Data Table DATBI
CE1S001 PPRCTR CE1S001 KOKRS CEPC Profit Center Master Data Table KOKRS
CE1S001 PRCTR CE1S001 PRCTR CEPC Profit Center Master Data Table PRCTR
CE1S001 PRCTR * CEPC Profit Center Master Data Table DATBI
CE1S001 PRCTR CE1S001 KOKRS CEPC Profit Center Master Data Table KOKRS
CE1S001 PRCTR CE1S001 MANDT CEPC Profit Center Master Data Table MANDT
CE1S001 PRZNR CE1S001 MANDT CBPR CO-ABC: Activity Master Table MANDT
CE1S001 PRZNR CE1S001 KOKRS CBPR CO-ABC: Activity Master Table KOKRS
CE1S001 PRZNR CE1S001 PRZNR CBPR CO-ABC: Activity Master Table PRZNR
CE1S001 PRZNR * CBPR CO-ABC: Activity Master Table DATBI
CE1S001 PSPNR CE1S001 MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
CE1S001 PSPNR CE1S001 PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
CE1S001 REC_WAERS CE1S001 MANDT TCURC Currency Codes MANDT
CE1S001 REC_WAERS CE1S001 REC_WAERS TCURC Currency Codes WAERS
CE1S001 RKAUFNR CE1S001 MANDT AUFK Order master data MANDT
CE1S001 RKAUFNR CE1S001 RKAUFNR AUFK Order master data AUFNR
CE1S001 SKOST CE1S001 SKOST CSKS Cost Center Master Data KOSTL
CE1S001 SKOST * CSKS Cost Center Master Data DATBI
CE1S001 SKOST CE1S001 MANDT CSKS Cost Center Master Data MANDT
CE1S001 SKOST CE1S001 KOKRS CSKS Cost Center Master Data KOKRS
CE1S001 SPART CE1S001 MANDT TSPA Organizational Unit: Sales Divisions MANDT
CE1S001 SPART CE1S001 SPART TSPA Organizational Unit: Sales Divisions SPART
CE1S001 VERSI CE1S001 MANDT TKVS CO Versions MANDT
CE1S001 VERSI CE1S001 VERSI TKVS CO Versions VERSI
CE1S001 VKBUR CE1S001 MANDT TVBUR Organizational Unit: Sales Offices MANDT
CE1S001 VKBUR CE1S001 VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
CE1S001 VKGRP CE1S001 MANDT TVKGR Organizational Unit: Sales Groups MANDT
CE1S001 VKGRP CE1S001 VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
CE1S001 VKORG CE1S001 MANDT TVKO Organizational Unit: Sales Organizations MANDT
CE1S001 VKORG CE1S001 VKORG TVKO Organizational Unit: Sales Organizations VKORG
CE1S001 VRGAR CE1S001 VRGAR TVGA Record types for CO-PA VRGAR
CE1S001 VRGAR CE1S001 MANDT TVGA Record types for CO-PA MANDT
CE1S001 VTWEG CE1S001 MANDT TVTW Organizational Unit: Distribution Channels MANDT
CE1S001 VTWEG CE1S001 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
CE1S001 WERKS CE1S001 MANDT T001W Plants/Branches MANDT
CE1S001 WERKS CE1S001 WERKS T001W Plants/Branches WERKS