SAP table ESLA (Service Type Editions)
SAP table ESLA has 3 primary key fields being MANDT,LBNUM,AUSGB.
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 | |
| LBNUM | Key to Service Type | CHAR | 3 | 0 | LBNUM1 | ||
| AUSGB | Edition of Service Type | NUMC | 4 | 0 | AUSGB | ||
| STRKT | Structure of service type | CHAR | 8 | 0 | T260 | STRKT | |
| KZEDT | Indicator: Whether editing allowed | CHAR | 1 | 0 | KZEDIT | ||
| KZVRW | Indicator: Whether usage allowed | CHAR | 1 | 0 | KZVERWEND | ||
| KZHIR | Standard service catalog hierarchical or combinatory | CHAR | 1 | 0 | KZHIER | ||
| KZVWM | Usage possible | CHAR | 1 | 0 | KZVWM | ||
| LOEKZ | Deletion Indicator | CHAR | 1 | 0 | DEL | ||
| LBDTV | "Valid from" date | DATS | 8 | 0 | LBDATV | ||
| LBDTB | "Valid until" date | DATS | 8 | 0 | LBDATB | ||
| AENDT | Last change to standard service catalog | DATS | 8 | 0 | AENDTSTLV | ||
| AEUHR | Time of last change | TIMS | 6 | 0 | AENUHR | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| BKLAS | Valuation Class | CHAR | 4 | 0 | * | BKLAS | |
| FORM1 | Text module format | CHAR | 1 | 0 | FORMTX | ||
| LENG1 | Display Length | NUMC | 2 | 0 | LENGT | ||
| TRKZ1 | Separator | CHAR | 1 | 0 | TRKZT | ||
| FORM2 | Text module format | CHAR | 1 | 0 | FORMTX | ||
| LENG2 | Display Length | NUMC | 2 | 0 | LENGT | ||
| TRKZ2 | Separator | CHAR | 1 | 0 | TRKZT | ||
| FORM3 | Text module format | CHAR | 1 | 0 | FORMTX | ||
| LENG3 | Display Length | NUMC | 2 | 0 | LENGT | ||
| TRKZ3 | Separator | CHAR | 1 | 0 | TRKZT | ||
| FORM4 | Text module format | CHAR | 1 | 0 | FORMTX | ||
| LENG4 | Display Length | NUMC | 2 | 0 | LENGT | ||
| TRKZ4 | Separator | CHAR | 1 | 0 | TRKZT | ||
| FORM5 | Text module format | CHAR | 1 | 0 | FORMTX | ||
| LENG5 | Display Length | NUMC | 2 | 0 | LENGT | ||
| TRKZ5 | Separator | CHAR | 1 | 0 | TRKZT | ||
| FORM6 | Text module format | CHAR | 1 | 0 | FORMTX | ||
| LENG6 | Display Length | NUMC | 2 | 0 | LENGT | ||
| TRKZ6 | Separator | CHAR | 1 | 0 | TRKZT | ||
| ASTYP | Service Category | CHAR | 4 | 0 | T362 | ASTYP | |
| MATKL | Material Group | CHAR | 9 | 0 | T023 | MATKL |
ESLA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ESLA | ASTYP | T362 | Service Categories | MANDT |
| 1 ESLA | MANDT | T000 | Clients | MANDT |
| 0 ESLA | MATKL | T023 | Material Groups | MATKL |
| 1 ESLA | STRKT | T260 | Standard Service Catalog: Structure Definition | MANDT |