1. Home
  2. Resources
  3. SAP Tables
  4. CE3IDEA - Op. Concern IDES Wor

SAP Table CE3IDEA

Op. Concern IDES Wor

CE3IDEA (Op. Concern IDES Wor) 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 CE3IDEA to other SAP tables.

CE3IDEA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PALEDGER Currency type for an operating concern LEDBO TKEL CHAR 2 0
VRGAR Record Type RKE_VRGAR TVGA CHAR 1 0
PLIKZ Plan/Actual Indicator PLIKZ CHAR 1 0
0 Actual data
1 Planning data
VERSI Plan version (CO-PA) RKEVERSI TKVS CHAR 3 0
PERBL Fiscal year/period block JAHRPERBL NUMC 7 0
PASUBNR Profitability segment changes (CO-PA) RKESUBNR NUMC 4 0
PAPAOBJNR Partner profitability segment number (CO-PA) RKEPOBJ NUMC 10 0
PAPASUBNR Changes to partner profitability segments (CO-PA) RKEPSUBNR NUMC 4 0
HRKFT Origins (CO-PA) RKEHERK CHAR 4 0
UPDAT Date of Last Change LAEDA DATS 8 0
USNAM Last changed by AENNM CHAR 12 0
GJAHR Fiscal Year GJAHR NUMC 4 0
REC_WAERS Currency of the data record RKE_REC_WAERS CUKY 5 0
TIMESTMP Time created (Greenwich Meantime) RKE_HZSTMP DEC 16 0
VVOQT001 Ordered quantity RKE2_VVOQT QUAN 15 3
VVIQT001 Invoiced quantity RKE2_VVIQT QUAN 15 3
VVSQT001 Invoic. qty in SKU RKE2_VVSQT QUAN 15 3
VVGRW001 Gross weight RKE2_VVGRW QUAN 15 3
VV010001 Revenue RKE2_VV010 CURR 15 2
VV020001 Quantity discount RKE2_VV020 CURR 15 2
VV030001 Customer discount RKE2_VV030 CURR 15 2
VV040001 Material discount RKE2_VV040 CURR 15 2
VV060001 Other rebates RKE2_VV060 CURR 15 2
VV070001 Accrued Sales deduc. RKE2_VV070 CURR 15 2
VV090001 Accrued bonus RKE2_VV090 CURR 15 2
VV100001 Outgoing freight RKE2_VV100 CURR 15 2
VV110001 Accrued freight RKE2_VV110 CURR 15 2
VV120001 Dispatch packaging RKE2_VV120 CURR 15 2
VV130001 Internal sales Comm. RKE2_VV130 CURR 15 2
VV140001 Cost of goods sold RKE2_VV140 CURR 15 2
VV150001 Material Input RKE2_VV150 CURR 15 2
VV160001 Trading Goods RKE2_VV160 CURR 15 2
VV170001 Production Labor fix RKE2_VV170 CURR 15 2
VV180001 Production Labor var RKE2_VV180 CURR 15 2
VV190001 Production Setup RKE2_VV190 CURR 15 2
VV200001 Produc. machine fix RKE2_VV200 CURR 15 2
VV210001 Produc. machine var RKE2_VV210 CURR 15 2
VV220001 Produc. Burn-in fix RKE2_VV220 CURR 15 2
VV230001 Produc. Burn-in var RKE2_VV230 CURR 15 2
VV240001 Outside Processing RKE2_VV240 CURR 15 2
VV250001 Material Overhead RKE2_VV250 CURR 15 2
VV260001 Administr. Overhead RKE2_VV260 CURR 15 2
VV270001 Sales Overhead RKE2_VV270 CURR 15 2
VV280001 Miscellaneous Costs RKE2_VV280 CURR 15 2
VV290001 Price variance RKE2_VV290 CURR 15 2
VV300001 Quant. Variance Mat. RKE2_VV300 CURR 15 2
VV310001 Quant. Variance Prod RKE2_VV310 CURR 15 2
VV320001 Lot-size Variance RKE2_VV320 CURR 15 2
VV330001 Usage variance RKE2_VV330 CURR 15 2
VV340001 Input Variances RKE2_VV340 CURR 15 2
VV350001 Scrap RKE2_VV350 CURR 15 2
VV360001 Remaining Variances RKE2_VV360 CURR 15 2
VV370001 Gen.Admin. costs CCA RKE2_VV370 CURR 15 2
VV380001 General Market.costs RKE2_VV380 CURR 15 2
VV390001 Distribution costs RKE2_VV390 CURR 15 2
VV400001 Production costs RKE2_VV400 CURR 15 2
VV410001 Marketing activities RKE2_VV410 CURR 15 2
VV420001 Research & Develop. RKE2_VV420 CURR 15 2
VV430001 Reserv.f.imminent lo RKE2_VV430 CURR 15 2
VV440001 Corr:Material Input RKE2_VV440 CURR 15 2
VV450001 Corr:Manuf.Costs fix RKE2_VV450 CURR 15 2
VV460001 Corr:Manuf.Costs var RKE2_VV460 CURR 15 2
VV470001 Corr:Overhead Costs RKE2_VV470 CURR 15 2
VV480001 Maintenance RKE2_VV480 CURR 15 2
VV145001 COGS alternative RKE2_VV145 CURR 15 2
VV075001 Actual Sales deduc. RKE2_VV075 CURR 15 2
VV500001 Process "Production" RKE2_VV500 CURR 15 2
VV510001 Process "Procurement" RKE2_VV510 CURR 15 2
VV520001 Process "Sales" RKE2_VV520 CURR 15 2
VV530001 Process "Administration" RKE2_VV530 CURR 15 2
VV550001 Number of sales order items RKE2_VV550 QUAN 15 3
VV560001 Number of payment problems RKE2_VV560 QUAN 15 3
VV570001 Number of purchase orders for sales order RKE2_VV570 QUAN 15 3
VV580001 Number of goods receipts for sales orders RKE2_VV580 QUAN 15 3
VV495001 Number of employees RKE2_VV495 QUAN 15 3
VVSTU001 Standard Unit of M. RKE2_VVSTU QUAN 15 3
VV155001 Grace costs RKE2_VV155 CURR 15 2
VV365001 Price differences RKE2_VV365 CURR 15 2
VV364001 Mixed-price variance RKE2_VV364 CURR 15 2
VVK15001 Group: Material RKE2_VVK15 CURR 15 2
VVK20001 Group: Material overhead costs RKE2_VVK20 CURR 15 2
VVK25001 Group: Production RKE2_VVK25 CURR 15 2
VVK30001 Group: Misc. RKE2_VVK30 CURR 15 2
VVK10001 Group price RKE2_VVK10 CURR 15 2
VVO10001 PCA: Int. revenues RKE2_VVO10 CURR 15 2
VVO20001 PCA: Int. costs RKE2_VVO20 CURR 15 2
VVOQU001 PCA: Delivery quantity RKE2_VVOQU QUAN 15 3
VV366001 Other Actual Costs RKE2_VV366 CURR 15 2
VV367001 S/A Costs - Actual RKE2_VV367 CURR 15 2
VV368001 Process "Production" Actual RKE2_VV368 CURR 15 2
VV151001 Actual Mat. Input RKE2_VV151 CURR 15 2
VV171001 Act. Fxd Prod. Costs RKE2_VV171 CURR 15 2
VV181001 Actual Variable Production Costs RKE2_VV181 CURR 15 2
VV191001 Actual Setup Costs RKE2_VV191 CURR 15 2
VV201001 Actual Fixed Machine Hours RKE2_VV201 CURR 15 2
VV211001 Actual Variable Machine Hours RKE2_VV211 CURR 15 2
VV251001 Actual Material Overhead Costs RKE2_VV251 CURR 15 2
VV810001 No. of Inquiries RKE2_VV810 QUAN 15 3
VV820001 No. of Complaints RKE2_VV820 QUAN 15 3
VV830001 Cost of Inquiries RKE2_VV830 CURR 15 2
VV840001 Cost of Complaints RKE2_VV840 CURR 15 2
VV095001 oth. sales deduct. RKE2_VV095 CURR 15 2
VV713001 Advertising RKE2_VV713 CURR 15 2
VV900001 Revenue fee RKE2_VV900 CURR 15 2
VV910001 Revenue from Expenses/Travel Costs RKE2_VV910 CURR 15 2
VV915001 Revenues from External Activities RKE2_VV915 CURR 15 2
VV920001 Sales Deductions RKE2_VV920 CURR 15 2
VV930001 Number of Labor Hours RKE2_VV930 QUAN 15 3
VV931001 Number of Hours Billed RKE2_VV931 QUAN 15 3
VV940001 Cost of Labor Hours RKE2_VV940 CURR 15 2
VV950001 Travel expenses RKE2_VV950 CURR 15 2
VV960001 Other expenses RKE2_VV960 CURR 15 2
VV970001 Ext. activity costs RKE2_VV970 CURR 15 2
VV999001 X_Technical RKE2_VV999 CURR 15 2
VVADV001 Advert. Costs SEM215 RKE2_VVADV CURR 15 2
VVCGS001 COGS in SEM215 RKE2_VVCGS CURR 15 2
VVDEP001 Deprec. Costs SEM215 RKE2_VVDEP CURR 15 2
VVENG001 Energy Costs SEM215 RKE2_VVENG CURR 15 2
VVNR001 NetRevenue in SEM215 RKE2_VVNR CURR 15 2
VVPSC001 PersonnelCost SEM215 RKE2_VVPSC CURR 15 2
VVREN001 Rent Costs SEM215 RKE2_VVREN CURR 15 2
VVREV001 Revenue SEM215 RKE2_VVREV CURR 15 2
VVSD001 SalesDiscount SEM215 RKE2_VVSD CURR 15 2
VVCM2001 Contr.Margin2 SEM215 RKE2_VVCM2 CURR 15 2
VVSV001 Sales Volume SEM215 RKE2_VVSV QUAN 15 3
VVLS1001 Costs pre-leg RKE2_VVLS1 CURR 15 2
VVLS2001 Costs main-leg RKE2_VVLS2 CURR 15 2
VVLS3001 Costs sub-leg RKE2_VVLS3 CURR 15 2

CE3IDEA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CE3IDEA MANDT CE3IDEA MANDT T000 Clients MANDT
CE3IDEA PALEDGER CE3IDEA MANDT TKEL CO-PA ledger MANDT
CE3IDEA PALEDGER CE3IDEA PALEDGER TKEL CO-PA ledger PALEDGER
CE3IDEA VERSI CE3IDEA MANDT TKVS CO Versions MANDT
CE3IDEA VERSI CE3IDEA VERSI TKVS CO Versions VERSI
CE3IDEA VRGAR CE3IDEA MANDT TVGA Record types for CO-PA MANDT
CE3IDEA VRGAR CE3IDEA VRGAR TVGA Record types for CO-PA VRGAR