SAP ABAP Table M_SHUSPD (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure M_SHUSPD   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
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 VMFLNO VIGWVMFLNO VVINTRENO CHAR 13   0   VIGWVMFL
3 VERSION VIGWSVERSION VIGWVERSION NUMC 4   0   Version Indicator  
4 DGUELBIS VIGWSGUELBIS DDAT DATS 8   0   Date: Valid To  
5 DGUELAB VIGWGUELAB DDAT DATS 8   0   Valid-from date  
6 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
7 SWENR SWENR SWENR CHAR 8   0   Business Entity Number VIOB01
8 FLLBEZ VIGWFFLBEZ XTEXT30 CHAR 30   0   Flächenbezeichnung einer Mietfläche  
9 FLID VIGWFFLID VIGWUFLID CHAR 13   0   Rental Space  
10 FLOT VIGWSFFLOT VIGWFLOT NUMC 4   0   Flächentyp TIG03
11 FLAAIND VIGWFLRAIND VIGWFLRAIND NUMC 1   0    
12 FLAA VIGWSFFLAA VIGWFLAA NUMC 10   0   Characteristics Key TIG01N
13 HCOUNT_P VIGWHCNTP VIGWHCNT NUMC 4   0   Personenbelegung (theoretisch)  
14 HCOUNT_I VIGWHCNTI VIGWHCNT NUMC 4   0   Personenbelegung (Ist)  
15 BERGRP VVBERGRP VVBERGRP CHAR 40   0   Authorization group TIVAG
16 DRV_KOND VIGWDRV_KOND JANE CHAR 1   0   Konditionen werden vererbt  
17 SGRNR SGRNR SGRNR CHAR 8   0   Land Number for BE  
18 SGENR SGENR SGENR CHAR 8   0   Building Number  
19 SGEBT SGEBT SGEBT CHAR 2   0   Part of Building TIV12
20 SSTOCKW VVSSTOCKW VVSSTOCKW NUMC 3   0   Floor TIV37
21 A_FLLBEZ VIGWARFLBEZ XTEXT30 CHAR 30   0   Flächenbezeichnung einer arch. Fläche  
22 A_FLID VIGWASPID VIGWFFLID CHAR 13   0    
23 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
24 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
25 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
26 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
27 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
28 ORT01_MC VVXORT01MC CHAR16 CHAR 16   0   IS-IS: City 1 in upper case characters for matchcode search  
29 STRAS_MC VVXSTRASMC CHAR16 CHAR 16   0   IS-IS: Street in upper case characters for matchcode search  
30 DGUELAB1 VIGWGUELAB DDAT DATS 8   0   Valid-from date  
31 DGUELBIS1 VIGWSGUELBIS DDAT DATS 8   0   Date: Valid To  
32 DGUELAB2 VIGWGUELAB DDAT DATS 8   0   Valid-from date  
33 DGUELBIS2 VIGWSGUELBIS DDAT DATS 8   0   Date: Valid To  
34 OBJTYPE VIGWVMOBJTYPE VIGWVMOBJTYPE CHAR 1   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 M_SHUSPD BERGRP TIVAG BERGRP    
2 M_SHUSPD BUKRS T001 BUKRS    
3 M_SHUSPD FLAA TIG01N FLAA REF C CN
4 M_SHUSPD FLOT TIG03 FLOT KEY 1 CN
5 M_SHUSPD LAND1 T005 LAND1 KEY 1 1
6 M_SHUSPD MANDT T000 MANDT KEY 1 CN
7 M_SHUSPD REGIO T005S BLAND KEY 1 1
8 M_SHUSPD SGEBT TIV12 SGEBT    
9 M_SHUSPD SSTOCKW TIV37 SSTOCKW    
10 M_SHUSPD SWENR VIOB01 SWENR    
11 M_SHUSPD VMFLNO VIGWVMFL MANDT KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in