SAP CE0RIL0 Operating Concern fo Table data and field list

CE0RIL0 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Operating Concern fo" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CE0RIL0 TYPE CE0RIL0.

The CE0RIL0 table consists of various fields, each holding specific information or linking keys about Operating Concern fo data available in SAP. These include PALEDGER (Currency type for an operating concern), VRGAR (Record Type), VERSI (Plan version (CO-PA)), PERIO (Period/year)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CE0RIL0 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CE0RIL0 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CE0RIL0 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PALEDGERCurrency type for an operating concern LEDBOCHAR2TKELLEDBOLEDBO
VRGARRecord Type RKE_VRGARCHAR1TVGAVRGARVGA
VERSIPlan version (CO-PA) RKEVERSICHAR3TKVSALPHACOVERSIPVS
PERIOPeriod/year JAHRPERNUMC7PERI7JAHRPER
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
BELNRDocument number of line item in Profitability Analysis RKE_BELNRCHAR10ALPHABELNR
POSNRItem no. of CO-PA line item RKE_POSNRCHAR6RKE_POSNR
HZDATDate on Which Record Was Created ERDATDATS8DATUM
USNAMCreated by ERFASSERCHAR12USNAM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PERDEPeriod PERIODENUMC3NUM3GFP
WADATGoods Issue Date WADATDATS8DATUM
FADATInvoice date (date created) FADATDATS8DATUM
BUDATPosting Date DAERFDATS8DATUM
ALTPERIOPeriod/year in alternative period type JAHRPERALTNUMC7PERI7JAHRPER
PAPAOBJNRPartner profitability segment number (CO-PA) RKEPOBJNUMC10RKEOBJNR
PAPASUBNRChanges to partner profitability segments (CO-PA) RKEPSUBNRNUMC4RKESUBNR
KNDNRCustomer KUNDE_PACHAR10KNA1ALPHAKUNNRVAG
ARTNRProduct number ARTNRCHAR18MARAMATN1MATNRMAT
FKARTBilling Type FKARTCHAR4TVFKFKART
FRWAEForeign currency key FRWAECUKY5TCURCWAERS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
KURSBKExchange rate for op.concern currency -> Co.code currency KURSBKDEC9(5) KURSF
KURSKZExchange rate op.concern currency -> group currency KURSKZDEC9(5) KURSF
REC_WAERSCurrency of the data record RKE_REC_WAERSCUKY5TCURCWAERS
KAUFNSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
RKAUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
SKOSTSender cost center SKOSTCHAR10CSKSALPHAKOSTLKSK
PRZNRSender Business Process SEPRZCHAR12CBPRALPHACO_PRZNRSEP
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
HRKFTOrigins (CO-PA) RKEHERKCHAR4RKEHERK
PLIKZPlan/Actual Indicator PLIKZCHAR1PLIKZ
KSTARCost Element KSTARCHAR10CSKAALPHAKSTARKAT
PSPNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
KSTRGCost Object KSTRGCHAR12CKPHKSTRGKTR
RBELNReference document number for CO-PA line item RKERFBELNRCHAR10ALPHABELNR
RPOSNItem number from reference document (CO-PA) RKERFPOSNRCHAR6RKE_POSNR
STO_BELNRCanceled document RKE_STO_BELNRCHAR10ALPHABELNR
STO_POSNRCanceled document item RKE_STO_POSNRCHAR6RKE_POSNR
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10CEPCALPHAPRCTRPPC
RKESTATUUpdate status for CO-PA line items RKESTATUCHAR10RKESTATU
TIMESTMPTime created (Greenwich Meantime) RKE_HZSTMPDEC16RKE_TSTMP
COPA_AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
COPA_AWORGReference Organizational Units AWORGCHAR10AWORG
COPA_BWZPTCO-PA Point of valuation BWZPTCHAR1BWZPT
COPA_AWSYSLogical system of source document AWSYSCHAR10TBDLSALPHALOGSYS
WTGBTRTotal Value in Transaction Currency WTGXXXCURR15(2) WERTV8
WOGBTRTotal Value in Object Currency WOGXXXCURR15(2) WERTV8
WKGBTRTotal Value in Controlling Area Currency WKGXXXCURR15(2) WERTV8
WKFBTRFixed Value in Controlling Area Currency WKFXXXCURR15(2) WERTV8
MEGBTRTotal Quantity MEGXXXQUAN15(3) MENGV8
MEINHUnit of Measure CO_MEINHUNIT3T006CUNITMEINS
KNT_FRM_KZIndicator for use in account-based Profitability Analysis RKE_KNTFRMNUMC1RKE_KNTFRM
VALUTYPValuation VALUTYP_ACTNUMC1VALUTYPVTP
LSTARActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
BRSCHIndustry key BRSCHCHAR4T016BRSCH
KMKDGRCustomer group KDGRPCHAR2T151KDGRPVKD
KMMAKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
KMVKBUSales Office VKBURCHAR4TVBURVKBURVKB
KMVKGRSales Group VKGRPCHAR3TVKGRVKGRPVKG
KMVTNRSales employee VRTNRNUMC8PERNRPREMV
KTGRMAccount assignment group for this material KTGRMCHAR2TVKMKTGRM
KUKLACustomer classification KUKLACHAR2TKUKLKUKLA
KUNWEShip-to party KUNWECHAR10KNA1ALPHAKUNNR
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1
PAPH1Prod.hierarchy01-1 RKEG_PAPH1CHAR5RKEG_PAPH1
PAPH2Prod.hierarchy01-2 RKEG_PAPH2CHAR10RKEG_PAPH2
PAPH3Prod.hierarchy01-3 RKEG_PAPH3CHAR18RKEG_PAPH3
WWRERegion RKEG_WWRECHAR5T2545RKEG_WWRE
WWRIBBusiness Unit RKEG_WWRIBCHAR8T2544RKEG_WWRIB
WWRSTIntern.Region Ship-t RKEG_WWRSTCHAR3T2518RKEG_WWRST
VVR50_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VV580_MEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
VVR01Revenue RKE2_VVR01CURR15(2) WERTV8
VVR02Discount RKE2_VVR02CURR15(2) WERTV8
VVR03Rebate RKE2_VVR03CURR15(2) WERTV8
VVR04COGS RKE2_VVR04CURR15(2) WERTV8
VVR05Gross Price RKE2_VVR05CURR15(2) WERTV8
VVR06Trade Discount RKE2_VVR06CURR15(2) WERTV8
VVR07Freight Charges RKE2_VVR07CURR15(2) WERTV8
VVR08Quantity Discount RKE2_VVR08CURR15(2) WERTV8
VVR09Insurance RKE2_VVR09CURR15(2) WERTV8
VVR10Purchase Price Diff. RKE2_VVR10CURR15(2) WERTV8
VVR11Inventory Reval. RKE2_VVR11CURR15(2) WERTV8
VVR12Physical Inventory D RKE2_VVR12CURR15(2) WERTV8
VVR13Sales Commission RKE2_VVR13CURR15(2) WERTV8
VVR14Sales Promotion Exp. RKE2_VVR14CURR15(2) WERTV8
VVR15Advertisements RKE2_VVR15CURR15(2) WERTV8
VVR16Travelling Expenses RKE2_VVR16CURR15(2) WERTV8
VVR17Depreciation RKE2_VVR17CURR15(2) WERTV8
VVR18Rent RKE2_VVR18CURR15(2) WERTV8
VVR19Salaries RKE2_VVR19CURR15(2) WERTV8
VVR20Miscellaneous or Ot. RKE2_VVR20CURR15(2) WERTV8
VVR21Input Price Variance RKE2_VVR21CURR15(2) WERTV8
VVR22Input Quantity Var. RKE2_VVR22CURR15(2) WERTV8
VVR23Resource Usage Var. RKE2_VVR23CURR15(2) WERTV8
VVR24Remaining Input Var. RKE2_VVR24CURR15(2) WERTV8
VVR25Output Price Var. RKE2_VVR25CURR15(2) WERTV8
VVR26Lot Size Variance RKE2_VVR26CURR15(2) WERTV8
VVR27Mixed Price Variance RKE2_VVR27CURR15(2) WERTV8
VVR28Scrap Variance RKE2_VVR28CURR15(2) WERTV8
VVR29Remaining Variance RKE2_VVR29CURR15(2) WERTV8
VVR30Material Cost-Local RKE2_VVR30CURR15(2) WERTV8
VVR31Material Cost-Import RKE2_VVR31CURR15(2) WERTV8
VVR32Packing Material RKE2_VVR32CURR15(2) WERTV8
VVR33Consumables RKE2_VVR33CURR15(2) WERTV8
VVR34Cleaning Cost RKE2_VVR34CURR15(2) WERTV8
VVR35Labor Cost RKE2_VVR35CURR15(2) WERTV8
VVR36Machine Cost RKE2_VVR36CURR15(2) WERTV8
VVR37Material Overheads RKE2_VVR37CURR15(2) WERTV8
VVR38Admin Overheads RKE2_VVR38CURR15(2) WERTV8
VVR39Material Cost RKE2_VVR39CURR15(2) WERTV8
VVR40Salaries RKE2_VVR40CURR15(2) WERTV8
VVR41Power RKE2_VVR41CURR15(2) WERTV8
VVR42Spare Parts RKE2_VVR42CURR15(2) WERTV8
VVR43Cleaning Cost RKE2_VVR43CURR15(2) WERTV8
VVR44Machine Cost RKE2_VVR44CURR15(2) WERTV8
VVR45Material Overheads RKE2_VVR45CURR15(2) WERTV8
VVR46Admin Overheads RKE2_VVR46CURR15(2) WERTV8
VVR50Sales Quantity RKE2_VVR50QUAN15(3) MENGV15_3
VV300Quant. Variance Mat. RKE2_VV300CURR15(2) WERTV8
VV580Input Quan. Variance RKE2_VV580QUAN15(3) MENGV15_3

Key field Non-key field



How do I retrieve data from SAP structure CE0RIL0 using ABAP code?

As CE0RIL0 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CE0RIL0 as there is no data to select.

How to access SAP table CE0RIL0

Within an ECC or HANA version of SAP you can also view further information about CE0RIL0 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).