SAP table ESLL (Lines of Service Package)

SAP table ESLL has 3 primary key fields being MANDT,PACKNO,INTROW.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PACKNO Package number NUMC 10 0 ESLH PACKNO
INTROW Line Number NUMC 10 0 NUMZEILE
EXTROW Line Number NUMC 10 0 EXTROW
DEL Deletion Indicator CHAR 1 0 DEL
SRVPOS Activity Number CHAR 18 0 ASMD ASNUM
RANG Hierarchy level of group INT1 3 0 RANG
EXTGROUP Outline Level CHAR 8 0 EXTGROUP
PACKAGE Service Assignment CHAR 1 0 PACKAGE
SUB_PACKNO Subpackage number NUMC 10 0 ESLH SUB_PACKNO
LBNUM Short Description of Service Type CHAR 3 0 LBNUM
AUSGB Edition of Service Type NUMC 4 0 AUSGB
STLVPOS Standard Service Catalog Item CHAR 18 0 STLVPOS
EXTSRVNO Supplier's Service Number CHAR 18 0 EXTSRVNO
MENGE Quantity with Sign QUAN 13 3 MENGEV
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
UEBTO Overfulfillment Tolerance DEC 3 1 SUEBTO
UEBTK Unlimited Overfulfillment CHAR 1 0 SUEBTK
WITH_LIM Also Search in Limits CHAR 1 0 WITH_LIM
SPINF Update Conditions CHAR 1 0 KUPDATE
PEINH Price unit DEC 5 0 EPEIN
BRTWR Gross Price CURR 11 2 SBRTWR
NETWR Net Value of Item CURR 11 2 SNETWR
FROMPOS Lower Limit CHAR 6 0 FROMPOS
TOPOS Upper Limit CHAR 6 0 TO_POS
KTEXT1 Short Text CHAR 40 0 SH_TEXT1
VRTKZ Distribution Indicator for Multiple Account Assignment CHAR 1 0 VRTKZ
Single Account Assignment
1 Distrib. on Quantity Basis
2 Distribution by Percentage
3 Distribution by Amount
TWRKZ Partial invoice indicator CHAR 1 0 TWRKZ
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 NUMC 8 0 PERNR_D
MOLGA HCM Localization CHAR 2 0 * MOLGA
LGART Wage Type CHAR 4 0 * LGART
LGTXT Wage Type Long Text CHAR 25 0 LGTXT
STELL Job NUMC 8 0 * STELL
IFTNR Sequence Number for CO/MM-SRV Interface Tables NUMC 10 0 IFTNR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
INSDT Date on Which This Record was Stored in the Table DATS 8 0 INSDT
PLN_PACKNO Source package number NUMC 10 0 ESLH PLN_PACKNO
PLN_INTROW Entry: Planned package line NUMC 10 0 * PLN_INTROW
KNT_PACKNO Entry: Unplanned from contract NUMC 10 0 ESLH KNT_PACKNO
KNT_INTROW Entry: Unplanned from contract NUMC 10 0 KNT_INTROW
TMP_PACKNO Entry: Unplanned service from model specifications NUMC 10 0 TMP_PACKNO
TMP_INTROW Entry: Unplanned service from model specifications NUMC 10 0 TMP_INTROW
STLV_LIM Service line refers to standard service catalog limits CHAR 1 0 STLV_LIM
LIMIT_ROW Entry: Unplanned, limit line NUMC 10 0 * LIMIT_ROW
ACT_MENGE Purchase Order: Entered Quantity QUAN 13 3 ACT_MENGE
ACT_WERT Entered Value CURR 11 2 ACT_WERT
KNT_WERT Contract: Value Released (via Release Orders) CURR 11 2 KNT_WERT
KNT_MENGE Contract: Quantity Released (by Issue of Release Orders) QUAN 13 3 KNT_MENGE
ZIELWERT Target Value CURR 11 2 WERT_ZIEL
UNG_WERT Contract: Unplanned Released Value CURR 11 2 UNG_WERT
UNG_MENGE Contract: Unplanned Released Quantity QUAN 13 3 UNG_MENGE
ALT_INTROW Alternatives: Reference to basic item NUMC 10 0 ALT_INTROW
BASIC Basic Line CHAR 1 0 GROUND
ALTERNAT Alternative Line CHAR 1 0 ALTERNAT
BIDDER Bidder's Line CHAR 1 0 BIDDER
SUPPLE Supplementary Line CHAR 1 0 SUPPLE
FREEQTY Line with Open Quantity CHAR 1 0 FREEQTY
INFORM Informatory Line CHAR 1 0 INFORM
PAUSCH Blanket Line CHAR 1 0 PAUSCHPOS
EVENTUAL Contingency Line CHAR 1 0 EVENTUAL
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
TXDAT Date for Determining Tax Rates DATS 8 0 TXDAT
PRS_CHG Price Change in Entry Sheet CHAR 1 0 PRS_CHG
MATKL Material Group CHAR 9 0 T023 MATKL_SRV
TBTWR Gross Price CURR 11 2 SBRTWR
NAVNW Non-deductible input tax CURR 11 2 NAVNW_SRV
BASWR Tax base amount CURR 11 2 BASWR
KKNUMV Number of the Document Condition CHAR 10 0 KNUMV
IWEIN Unit for Work UNIT 3 0 T006 IWEIN
INT_WORK Internal Work QUAN 8 2 INT_WORK
EXTERNALID SRM Reference Key CHAR 40 0 SRMID
KSTAR Cost Element CHAR 10 0 * KSTAR
ACT_WORK Internal Work QUAN 8 2 INT_WORK
MAPNO Mapping Field f. PACKNO, INTROW at Item Level for Commitment NUMC 4 0 MAPNO
SRVMAPKEY Item Key for eSOA Messages NUMC 10 0 SRVMAPKEY
TAXTARIFFCODE Tax Tariff Code CHAR 16 0 T604F J_1B_TAX_TARIFF_CODE
SDATE Date DATS 8 0 SIDATE
BEGTIME Start Time TIMS 6 0 BEGINUZ
ENDTIME End Time TIMS 6 0 ENDEUZ
PERSEXT External Personnel Number CHAR 40 0 PERSEXT
CATSCOUNTE Counter for Records in Time Recording CHAR 12 0 CATSCOUNTE
STOKZ Indicator: Document was reversed CHAR 1 0 CO_STOKZ
BELNR Document no. CHAR 10 0 CATSBELNR
FORMELNR Formula Number CHAR 10 0 T167F FORMELNR
FRMVAL1 Formula Value QUAN 13 3 FRMVAL
FRMVAL2 Formula Value QUAN 13 3 FRMVAL
FRMVAL3 Formula Value QUAN 13 3 FRMVAL
FRMVAL4 Formula Value QUAN 13 3 FRMVAL
FRMVAL5 Formula Value QUAN 13 3 FRMVAL
USERF1_NUM User-Defined Field NUMC 10 0 USERF1_NUM
USERF2_NUM User-Defined Field QUAN 13 3 USERF2_NUM
USERF1_TXT User-Defined Field CHAR 40 0 USERF1_TXT
USERF2_TXT User-Defined Field CHAR 10 0 USERF2_TXT
KNOBJ Number of Object with Assigned Dependencies NUMC 18 0 KNOBJ
CHGTEXT Short Text Change Allowed CHAR 1 0 CHGTEXT
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 * CK_KALNR
KLVAR Costing Variant CHAR 4 0 * CK_KLVAR
EXTDES Line ID CHAR 10 0 EXTDES
BOSINTER Internal line CHAR 1 0 BOSINTER
BOSGRP Subcontractor group CHAR 4 0 TBOSGRP BOSGRP
BOS_RISK Risk Line CHAR 1 0 BOS_RISK
BOS_ECP Checkbox CHAR 1 0 XFELD
No
X Yes
CHGLTEXT Change to Long Text Allowed CHAR 1 0 CHGLTEXT
BOSGRUPPENR Group Number of Assignemnt Number for Execution Model NUMC 3 0 BOSGRUPPENR
BOSLFDNR Sequence Number of Assignemnt Number for Execution Model NUMC 1 0 BOSLFDNR
BOSDRUKZ Print ID CHAR 1 0 BOSDRUKZ
Print Service Line
N No Printing
BOSSUPPLENO Supplementary Number NUMC 3 0 BOSSUPPLENO
BOSSUPPLESTATUS Supplemetary Status NUMC 1 0 TBOSSUPPLE BOSSUPPLESTATUS
/SAPBOQ/OBJTYPE Object Category of Line in BOS CHAR 1 0 /SAPBOQ/OBJTYPE
M Main item
U Subitem
/SAPBOQ/SPOSNR Subitem Number NUMC 4 0 /SAPBOQ/SPOSNR
/SAPBOQ/MINTROW Line Number NUMC 10 0 NUMZEILE
/SAPBOQ/QT_REL Service Entry Allowed for Subitem CHAR 1 0 /SAPBOQ/QT_REL
/SAPBOQ/CK_QTY Lot Size for Costing CHAR 1 0 /SAPBOQ/CK_QTY
/SAPBOQ/M_FRATE Flat Rate for the Main Item Defined CHAR 1 0 /SAPBOQ/MFLT_RATE
EXTREFKEY External Reference Key for Service CHAR 40 0 EXTREFKEY
INV_MENGE Purchase Order: Quantity Entered from the Invoice QUAN 13 3 INV_MENGE
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
PER_SDATE Period of Performance Start Date DATS 8 0 MMSRV_PEROP_SDATE
PER_EDATE Period of Performance End Date DATS 8 0 MMSRV_PEROP_EDATE

ESLL foreign key relationships

Table Field Check Table Check Field
0 ESLL BOSGRP TBOSGRP Service Line: Subcontractor Group MANDT
1 ESLL BOSSUPPLESTATUS TBOSSUPPLE BOS Line: Subsequent Status MANDT
0 ESLL FORMELNR T167F Formulas for Service Lines FORMELNR
1 ESLL IWEIN T006 Units of Measurement MANDT
1 ESLL IWEIN T006 Units of Measurement MSEHI
0 ESLL KNT_PACKNO ESLH Service Package Header Data PACKNO
1 ESLL MANDT T000 Clients MANDT
0 ESLL MATKL T023 Material Groups MATKL
1 ESLL MEINS T006 Units of Measurement MANDT
1 ESLL MEINS T006 Units of Measurement MSEHI
0 ESLL MWSKZ T007A Tax Keys KALSM
0 ESLL MWSKZ T007A Tax Keys MWSKZ
1 ESLL PACKNO ESLH Service Package Header Data PACKNO
0 ESLL PLN_PACKNO ESLH Service Package Header Data PACKNO
1 ESLL SUB_PACKNO ESLH Service Package Header Data PACKNO
0 ESLL TAXTARIFFCODE T604F Import Processing: Control Code MANDT
0 ESLL TAXTARIFFCODE T604F Import Processing: Control Code LAND1
1 ESLL TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 ESLL TXJCD TTXJ Check Table for Tax Jurisdiction KALSM