SAP table reference
TVMS
Materials: Status in Sales and DistributionExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TVMS.
SAP table TVMS has 2 primary key fields: MANDT,VMSTA.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
TVMS fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key VMSTA | Distribution-chain-specific material status | CHAR | 2 | 0 | VMSTA | ||
| SPVBA | Blocked for inquiry | CHAR | 1 | 0 | SPVBA | ||
| SPVBB | Blocked for quotation | CHAR | 1 | 0 | SPVBB | ||
| SPVBC | Blocked for sales order | CHAR | 1 | 0 | SPVBC | ||
| SPVBD | Blocked for product proposal | CHAR | 1 | 0 | SPVBD | ||
| SPVBE | Blocked for scheduling agreement | CHAR | 1 | 0 | SPVBE | ||
| SPVBF | Blocked for value contract | CHAR | 1 | 0 | SPVBF_VMS | ||
| SPVBG | Blocked for contract | CHAR | 1 | 0 | SPVBG | ||
| SPVBH | Blocked for returns | CHAR | 1 | 0 | SPVBH | ||
| SPVBI | Blocked for free of charge delivery | CHAR | 1 | 0 | SPVBI | ||
| SPVBJ | Blocked for delivery | CHAR | 1 | 0 | SPVBJ | ||
| SPVBK | Blocked for credit memo request | CHAR | 1 | 0 | SPVBK | ||
| SPVBL | Blocked for debit memo request | CHAR | 1 | 0 | SPVBL | ||
| LIFSP | Schedule Line Blocked for Delivery | CHAR | 2 | 0 | TVLS | LIFSP_EP | |
| WAUFT | Blocked for allocation table | CHAR | 1 | 0 | WAUFT | ||
| WREPL | Blocked for Replenishment | CHAR | 1 | 0 | WREPL | ||
| WSTOR | Blocked for store order | CHAR | 1 | 0 | WSTOR |