CE3EMPR SAP () Table details
Dictionary Type: Table
Description:
Description:
Table field list including key, data, relationships and ABAP select examples
CE3EMPR is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.
The CE3EMPR table consists of various fields, each holding specific information or linking keys about 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. .
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 CE3EMPR table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PALEDGER | Currency type for an operating concern | LEDBO | CHAR | 2 | TKEL | LEDBO | LEDBO | ||
VRGAR | Record Type | RKE_VRGAR | CHAR | 1 | TVGA | VRGAR | VGA | ||
PLIKZ | Plan/Actual Indicator | PLIKZ | CHAR | 1 | PLIKZ | ||||
VERSI | Plan version (CO-PA) | RKEVERSI | CHAR | 3 | TKVS | ALPHA | COVERSI | PVS | |
PERBL | Fiscal year/period block | JAHRPERBL | NUMC | 7 | PERI7 | JAHRPER | |||
PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | RKESUBNR | ||||
PAPAOBJNR | Partner profitability segment number (CO-PA) | RKEPOBJ | NUMC | 10 | RKEOBJNR | ||||
PAPASUBNR | Changes to partner profitability segments (CO-PA) | RKEPSUBNR | NUMC | 4 | RKESUBNR | ||||
HRKFT | Origins (CO-PA) | RKEHERK | CHAR | 4 | RKEHERK | ||||
UPDAT | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
USNAM | Last changed by | AENNM | CHAR | 12 | USNAM | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
REC_WAERS | Currency of the data record | RKE_REC_WAERS | CUKY | 5 | Assigned to domain | WAERS | |||
TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC | 16 | RKE_TSTMP | ||||
VVOQT001 | Ordered quantity | RKE2_VVOQT | QUAN | 15(3) | MENGV15_3 | ||||
VVIQT001 | Invoiced quantity | RKE2_VVIQT | QUAN | 15(3) | MENGV15_3 | ||||
VVSQT001 | Input Quan. Variance | RKE2_VVSQT | QUAN | 15(3) | MENGV15_3 | ||||
VVGRW001 | Gross weight | RKE2_VVGRW | QUAN | 15(3) | MENGV15_3 | ||||
VV010001 | Revenue | RKE2_VV010 | CURR | 15(2) | WERTV8 | ||||
VV020001 | Quantity discount | RKE2_VV020 | CURR | 15(2) | WERTV8 | ||||
VV030001 | Customer discount | RKE2_VV030 | CURR | 15(2) | WERTV8 | ||||
VV040001 | Material discount | RKE2_VV040 | CURR | 15(2) | WERTV8 | ||||
VV060001 | Other rebates | RKE2_VV060 | CURR | 15(2) | WERTV8 | ||||
VV070001 | Accrued Sales deduc. | RKE2_VV070 | CURR | 15(2) | WERTV8 | ||||
VV090001 | Accrued bonus | RKE2_VV090 | CURR | 15(2) | WERTV8 | ||||
VV100001 | Outgoing freight | RKE2_VV100 | CURR | 15(2) | WERTV8 | ||||
VV110001 | Accrued freight | RKE2_VV110 | CURR | 15(2) | WERTV8 | ||||
VV120001 | Dispatch packaging | RKE2_VV120 | CURR | 15(2) | WERTV8 | ||||
VV130001 | Internal sales Comm. | RKE2_VV130 | CURR | 15(2) | WERTV8 | ||||
VV140001 | Cost of goods sold | RKE2_VV140 | CURR | 15(2) | WERTV8 | ||||
VV150001 | Material Input | RKE2_VV150 | CURR | 15(2) | WERTV8 | ||||
VV160001 | Trading Goods | RKE2_VV160 | CURR | 15(2) | WERTV8 | ||||
VV170001 | Production Labor fix | RKE2_VV170 | CURR | 15(2) | WERTV8 | ||||
VV180001 | Production Labor var | RKE2_VV180 | CURR | 15(2) | WERTV8 | ||||
VV190001 | Production Setup | RKE2_VV190 | CURR | 15(2) | WERTV8 | ||||
VV200001 | Produc. machine fix | RKE2_VV200 | CURR | 15(2) | WERTV8 | ||||
VV210001 | Produc. machine var | RKE2_VV210 | CURR | 15(2) | WERTV8 | ||||
VV220001 | Produc. Burn-in fix | RKE2_VV220 | CURR | 15(2) | WERTV8 | ||||
VV230001 | Produc. Burn-in var | RKE2_VV230 | CURR | 15(2) | WERTV8 | ||||
VV240001 | Outside Processing | RKE2_VV240 | CURR | 15(2) | WERTV8 | ||||
VV250001 | Material Overhead | RKE2_VV250 | CURR | 15(2) | WERTV8 | ||||
VV260001 | Administr. Overhead | RKE2_VV260 | CURR | 15(2) | WERTV8 | ||||
VV270001 | Sales Overhead | RKE2_VV270 | CURR | 15(2) | WERTV8 | ||||
VV280001 | Miscellaneous Costs | RKE2_VV280 | CURR | 15(2) | WERTV8 | ||||
VV290001 | Price variance | RKE2_VV290 | CURR | 15(2) | WERTV8 | ||||
VV300001 | Quant. Variance Mat. | RKE2_VV300 | CURR | 15(2) | WERTV8 | ||||
VV310001 | Quant. Variance Prod | RKE2_VV310 | CURR | 15(2) | WERTV8 | ||||
VV320001 | Lot-size Variance | RKE2_VV320 | CURR | 15(2) | WERTV8 | ||||
VV330001 | Usage variance | RKE2_VV330 | CURR | 15(2) | WERTV8 | ||||
VV340001 | Input Variances | RKE2_VV340 | CURR | 15(2) | WERTV8 | ||||
VV350001 | Scrap | RKE2_VV350 | CURR | 15(2) | WERTV8 | ||||
VV360001 | Remaining Variances | RKE2_VV360 | CURR | 15(2) | WERTV8 | ||||
VV370001 | Gen.Admin. costs CCA | RKE2_VV370 | CURR | 15(2) | WERTV8 | ||||
VV380001 | General Market.costs | RKE2_VV380 | CURR | 15(2) | WERTV8 | ||||
VV390001 | Distribution costs | RKE2_VV390 | CURR | 15(2) | WERTV8 | ||||
VV400001 | Production costs | RKE2_VV400 | CURR | 15(2) | WERTV8 | ||||
VV410001 | Marketing activities | RKE2_VV410 | CURR | 15(2) | WERTV8 | ||||
VV420001 | Research & Develop. | RKE2_VV420 | CURR | 15(2) | WERTV8 | ||||
VV430001 | Reserv.f.imminent lo | RKE2_VV430 | CURR | 15(2) | WERTV8 | ||||
VV440001 | Corr:Material Input | RKE2_VV440 | CURR | 15(2) | WERTV8 | ||||
VV450001 | Corr:Manuf.Costs fix | RKE2_VV450 | CURR | 15(2) | WERTV8 | ||||
VV460001 | Corr:Manuf.Costs var | RKE2_VV460 | CURR | 15(2) | WERTV8 | ||||
VV470001 | Corr:Overhead Costs | RKE2_VV470 | CURR | 15(2) | WERTV8 | ||||
VV480001 | Maintenance | RKE2_VV480 | CURR | 15(2) | WERTV8 | ||||
VV145001 | COGS alternative | RKE2_VV145 | CURR | 15(2) | WERTV8 | ||||
VV075001 | Actual Sales deduc. | RKE2_VV075 | CURR | 15(2) | WERTV8 | ||||
VV500001 | Process 'Production' | RKE2_VV500 | CURR | 15(2) | WERTV8 | ||||
VV510001 | Process 'Procurement' | RKE2_VV510 | CURR | 15(2) | WERTV8 | ||||
VV520001 | Process 'Sales' | RKE2_VV520 | CURR | 15(2) | WERTV8 | ||||
VV530001 | Process 'Administration' | RKE2_VV530 | CURR | 15(2) | WERTV8 | ||||
VV550001 | Number of sales order items | RKE2_VV550 | QUAN | 15(3) | MENGV15_3 | ||||
VV560001 | Number of payment problems | RKE2_VV560 | QUAN | 15(3) | MENGV15_3 | ||||
VV570001 | Number of purchase orders for sales order | RKE2_VV570 | QUAN | 15(3) | MENGV15_3 | ||||
VV580001 | Input Quan. Variance | RKE2_VV580 | QUAN | 15(3) | MENGV15_3 | ||||
VV495001 | Number of employees | RKE2_VV495 | QUAN | 15(3) | MENGV15_3 | ||||
VVSTU001 | Standard Unit of M. | RKE2_VVSTU | QUAN | 15(3) | MENGV15_3 | ||||
VV155001 | Grace costs | RKE2_VV155 | CURR | 15(2) | WERTV8 | ||||
VV365001 | Price differences | RKE2_VV365 | CURR | 15(2) | WERTV8 | ||||
VV364001 | Mixed-price variance | RKE2_VV364 | CURR | 15(2) | WERTV8 | ||||
VVK15001 | Group: Material | RKE2_VVK15 | CURR | 15(2) | WERTV8 | ||||
VVK20001 | Group: Material overhead costs | RKE2_VVK20 | CURR | 15(2) | WERTV8 | ||||
VVK25001 | Group: Production | RKE2_VVK25 | CURR | 15(2) | WERTV8 | ||||
VVK30001 | Group: Misc. | RKE2_VVK30 | CURR | 15(2) | WERTV8 | ||||
VVK10001 | Group price | RKE2_VVK10 | CURR | 15(2) | WERTV8 | ||||
VVO10001 | PCA: Int. revenues | RKE2_VVO10 | CURR | 15(2) | WERTV8 | ||||
VVO20001 | PCA: Int. costs | RKE2_VVO20 | CURR | 15(2) | WERTV8 | ||||
VVOQU001 | PCA: Delivery quantity | RKE2_VVOQU | QUAN | 15(3) | MENGV15_3 | ||||
VV366001 | Other Actual Costs | RKE2_VV366 | CURR | 15(2) | WERTV8 | ||||
VV367001 | Sales and Administration Costs - Actual | RKE2_VV367 | CURR | 15(2) | WERTV8 | ||||
VV368001 | Process 'Production' Actual | RKE2_VV368 | CURR | 15(2) | WERTV8 | ||||
VV151001 | Actual Mat. Input | RKE2_VV151 | CURR | 15(2) | WERTV8 | ||||
VV171001 | Act. Fxd Prod. Costs | RKE2_VV171 | CURR | 15(2) | WERTV8 | ||||
VV181001 | Actual Variable Production Costs | RKE2_VV181 | CURR | 15(2) | WERTV8 | ||||
VV191001 | Actual Setup Costs | RKE2_VV191 | CURR | 15(2) | WERTV8 | ||||
VV201001 | Actual Fixed Machine Hours | RKE2_VV201 | CURR | 15(2) | WERTV8 | ||||
VV211001 | Actual Variable Machine Hours | RKE2_VV211 | CURR | 15(2) | WERTV8 | ||||
VV251001 | Actual Material Overhead Costs | RKE2_VV251 | CURR | 15(2) | WERTV8 | ||||
VV810001 | No. of Inquiries | RKE2_VV810 | QUAN | 15(3) | MENGV15_3 | ||||
VV820001 | No. of Complaints | RKE2_VV820 | QUAN | 15(3) | MENGV15_3 | ||||
VV830001 | Cost of Inquiries | RKE2_VV830 | CURR | 15(2) | WERTV8 | ||||
VV840001 | Cost of Complaints | RKE2_VV840 | CURR | 15(2) | WERTV8 | ||||
VV095001 | oth. sales deduct. | RKE2_VV095 | CURR | 15(2) | WERTV8 | ||||
VV713001 | Advertising | RKE2_VV713 | CURR | 15(2) | WERTV8 | ||||
VV900001 | Revenue fee | RKE2_VV900 | CURR | 15(2) | WERTV8 | ||||
VV910001 | Revenue from Expenses/Travel Costs | RKE2_VV910 | CURR | 15(2) | WERTV8 | ||||
VV915001 | Revenues from External Activities | RKE2_VV915 | CURR | 15(2) | WERTV8 | ||||
VV920001 | Sales Deductions | RKE2_VV920 | CURR | 15(2) | WERTV8 | ||||
VV930001 | Number of Labor Hours | RKE2_VV930 | QUAN | 15(3) | MENGV15_3 | ||||
VV931001 | Number of Hours Billed | RKE2_VV931 | QUAN | 15(3) | MENGV15_3 | ||||
VV940001 | Cost of Labor Hours | RKE2_VV940 | CURR | 15(2) | WERTV8 | ||||
VV950001 | Travel expenses | RKE2_VV950 | CURR | 15(2) | WERTV8 | ||||
VV960001 | Other expenses | RKE2_VV960 | CURR | 15(2) | WERTV8 | ||||
VV970001 | Costs from External Activities | RKE2_VV970 | CURR | 15(2) | WERTV8 | ||||
VV999001 | X_Technical | RKE2_VV999 | CURR | 15(2) | WERTV8 | ||||
VVADV001 | Advert. Costs SEM215 | RKE2_VVADV | CURR | 15(2) | WERTV8 | ||||
VVCGS001 | COGS in SEM215 | RKE2_VVCGS | CURR | 15(2) | WERTV8 | ||||
VVDEP001 | Deprec. Costs SEM215 | RKE2_VVDEP | CURR | 15(2) | WERTV8 | ||||
VVENG001 | Energy Costs SEM215 | RKE2_VVENG | CURR | 15(2) | WERTV8 | ||||
VVNR001 | NetRevenue in SEM215 | RKE2_VVNR | CURR | 15(2) | WERTV8 | ||||
VVPSC001 | PersonnelCost SEM215 | RKE2_VVPSC | CURR | 15(2) | WERTV8 | ||||
VVREN001 | Rent Costs SEM215 | RKE2_VVREN | CURR | 15(2) | WERTV8 | ||||
VVREV001 | Revenue SEM215 | RKE2_VVREV | CURR | 15(2) | WERTV8 | ||||
VVSD001 | SalesDiscount SEM215 | RKE2_VVSD | CURR | 15(2) | WERTV8 | ||||
VVCM2001 | Contr.Margin2 SEM215 | RKE2_VVCM2 | CURR | 15(2) | WERTV8 | ||||
VVSV001 | Sales Volume SEM215 | RKE2_VVSV | QUAN | 15(3) | MENGV15_3 | ||||
VVLS1001 | Costs pre-leg | RKE2_VVLS1 | CURR | 15(2) | WERTV8 | ||||
VVLS2001 | Costs main-leg | RKE2_VVLS2 | CURR | 15(2) | WERTV8 | ||||
VVLS3001 | Costs sub-leg | RKE2_VVLS3 | CURR | 15(2) | WERTV8 |
Key field | Non-key field |
How do I retrieve data from SAP table CE3EMPR using ABAP code
The following ABAP code Example will allow you to do a basic selection on CE3EMPR to SELECT all data from the tableDATA: WA_CE3EMPR TYPE CE3EMPR.
SELECT SINGLE *
FROM CE3EMPR
INTO CORRESPONDING FIELDS OF WA_CE3EMPR
WHERE...
How to access SAP table CE3EMPR
Within an ECC or HANA version of SAP you can also view further information about CE3EMPR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects