SAP ABAP Table V_TNSTA0 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_TNSTA0   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
3 ENDDT RI_ENDDT RI_DATUM DATS 8   0   IS-H: Valid-To Date of Record  
4 BEGDT RI_BEGDT RI_DATUM DATS 8   0   IS-H: Valid-From Date of Record  
5 S_STSMA ISH_MD_S_STSMA J_STSMA CHAR 8   0   IS-H: Status Profile Med. Basic Doc. for Inpatient Cases TJ20
6 T_STSMA ISH_MD_T_STSMA J_STSMA CHAR 8   0   IS-H: Status Profile Med. Basic Doc. for Day Patient Cases TJ20
7 A_STSMA ISH_MD_A_STSMA J_STSMA CHAR 8   0   IS-H: Status Profile Med. Basic Doc. for Outpatient Cases TJ20
8 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
9 ERTIM ISH_ERTIM UHRZT TIMS 6   0   IS-H: Time when Data Record Created  
10 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
11 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
12 UPTIM ISH_UPTIM UHRZT TIMS 6   0   IS-H: Time Data Record was Last Changed  
13 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_TNSTA0 A_STSMA TJ20 STSMA KEY 1 CN
2 V_TNSTA0 EINRI TN01 EINRI    
3 V_TNSTA0 MANDT T000 MANDT    
4 V_TNSTA0 S_STSMA TJ20 STSMA KEY 1 CN
5 V_TNSTA0 T_STSMA TJ20 STSMA KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in