ESLL SAP (Lines of Service Package) Table details
Dictionary Type: Table
Description: Lines of Service Package
Description: Lines of Service Package
Table field list including key, data, relationships and ABAP select examples
ESLL is a standard SAP Table which is used to store Lines of Service Package data and is available within R/3 SAP systems depending on the version and release level.
The ESLL table consists of various fields, each holding specific information or linking keys about Lines of Service Package 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ESLL 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 | |||
PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | 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 | ||||
WITH_LIM | Also Search in Limits | WITH_LIM | CHAR | 1 | CHAR01 | ||||
SPINF | Update Conditions | KUPDATE | CHAR | 1 | XFELD | ||||
PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
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 | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
MOLGA | Country Grouping | MOLGA | CHAR | 2 | Assigned to domain | MOLGA | MOL | ||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
LGTXT | Wage Type Long Text | LGTXT | CHAR | 25 | TEXT25 | ||||
STELL | Job | STELL | NUMC | 8 | Assigned to domain | STELL | |||
IFTNR | Sequence Number for CO/MM-SRV Interface Tables | IFTNR | NUMC | 10 | IFTNR | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
INSDT | Date on Which This Record was Stored in the Table | INSDT | DATS | 8 | DATUM | ||||
PLN_PACKNO | Source package number | PLN_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
PLN_INTROW | Entry: Planned package line | PLN_INTROW | NUMC | 10 | Assigned to domain | PACKNO | |||
KNT_PACKNO | Entry: Unplanned from contract | KNT_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
KNT_INTROW | Entry: Unplanned from contract | KNT_INTROW | NUMC | 10 | INTROW | ||||
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 | ||||
LIMIT_ROW | Entry: Unplanned, limit line | LIMIT_ROW | NUMC | 10 | Assigned to domain | PACKNO | |||
ACT_MENGE | Purchase Order: Entered Quantity | ACT_MENGE | QUAN | 13(3) | MENG13V | ||||
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 | ||||
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 | ||||
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 | |
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 | ||||
KKNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
IWEIN | Unit for Work | IWEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
INT_WORK | Internal Work | INT_WORK | QUAN | 8(2) | INT_WORK | ||||
EXTERNALID | SRM Reference Key | SRMID | CHAR | 40 | |||||
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
ACT_WORK | Internal Work | INT_WORK | QUAN | 8(2) | INT_WORK | ||||
MAPNO | Mapping Field f. PACKNO, INTROW at Item Level for Commitment | MAPNO | NUMC | 4 | NUMC4 | ||||
SRVMAPKEY | Item Key for eSOA Messages | SRVMAPKEY | NUMC | 10 | |||||
.INCLU--AP | 0 | ||||||||
TAXTARIFFCODE | Tax Tariff Code | J_1B_TAX_TARIFF_CODE | CHAR | 16 | T604F | STEUC | |||
SDATE | Date | SIDATE | DATS | 8 | DATUM | ||||
BEGTIME | Start Time | BEGINUZ | TIMS | 6 | UZEIT | ||||
ENDTIME | End Time | ENDEUZ | TIMS | 6 | UZEIT | ||||
PERSEXT | External Personnel Number | PERSEXT | CHAR | 40 | TEXT40 | ||||
CATSCOUNTE | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
STOKZ | Indicator: Document Has Been Reversed | CO_STOKZ | CHAR | 1 | FLAG | ||||
BELNR | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
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 | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
CHGTEXT | Short Text Change Allowed | CHGTEXT | CHAR | 1 | XFELD | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
KLVAR | Costing Variant | CK_KLVAR | CHAR | 4 | Assigned to domain | KLVAR | KRT | ||
.INCLU--AP | 0 | ||||||||
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 | ||||
BOS_ECP | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
CHGLTEXT | Change to Long Text Allowed | CHGLTEXT | CHAR | 1 | XFELD | ||||
BOSGRUPPENR | Group Number of Assignemnt Number for Execution Model | BOSGRUPPENR | NUMC | 3 | NUM3 | ||||
BOSLFDNR | Sequence Number of Assignemnt Number for Execution Model | BOSLFDNR | NUMC | 1 | BOSLFDNR | ||||
BOSDRUKZ | Print ID | BOSDRUKZ | CHAR | 1 | BOSDRUKZ | ||||
BOSSUPPLENO | Supplementary Number | BOSSUPPLENO | NUMC | 3 | NUM3 | ||||
BOSSUPPLESTATUS | Supplemetary Status | BOSSUPPLESTATUS | NUMC | 1 | TBOSSUPPLE | NUM1 | |||
/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 | ||||
/SAPBOQ/M_FRATE | Flat Rate for the Main Item Defined | /SAPBOQ/MFLT_RATE | CHAR | 1 | XFELD | ||||
EXTREFKEY | External Reference Key for Service | EXTREFKEY | CHAR | 40 | CHAR_40 | ||||
INV_MENGE | Purchase Order: Quantity Entered from the Invoice | INV_MENGE | QUAN | 13(3) | MENG13V | ||||
.INCLU--AP | 0 | ||||||||
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 |
Key field | Non-key field |
How do I retrieve data from SAP table ESLL using ABAP code
The following ABAP code Example will allow you to do a basic selection on ESLL to SELECT all data from the tableDATA: WA_ESLL TYPE ESLL.
SELECT SINGLE *
FROM ESLL
INTO CORRESPONDING FIELDS OF WA_ESLL
WHERE...
How to access SAP table ESLL
Within an ECC or HANA version of SAP you can also view further information about 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