SAP Table TVMS
Materials: Status in Sales and Distribution
TVMS (Materials: Status in Sales and Distribution) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TVMS to other SAP tables.
TVMS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
VMSTA
Distribution-chain-specific material status
|
VMSTA |
CHAR
|
2 | 0 | ||||||||||
|
SPVBA
Blocked for inquiry
|
SPVBA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBB
Blocked for quotation
|
SPVBB |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBC
Blocked for sales order
|
SPVBC |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBD
Blocked for product proposal
|
SPVBD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBE
Blocked for scheduling agreement
|
SPVBE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBF
Blocked for value contract
|
SPVBF_VMS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBG
Blocked for contract
|
SPVBG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBH
Blocked for returns
|
SPVBH |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBI
Blocked for free of charge delivery
|
SPVBI |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBJ
Blocked for delivery
|
SPVBJ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBK
Blocked for credit memo request
|
SPVBK |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SPVBL
Blocked for debit memo request
|
SPVBL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LIFSP
Schedule line blocked for delivery
|
LIFSP_EP | TVLS |
CHAR
|
2 | 0 | |||||||||
|
WAUFT
Blocked for allocation table
|
WAUFT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
WREPL
Blocked for Replenishment
|
WREPL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
WSTOR
Blocked for store order
|
WSTOR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
JSPQP
Locked for Quantity Planning
|
JSPQP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
JSPOG
Locked for Order Generation
|
JSPOG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
JSPRP
Locked for Returns
|
JSPRP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
JSPIP
Locked for Insert Planning
|
JSPIP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||