1. Home
  2. Resources
  3. SAP Tables
  4. CE1OC01 - Bike International

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.

Source: CE1OC01 (Bike International)

CE1OC01 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
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 ABSMG_ME T006 Units of Measurement MSEHI
CE1OC01 ABSMG_ME CE1OC01 MANDT T006 Units of Measurement MANDT
CE1OC01 ARTNR CE1OC01 ARTNR MARA General Material Data MATNR
CE1OC01 ARTNR CE1OC01 MANDT MARA General Material Data MANDT
CE1OC01 AUGRU CE1OC01 AUGRU TVAU Sales Documents: Order Reasons AUGRU
CE1OC01 AUGRU CE1OC01 MANDT TVAU Sales Documents: Order Reasons MANDT
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 EKORG T024E Purchasing Organizations EKORG
CE1OC01 EKORG CE1OC01 MANDT T024E Purchasing Organizations MANDT
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 MANDT KNA1 General Data in Customer Master MANDT
CE1OC01 HIE02 CE1OC01 HIE02 KNA1 General Data in Customer Master KUNNR
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 MANDT TKA01 Controlling Areas MANDT
CE1OC01 KOKRS CE1OC01 KOKRS TKA01 Controlling Areas KOKRS
CE1OC01 KSTAR CE1OC01 KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KSTAR
CE1OC01 KSTAR * CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
CE1OC01 KSTAR CE1OC01 MANDT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
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 KSTRG * CKPH Master Record: Cost Object ID Number DATBI
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 LAND1 T005 Countries LAND1
CE1OC01 LAND1 CE1OC01 MANDT T005 Countries MANDT
CE1OC01 MANDT CE1OC01 MANDT T000 Clients MANDT
CE1OC01 MATKL CE1OC01 MATKL T023 Material Groups MATKL
CE1OC01 MATKL CE1OC01 MANDT T023 Material Groups MANDT
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 KOKRS CEPC Profit Center Master Data Table KOKRS
CE1OC01 PRCTR * CEPC Profit Center Master Data Table DATBI
CE1OC01 PRCTR CE1OC01 MANDT CEPC Profit Center Master Data Table MANDT
CE1OC01 PRCTR CE1OC01 PRCTR CEPC Profit Center Master Data Table PRCTR
CE1OC01 PRZNR CE1OC01 MANDT CBPR CO-ABC: Activity Master Table MANDT
CE1OC01 PRZNR CE1OC01 KOKRS CBPR CO-ABC: Activity Master Table KOKRS
CE1OC01 PRZNR * CBPR CO-ABC: Activity Master Table DATBI
CE1OC01 PRZNR CE1OC01 PRZNR CBPR CO-ABC: Activity Master Table PRZNR
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 RKAUFNR AUFK Order master data AUFNR
CE1OC01 RKAUFNR CE1OC01 MANDT AUFK Order master data MANDT
CE1OC01 SKOST CE1OC01 MANDT CSKS Cost Center Master Data MANDT
CE1OC01 SKOST * CSKS Cost Center Master Data DATBI
CE1OC01 SKOST CE1OC01 SKOST CSKS Cost Center Master Data KOSTL
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 VERSI TKVS CO Versions VERSI
CE1OC01 VERSI CE1OC01 MANDT TKVS CO Versions MANDT
CE1OC01 VKBUR CE1OC01 VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
CE1OC01 VKBUR CE1OC01 MANDT TVBUR Organizational Unit: Sales Offices MANDT
CE1OC01 VKORG CE1OC01 VKORG TVKO Organizational Unit: Sales Organizations VKORG
CE1OC01 VKORG CE1OC01 MANDT TVKO Organizational Unit: Sales Organizations MANDT
CE1OC01 VRGAR CE1OC01 MANDT TVGA Record types for CO-PA MANDT
CE1OC01 VRGAR CE1OC01 VRGAR TVGA Record types for CO-PA VRGAR
CE1OC01 VTWEG CE1OC01 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
CE1OC01 VTWEG CE1OC01 MANDT TVTW Organizational Unit: Distribution Channels MANDT
CE1OC01 VVGRW_ME CE1OC01 MANDT T006 Units of Measurement MANDT
CE1OC01 VVGRW_ME CE1OC01 VVGRW_ME T006 Units of Measurement MSEHI
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 WWCST T2517 Table of Characteristic Values WWCST
CE1OC01 WWCST CE1OC01 MANDT T2517 Table of Characteristic Values MANDT