SAP table ESKL (Account Assignment Specification: Service Line)
SAP table ESKL has 4 primary key fields being MANDT,PACKNO,INTROW,NUMKN.
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 | ||
| NUMKN | Seq. Number of Acc. Assignment Specification: Service Line | NUMC | 2 | 0 | NUMKN | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| LOEKZ | Deletion Indicator | CHAR | 1 | 0 | DEL | ||
| NOACT | Inactive account assignment specification | CHAR | 1 | 0 | NOACT | ||
| MENGE | Quantity with Sign | QUAN | 13 | 3 | MENGEV | ||
| WPROZ | Percentage for Account Assignment Value Distribution | DEC | 4 | 1 | WPROZ | ||
| NETWR | Net Value of Item | CURR | 11 | 2 | SNETWR | ||
| ZEKKN | Sequential Number of Account Assignment in ESKN | NUMC | 2 | 0 | ESKL_ZEKKN | ||
| HPACKNO | Highest package number | NUMC | 10 | 0 | ESLH | HPACKNO | |
| ACT_MENGE | Purchase Order: Entered Quantity | QUAN | 13 | 3 | ACT_MENGE | ||
| ACT_WERT | Purchase order: Entered value | CURR | 13 | 2 | ACT_WERT2 | ||
| PLN_NUMKN | Seq. Number of Acc. Assignment Specification: Service Line | NUMC | 2 | 0 | NUMKN | ||
| NAVNW | Non-deductible input tax | CURR | 11 | 2 | NAVNW_SRV | ||
| LFPOS | Item of a Reference Document | NUMC | 4 | 0 | LFPOS | ||
| INV_MENGE | Purchase Order: Quantity Entered from the Invoice | QUAN | 13 | 3 | INV_MENGE | ||
| FINAL | Final Account Assignment Indicator | CHAR | 1 | 0 | AA_FINAL_IND | ||
| FINAL_QTY | Final Account Assignment Quantity | QUAN | 13 | 3 | AA_FINAL_QTY | ||
| FINAL_REASON | Final Account Assignment Reason Code | CHAR | 2 | 0 | T163RC | AA_FINAL_REASON | |
| AA_FINAL_QTY_F | Final Account Assignment Quantity (Floating Point Number) | FLTP | 16 | 16 | AA_FINAL_QTY_F | ||
| MENGE_F | Quantity (Floating Point Number - Internal Field) | FLTP | 16 | 16 | MENGE_F | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |
ESKL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ESKL | FINAL_REASON | T163RC | Reason for Final Account Assignment Indicator | MANDT |
| 0 ESKL | FINAL_REASON | T163RC | Reason for Final Account Assignment Indicator | AA_FINAL_REASON |
| 1 ESKL | HPACKNO | ESLH | Service Package Header Data | PACKNO |
| 0 ESKL | MANDT | T000 | Clients | MANDT |
| 1 ESKL | PACKNO | ESLH | Service Package Header Data | PACKNO |