SAP ABAP Table M_SHRAF (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure M_SHRAF   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 INTRENO VVINTRENO VVINTRENO CHAR 13   0   Internal Real Estate Master Data Code  
3 DGUELBIS VIGWSGUELBIS DDAT DATS 8   0   Date: Valid To  
4 VERSION VIGWSVERSION VIGWVERSION NUMC 4   0   Version Indicator  
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
6 SWENR SWENR SWENR CHAR 8   0   Business Entity Number VIOB01
7 SGENR SGENR SGENR CHAR 8   0   Building Number VIOB03
8 SRAUMEXT VIGWRAUMEXT VIGWRAUMEXT CHAR 13   0    
9 DGUELAB VIGWGUELAB DDAT DATS 8   0   Valid-from date  
10 SGEBT SGEBT SGEBT CHAR 2   0   Part of Building TIV12
11 SSTOCKW VVSSTOCKW VVSSTOCKW NUMC 3   0   Floor TIV37
12 XRBEZ VIGWRBEZ XMBEZ CHAR 30   0   Name of Room  
13 SRAART SRAART SRAART NUMC 2   0   Room type TIV09
14 SOBJEKT VVSOBJGPO CHAR13 CHAR 13   0   Internal key for object for business partner table  
15 PARTNR BP_PARTNR BP_PARTNR CHAR 10   0   Business Partner Number BP000
16 ROLETYP BP_ROLETYP BP_ROLETYP CHAR 4   0   Business Partner Role Category TPZ3
17 NAME1 BP_NAME1 TEXT40 CHAR 40   0   Name 1 (surname for persons, otherwise company name)  
18 NAME2 BP_NAME2 TEXT40 CHAR 40   0   Name 2 (Continuation of NAME 1)  
19 MC_NAME1 BP_MC_NAM1 CHAR25 CHAR 25   0   Field NAME1 in Upper Case  
20 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
21 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
22 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
23 ORT01_MC VVXORT01MC CHAR16 CHAR 16   0   IS-IS: City 1 in upper case characters for matchcode search  
24 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
25 STRAS_MC VVXSTRASMC CHAR16 CHAR 16   0   IS-IS: Street in upper case characters for matchcode search  
26 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 M_SHRAF BUKRS T001 BUKRS KEY 1 CN
2 M_SHRAF LAND1 T005 LAND1 KEY 1 1
3 M_SHRAF MANDT T000 MANDT KEY 1 CN
4 M_SHRAF PARTNR BP000 PARTNR    
5 M_SHRAF REGIO T005S BLAND KEY 1 1
6 M_SHRAF ROLETYP TPZ3 ROLETYP    
7 M_SHRAF SGEBT TIV12 SGEBT KEY 1 CN
8 M_SHRAF SGENR VIOB03 SGENR KEY 1 CN
9 M_SHRAF SRAART TIV09 SRAART KEY 1 CN
10 M_SHRAF SSTOCKW TIV37 SSTOCKW KEY 1 CN
11 M_SHRAF SWENR VIOB01 SWENR KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in