SAP ABAP View U_16224 (Material grouping - sales status)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)
Basic Data
View Type D Database View 
Database View U_16224  
Short Description Material grouping - sales status    
Root table TVMS   Materials: Status in Sales and Distribution 
Entity TypeDM02L 
Short text Material grouping - sales and distribution status
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TVMS TVMS
2 TVMST  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TVMS MANDT JL EQ 0 0
2 TVMST MANDT JR EQ AND 0 0
3 TVMS VMSTA JL EQ 0 0
4 TVMST VMSTA JR EQ 0 0
                     
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 SPRAS TVMST SPRAS   SPRAS Language Key
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
17 VMSTB TVMST VMSTB   BEZEI20 Description
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in