SAP ABAP Table M_SHASPD (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure M_SHASPD   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 ARFLNO VIGWARFLNO VVINTRENO CHAR 13   0    
3 VERSION VIGWSVERSION VIGWVERSION NUMC 4   0   Version Indicator  
4 OBJNR SNKS J_OBJNR CHAR 22   0   Service Charge Collector Number ONR00
5 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
6 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
7 DERF DERF DATUM DATS 8   0   First Entered on  
8 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
9 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
10 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
11 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
12 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
13 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
14 JLOESCH JLOESCH JLOESCH CHAR 1   0   Real Estate Deletion Indicator/Flag  
15 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
16 SWENR SWENR SWENR CHAR 8   0   Business Entity Number VIOB01
17 SGRNR SGRNR SGRNR CHAR 8   0   Land Number for BE VIOB02
18 SGENR SGENR SGENR CHAR 8   0   Building Number VIOB03
19 SGEBT SGEBT SGEBT CHAR 2   0   Part of Building TIV12
20 SSTOCKW VVSSTOCKW VVSSTOCKW NUMC 3   0   Floor TIV37
21 FLID VIGWASPID VIGWFFLID CHAR 13   0    
22 BERGRP VVBERGRP VVBERGRP CHAR 40   0   Authorization group  
23 DGUELBIS VIGWSGUELBIS DDAT DATS 8   0   Date: Valid To  
24 DGUELAB VIGWGUELAB DDAT DATS 8   0   Valid-from date  
25 FLLBEZ VIGWARFLBEZ XTEXT30 CHAR 30   0   Flächenbezeichnung einer arch. Fläche  
26 DTRAGFKT VIGWFTRAGFKT VIGWFTRAGFKT QUAN 11   3   Durchschnittliche Tragfähigkeit der Bodenfläche  
27 TFEINHT VIGWFTFEINHT MEINS UNIT 3   0   T006
28 DRAUMHOE VIGWFRAHOEHE VIGWFRAHOEHE QUAN 11   3    
29 RHEINHT VIGWFRHEINHT MEINS UNIT 3   0   T006
30 UMBRAUM VIGWFUMBRAUM VIGWFUMBRAUM QUAN 11   3    
31 REINHT VIGWFREINHT MEINS UNIT 3   0   T006
32 FLOT VIGWARFLOT VIGWFLOT NUMC 4   0   Arch. Flächentyp TIG03AR
33 FLAA VIGWARFLAA VIGWFLAA NUMC 10   0   TIG01AR
34 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
35 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
36 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
37 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
38 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
39 ORT01_MC VVXORT01MC CHAR16 CHAR 16   0   IS-IS: City 1 in upper case characters for matchcode search  
40 STRAS_MC VVXSTRASMC CHAR16 CHAR 16   0   IS-IS: Street in upper case characters for matchcode search  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 M_SHASPD BUKRS T001 BUKRS    
2 M_SHASPD FLAA TIG01AR ARFLAA KEY 1 CN
3 M_SHASPD FLOT TIG03AR FLOT    
4 M_SHASPD LAND1 T005 LAND1 KEY 1 1
5 M_SHASPD MANDT T000 MANDT KEY 1 CN
6 M_SHASPD OBJNR ONR00 OBJNR KEY 1 CN
7 M_SHASPD REGIO T005S BLAND KEY 1 1
8 M_SHASPD REINHT T006 MSEHI    
9 M_SHASPD RHEINHT T006 MSEHI    
10 M_SHASPD SGEBT TIV12 SGEBT    
11 M_SHASPD SGENR VIOB03 SGENR    
12 M_SHASPD SGRNR VIOB02 SGRNR    
13 M_SHASPD SSTOCKW TIV37 SSTOCKW    
14 M_SHASPD SWENR VIOB01 SWENR    
15 M_SHASPD TFEINHT T006 MSEHI    
History
Last changed by/on SAP  20130529 
SAP Release Created in