1. Home
  2. Resources
  3. SAP Tables
  4. TVMS - Materials: Status in Sales and Distribution

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
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
NULL No message
A Warning
B Error message
SPVBB Blocked for quotation SPVBB CHAR 1 0
NULL No message
A Warning
B Error message
SPVBC Blocked for sales order SPVBC CHAR 1 0
NULL No message
A Warning
B Error message
SPVBD Blocked for product proposal SPVBD CHAR 1 0
NULL No message
A Warning
B Error message
SPVBE Blocked for scheduling agreement SPVBE CHAR 1 0
NULL No message
A Warning
B Error message
SPVBF Blocked for value contract SPVBF_VMS CHAR 1 0
NULL No message
A Warning
B Error message
SPVBG Blocked for contract SPVBG CHAR 1 0
NULL No message
A Warning
B Error message
SPVBH Blocked for returns SPVBH CHAR 1 0
NULL No message
A Warning
B Error message
SPVBI Blocked for free of charge delivery SPVBI CHAR 1 0
NULL No message
A Warning
B Error message
SPVBJ Blocked for delivery SPVBJ CHAR 1 0
NULL No message
A Warning
B Error message
SPVBK Blocked for credit memo request SPVBK CHAR 1 0
NULL No message
A Warning
B Error message
SPVBL Blocked for debit memo request SPVBL CHAR 1 0
NULL No message
A Warning
B Error message
LIFSP Schedule line blocked for delivery LIFSP_EP TVLS CHAR 2 0
WAUFT Blocked for allocation table WAUFT CHAR 1 0
NULL No message
A Warning
B Error message
WREPL Blocked for Replenishment WREPL CHAR 1 0
NULL No message
A Warning
B Error message
WSTOR Blocked for store order WSTOR CHAR 1 0
NULL No message
A Warning
B Error message
JSPQP Locked for Quantity Planning JSPQP CHAR 1 0
NULL No message
A Warning
B Error message
JSPOG Locked for Order Generation JSPOG CHAR 1 0
NULL No message
A Warning
B Error message
JSPRP Locked for Returns JSPRP CHAR 1 0
NULL No message
A Warning
B Error message
JSPIP Locked for Insert Planning JSPIP CHAR 1 0
NULL No message
A Warning
B Error message

TVMS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVMS LIFSP TVMS MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
TVMS LIFSP TVMS LIFSP TVLS Deliveries: Blocking Reasons/Criteria LIFSP
TVMS MANDT TVMS MANDT T000 Clients MANDT