SAP Table ESLL

Lines of Service Package

ESLL (Lines of Service Package) 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 ESLL to other SAP tables.

ESLL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PACKNO Package number PACKNO ESLH NUMC 10 0
INTROW Line Number NUMZEILE NUMC 10 0
EXTROW Line Number EXTROW NUMC 10 0
DEL Deletion Indicator DEL CHAR 1 0
SRVPOS Activity Number ASNUM ASMD CHAR 18 0
RANG Hierarchy level of group RANG INT1 3 0
EXTGROUP Outline Level EXTGROUP CHAR 8 0
PACKAGE Service Assignment PACKAGE CHAR 1 0
SUB_PACKNO Subpackage number SUB_PACKNO ESLH NUMC 10 0
LBNUM Short Description of Service Type LBNUM CHAR 3 0
AUSGB Edition of Service Type AUSGB NUMC 4 0
STLVPOS Standard Service Catalog Item STLVPOS CHAR 18 0
EXTSRVNO Vendor's Service Number EXTSRVNO CHAR 18 0
MENGE Quantity with Sign MENGEV QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
UEBTO Overfulfillment Tolerance SUEBTO DEC 3 1
UEBTK Unlimited Overfulfillment SUEBTK CHAR 1 0
X Yes
NULL No
WITH_LIM Also Search in Limits WITH_LIM CHAR 1 0
SPINF Update Conditions KUPDATE CHAR 1 0
X Yes
NULL No
PEINH Price Unit EPEIN DEC 5 0
BRTWR Gross Price SBRTWR CURR 11 2
NETWR Net Value of Item SNETWR CURR 11 2
FROMPOS Lower Limit FROMPOS CHAR 6 0
TOPOS Upper Limit TO_POS CHAR 6 0
KTEXT1 Short Text SH_TEXT1 CHAR 40 0
VRTKZ Distribution indicator for multiple account assignment VRTKZ CHAR 1 0
NULL Single account assignment
1 Distrib. on quantity basis
2 Distribution by percentage
TWRKZ Partial Invoice Indicator TWRKZ CHAR 1 0
NULL No multiple account assignment
1 Apportion IR quantities to GR quantities one after another
2 Apportion IR quantities to GR quantities proportionately
PERNR Personnel Number PERNR_D NUMC 8 0
MOLGA Country Grouping MOLGA CHAR 2 0
LGART Wage Type LGART CHAR 4 0
LGTXT Wage Type Long Text LGTXT CHAR 25 0
STELL Job STELL NUMC 8 0
IFTNR Sequence Number for CO/MM-SRV Interface Tables IFTNR NUMC 10 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
INSDT Date on Which This Record was Stored in the Table INSDT DATS 8 0
PLN_PACKNO Source package number PLN_PACKNO ESLH NUMC 10 0
PLN_INTROW Entry: Planned package line PLN_INTROW NUMC 10 0
KNT_PACKNO Entry: Unplanned from contract KNT_PACKNO ESLH NUMC 10 0
KNT_INTROW Entry: Unplanned from contract KNT_INTROW NUMC 10 0
TMP_PACKNO Entry: Unplanned service from model specifications TMP_PACKNO NUMC 10 0
TMP_INTROW Entry: Unplanned service from model specifications TMP_INTROW NUMC 10 0
STLV_LIM Service line refers to standard service catalog limits STLV_LIM CHAR 1 0
X Yes
NULL No
LIMIT_ROW Entry: Unplanned, limit line LIMIT_ROW NUMC 10 0
ACT_MENGE Purchase Order: Entered Quantity ACT_MENGE QUAN 13 3
ACT_WERT Entered Value ACT_WERT CURR 11 2
KNT_WERT Contract: Value Released (via Release Orders) KNT_WERT CURR 11 2
KNT_MENGE Contract: Quantity Released (by Issue of Release Orders) KNT_MENGE QUAN 13 3
ZIELWERT Target Value WERT_ZIEL CURR 11 2
UNG_WERT Contract: Unplanned Released Value UNG_WERT CURR 11 2
UNG_MENGE Contract: Unplanned Released Quantity UNG_MENGE QUAN 13 3
ALT_INTROW Alternatives: Reference to basic item ALT_INTROW NUMC 10 0
BASIC Basic Line GROUND CHAR 1 0
ALTERNAT Alternative Line ALTERNAT CHAR 1 0
BIDDER Bidder's Line BIDDER CHAR 1 0
SUPPLE Supplementary Line SUPPLE CHAR 1 0
FREEQTY Line with Open Quantity FREEQTY CHAR 1 0
INFORM Informatory Line INFORM CHAR 1 0
PAUSCH Blanket Line PAUSCHPOS CHAR 1 0
EVENTUAL Contingency Line EVENTUAL CHAR 1 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
PRS_CHG Price Change in Entry Sheet PRS_CHG CHAR 1 0
X Yes
NULL No
MATKL Material Group MATKL_SRV T023 CHAR 9 0
TBTWR Gross Price SBRTWR CURR 11 2
NAVNW Non-deductible input tax NAVNW_SRV CURR 11 2
BASWR Tax base amount BASWR CURR 11 2
KKNUMV Number of the document condition KNUMV CHAR 10 0
IWEIN Unit for Work IWEIN T006 UNIT 3 0
INT_WORK Internal Work INT_WORK QUAN 8 2
EXTERNALID SRM Reference Key SRMID CHAR 40 0
KSTAR Cost Element KSTAR CHAR 10 0
ACT_WORK Internal Work INT_WORK QUAN 8 2
MAPNO Mapping Field f. PACKNO, INTROW at Item Level for Commitment MAPNO NUMC 4 0
SRVMAPKEY Item Key for eSOA Messages SRVMAPKEY NUMC 10 0
TAXTARIFFCODE Tax Tariff Code J_1B_TAX_TARIFF_CODE T604F CHAR 16 0
SDATE Date SIDATE DATS 8 0
BEGTIME Start Time BEGINUZ TIMS 6 0
ENDTIME End Time ENDEUZ TIMS 6 0
PERSEXT External Personnel Number PERSEXT CHAR 40 0
CATSCOUNTE Counter for Records in Time Recording CATSCOUNTE CHAR 12 0
STOKZ Indicator: Document Has Been Reversed CO_STOKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
BELNR Document Number CATSBELNR CHAR 10 0
FORMELNR Formula Number FORMELNR T167F CHAR 10 0
FRMVAL1 Formula Value FRMVAL QUAN 13 3
FRMVAL2 Formula Value FRMVAL QUAN 13 3
FRMVAL3 Formula Value FRMVAL QUAN 13 3
FRMVAL4 Formula Value FRMVAL QUAN 13 3
FRMVAL5 Formula Value FRMVAL QUAN 13 3
USERF1_NUM User-Defined Field USERF1_NUM NUMC 10 0
USERF2_NUM User-Defined Field USERF2_NUM QUAN 13 3
USERF1_TXT User-Defined Field USERF1_TXT CHAR 40 0
USERF2_TXT User-Defined Field USERF2_TXT CHAR 10 0
KNOBJ Number of Object with Assigned Dependencies KNOBJ NUMC 18 0
CHGTEXT Short Text Change Allowed CHGTEXT CHAR 1 0
X Yes
NULL No
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
KLVAR Costing Variant CK_KLVAR CHAR 4 0
EXTREFKEY External Reference Key for Service EXTREFKEY CHAR 40 0
INV_MENGE Purchase Order: Quantity Entered from the Invoice INV_MENGE QUAN 13 3
PER_SDATE Period of Performance Start Date MMSRV_PEROP_SDATE DATS 8 0
PER_EDATE Period of Performance End Date MMSRV_PEROP_EDATE DATS 8 0
OIO_XRENT Flag: service item is for equipment rental OIO_RN_XRENT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
OIO_MATNR Mobilization material OIO_RN_MATNR CHAR 18 0
OIO_MBTXT Text for mobilization of rented equipment OIO_RN_MBTXT CHAR 40 0
OIO_MBMNG Mobilization quantity OIO_RN_MBMNG QUAN 13 3
OIO_MBMEI Mobilization unit OIO_RN_MBMEI UNIT 3 0
OIO_MENGE Mobilization quantity in base units OIO_RN_MENGE QUAN 13 3
OIO_MEINS Base unit of measure OIO_RN_MEINS UNIT 3 0
OIO_RMOBSTAT Mobilization Status OIO_RN_MOBSTAT CHAR 1 0
W Waiting
M Mobilized
D Demobilized
NULL
OIO_RNUMPACK Number of Packages OIO_RN_NUMPACK NUMC 4 0
OIO_RVENDREF Vendor's Reference OIO_RN_VENDREF CHAR 20 0
OIO_RX_PRT Flag: is a Production Resource or Tool OIO_RN_X_PRT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

ESLL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ESLL FORMELNR ESLL MANDT T167F Formulas for Service Lines MANDT
ESLL FORMELNR ESLL FORMELNR T167F Formulas for Service Lines FORMELNR
ESLL IWEIN ESLL IWEIN T006 Units of Measurement MSEHI
ESLL IWEIN ESLL MANDT T006 Units of Measurement MANDT
ESLL KNT_PACKNO SYST MANDT ESLH Service Package Header Data MANDT
ESLL KNT_PACKNO ESLL KNT_PACKNO ESLH Service Package Header Data PACKNO
ESLL MANDT ESLL MANDT T000 Clients MANDT
ESLL MATKL ESLL MANDT T023 Material Groups MANDT
ESLL MATKL ESLL MATKL T023 Material Groups MATKL
ESLL MEINS ESLL MANDT T006 Units of Measurement MANDT
ESLL MEINS ESLL MEINS T006 Units of Measurement MSEHI
ESLL MWSKZ ESLL MANDT T007A Tax Keys MANDT
ESLL MWSKZ T005 KALSM T007A Tax Keys KALSM
ESLL MWSKZ ESLL MWSKZ T007A Tax Keys MWSKZ
ESLL PACKNO ESLL MANDT ESLH Service Package Header Data MANDT
ESLL PACKNO ESLL PACKNO ESLH Service Package Header Data PACKNO
ESLL PLN_PACKNO ESLL PLN_PACKNO ESLH Service Package Header Data PACKNO
ESLL PLN_PACKNO ESLH MANDT ESLH Service Package Header Data MANDT
ESLL SRVPOS SYST MANDT ASMD Service Master: Basic Data MANDT
ESLL SRVPOS ESLL SRVPOS ASMD Service Master: Basic Data ASNUM
ESLL SUB_PACKNO ESLH MANDT ESLH Service Package Header Data MANDT
ESLL SUB_PACKNO ESLL SUB_PACKNO ESLH Service Package Header Data PACKNO
ESLL TAXTARIFFCODE 'BR' T604F Import Processing: Control Code LAND1
ESLL TAXTARIFFCODE ESLL TAXTARIFFCODE T604F Import Processing: Control Code STEUC
ESLL TAXTARIFFCODE SYST MANDT T604F Import Processing: Control Code MANDT
ESLL TXJCD ESLL MANDT TTXJ Check Table for Tax Jurisdiction MANDT
ESLL TXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
ESLL TXJCD ESLL TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD