CE5MM00 SAP () Structure details
Description:
Structure field list including key, data, relationships and ABAP select examples
CE5MM00 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 "" 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_CE5MM00 TYPE CE5MM00.
The CE5MM00 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include PALEDGER (Currency type for an operating concern), VRGAR (Record Type), PLIKZ (Plan/Actual Indicator), VERSI (Plan version (CO-PA)).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP CE5MM00 structure 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 | |||
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 | |
HRKFT | Origins (CO-PA) | RKEHERK | CHAR | 4 | RKEHERK | ||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | RKESUBNR | ||||
PERIO | Period/year | JAHRPER | NUMC | 7 | PERI7 | JAHRPER | |||
ALTPERIO | Period/year in alternative period type | JAHRPERALT | NUMC | 7 | PERI7 | JAHRPER | |||
WTGBTR | Total Value in Transaction Currency | WTGXXX | CURR | 15(2) | WERTV8 | ||||
WOGBTR | Total Value in Object Currency | WOGXXX | CURR | 15(2) | WERTV8 | ||||
WKGBTR | Total Value in Controlling Area Currency | WKGXXX | CURR | 15(2) | WERTV8 | ||||
WKFBTR | Fixed Value in Controlling Area Currency | WKFXXX | CURR | 15(2) | WERTV8 | ||||
MEGBTR | Total Quantity | MEGXXX | QUAN | 15(3) | MENGV8 | ||||
VVOQT | Ordered quantity | RKE2_VVOQT | QUAN | 15(3) | MENGV15_3 | ||||
VVIQT | Invoiced quantity | RKE2_VVIQT | QUAN | 15(3) | MENGV15_3 | ||||
VVSQT | Input Quan. Variance | RKE2_VVSQT | QUAN | 15(3) | MENGV15_3 | ||||
VVGRW | Gross weight | RKE2_VVGRW | QUAN | 15(3) | MENGV15_3 | ||||
VV010 | Revenue | RKE2_VV010 | CURR | 15(2) | WERTV8 | ||||
VV020 | Quantity discount | RKE2_VV020 | CURR | 15(2) | WERTV8 | ||||
VV030 | Customer discount | RKE2_VV030 | CURR | 15(2) | WERTV8 | ||||
VV040 | Material discount | RKE2_VV040 | CURR | 15(2) | WERTV8 | ||||
VV060 | Other rebates | RKE2_VV060 | CURR | 15(2) | WERTV8 | ||||
VV070 | Accrued Sales deduc. | RKE2_VV070 | CURR | 15(2) | WERTV8 | ||||
VV090 | Accrued bonus | RKE2_VV090 | CURR | 15(2) | WERTV8 | ||||
VV100 | Outgoing freight | RKE2_VV100 | CURR | 15(2) | WERTV8 | ||||
VV110 | Accrued freight | RKE2_VV110 | CURR | 15(2) | WERTV8 | ||||
VV120 | Dispatch packaging | RKE2_VV120 | CURR | 15(2) | WERTV8 | ||||
VV130 | Internal sales Comm. | RKE2_VV130 | CURR | 15(2) | WERTV8 | ||||
VV140 | Cost of goods sold | RKE2_VV140 | CURR | 15(2) | WERTV8 | ||||
VV150 | Material Input | RKE2_VV150 | CURR | 15(2) | WERTV8 | ||||
VV160 | Trading Goods | RKE2_VV160 | CURR | 15(2) | WERTV8 | ||||
VV170 | Production Labor fix | RKE2_VV170 | CURR | 15(2) | WERTV8 | ||||
VV180 | Production Labor var | RKE2_VV180 | CURR | 15(2) | WERTV8 | ||||
VV190 | Production Setup | RKE2_VV190 | CURR | 15(2) | WERTV8 | ||||
VV200 | Produc. machine fix | RKE2_VV200 | CURR | 15(2) | WERTV8 | ||||
VV210 | Produc. machine var | RKE2_VV210 | CURR | 15(2) | WERTV8 | ||||
VV220 | Produc. Burn-in fix | RKE2_VV220 | CURR | 15(2) | WERTV8 | ||||
VV230 | Produc. Burn-in var | RKE2_VV230 | CURR | 15(2) | WERTV8 | ||||
VV240 | Outside Processing | RKE2_VV240 | CURR | 15(2) | WERTV8 | ||||
VV250 | Material Overhead | RKE2_VV250 | CURR | 15(2) | WERTV8 | ||||
VV260 | Administr. Overhead | RKE2_VV260 | CURR | 15(2) | WERTV8 | ||||
VV270 | Sales Overhead | RKE2_VV270 | CURR | 15(2) | WERTV8 | ||||
VV280 | Miscellaneous Costs | RKE2_VV280 | CURR | 15(2) | WERTV8 | ||||
VV290 | Price variance | RKE2_VV290 | CURR | 15(2) | WERTV8 | ||||
VV300 | Quant. Variance Mat. | RKE2_VV300 | CURR | 15(2) | WERTV8 | ||||
VV310 | Quant. Variance Prod | RKE2_VV310 | CURR | 15(2) | WERTV8 | ||||
VV320 | Lot-size Variance | RKE2_VV320 | CURR | 15(2) | WERTV8 | ||||
VV330 | Usage variance | RKE2_VV330 | CURR | 15(2) | WERTV8 | ||||
VV340 | Input Variances | RKE2_VV340 | CURR | 15(2) | WERTV8 | ||||
VV350 | Scrap | RKE2_VV350 | CURR | 15(2) | WERTV8 | ||||
VV360 | Remaining Variances | RKE2_VV360 | CURR | 15(2) | WERTV8 | ||||
VV370 | Gen.Admin. costs CCA | RKE2_VV370 | CURR | 15(2) | WERTV8 | ||||
VV380 | General Market.costs | RKE2_VV380 | CURR | 15(2) | WERTV8 | ||||
VV390 | Distribution costs | RKE2_VV390 | CURR | 15(2) | WERTV8 | ||||
VV400 | Production costs | RKE2_VV400 | CURR | 15(2) | WERTV8 | ||||
VV410 | Marketing activities | RKE2_VV410 | CURR | 15(2) | WERTV8 | ||||
VV420 | Research & Develop. | RKE2_VV420 | CURR | 15(2) | WERTV8 | ||||
VV430 | Reserv.f.imminent lo | RKE2_VV430 | CURR | 15(2) | WERTV8 | ||||
VV440 | Corr:Material Input | RKE2_VV440 | CURR | 15(2) | WERTV8 | ||||
VV450 | Corr:Manuf.Costs fix | RKE2_VV450 | CURR | 15(2) | WERTV8 | ||||
VV460 | Corr:Manuf.Costs var | RKE2_VV460 | CURR | 15(2) | WERTV8 | ||||
VV470 | Corr:Overhead Costs | RKE2_VV470 | CURR | 15(2) | WERTV8 | ||||
VV480 | Maintenance | RKE2_VV480 | CURR | 15(2) | WERTV8 | ||||
VV145 | COGS alternative | RKE2_VV145 | CURR | 15(2) | WERTV8 | ||||
VV075 | Actual Sales deduc. | RKE2_VV075 | CURR | 15(2) | WERTV8 | ||||
VV500 | Process 'Production' | RKE2_VV500 | CURR | 15(2) | WERTV8 | ||||
VV510 | Process 'Procurement' | RKE2_VV510 | CURR | 15(2) | WERTV8 | ||||
VV520 | Process 'Sales' | RKE2_VV520 | CURR | 15(2) | WERTV8 | ||||
VV530 | Process 'Administration' | RKE2_VV530 | CURR | 15(2) | WERTV8 | ||||
VV550 | Number of sales order items | RKE2_VV550 | QUAN | 15(3) | MENGV15_3 | ||||
VV560 | Number of payment problems | RKE2_VV560 | QUAN | 15(3) | MENGV15_3 | ||||
VV570 | Number of purchase orders for sales order | RKE2_VV570 | QUAN | 15(3) | MENGV15_3 | ||||
VV580 | Input Quan. Variance | RKE2_VV580 | QUAN | 15(3) | MENGV15_3 | ||||
VV495 | Number of employees | RKE2_VV495 | QUAN | 15(3) | MENGV15_3 | ||||
VVSTU | Standard Unit of M. | RKE2_VVSTU | QUAN | 15(3) | MENGV15_3 | ||||
VV155 | Grace costs | RKE2_VV155 | CURR | 15(2) | WERTV8 | ||||
VV365 | Price differences | RKE2_VV365 | CURR | 15(2) | WERTV8 | ||||
VV364 | Mixed-price variance | RKE2_VV364 | CURR | 15(2) | WERTV8 | ||||
VVK15 | Group: Material | RKE2_VVK15 | CURR | 15(2) | WERTV8 | ||||
VVK20 | Group: Material overhead costs | RKE2_VVK20 | CURR | 15(2) | WERTV8 | ||||
VVK25 | Group: Production | RKE2_VVK25 | CURR | 15(2) | WERTV8 | ||||
VVK30 | Group: Misc. | RKE2_VVK30 | CURR | 15(2) | WERTV8 | ||||
VVK10 | Group price | RKE2_VVK10 | CURR | 15(2) | WERTV8 | ||||
VVO10 | PCA: Int. revenues | RKE2_VVO10 | CURR | 15(2) | WERTV8 | ||||
VVO20 | PCA: Int. costs | RKE2_VVO20 | CURR | 15(2) | WERTV8 | ||||
VVOQU | PCA: Delivery quantity | RKE2_VVOQU | QUAN | 15(3) | MENGV15_3 | ||||
VV366 | Other Actual Costs | RKE2_VV366 | CURR | 15(2) | WERTV8 | ||||
VV367 | Sales and Administration Costs - Actual | RKE2_VV367 | CURR | 15(2) | WERTV8 | ||||
VV368 | Process 'Production' Actual | RKE2_VV368 | CURR | 15(2) | WERTV8 | ||||
VV151 | Actual Mat. Input | RKE2_VV151 | CURR | 15(2) | WERTV8 | ||||
VV171 | Act. Fxd Prod. Costs | RKE2_VV171 | CURR | 15(2) | WERTV8 | ||||
VV181 | Actual Variable Production Costs | RKE2_VV181 | CURR | 15(2) | WERTV8 | ||||
VV191 | Actual Setup Costs | RKE2_VV191 | CURR | 15(2) | WERTV8 | ||||
VV201 | Actual Fixed Machine Hours | RKE2_VV201 | CURR | 15(2) | WERTV8 | ||||
VV211 | Actual Variable Machine Hours | RKE2_VV211 | CURR | 15(2) | WERTV8 | ||||
VV251 | Actual Material Overhead Costs | RKE2_VV251 | CURR | 15(2) | WERTV8 | ||||
VV810 | No. of Inquiries | RKE2_VV810 | QUAN | 15(3) | MENGV15_3 | ||||
VV820 | No. of Complaints | RKE2_VV820 | QUAN | 15(3) | MENGV15_3 | ||||
VV830 | Cost of Inquiries | RKE2_VV830 | CURR | 15(2) | WERTV8 | ||||
VV840 | Cost of Complaints | RKE2_VV840 | CURR | 15(2) | WERTV8 | ||||
VV095 | oth. sales deduct. | RKE2_VV095 | CURR | 15(2) | WERTV8 | ||||
VV713 | Advertising | RKE2_VV713 | CURR | 15(2) | WERTV8 | ||||
VV900 | Revenue fee | RKE2_VV900 | CURR | 15(2) | WERTV8 | ||||
VV910 | Revenue from Expenses/Travel Costs | RKE2_VV910 | CURR | 15(2) | WERTV8 | ||||
VV915 | Revenues from External Activities | RKE2_VV915 | CURR | 15(2) | WERTV8 | ||||
VV920 | Sales Deductions | RKE2_VV920 | CURR | 15(2) | WERTV8 | ||||
VV930 | Number of Labor Hours | RKE2_VV930 | QUAN | 15(3) | MENGV15_3 | ||||
VV931 | Number of Hours Billed | RKE2_VV931 | QUAN | 15(3) | MENGV15_3 | ||||
VV940 | Cost of Labor Hours | RKE2_VV940 | CURR | 15(2) | WERTV8 | ||||
VV950 | Travel expenses | RKE2_VV950 | CURR | 15(2) | WERTV8 | ||||
VV960 | Other expenses | RKE2_VV960 | CURR | 15(2) | WERTV8 | ||||
VV970 | Costs from External Activities | RKE2_VV970 | CURR | 15(2) | WERTV8 | ||||
VV999 | X_Technical | RKE2_VV999 | CURR | 15(2) | WERTV8 | ||||
VVADV | Advert. Costs SEM215 | RKE2_VVADV | CURR | 15(2) | WERTV8 | ||||
VVCGS | COGS in SEM215 | RKE2_VVCGS | CURR | 15(2) | WERTV8 | ||||
VVDEP | Deprec. Costs SEM215 | RKE2_VVDEP | CURR | 15(2) | WERTV8 | ||||
VVENG | Energy Costs SEM215 | RKE2_VVENG | CURR | 15(2) | WERTV8 | ||||
VVNR | NetRevenue in SEM215 | RKE2_VVNR | CURR | 15(2) | WERTV8 | ||||
VVPSC | PersonnelCost SEM215 | RKE2_VVPSC | CURR | 15(2) | WERTV8 | ||||
VVREN | Rent Costs SEM215 | RKE2_VVREN | CURR | 15(2) | WERTV8 | ||||
VVREV | Revenue SEM215 | RKE2_VVREV | CURR | 15(2) | WERTV8 | ||||
VVSD | SalesDiscount SEM215 | RKE2_VVSD | CURR | 15(2) | WERTV8 | ||||
VVCM2 | Contr.Margin2 SEM215 | RKE2_VVCM2 | CURR | 15(2) | WERTV8 | ||||
VVSV | Sales Volume SEM215 | RKE2_VVSV | QUAN | 15(3) | MENGV15_3 | ||||
VVLS1 | Costs pre-leg | RKE2_VVLS1 | CURR | 15(2) | WERTV8 | ||||
VVLS2 | Costs main-leg | RKE2_VVLS2 | CURR | 15(2) | WERTV8 | ||||
VVLS3 | Costs sub-leg | RKE2_VVLS3 | CURR | 15(2) | WERTV8 |
Key field | Non-key field |
How do I retrieve data from SAP structure CE5MM00 using ABAP code?
As CE5MM00 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 CE5MM00 as there is no data to select.How to access SAP table CE5MM00
Within an ECC or HANA version of SAP you can also view further information about CE5MM00 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