SAP ABAP Table M_SHASPA (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure M_SHASPA   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
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 M_SHASPA BUKRS T001 BUKRS    
2 M_SHASPA FLAA TIG01AR ARFLAA KEY 1 CN
3 M_SHASPA FLOT TIG03AR FLOT    
4 M_SHASPA MANDT T000 MANDT KEY 1 CN
5 M_SHASPA OBJNR ONR00 OBJNR KEY 1 CN
6 M_SHASPA REINHT T006 MSEHI    
7 M_SHASPA RHEINHT T006 MSEHI    
8 M_SHASPA SGEBT TIV12 SGEBT    
9 M_SHASPA SGENR VIOB03 SGENR    
10 M_SHASPA SGRNR VIOB02 SGRNR    
11 M_SHASPA SSTOCKW TIV37 SSTOCKW    
12 M_SHASPA SWENR VIOB01 SWENR    
13 M_SHASPA TFEINHT T006 MSEHI    
History
Last changed by/on SAP  20100310 
SAP Release Created in