SAP ABAP View V_TVMS (Materials: Status in Sales and Distribution)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       VS0C (Package) Customizing R/3 Sales and Distribution master data
Basic Data
View Type C Maintenance View 
Maintenance View V_TVMS  
Short Description Materials: Status in Sales and Distribution    
Root table TVMS   Materials: Status in Sales and Distribution 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TVMS TVMS
2 TVMST TVMS VMSTA I
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TVMS MANDT   MANDT Client
2 VMSTA TVMS VMSTA   VMSTA Distribution-chain-specific material status
3 VMSTB TVMST VMSTB   BEZEI20 Description
4 SPVBA TVMS SPVBA   SPVBA Blocked for inquiry
5 SPVBB TVMS SPVBB   SPVBB Blocked for quotation
6 SPVBC TVMS SPVBC   SPVBC Blocked for sales order
7 SPVBD TVMS SPVBD   SPVBD Blocked for product proposal
8 SPVBE TVMS SPVBE   SPVBE Blocked for scheduling agreement
9 SPVBF TVMS SPVBF   SPVBF_VMS Blocked for value contract
10 SPVBG TVMS SPVBG   SPVBG Blocked for contract
11 SPVBH TVMS SPVBH   SPVBH Blocked for returns
12 SPVBI TVMS SPVBI   SPVBI Blocked for free of charge delivery
13 SPVBJ TVMS SPVBJ   SPVBJ Blocked for delivery
14 SPVBK TVMS SPVBK   SPVBK Blocked for credit memo request
15 SPVBL TVMS SPVBL   SPVBL Blocked for debit memo request
16 LIFSP TVMS LIFSP   LIFSP_EP Schedule line blocked for delivery
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X  Display/Maintenance Allowed  
History
Last changed by/on SAP  20130529 
SAP Release Created in