SAP Table
T405 Purchasing Value Key
SAP table T405 has 2 primary key fields being MANDT,EKWSL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T405 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| KeyEKWSL | Purchasing Value Key | CHAR | 4 | 0 | EKWSL | ||
| MAHN1 | Number of Days for First Reminder/Expediter | DEC | 3 | 0 | MAHN1 | ||
| MAHN2 | Number of Days for Second Reminder/Expediter | DEC | 3 | 0 | MAHN2 | ||
| MAHN3 | Number of Days for Third Reminder/Expediter | DEC | 3 | 0 | MAHN3 | ||
| UNTTO | Underdelivery Tolerance | DEC | 3 | 1 | UNTTO | ||
| UEBTO | Overdelivery Tolerance | DEC | 3 | 1 | UEBTO | ||
| UEBTK | Unlimited Overdelivery Allowed | CHAR | 1 | 0 | UEBTK | ||
| EVERS | Shipping Instructions | CHAR | 2 | 0 | T027A | EVERS | |
| KZABS | Order Acknowledgment Requirement | CHAR | 1 | 0 | KZABS | ||
| WEPRZ | Minimum Delivery Quantity (Percentage) | DEC | 3 | 1 | WEPRZ | ||
| WELFZ | Standardizing Value for Delivery Date Variance | NUMC | 3 | 0 | WELFZ |
/ Relationships
T405 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T405 | EVERS | T027A | Shipping Instructions, Purchasing | EVERS |