SAP ABAP Table AVIMI12 (Change document structure; individually generated)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
Basic Data
Table Category INTTAB    Structure 
Structure AVIMI12   Table Relationship Diagram
Short Description Change document structure; individually generated    
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 .INCLUDE       0   0   Rental requests in an application  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 SBWNR SBWNR SBWNR NUMC 7   0   Application number VIMI11
4 SMIWUNR SMIWUNR SMIWUNR NUMC 3   0   Rent request number *
5 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
6 SNUNR SNUNR SNUNR NUMC 4   0   Rental unit external usage type TIV01
7 SVERKEHR SVERKEHR SVERKEHR CHAR 1   0   Transport Connections of Business Entity TIV44
8 SOBJLAGE RESOBJLAGE RESOBJLAGE NUMC 2   0   Indicator: District Location of Object TIV45
9 RGEBART RGEBART SOBJART NUMC 2   0   Type of building TIV5A
10 AZIMMV AZIMMV DEC2_1 DEC 3   1   Number of rooms from  
11 AZIMMB AZIMMB DEC2_1 DEC 3   1   Number of rooms up to  
12 FGROESA FGROES FLAE DEC 8   2   Total area from  
13 FGROESB FGROESB FLAE DEC 8   2   Total area to  
14 SALTNEU SALTNEU SALTNEU CHAR 1   0   Indicator old-/new building/initial occupancy  
15 JLIFT JLIFT JANEI CHAR 1   0   Indicator: Elevator required  
16 DBEZUA DBEZUA DDAT DATS 8   0   Date for occupation as from  
17 DBEZUB DBEZUB DDAT DATS 8   0   Move-in by date  
18 ASTELL ASTELL DEC3 DEC 3   0   Number of parking spaces  
19 BGESMIET BGESMIET WRTV6 CURR 11   2   Rent total amount  
20 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
21 SGWENR SGWENR SWENR CHAR 8   0   Requested business entity VIOB01
22 SGME SGME SMENR CHAR 8   0   Rental unit requested VIMI01
23 DEING DEING DDAT DATS 8   0   Date of receipt of rental request  
24 DABSAG DABSAG DDAT DATS 8   0   Rejection date  
25 AANGEB AANGEB DEC3 DEC 3   0   Number of first-time offers  
26 JMAXG JMAXG JANEIX10 CHAR 1   0   Indicator: Only top floor requested  
27 JLOESCH JLOESCH JLOESCH CHAR 1   0   Real Estate Deletion Indicator/Flag  
28 FEINS FEINS MEINS UNIT 3   0   Area unit T006
29 DENDB VVDENDB DDAT DATS 8   0   Application valid to  
30 .INCLUDE       0   0   Structures for generating change document update programs  
31 KZ CDCHNGIND CDCHNGIND CHAR 1   0   Change type (U, I, E, D)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 AVIMI12 BUKRS T001 BUKRS    
2 AVIMI12 FEINS T006 MSEHI    
3 AVIMI12 MANDT T000 MANDT    
4 AVIMI12 RGEBART TIV5A SOBJART    
5 AVIMI12 SBWNR VIMI11 SBWNR    
6 AVIMI12 SGME VIMI01 SMENR    
7 AVIMI12 SGWENR VIOB01 SWENR    
8 AVIMI12 SNUNR TIV01 SNUNR    
9 AVIMI12 SOBJLAGE TIV45 SOBJLAGE    
10 AVIMI12 SVERKEHR TIV44 SVERKEHR    
11 AVIMI12 WAERS TCURC WAERS    
History
Last changed by/on SAP  20110901 
SAP Release Created in