ML_ESLL SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
ML_ESLL is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The ML_ESLL table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PACKNO (Package number), INTROW (Line Number), EXTROW (Line Number), DEL (Deletion 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP ML_ESLL table view 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 | |||
PACKNO | Package number | PACKNO | NUMC | 10 | PACKNO | ||||
INTROW | Line Number | NUMZEILE | NUMC | 10 | INTROW | ||||
EXTROW | Line Number | EXTROW | NUMC | 10 | NUMC10 | ||||
DEL | Deletion Indicator | DEL | CHAR | 1 | CHAR01 | ||||
SRVPOS | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
RANG | Hierarchy level of group | RANG | INT1 | 3 | INT1 | ||||
EXTGROUP | Outline Level | EXTGROUP | CHAR | 8 | CHAR8 | ||||
PACKAGE | Service Assignment | PACKAGE | CHAR | 1 | CHAR1 | ||||
SUB_PACKNO | Subpackage number | SUB_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
LBNUM | Short Description of Service Type | LBNUM | CHAR | 3 | CHAR3 | LBR | |||
AUSGB | Edition of Service Type | AUSGB | NUMC | 4 | NUMC4 | AGB | |||
STLVPOS | Standard Service Catalog Item | STLVPOS | CHAR | 18 | CHAR18 | ||||
EXTSRVNO | Vendor's Service Number | EXTSRVNO | CHAR | 18 | CHAR18 | ||||
MENGE | Quantity with Sign | MENGEV | QUAN | 13(3) | MENGV13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
UEBTO | Overfulfillment Tolerance | SUEBTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Unlimited Overfulfillment | SUEBTK | CHAR | 1 | XFELD | ||||
BRTWR | Gross Price | SBRTWR | CURR | 11(2) | WERT11V | ||||
NETWR | Net Value of Item | SNETWR | CURR | 11(2) | WERT11V | ||||
FROMPOS | Lower Limit | FROMPOS | CHAR | 6 | CHAR6 | ||||
TOPOS | Upper Limit | TO_POS | CHAR | 6 | CHAR6 | ||||
KTEXT1 | Short Text | SH_TEXT1 | CHAR | 40 | TEXT40 | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
PLN_PACKNO | Source package number | PLN_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
PLN_INTROW | Entry: Planned package line | PLN_INTROW | NUMC | 10 | PACKNO | ||||
ACT_MENGE | Purchase Order: Entered Quantity | ACT_MENGE | QUAN | 13(3) | MENG13V | ||||
ALT_INTROW | Alternatives: Reference to basic item | ALT_INTROW | NUMC | 10 | INTROW | ||||
BASIC | Basic Line | GROUND | CHAR | 1 | CHAR01 | ||||
ALTERNAT | Alternative Line | ALTERNAT | CHAR | 1 | CHAR01 | ||||
BIDDER | Bidder's Line | BIDDER | CHAR | 1 | CHAR01 | ||||
SUPPLE | Supplementary Line | SUPPLE | CHAR | 1 | CHAR01 | ||||
FREEQTY | Line with Open Quantity | FREEQTY | CHAR | 1 | CHAR01 | ||||
INFORM | Informatory Line | INFORM | CHAR | 1 | CHAR01 | ||||
PAUSCH | Blanket Line | PAUSCHPOS | CHAR | 1 | CHAR01 | ||||
EVENTUAL | Contingency Line | EVENTUAL | CHAR | 1 | CHAR01 | ||||
HPACKNO | Highest package number | HPACKNO | NUMC | 10 | ESLH | PACKNO | |||
FPACKNO | Parent package number | FPACKNO | NUMC | 10 | ESLH | PACKNO | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
LGART | Wage Type | LGART | CHAR | 4 | LGART | ||||
KNT_PACKNO | Entry: Unplanned from contract | KNT_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
KNT_INTROW | Entry: Unplanned from contract | KNT_INTROW | NUMC | 10 | INTROW | ||||
LIMIT_ROW | Entry: Unplanned, limit line | LIMIT_ROW | NUMC | 10 | PACKNO | ||||
ACT_WERT | Entered Value | ACT_WERT | CURR | 11(2) | WERT11V | ||||
KNT_WERT | Contract: Value Released (via Release Orders) | KNT_WERT | CURR | 11(2) | WERT11V | ||||
KNT_MENGE | Contract: Quantity Released (by Issue of Release Orders) | KNT_MENGE | QUAN | 13(3) | MENG13V | ||||
ZIELWERT | Target Value | WERT_ZIEL | CURR | 11(2) | WERT11 | ||||
UNG_WERT | Contract: Unplanned Released Value | UNG_WERT | CURR | 11(2) | WERT11V | ||||
UNG_MENGE | Contract: Unplanned Released Quantity | UNG_MENGE | QUAN | 13(3) | MENG13V | ||||
PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
PERSEXT | External Personnel Number | PERSEXT | CHAR | 40 | TEXT40 | ||||
SDATE | Date | SIDATE | DATS | 8 | DATUM | ||||
BEGTIME | Start Time | BEGINUZ | TIMS | 6 | UZEIT | ||||
ENDTIME | End Time | ENDEUZ | TIMS | 6 | UZEIT | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
PRS_CHG | Price Change in Entry Sheet | PRS_CHG | CHAR | 1 | XFELD | ||||
MATKL | Material Group | MATKL_SRV | CHAR | 9 | T023 | MATKL | MKL | WBWG | |
FORMELNR | Formula Number | FORMELNR | CHAR | 10 | T167F | CHAR10 | |||
FRMVAL1 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL2 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL3 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL4 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL5 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
USERF1_NUM | User-Defined Field | USERF1_NUM | NUMC | 10 | NUMC10 | ||||
USERF2_NUM | User-Defined Field | USERF2_NUM | QUAN | 13(3) | MENGE | ||||
USERF1_TXT | User-Defined Field | USERF1_TXT | CHAR | 40 | TEXT40 | ||||
USERF2_TXT | User-Defined Field | USERF2_TXT | CHAR | 10 | TEXT10 | ||||
TMP_PACKNO | Entry: Unplanned service from model specifications | TMP_PACKNO | NUMC | 10 | NUMC10 | ||||
TMP_INTROW | Entry: Unplanned service from model specifications | TMP_INTROW | NUMC | 10 | NUMC10 | ||||
STLV_LIM | Service line refers to standard service catalog limits | STLV_LIM | CHAR | 1 | XFELD | ||||
TBTWR | Gross Price | SBRTWR | CURR | 11(2) | WERT11V | ||||
NAVNW | Non-deductible input tax | NAVNW_SRV | CURR | 11(2) | WERT11V | ||||
BASWR | Tax base amount | BASWR | CURR | 11(2) | WERT11 | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
IWEIN | Unit for Work | IWEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
INT_WORK | Internal Work | INT_WORK | QUAN | 8(2) | INT_WORK | ||||
EXTREFKEY | External Reference Key for Service | EXTREFKEY | CHAR | 40 | CHAR_40 | ||||
MAPNO | Mapping Field f. PACKNO, INTROW at Item Level for Commitment | MAPNO | NUMC | 4 | NUMC4 | ||||
SRVMAPKEY | Item Key for eSOA Messages | SRVMAPKEY | NUMC | 10 | |||||
EXTERNALID | SRM Reference Key | SRMID | CHAR | 40 | |||||
PER_SDATE | Period of Performance Start Date | MMSRV_PEROP_SDATE | DATS | 8 | DATS | ||||
PER_EDATE | Period of Performance End Date | MMSRV_PEROP_EDATE | DATS | 8 | DATS | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | CK_KALNR | KNR | |||
KLVAR | Costing Variant | CK_KLVAR | CHAR | 4 | KLVAR | KRT | |||
EXTDES | Line ID | EXTDES | CHAR | 10 | CHAR10 | ||||
BOSINTER | Internal line | BOSINTER | CHAR | 1 | CHAR01 | ||||
BOSGRP | Subcontractor group | BOSGRP | CHAR | 4 | TBOSGRP | BOSGRP | |||
BOS_RISK | Risk Line | BOS_RISK | CHAR | 1 | CHAR01 | ||||
BOSDRUKZ | Print ID | BOSDRUKZ | CHAR | 1 | BOSDRUKZ | ||||
BOSSUPPLENO | Supplementary Number | BOSSUPPLENO | NUMC | 3 | NUM3 | ||||
/SAPBOQ/OBJTYPE | Object Category of Line in BOS | /SAPBOQ/OBJTYPE | CHAR | 1 | /SAPBOQ/OBJTYPE | ||||
/SAPBOQ/SPOSNR | Subitem Number | /SAPBOQ/SPOSNR | NUMC | 4 | /SAPBOQ/SPOSNR | ||||
/SAPBOQ/MINTROW | Line Number | NUMZEILE | NUMC | 10 | INTROW | ||||
/SAPBOQ/QT_REL | Service Entry Allowed for Subitem | /SAPBOQ/QT_REL | CHAR | 1 | CHAR01 | ||||
/SAPBOQ/CK_QTY | Lot Size for Costing | /SAPBOQ/CK_QTY | CHAR | 1 | XFELD | ||||
BOSSUPPLESTATUS | Supplemetary Status | BOSSUPPLESTATUS | NUMC | 1 | TBOSSUPPLE | NUM1 |
Key field | Non-key field |
How do I retrieve data from SAP table ML_ESLL using ABAP code
The following ABAP code Example will allow you to do a basic selection on ML_ESLL to SELECT all data from the tableDATA: WA_ML_ESLL TYPE ML_ESLL.
SELECT SINGLE *
FROM ML_ESLL
INTO CORRESPONDING FIELDS OF WA_ML_ESLL
WHERE...
How to access SAP table ML_ESLL
Within an ECC or HANA version of SAP you can also view further information about ML_ESLL 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