SAP table ELBK (Supplier Evaluation: Header Data)
SAP table ELBK has 3 primary key fields being MANDT,EKORG,LIFNR.
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 | |
| EKORG | Purchasing organization | CHAR | 4 | 0 | T024E | EKORG | |
| LIFNR | Vendor's account number | CHAR | 10 | 0 | LFA1 | ELIFN | |
| LOEKZ | Deletion indicator | CHAR | 1 | 0 | ELOEK1 | ||
| KLASS | Supplier Class | CHAR | 9 | 0 | T023 | LIFKL | |
| GEWSL | Weighting key | CHAR | 2 | 0 | T147J | GEWSL | |
| GESBU | Overall score | DEC | 3 | 0 | BEWER | ||
| LEBEW | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| LEBDT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| TXTSL | Text key | CHAR | 5 | 0 | TXTSL |
ELBK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ELBK | EKORG | T024E | Purchasing Organizations | EKORG |
| 1 ELBK | GEWSL | T147J | Weighting Keys in Supplier Evaluation | MANDT |
| 1 ELBK | GEWSL | T147J | Weighting Keys in Supplier Evaluation | GEWSL |
| 0 ELBK | KLASS | T023 | Material Groups | MATKL |
| 1 ELBK | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 1 ELBK | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 ELBK | MANDT | T000 | Clients | MANDT |
| 1 ELBK | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |