Follow us on LinkedIn for your next SAP project

SAP Table CE1OC01

Bike International

CE1OC01 (Bike International) 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 CE1OC01 to other SAP tables.

CE1OC01 table fields

Field Data element Checktable Datatype Length Decimals Possible values
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
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
COPA_AWSYS
Logical system of source document
AWSYS TBDLS
CHAR
10 0
AUGRU
Order reason (reason for the business transaction)
AUGRU TVAU
CHAR
3 0
BRSCH
Industry key
BRSCH T016
CHAR
4 0
BZIRK
Sales district
BZIRK T171
CHAR
6 0
EKORG
Purchasing Organization
EKORG T024E
CHAR
4 0
HIE01
Customer hierarchy Level 1
HIEZU01 KNA1
CHAR
10 0
HIE02
Customer hierarchy Level 2
HIEZU02 KNA1
CHAR
10 0
HIE03
Customer hierarchy Level 3
HIEZU03 KNA1
CHAR
10 0
KDGRP
Customer group
KDGRP T151
CHAR
2 0
KMNIEL
Nielsen ID
NIELS TNLS
CHAR
2 0
KMSTGE
Strategic Business Unit
RKESKMSTGE T2247
NUMC
2 0
KUNWE
Ship-to party
KUNWE KNA1
CHAR
10 0
LAND1
Country Key
LAND1_GP T005
CHAR
3 0
MATKL
Material Group
MATKL T023
CHAR
9 0
PAPH1
Prod.hierarchy01-1
RKEG_PAPH1
CHAR
5 0
PAPH2
Prod.hierarchy01-2
RKEG_PAPH2
CHAR
10 0
PAPH3
Prod.hierarchy01-3
RKEG_PAPH3
CHAR
18 0
VKBUR
Sales Office
VKBUR TVBUR
CHAR
4 0
WWCST
Country Ship-to
RKEG_WWCST T2517
CHAR
3 0
ABSMG_ME
Base Unit of Measure
MEINS T006
UNIT
3 0
VVGRW_ME
Base Unit of Measure
MEINS T006
UNIT
3 0
VVIQT_ME
Base Unit of Measure
MEINS T006
UNIT
3 0
VVOQT_ME
Base Unit of Measure
MEINS T006
UNIT
3 0
ABSMG
Sales quantity
RKE2_ABSMG
QUAN
15 3
ERLOS
Revenue
RKE2_ERLOS
CURR
15 2
VV020
Quantity discount
RKE2_VV020
CURR
15 2
VV030
Customer discount
RKE2_VV030
CURR
15 2
VV040
Material discount
RKE2_VV040
CURR
15 2
VV060
Other rebates
RKE2_VV060
CURR
15 2
VV070
Accrued Sales deduc.
RKE2_VV070
CURR
15 2
VV140
Cost of goods sold
RKE2_VV140
CURR
15 2
VV190
Production Setup
RKE2_VV190
CURR
15 2
VV250
Material Overhead
RKE2_VV250
CURR
15 2
VV260
Administr. Overhead
RKE2_VV260
CURR
15 2
VV270
Sales Overhead
RKE2_VV270
CURR
15 2
VV290
Price variance
RKE2_VV290
CURR
15 2
VV300
Quant. Variance Mat.
RKE2_VV300
CURR
15 2
VV310
Quant. Variance Prod
RKE2_VV310
CURR
15 2
VV320
Lot-size Variance
RKE2_VV320
CURR
15 2
VV330
Usage variance
RKE2_VV330
CURR
15 2
VV340
Input Variances
RKE2_VV340
CURR
15 2
VV350
Scrap
RKE2_VV350
CURR
15 2
VV360
Remaining Variances
RKE2_VV360
CURR
15 2
VV400
Production costs
RKE2_VV400
CURR
15 2
VV510
Process "Procurement"
RKE2_VV510
CURR
15 2
VV701
Net sales
RKE2_VV701
CURR
15 2
VVGRW
Gross weight
RKE2_VVGRW
QUAN
15 3
VVIQT
Invoiced quantity
RKE2_VVIQT
QUAN
15 3
VVOQT
Ordered quantity
RKE2_VVOQT
QUAN
15 3

CE1OC01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CE1OC01 ABSMG_ME CE1OC01 MANDT T006
Units of Measurement
MANDT
CE1OC01 ABSMG_ME CE1OC01 ABSMG_ME T006
Units of Measurement
MSEHI
CE1OC01 ARTNR CE1OC01 MANDT MARA
General Material Data
MANDT
CE1OC01 ARTNR CE1OC01 ARTNR MARA
General Material Data
MATNR
CE1OC01 AUGRU CE1OC01 MANDT TVAU
Sales Documents: Order Reasons
MANDT
CE1OC01 AUGRU CE1OC01 AUGRU TVAU
Sales Documents: Order Reasons
AUGRU
CE1OC01 BRSCH CE1OC01 BRSCH T016
Industries
BRSCH
CE1OC01 BRSCH CE1OC01 MANDT T016
Industries
MANDT
CE1OC01 BUKRS CE1OC01 MANDT T001
Company Codes
MANDT
CE1OC01 BUKRS CE1OC01 BUKRS T001
Company Codes
BUKRS
CE1OC01 BZIRK CE1OC01 MANDT T171
Customers: Sales Districts
MANDT
CE1OC01 BZIRK CE1OC01 BZIRK T171
Customers: Sales Districts
BZIRK
CE1OC01 COPA_AWSYS CE1OC01 COPA_AWSYS TBDLS
Logical system
LOGSYS
CE1OC01 EKORG CE1OC01 MANDT T024E
Purchasing Organizations
MANDT
CE1OC01 EKORG CE1OC01 EKORG T024E
Purchasing Organizations
EKORG
CE1OC01 FKART CE1OC01 MANDT TVFK
Billing: Document Types
MANDT
CE1OC01 FKART CE1OC01 FKART TVFK
Billing: Document Types
FKART
CE1OC01 FRWAE CE1OC01 MANDT TCURC
Currency Codes
MANDT
CE1OC01 FRWAE CE1OC01 FRWAE TCURC
Currency Codes
WAERS
CE1OC01 GSBER CE1OC01 MANDT TGSB
Business Areas
MANDT
CE1OC01 GSBER CE1OC01 GSBER TGSB
Business Areas
GSBER
CE1OC01 HIE01 CE1OC01 MANDT KNA1
General Data in Customer Master
MANDT
CE1OC01 HIE01 CE1OC01 HIE01 KNA1
General Data in Customer Master
KUNNR
CE1OC01 HIE02 CE1OC01 HIE02 KNA1
General Data in Customer Master
KUNNR
CE1OC01 HIE02 CE1OC01 MANDT KNA1
General Data in Customer Master
MANDT
CE1OC01 HIE03 CE1OC01 MANDT KNA1
General Data in Customer Master
MANDT
CE1OC01 HIE03 CE1OC01 HIE03 KNA1
General Data in Customer Master
KUNNR
CE1OC01 KAUFN CE1OC01 MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
CE1OC01 KAUFN CE1OC01 KAUFN VBUK
Sales Document: Header Status and Administrative Data
VBELN
CE1OC01 KDGRP CE1OC01 MANDT T151
Customers: Customer Groups
MANDT
CE1OC01 KDGRP CE1OC01 KDGRP T151
Customers: Customer Groups
KDGRP
CE1OC01 KMNIEL CE1OC01 MANDT TNLS
Nielsen ID
MANDT
CE1OC01 KMNIEL CE1OC01 KMNIEL TNLS
Nielsen ID
NIELS
CE1OC01 KMSTGE CE1OC01 KMSTGE T2247
Values for Characteristic "Strategy Business Unit."
KMSTGE
CE1OC01 KMSTGE CE1OC01 MANDT T2247
Values for Characteristic "Strategy Business Unit."
MANDT
CE1OC01 KNDNR CE1OC01 MANDT KNA1
General Data in Customer Master
MANDT
CE1OC01 KNDNR CE1OC01 KNDNR KNA1
General Data in Customer Master
KUNNR
CE1OC01 KOKRS CE1OC01 KOKRS TKA01
Controlling Areas
KOKRS
CE1OC01 KOKRS CE1OC01 MANDT TKA01
Controlling Areas
MANDT
CE1OC01 KSTAR CE1OC01 MANDT CSKA
Cost Elements (Data Dependent on Chart of Accounts)
MANDT
CE1OC01 KSTAR * CSKA
Cost Elements (Data Dependent on Chart of Accounts)
KTOPL
CE1OC01 KSTAR CE1OC01 KSTAR CSKA
Cost Elements (Data Dependent on Chart of Accounts)
KSTAR
CE1OC01 KSTRG * CKPH
Master Record: Cost Object ID Number
DATBI
CE1OC01 KSTRG CE1OC01 MANDT CKPH
Master Record: Cost Object ID Number
MANDT
CE1OC01 KSTRG CE1OC01 KSTRG CKPH
Master Record: Cost Object ID Number
KSTRG
CE1OC01 KUNWE CE1OC01 MANDT KNA1
General Data in Customer Master
MANDT
CE1OC01 KUNWE CE1OC01 KUNWE KNA1
General Data in Customer Master
KUNNR
CE1OC01 LAND1 CE1OC01 MANDT T005
Countries
MANDT
CE1OC01 LAND1 CE1OC01 LAND1 T005
Countries
LAND1
CE1OC01 MANDT CE1OC01 MANDT T000
Clients
MANDT
CE1OC01 MATKL CE1OC01 MANDT T023
Material Groups
MANDT
CE1OC01 MATKL CE1OC01 MATKL T023
Material Groups
MATKL
CE1OC01 PALEDGER CE1OC01 MANDT TKEL
CO-PA ledger
MANDT
CE1OC01 PALEDGER CE1OC01 PALEDGER TKEL
CO-PA ledger
PALEDGER
CE1OC01 PPRCTR CE1OC01 MANDT CEPC
Profit Center Master Data Table
MANDT
CE1OC01 PPRCTR CE1OC01 PPRCTR CEPC
Profit Center Master Data Table
PRCTR
CE1OC01 PPRCTR * CEPC
Profit Center Master Data Table
DATBI
CE1OC01 PPRCTR CE1OC01 KOKRS CEPC
Profit Center Master Data Table
KOKRS
CE1OC01 PRCTR CE1OC01 PRCTR CEPC
Profit Center Master Data Table
PRCTR
CE1OC01 PRCTR * CEPC
Profit Center Master Data Table
DATBI
CE1OC01 PRCTR CE1OC01 KOKRS CEPC
Profit Center Master Data Table
KOKRS
CE1OC01 PRCTR CE1OC01 MANDT CEPC
Profit Center Master Data Table
MANDT
CE1OC01 PRZNR CE1OC01 MANDT CBPR
CO-ABC: Activity Master Table
MANDT
CE1OC01 PRZNR CE1OC01 KOKRS CBPR
CO-ABC: Activity Master Table
KOKRS
CE1OC01 PRZNR CE1OC01 PRZNR CBPR
CO-ABC: Activity Master Table
PRZNR
CE1OC01 PRZNR * CBPR
CO-ABC: Activity Master Table
DATBI
CE1OC01 PSPNR CE1OC01 MANDT PRPS
WBS (Work Breakdown Structure) Element Master Data
MANDT
CE1OC01 PSPNR CE1OC01 PSPNR PRPS
WBS (Work Breakdown Structure) Element Master Data
PSPNR
CE1OC01 REC_WAERS CE1OC01 MANDT TCURC
Currency Codes
MANDT
CE1OC01 REC_WAERS CE1OC01 REC_WAERS TCURC
Currency Codes
WAERS
CE1OC01 RKAUFNR CE1OC01 MANDT AUFK
Order master data
MANDT
CE1OC01 RKAUFNR CE1OC01 RKAUFNR AUFK
Order master data
AUFNR
CE1OC01 SKOST CE1OC01 SKOST CSKS
Cost Center Master Data
KOSTL
CE1OC01 SKOST * CSKS
Cost Center Master Data
DATBI
CE1OC01 SKOST CE1OC01 MANDT CSKS
Cost Center Master Data
MANDT
CE1OC01 SKOST CE1OC01 KOKRS CSKS
Cost Center Master Data
KOKRS
CE1OC01 SPART CE1OC01 MANDT TSPA
Organizational Unit: Sales Divisions
MANDT
CE1OC01 SPART CE1OC01 SPART TSPA
Organizational Unit: Sales Divisions
SPART
CE1OC01 VERSI CE1OC01 MANDT TKVS
CO Versions
MANDT
CE1OC01 VERSI CE1OC01 VERSI TKVS
CO Versions
VERSI
CE1OC01 VKBUR CE1OC01 MANDT TVBUR
Organizational Unit: Sales Offices
MANDT
CE1OC01 VKBUR CE1OC01 VKBUR TVBUR
Organizational Unit: Sales Offices
VKBUR
CE1OC01 VKORG CE1OC01 MANDT TVKO
Organizational Unit: Sales Organizations
MANDT
CE1OC01 VKORG CE1OC01 VKORG TVKO
Organizational Unit: Sales Organizations
VKORG
CE1OC01 VRGAR CE1OC01 VRGAR TVGA
Record types for CO-PA
VRGAR
CE1OC01 VRGAR CE1OC01 MANDT TVGA
Record types for CO-PA
MANDT
CE1OC01 VTWEG CE1OC01 MANDT TVTW
Organizational Unit: Distribution Channels
MANDT
CE1OC01 VTWEG CE1OC01 VTWEG TVTW
Organizational Unit: Distribution Channels
VTWEG
CE1OC01 VVGRW_ME CE1OC01 VVGRW_ME T006
Units of Measurement
MSEHI
CE1OC01 VVGRW_ME CE1OC01 MANDT T006
Units of Measurement
MANDT
CE1OC01 VVIQT_ME CE1OC01 MANDT T006
Units of Measurement
MANDT
CE1OC01 VVIQT_ME CE1OC01 VVIQT_ME T006
Units of Measurement
MSEHI
CE1OC01 VVOQT_ME CE1OC01 MANDT T006
Units of Measurement
MANDT
CE1OC01 VVOQT_ME CE1OC01 VVOQT_ME T006
Units of Measurement
MSEHI
CE1OC01 WERKS CE1OC01 MANDT T001W
Plants/Branches
MANDT
CE1OC01 WERKS CE1OC01 WERKS T001W
Plants/Branches
WERKS
CE1OC01 WWCST CE1OC01 MANDT T2517
Table of Characteristic Values
MANDT
CE1OC01 WWCST CE1OC01 WWCST T2517
Table of Characteristic Values
WWCST