SAP ABAP View V_VTDST (Delivery status for transfer to external transp. planning)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     VTRI (Package) Interfaces to external transport systems
Basic Data
View Type D Database View 
Database View V_VTDST  
Short Description Delivery status for transfer to external transp. planning    
Root table VTDST   Status of deliveries within transportation planning 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VTDST VTDST
2 TTDS  
3 TTDST  
4 LIKP  
5 KNA1  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VTDST MANDT JL EQ 0 0
2 TTDS MANDT JR EQ AND 0 0
3 VTDST TPLST JL EQ 0 0
4 TTDS TPLST JR EQ AND 0 0
5 TTDS TPLST JL EQ 0 0
6 TTDST TPLST JR EQ AND 0 0
7 TTDS MANDT JL EQ 0 0
8 TTDST MANDT JR EQ AND 0 0
9 VTDST MANDT JL EQ 0 0
10 LIKP MANDT JR EQ AND 0 0
11 VTDST VBELN JL EQ 0 0
12 LIKP VBELN JR EQ AND 0 0
13 VTDST MANDT JL EQ 0 0
14 KNA1 MANDT JR EQ AND 0 0
15 LIKP KUNNR JL EQ 0 0
16 KNA1 KUNNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VTDST MANDT   MANDT Client
2 VBELN VTDST VBELN   VBELN Sales and Distribution Document Number
3 TPLST VTDST TPLST   TPLST Transportation planning point
4 BEZEI TTDST BEZEI   BEZEI20 Description
5 AEDAT VTDST AEDAT   AEDAT Last Changed On
6 AEZET VTDST AEZET   AEZET Time last change was made
7 KUNNR LIKP KUNNR   KUNWE Ship-to party
8 NAME1 KNA1 NAME1   NAME1_GP Name 1
9 LAND1 KNA1 LAND1   LAND1_GP Country Key
10 PSTLZ KNA1 PSTLZ   PSTLZ Postal Code
11 ORT01 KNA1 ORT01   ORT01_GP City
12 LFDAT LIKP LFDAT   LFDAT_V Delivery Date
                 
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  20131127 
SAP Release Created in