SAP Table
TVLS Deliveries: Blocking Reasons/Criteria
SAP table TVLS has 2 primary key fields being MANDT,LIFSP.
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
TVLS columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||
| KeyLIFSP | Default Delivery Block | CHAR | 2 | 0 | LIFSP | ||
| SPELF | Delivery block | CHAR | 1 | 0 | SPELF | ||
| SPEKO | Picking Block | CHAR | 1 | 0 | SPEKO | ||
| SPEWA | Goods Issue Block | CHAR | 1 | 0 | SPEWA | ||
| SPEFT | Block production | CHAR | 1 | 0 | SPEFT | ||
| SPEBE | Confirmation Block | CHAR | 1 | 0 | SPEBE | ||
| SPEAU | Sales Order Block | CHAR | 1 | 0 | SPEAU | ||
| SPEDR | Printing block | CHAR | 1 | 0 | SPEDR | ||
| SPEVI | Delivery Due List Block | CHAR | 1 | 0 | SPEVI | ||
| MBDIF | Deferment period for material provision in days | NUMC | 3 | 0 | MBDIF | ||
| PREQ_BLOCK | Block the Creation of Purchase Requisitions | CHAR | 1 | 0 | PREQ_BLOCK |