ESLL

Transparent Table Application Table
114 Fields 3 CDS Views

Lines of Service Package

ESLL is an SAP database table in S/4HANA. Lines of Service Package. It contains 114 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintOrderServicePackageItem view from BASIC Service Package Items in Maint. Order
P_MaintOrderServicePackageItem view from BASIC
P_ServPkgItem view from BASIC

Fields (114)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY packno PACKNO Package number
KEY introw NUMZEILE Line
extrow EXTROW Line Number
del DEL Deletion Ind.
srvpos ASNUM Activity number
rang RANG Level
extgroup EXTGROUP Outline level
package PACKAGE Service Assgt
sub_packno SUB_PACKNO Package
lbnum LBNUM Service Type
ausgb AUSGB Edition
stlvpos STLVPOS SSC Item
extsrvno EXTSRVNO Ext. Serv. No.
menge MENGEV Quantity
meins MEINS Base Unit
uebto SUEBTO Overfulf. Tol.
uebtk SUEBTK Unlimited
with_lim WITH_LIM With Limit
spinf KUPDATE Condition Update
peinh EPEIN Price Unit
brtwr SBRTWR Gross
netwr SNETWR Net Value
frompos FROMPOS Lower Limit
topos TO_POS Upper Limit
ktext1 SH_TEXT1 Short Text
vrtkz VRTKZ Distribution
twrkz TWRKZ Partial invoice
pernr PERNR_D Personnel No.
molga MOLGA HCM Local.
lgart LGART Wage Type
lgtxt LGTXT Long text
stell STELL Job
iftnr IFTNR Number
budat BUDAT Posting Date
insdt INSDT Insert date
pln_packno PLN_PACKNO P
pln_introw PLN_INTROW I
knt_packno KNT_PACKNO Pkg. no.
knt_introw KNT_INTROW Line
tmp_packno TMP_PACKNO Entry: Unplanned service from model specifications
tmp_introw TMP_INTROW Entry: Unplanned service from model specifications
stlv_lim STLV_LIM SSC limits
limit_row LIMIT_ROW Line
act_menge ACT_MENGE Actual Quantity
act_wert ACT_WERT Entered Value
knt_wert KNT_WERT Value Released
knt_menge KNT_MENGE Qty Released
zielwert WERT_ZIEL Tgt Val.
ung_wert UNG_WERT Unpl. Released Val.
ung_menge UNG_MENGE Unpl. Released Qty
alt_introw ALT_INTROW Alternative
basic GROUND Basic Line
alternat ALTERNAT Altern. Line
bidder BIDDER Bidder's Line
supple SUPPLE Supplem. Line
freeqty FREEQTY Open Quantity
inform INFORM Inform. Line
pausch PAUSCHPOS Blanket Line
eventual EVENTUAL Conting. Line
mwskz MWSKZ Tax Code
txjcd TXJCD Tax Jur.
txdat TXDAT Tax Date
prs_chg PRS_CHG Price Change
matkl MATKL_SRV Material Group
tbtwr SBRTWR Gross
navnw NAVNW_SRV Non-ded. input tax
baswr BASWR Tax Base Amount
kknumv KNUMV Doc. Condition
iwein IWEIN Unit
int_work INT_WORK Work
externalid SRMID SRM Reference
kstar KSTAR Cost Element
act_work INT_WORK Work
mapno MAPNO Mapping Comm.
srvmapkey SRVMAPKEY Item ID
taxtariffcode J_1B_TAX_TARIFF_CODE Tax Tariff Code
sdate SIDATE Date
begtime BEGINUZ Start Time
endtime ENDEUZ End Time
persext PERSEXT Personnel
catscounte CATSCOUNTE Counter
stokz CO_STOKZ Reversed
belnr CATSBELNR Document no.
formelnr FORMELNR Formula
frmval1 FRMVAL Formula Value
frmval2 FRMVAL Formula Value
frmval3 FRMVAL Formula Value
frmval4 FRMVAL Formula Value
frmval5 FRMVAL Formula Value
userf1_num USERF1_NUM User Field
userf2_num USERF2_NUM User Field
userf1_txt USERF1_TXT User Field
userf2_txt USERF2_TXT User Field
knobj KNOBJ Assgmt no.
chgtext CHGTEXT Text Change
kalnr CK_KALNR Cost EstimateNo
klvar CK_KLVAR Costing Variant
extdes EXTDES Line ID
bosinter BOSINTER Internal line
bosgrp BOSGRP SC Group
bos_risk BOS_RISK Risk Line
bos_ecp XFELD Checkbox
chgltext CHGLTEXT Text Change
bosgruppenr BOSGRUPPENR Group No.
boslfdnr BOSLFDNR Seq. No.
bosdrukz BOSDRUKZ Print
bossuppleno BOSSUPPLENO Suppl. Number
bossupplestatus BOSSUPPLESTATUS Suppl. Status
extrefkey EXTREFKEY External Ref. Key
inv_menge INV_MENGE Actual Quantity
_dataaging DATA_TEMPERATURE Data Aging
per_sdate MMSRV_PEROP_SDATE PoP Start Date
per_edate MMSRV_PEROP_EDATE PoP End Date

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Lines of Service Package
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESLL (
    MANDT,            -- Client [MANDT]
    PACKNO,           -- Package number [PACKNO]
    INTROW,           -- Line [NUMZEILE]
    EXTROW,           -- Line Number [EXTROW]
    DEL,              -- Deletion Ind. [DEL]
    SRVPOS,           -- Activity number [ASNUM]
    RANG,             -- Level [RANG]
    EXTGROUP,         -- Outline level [EXTGROUP]
    PACKAGE,          -- Service Assgt [PACKAGE]
    SUB_PACKNO,       -- Package [SUB_PACKNO]
    LBNUM,            -- Service Type [LBNUM]
    AUSGB,            -- Edition [AUSGB]
    STLVPOS,          -- SSC Item [STLVPOS]
    EXTSRVNO,         -- Ext. Serv. No. [EXTSRVNO]
    MENGE,            -- Quantity [MENGEV]
    MEINS,            -- Base Unit [MEINS]
    UEBTO,            -- Overfulf. Tol. [SUEBTO]
    UEBTK,            -- Unlimited [SUEBTK]
    WITH_LIM,         -- With Limit [WITH_LIM]
    SPINF,            -- Condition Update [KUPDATE]
    PEINH,            -- Price Unit [EPEIN]
    BRTWR,            -- Gross [SBRTWR]
    NETWR,            -- Net Value [SNETWR]
    FROMPOS,          -- Lower Limit [FROMPOS]
    TOPOS,            -- Upper Limit [TO_POS]
    KTEXT1,           -- Short Text [SH_TEXT1]
    VRTKZ,            -- Distribution [VRTKZ]
    TWRKZ,            -- Partial invoice [TWRKZ]
    PERNR,            -- Personnel No. [PERNR_D]
    MOLGA,            -- HCM Local. [MOLGA]
    LGART,            -- Wage Type [LGART]
    LGTXT,            -- Long text [LGTXT]
    STELL,            -- Job [STELL]
    IFTNR,            -- Number [IFTNR]
    BUDAT,            -- Posting Date [BUDAT]
    INSDT,            -- Insert date [INSDT]
    PLN_PACKNO,       -- P [PLN_PACKNO]
    PLN_INTROW,       -- I [PLN_INTROW]
    KNT_PACKNO,       -- Pkg. no. [KNT_PACKNO]
    KNT_INTROW,       -- Line [KNT_INTROW]
    TMP_PACKNO,       -- Entry: Unplanned service from model specifications [TMP_PACKNO]
    TMP_INTROW,       -- Entry: Unplanned service from model specifications [TMP_INTROW]
    STLV_LIM,         -- SSC limits [STLV_LIM]
    LIMIT_ROW,        -- Line [LIMIT_ROW]
    ACT_MENGE,        -- Actual Quantity [ACT_MENGE]
    ACT_WERT,         -- Entered Value [ACT_WERT]
    KNT_WERT,         -- Value Released [KNT_WERT]
    KNT_MENGE,        -- Qty Released [KNT_MENGE]
    ZIELWERT,         -- Tgt Val. [WERT_ZIEL]
    UNG_WERT,         -- Unpl. Released Val. [UNG_WERT]
    UNG_MENGE,        -- Unpl. Released Qty [UNG_MENGE]
    ALT_INTROW,       -- Alternative [ALT_INTROW]
    BASIC,            -- Basic Line [GROUND]
    ALTERNAT,         -- Altern. Line [ALTERNAT]
    BIDDER,           -- Bidder's Line [BIDDER]
    SUPPLE,           -- Supplem. Line [SUPPLE]
    FREEQTY,          -- Open Quantity [FREEQTY]
    INFORM,           -- Inform. Line [INFORM]
    PAUSCH,           -- Blanket Line [PAUSCHPOS]
    EVENTUAL,         -- Conting. Line [EVENTUAL]
    MWSKZ,            -- Tax Code [MWSKZ]
    TXJCD,            -- Tax Jur. [TXJCD]
    TXDAT,            -- Tax Date [TXDAT]
    PRS_CHG,          -- Price Change [PRS_CHG]
    MATKL,            -- Material Group [MATKL_SRV]
    TBTWR,            -- Gross [SBRTWR]
    NAVNW,            -- Non-ded. input tax [NAVNW_SRV]
    BASWR,            -- Tax Base Amount [BASWR]
    KKNUMV,           -- Doc. Condition [KNUMV]
    IWEIN,            -- Unit [IWEIN]
    INT_WORK,         -- Work [INT_WORK]
    EXTERNALID,       -- SRM Reference [SRMID]
    KSTAR,            -- Cost Element [KSTAR]
    ACT_WORK,         -- Work [INT_WORK]
    MAPNO,            -- Mapping Comm. [MAPNO]
    SRVMAPKEY,        -- Item ID [SRVMAPKEY]
    TAXTARIFFCODE,    -- Tax Tariff Code [J_1B_TAX_TARIFF_CODE]
    SDATE,            -- Date [SIDATE]
    BEGTIME,          -- Start Time [BEGINUZ]
    ENDTIME,          -- End Time [ENDEUZ]
    PERSEXT,          -- Personnel [PERSEXT]
    CATSCOUNTE,       -- Counter [CATSCOUNTE]
    STOKZ,            -- Reversed [CO_STOKZ]
    BELNR,            -- Document no. [CATSBELNR]
    FORMELNR,         -- Formula [FORMELNR]
    FRMVAL1,          -- Formula Value [FRMVAL]
    FRMVAL2,          -- Formula Value [FRMVAL]
    FRMVAL3,          -- Formula Value [FRMVAL]
    FRMVAL4,          -- Formula Value [FRMVAL]
    FRMVAL5,          -- Formula Value [FRMVAL]
    USERF1_NUM,       -- User Field [USERF1_NUM]
    USERF2_NUM,       -- User Field [USERF2_NUM]
    USERF1_TXT,       -- User Field [USERF1_TXT]
    USERF2_TXT,       -- User Field [USERF2_TXT]
    KNOBJ,            -- Assgmt no. [KNOBJ]
    CHGTEXT,          -- Text Change [CHGTEXT]
    KALNR,            -- Cost EstimateNo [CK_KALNR]
    KLVAR,            -- Costing Variant [CK_KLVAR]
    EXTDES,           -- Line ID [EXTDES]
    BOSINTER,         -- Internal line [BOSINTER]
    BOSGRP,           -- SC Group [BOSGRP]
    BOS_RISK,         -- Risk Line [BOS_RISK]
    BOS_ECP,          -- Checkbox [XFELD]
    CHGLTEXT,         -- Text Change [CHGLTEXT]
    BOSGRUPPENR,      -- Group No. [BOSGRUPPENR]
    BOSLFDNR,         -- Seq. No. [BOSLFDNR]
    BOSDRUKZ,         -- Print [BOSDRUKZ]
    BOSSUPPLENO,      -- Suppl. Number [BOSSUPPLENO]
    BOSSUPPLESTATUS,  -- Suppl. Status [BOSSUPPLESTATUS]
    EXTREFKEY,        -- External Ref. Key [EXTREFKEY]
    INV_MENGE,        -- Actual Quantity [INV_MENGE]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    PER_SDATE,        -- PoP Start Date [MMSRV_PEROP_SDATE]
    PER_EDATE,        -- PoP End Date [MMSRV_PEROP_EDATE]
    PRIMARY KEY (MANDT, PACKNO, INTROW)
);

Learn More