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 |
Possible values
|
||||||
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 |
Possible values
|
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 |