SAP ABAP Table M_SHAROD (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure M_SHAROD   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 ARRANO VIGWARRANO VVINTRENO CHAR 13   0   Interne Objektnummer für architektonische Räume  
3 VERSION VIGWSVERSION VIGWVERSION NUMC 4   0   Version Indicator  
4 OBJNR SNKS J_OBJNR CHAR 22   0   Service Charge Collector Number ONR00
5 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
6 DERF DERF DATUM DATS 8   0   First Entered on  
7 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
8 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
9 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
10 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
11 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
12 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
13 JLOESCH JLOESCH JLOESCH CHAR 1   0   Real Estate Deletion Indicator/Flag  
14 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
15 SWENR SWENR SWENR CHAR 8   0   Business Entity Number VIOB01
16 SGENR SGENR SGENR CHAR 8   0   Building Number VIOB03
17 SGEBT SGEBT SGEBT CHAR 2   0   Part of Building TIV12
18 SRAUMEXT VIGWRAUMEXT VIGWRAUMEXT CHAR 13   0    
19 SSTOCKW VVSSTOCKW VVSSTOCKW NUMC 3   0   Floor TIV37
20 BERGRP VVBERGRP VVBERGRP CHAR 40   0   Authorization group  
21 DGUELBIS VIGWSGUELBIS DDAT DATS 8   0   Date: Valid To  
22 DGUELAB VIGWGUELAB DDAT DATS 8   0   Valid-from date  
23 XRBEZ VIGWRBEZ XMBEZ CHAR 30   0   Name of Room  
24 SRAART SRAART SRAART NUMC 2   0   Room type TIV09
25 FLOT VIGWARFLOT VIGWFLOT NUMC 4   0   Arch. Flächentyp TIG03AR
26 DRENOV DRENOV DATUM DATS 8   0   Date of last redecoration  
27 XDOORBEZ XDOORBEZ VIGWXDOORBEZ CHAR 15   0   Door-Plate Description  
28 DTRAGFKT VIGWFTRAGFKT VIGWFTRAGFKT QUAN 11   3   Durchschnittliche Tragfähigkeit der Bodenfläche  
29 TFEINHT VIGWFTFEINHT MEINS UNIT 3   0   T006
30 DRAUMHOE VIGWFRAHOEHE VIGWFRAHOEHE QUAN 11   3    
31 RHEINHT VIGWFRHEINHT MEINS UNIT 3   0   T006
32 UMBRAUM VIGWFUMBRAUM VIGWFUMBRAUM QUAN 11   3    
33 REINHT VIGWFREINHT MEINS UNIT 3   0   T006
34 RAAA VIGWARFLAA VIGWFLAA NUMC 10   0   TIG01AR
35 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
36 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
37 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
38 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
39 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
40 ORT01_MC VVXORT01MC CHAR16 CHAR 16   0   IS-IS: City 1 in upper case characters for matchcode search  
41 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_SHAROD BUKRS T001 BUKRS    
2 M_SHAROD FLOT TIG03AR FLOT    
3 M_SHAROD LAND1 T005 LAND1 KEY 1 1
4 M_SHAROD MANDT T000 MANDT    
5 M_SHAROD OBJNR ONR00 OBJNR    
6 M_SHAROD RAAA TIG01AR ARFLAA KEY C CN
7 M_SHAROD REGIO T005S BLAND KEY 1 1
8 M_SHAROD REINHT T006 MSEHI    
9 M_SHAROD RHEINHT T006 MSEHI    
10 M_SHAROD SGEBT TIV12 SGEBT    
11 M_SHAROD SGENR VIOB03 SGENR    
12 M_SHAROD SRAART TIV09 SRAART 1 CN
13 M_SHAROD SSTOCKW TIV37 SSTOCKW    
14 M_SHAROD SWENR VIOB01 SWENR    
15 M_SHAROD TFEINHT T006 MSEHI    
History
Last changed by/on SAP  20130529 
SAP Release Created in