SAP CE3IDEA Op. Concern IDES Wor Table data and field list

CE3IDEA is a standard SAP Table which is used to store Op. Concern IDES Wor data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CE3IDEA table consists of various fields, each holding specific information or linking keys about Op. Concern IDES Wor data available in SAP. These include PAOBJNR (Profitability Segment Number (CO-PA)), PALEDGER (Currency type for an operating concern), VRGAR (Record Type), PLIKZ (Plan/Actual Indicator)... 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. .

CE3IDEA table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CE3IDEA table 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 CE3IDEA 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
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PALEDGERCurrency type for an operating concern LEDBOCHAR2TKELLEDBOLEDBO
VRGARRecord Type RKE_VRGARCHAR1TVGAVRGARVGA
PLIKZPlan/Actual Indicator PLIKZCHAR1PLIKZ
VERSIPlan version (CO-PA) RKEVERSICHAR3TKVSALPHACOVERSIPVS
PERBLFiscal year/period block JAHRPERBLNUMC7PERI7JAHRPER
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
PAPAOBJNRPartner profitability segment number (CO-PA) RKEPOBJNUMC10RKEOBJNR
PAPASUBNRChanges to partner profitability segments (CO-PA) RKEPSUBNRNUMC4RKESUBNR
HRKFTOrigins (CO-PA) RKEHERKCHAR4RKEHERK
UPDATDate of Last Change LAEDADATS8DATUM
USNAMLast changed by AENNMCHAR12USNAM
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
REC_WAERSCurrency of the data record RKE_REC_WAERSCUKY5Assigned to domainWAERS
TIMESTMPTime created (Greenwich Meantime) RKE_HZSTMPDEC16RKE_TSTMP
VVOQT001Ordered quantity RKE2_VVOQTQUAN15(3) MENGV15_3
VVIQT001Invoiced quantity RKE2_VVIQTQUAN15(3) MENGV15_3
VVSQT001Input Quan. Variance RKE2_VVSQTQUAN15(3) MENGV15_3
VVGRW001Gross weight RKE2_VVGRWQUAN15(3) MENGV15_3
VV010001Revenue RKE2_VV010CURR15(2) WERTV8
VV020001Quantity discount RKE2_VV020CURR15(2) WERTV8
VV030001Customer discount RKE2_VV030CURR15(2) WERTV8
VV040001Material discount RKE2_VV040CURR15(2) WERTV8
VV060001Other rebates RKE2_VV060CURR15(2) WERTV8
VV070001Accrued Sales deduc. RKE2_VV070CURR15(2) WERTV8
VV090001Accrued bonus RKE2_VV090CURR15(2) WERTV8
VV100001Outgoing freight RKE2_VV100CURR15(2) WERTV8
VV110001Accrued freight RKE2_VV110CURR15(2) WERTV8
VV120001Dispatch packaging RKE2_VV120CURR15(2) WERTV8
VV130001Internal sales Comm. RKE2_VV130CURR15(2) WERTV8
VV140001Cost of goods sold RKE2_VV140CURR15(2) WERTV8
VV150001Material Input RKE2_VV150CURR15(2) WERTV8
VV160001Trading Goods RKE2_VV160CURR15(2) WERTV8
VV170001Production Labor fix RKE2_VV170CURR15(2) WERTV8
VV180001Production Labor var RKE2_VV180CURR15(2) WERTV8
VV190001Production Setup RKE2_VV190CURR15(2) WERTV8
VV200001Produc. machine fix RKE2_VV200CURR15(2) WERTV8
VV210001Produc. machine var RKE2_VV210CURR15(2) WERTV8
VV220001Produc. Burn-in fix RKE2_VV220CURR15(2) WERTV8
VV230001Produc. Burn-in var RKE2_VV230CURR15(2) WERTV8
VV240001Outside Processing RKE2_VV240CURR15(2) WERTV8
VV250001Material Overhead RKE2_VV250CURR15(2) WERTV8
VV260001Administr. Overhead RKE2_VV260CURR15(2) WERTV8
VV270001Sales Overhead RKE2_VV270CURR15(2) WERTV8
VV280001Miscellaneous Costs RKE2_VV280CURR15(2) WERTV8
VV290001Price variance RKE2_VV290CURR15(2) WERTV8
VV300001Quant. Variance Mat. RKE2_VV300CURR15(2) WERTV8
VV310001Quant. Variance Prod RKE2_VV310CURR15(2) WERTV8
VV320001Lot-size Variance RKE2_VV320CURR15(2) WERTV8
VV330001Usage variance RKE2_VV330CURR15(2) WERTV8
VV340001Input Variances RKE2_VV340CURR15(2) WERTV8
VV350001Scrap RKE2_VV350CURR15(2) WERTV8
VV360001Remaining Variances RKE2_VV360CURR15(2) WERTV8
VV370001Gen.Admin. costs CCA RKE2_VV370CURR15(2) WERTV8
VV380001General Market.costs RKE2_VV380CURR15(2) WERTV8
VV390001Distribution costs RKE2_VV390CURR15(2) WERTV8
VV400001Production costs RKE2_VV400CURR15(2) WERTV8
VV410001Marketing activities RKE2_VV410CURR15(2) WERTV8
VV420001Research & Develop. RKE2_VV420CURR15(2) WERTV8
VV430001Reserv.f.imminent lo RKE2_VV430CURR15(2) WERTV8
VV440001Corr:Material Input RKE2_VV440CURR15(2) WERTV8
VV450001Corr:Manuf.Costs fix RKE2_VV450CURR15(2) WERTV8
VV460001Corr:Manuf.Costs var RKE2_VV460CURR15(2) WERTV8
VV470001Corr:Overhead Costs RKE2_VV470CURR15(2) WERTV8
VV480001Maintenance RKE2_VV480CURR15(2) WERTV8
VV145001COGS alternative RKE2_VV145CURR15(2) WERTV8
VV075001Actual Sales deduc. RKE2_VV075CURR15(2) WERTV8
VV500001Process 'Production' RKE2_VV500CURR15(2) WERTV8
VV510001Process 'Procurement' RKE2_VV510CURR15(2) WERTV8
VV520001Process 'Sales' RKE2_VV520CURR15(2) WERTV8
VV530001Process 'Administration' RKE2_VV530CURR15(2) WERTV8
VV550001Number of sales order items RKE2_VV550QUAN15(3) MENGV15_3
VV560001Number of payment problems RKE2_VV560QUAN15(3) MENGV15_3
VV570001Number of purchase orders for sales order RKE2_VV570QUAN15(3) MENGV15_3
VV580001Input Quan. Variance RKE2_VV580QUAN15(3) MENGV15_3
VV495001Number of employees RKE2_VV495QUAN15(3) MENGV15_3
VVSTU001Standard Unit of M. RKE2_VVSTUQUAN15(3) MENGV15_3
VV155001Grace costs RKE2_VV155CURR15(2) WERTV8
VV365001Price differences RKE2_VV365CURR15(2) WERTV8
VV364001Mixed-price variance RKE2_VV364CURR15(2) WERTV8
VVK15001Group: Material RKE2_VVK15CURR15(2) WERTV8
VVK20001Group: Material overhead costs RKE2_VVK20CURR15(2) WERTV8
VVK25001Group: Production RKE2_VVK25CURR15(2) WERTV8
VVK30001Group: Misc. RKE2_VVK30CURR15(2) WERTV8
VVK10001Group price RKE2_VVK10CURR15(2) WERTV8
VVO10001PCA: Int. revenues RKE2_VVO10CURR15(2) WERTV8
VVO20001PCA: Int. costs RKE2_VVO20CURR15(2) WERTV8
VVOQU001PCA: Delivery quantity RKE2_VVOQUQUAN15(3) MENGV15_3
VV366001Other Actual Costs RKE2_VV366CURR15(2) WERTV8
VV367001Sales and Administration Costs - Actual RKE2_VV367CURR15(2) WERTV8
VV368001Process 'Production' Actual RKE2_VV368CURR15(2) WERTV8
VV151001Actual Mat. Input RKE2_VV151CURR15(2) WERTV8
VV171001Act. Fxd Prod. Costs RKE2_VV171CURR15(2) WERTV8
VV181001Actual Variable Production Costs RKE2_VV181CURR15(2) WERTV8
VV191001Actual Setup Costs RKE2_VV191CURR15(2) WERTV8
VV201001Actual Fixed Machine Hours RKE2_VV201CURR15(2) WERTV8
VV211001Actual Variable Machine Hours RKE2_VV211CURR15(2) WERTV8
VV251001Actual Material Overhead Costs RKE2_VV251CURR15(2) WERTV8
VV810001No. of Inquiries RKE2_VV810QUAN15(3) MENGV15_3
VV820001No. of Complaints RKE2_VV820QUAN15(3) MENGV15_3
VV830001Cost of Inquiries RKE2_VV830CURR15(2) WERTV8
VV840001Cost of Complaints RKE2_VV840CURR15(2) WERTV8
VV095001oth. sales deduct. RKE2_VV095CURR15(2) WERTV8
VV713001Advertising RKE2_VV713CURR15(2) WERTV8
VV900001Revenue fee RKE2_VV900CURR15(2) WERTV8
VV910001Revenue from Expenses/Travel Costs RKE2_VV910CURR15(2) WERTV8
VV915001Revenues from External Activities RKE2_VV915CURR15(2) WERTV8
VV920001Sales Deductions RKE2_VV920CURR15(2) WERTV8
VV930001Number of Labor Hours RKE2_VV930QUAN15(3) MENGV15_3
VV931001Number of Hours Billed RKE2_VV931QUAN15(3) MENGV15_3
VV940001Cost of Labor Hours RKE2_VV940CURR15(2) WERTV8
VV950001Travel expenses RKE2_VV950CURR15(2) WERTV8
VV960001Other expenses RKE2_VV960CURR15(2) WERTV8
VV970001Costs from External Activities RKE2_VV970CURR15(2) WERTV8
VV999001X_Technical RKE2_VV999CURR15(2) WERTV8
VVADV001Advert. Costs SEM215 RKE2_VVADVCURR15(2) WERTV8
VVCGS001COGS in SEM215 RKE2_VVCGSCURR15(2) WERTV8
VVDEP001Deprec. Costs SEM215 RKE2_VVDEPCURR15(2) WERTV8
VVENG001Energy Costs SEM215 RKE2_VVENGCURR15(2) WERTV8
VVNR001NetRevenue in SEM215 RKE2_VVNRCURR15(2) WERTV8
VVPSC001PersonnelCost SEM215 RKE2_VVPSCCURR15(2) WERTV8
VVREN001Rent Costs SEM215 RKE2_VVRENCURR15(2) WERTV8
VVREV001Revenue SEM215 RKE2_VVREVCURR15(2) WERTV8
VVSD001SalesDiscount SEM215 RKE2_VVSDCURR15(2) WERTV8
VVCM2001Contr.Margin2 SEM215 RKE2_VVCM2CURR15(2) WERTV8
VVSV001Sales Volume SEM215 RKE2_VVSVQUAN15(3) MENGV15_3
VVLS1001Costs pre-leg RKE2_VVLS1CURR15(2) WERTV8
VVLS2001Costs main-leg RKE2_VVLS2CURR15(2) WERTV8
VVLS3001Costs sub-leg RKE2_VVLS3CURR15(2) WERTV8

Key field Non-key field



How do I retrieve data from SAP table CE3IDEA using ABAP code

The following ABAP code Example will allow you to do a basic selection on CE3IDEA to SELECT all data from the table
DATA: WA_CE3IDEA TYPE CE3IDEA.

SELECT SINGLE *
FROM CE3IDEA
INTO CORRESPONDING FIELDS OF WA_CE3IDEA
WHERE...

How to access SAP table CE3IDEA

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

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