SAP ABAP Table ESLL (Lines of Service Package)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ ML (Package) R/3 services management
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ ML (Package) R/3 services management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ESLL | Table Relationship Diagram |
Short Description | Lines of Service Package |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PACKNO | PACKNO | PACKNO | NUMC | 10 | 0 | Package number | ESLH | |
3 | INTROW | NUMZEILE | INTROW | NUMC | 10 | 0 | Line Number | ||
4 | EXTROW | EXTROW | NUMC10 | NUMC | 10 | 0 | Line Number | ||
5 | .INCLUDE | 0 | 0 | Data Fields for Service Lines | |||||
6 | DEL | DEL | CHAR01 | CHAR | 1 | 0 | Deletion Indicator | ||
7 | SRVPOS | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | ASMD | |
8 | RANG | RANG | INT1 | INT1 | 3 | 0 | Hierarchy level of group | ||
9 | EXTGROUP | EXTGROUP | CHAR8 | CHAR | 8 | 0 | Outline Level | ||
10 | PACKAGE | PACKAGE | CHAR1 | CHAR | 1 | 0 | Service Assignment | ||
11 | SUB_PACKNO | SUB_PACKNO | PACKNO | NUMC | 10 | 0 | Subpackage number | ESLH | |
12 | LBNUM | LBNUM | CHAR3 | CHAR | 3 | 0 | Short Description of Service Type | ||
13 | AUSGB | AUSGB | NUMC4 | NUMC | 4 | 0 | Edition of Service Type | ||
14 | STLVPOS | STLVPOS | CHAR18 | CHAR | 18 | 0 | Standard Service Catalog Item | ||
15 | EXTSRVNO | EXTSRVNO | CHAR18 | CHAR | 18 | 0 | Vendor's Service Number | ||
16 | MENGE | MENGEV | MENGV13 | QUAN | 13 | 3 | Quantity with Sign | ||
17 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
18 | UEBTO | SUEBTO | PRZ21 | DEC | 3 | 1 | Overfulfillment Tolerance | ||
19 | UEBTK | SUEBTK | XFELD | CHAR | 1 | 0 | Unlimited Overfulfillment | ||
20 | WITH_LIM | WITH_LIM | CHAR01 | CHAR | 1 | 0 | Also Search in Limits | ||
21 | SPINF | KUPDATE | XFELD | CHAR | 1 | 0 | Update Conditions | ||
22 | PEINH | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
23 | BRTWR | SBRTWR | WERT11V | CURR | 11 | 2 | Gross Price | ||
24 | NETWR | SNETWR | WERT11V | CURR | 11 | 2 | Net Value of Item | ||
25 | FROMPOS | FROMPOS | CHAR6 | CHAR | 6 | 0 | Lower Limit | ||
26 | TOPOS | TO_POS | CHAR6 | CHAR | 6 | 0 | Upper Limit | ||
27 | KTEXT1 | SH_TEXT1 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
28 | VRTKZ | VRTKZ | VRTKZ | CHAR | 1 | 0 | Distribution indicator for multiple account assignment | ||
29 | TWRKZ | TWRKZ | TWRKZ | CHAR | 1 | 0 | Partial invoice indicator | ||
30 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
31 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
32 | LGART | LGART | LGART | CHAR | 4 | 0 | Wage Type | * | |
33 | LGTXT | LGTXT | TEXT25 | CHAR | 25 | 0 | Wage Type Long Text | ||
34 | STELL | STELL | STELL | NUMC | 8 | 0 | Job | * | |
35 | IFTNR | IFTNR | IFTNR | NUMC | 10 | 0 | Sequence Number for CO/MM-SRV Interface Tables | ||
36 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
37 | INSDT | INSDT | DATUM | DATS | 8 | 0 | Date on Which This Record was Stored in the Table | ||
38 | PLN_PACKNO | PLN_PACKNO | PACKNO | NUMC | 10 | 0 | Source package number | ESLH | |
39 | PLN_INTROW | PLN_INTROW | PACKNO | NUMC | 10 | 0 | Entry: Planned package line | * | |
40 | KNT_PACKNO | KNT_PACKNO | PACKNO | NUMC | 10 | 0 | Entry: Unplanned from contract | ESLH | |
41 | KNT_INTROW | KNT_INTROW | INTROW | NUMC | 10 | 0 | Entry: Unplanned from contract | ||
42 | TMP_PACKNO | TMP_PACKNO | NUMC10 | NUMC | 10 | 0 | Entry: Unplanned service from model specifications | ||
43 | TMP_INTROW | TMP_INTROW | NUMC10 | NUMC | 10 | 0 | Entry: Unplanned service from model specifications | ||
44 | STLV_LIM | STLV_LIM | XFELD | CHAR | 1 | 0 | Service line refers to standard service catalog limits | ||
45 | LIMIT_ROW | LIMIT_ROW | PACKNO | NUMC | 10 | 0 | Entry: Unplanned, limit line | * | |
46 | ACT_MENGE | ACT_MENGE | MENG13V | QUAN | 13 | 3 | Purchase Order: Entered Quantity | ||
47 | ACT_WERT | ACT_WERT | WERT11V | CURR | 11 | 2 | Entered Value | ||
48 | KNT_WERT | KNT_WERT | WERT11V | CURR | 11 | 2 | Contract: Value Released (via Release Orders) | ||
49 | KNT_MENGE | KNT_MENGE | MENG13V | QUAN | 13 | 3 | Contract: Quantity Released (by Issue of Release Orders) | ||
50 | ZIELWERT | WERT_ZIEL | WERT11 | CURR | 11 | 2 | Target Value | ||
51 | UNG_WERT | UNG_WERT | WERT11V | CURR | 11 | 2 | Contract: Unplanned Released Value | ||
52 | UNG_MENGE | UNG_MENGE | MENG13V | QUAN | 13 | 3 | Contract: Unplanned Released Quantity | ||
53 | ALT_INTROW | ALT_INTROW | INTROW | NUMC | 10 | 0 | Alternatives: Reference to basic item | ||
54 | BASIC | GROUND | CHAR01 | CHAR | 1 | 0 | Basic Line | ||
55 | ALTERNAT | ALTERNAT | CHAR01 | CHAR | 1 | 0 | Alternative Line | ||
56 | BIDDER | BIDDER | CHAR01 | CHAR | 1 | 0 | Bidder's Line | ||
57 | SUPPLE | SUPPLE | CHAR01 | CHAR | 1 | 0 | Supplementary Line | ||
58 | FREEQTY | FREEQTY | CHAR01 | CHAR | 1 | 0 | Line with Open Quantity | ||
59 | INFORM | INFORM | CHAR01 | CHAR | 1 | 0 | Informatory Line | ||
60 | PAUSCH | PAUSCHPOS | CHAR01 | CHAR | 1 | 0 | Blanket Line | ||
61 | EVENTUAL | EVENTUAL | CHAR01 | CHAR | 1 | 0 | Contingency Line | ||
62 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
63 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
64 | PRS_CHG | PRS_CHG | XFELD | CHAR | 1 | 0 | Price Change in Entry Sheet | ||
65 | MATKL | MATKL_SRV | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
66 | TBTWR | SBRTWR | WERT11V | CURR | 11 | 2 | Gross Price | ||
67 | NAVNW | NAVNW_SRV | WERT11V | CURR | 11 | 2 | Non-deductible input tax | ||
68 | BASWR | BASWR | WERT11 | CURR | 11 | 2 | Tax base amount | ||
69 | KKNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
70 | IWEIN | IWEIN | MEINS | UNIT | 3 | 0 | Unit for Work | T006 | |
71 | INT_WORK | INT_WORK | INT_WORK | QUAN | 8 | 2 | Internal Work | ||
72 | EXTERNALID | SRMID | CHAR | 40 | 0 | SRM Reference Key | |||
73 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | * | |
74 | ACT_WORK | INT_WORK | INT_WORK | QUAN | 8 | 2 | Internal Work | ||
75 | MAPNO | MAPNO | NUMC4 | NUMC | 4 | 0 | Mapping Field f. PACKNO, INTROW at Item Level for Commitment | ||
76 | SRVMAPKEY | SRVMAPKEY | NUMC | 10 | 0 | Item Key for eSOA Messages | |||
77 | .INCLU--AP | 0 | 0 | Country-specific enhancement of structure SRV_DATA | |||||
78 | .INCLUDE | 0 | 0 | Country-specific fields of service-line items | |||||
79 | TAXTARIFFCODE | J_1B_TAX_TARIFF_CODE | STEUC | CHAR | 16 | 0 | Tax Tariff Code | T604F | |
80 | .INCLUDE | 0 | 0 | Additional Fields: Service Line | |||||
81 | SDATE | SIDATE | DATUM | DATS | 8 | 0 | Date | ||
82 | BEGTIME | BEGINUZ | UZEIT | TIMS | 6 | 0 | Start Time | ||
83 | ENDTIME | ENDEUZ | UZEIT | TIMS | 6 | 0 | End Time | ||
84 | PERSEXT | PERSEXT | TEXT40 | CHAR | 40 | 0 | External Personnel Number | ||
85 | CATSCOUNTE | CATSCOUNTE | CHAR12 | CHAR | 12 | 0 | Counter for Records in Time Recording | ||
86 | STOKZ | CO_STOKZ | FLAG | CHAR | 1 | 0 | Indicator: Document Has Been Reversed | ||
87 | BELNR | CATSBELNR | BELNR | CHAR | 10 | 0 | Document number | ||
88 | FORMELNR | FORMELNR | CHAR10 | CHAR | 10 | 0 | Formula Number | T167F | |
89 | FRMVAL1 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
90 | FRMVAL2 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
91 | FRMVAL3 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
92 | FRMVAL4 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
93 | FRMVAL5 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
94 | USERF1_NUM | USERF1_NUM | NUMC10 | NUMC | 10 | 0 | User-Defined Field | ||
95 | USERF2_NUM | USERF2_NUM | MENGE | QUAN | 13 | 3 | User-Defined Field | ||
96 | USERF1_TXT | USERF1_TXT | TEXT40 | CHAR | 40 | 0 | User-Defined Field | ||
97 | USERF2_TXT | USERF2_TXT | TEXT10 | CHAR | 10 | 0 | User-Defined Field | ||
98 | KNOBJ | KNOBJ | KNOBJ | NUMC | 18 | 0 | Number of Object with Assigned Dependencies | ||
99 | CHGTEXT | CHGTEXT | XFELD | CHAR | 1 | 0 | Short Text Change Allowed | ||
100 | .INCLUDE | 0 | 0 | ||||||
101 | .INCLUDE | 0 | 0 | Fields for Unit Costing | |||||
102 | KALNR | CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure | * | |
103 | KLVAR | CK_KLVAR | KLVAR | CHAR | 4 | 0 | Costing Variant | * | |
104 | EXTREFKEY | EXTREFKEY | CHAR_40 | CHAR | 40 | 0 | External Reference Key for Service | ||
105 | INV_MENGE | INV_MENGE | MENG13V | QUAN | 13 | 3 | Purchase Order: Quantity Entered from the Invoice | ||
106 | .INCLU--AP | 0 | 0 | ESLL Period of Performance | |||||
107 | PER_SDATE | MMSRV_PEROP_SDATE | DATS | DATS | 8 | 0 | Period of Performance Start Date | ||
108 | PER_EDATE | MMSRV_PEROP_EDATE | DATS | DATS | 8 | 0 | Period of Performance End Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ESLL | FORMELNR | T167F | FORMELNR | KEY | 1 | CN |
2 | ESLL | IWEIN | T006 | MSEHI | |||
3 | ESLL | KNT_PACKNO | ESLH | PACKNO | |||
4 | ESLL | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | ESLL | MATKL | T023 | MATKL | 1 | CN | |
6 | ESLL | MEINS | T006 | MSEHI | |||
7 | ESLL | MWSKZ | T007A | MWSKZ | KEY | 1 | CN |
8 | ESLL | PACKNO | ESLH | PACKNO | KEY | 1 | CN |
9 | ESLL | PLN_PACKNO | ESLH | PACKNO | |||
10 | ESLL | SRVPOS | ASMD | ASNUM | KEY | 1 | CN |
11 | ESLL | SUB_PACKNO | ESLH | PACKNO | |||
12 | ESLL | TAXTARIFFCODE | T604F | STEUC | KEY | 1 | CN |
13 | ESLL | TXJCD | TTXJ | TXJCD | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |