SAP Table VIMI12
Rental requests in an application
VIMI12 (Rental requests in an application) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VIMI12 to other SAP tables.
VIMI12 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
SBWNR
Application number
|
SBWNR | VIMI11 |
NUMC
|
7 | 0 | |||||||||||
|
SMIWUNR
Rent request number
|
SMIWUNR |
NUMC
|
3 | 0 | ||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||
|
SNUNR
Rental unit external usage type
|
SNUNR | TIV01 |
NUMC
|
4 | 0 | |||||||||||
|
SVERKEHR
Transport Connections of Business Entity
|
SVERKEHR | TIV44 |
CHAR
|
1 | 0 | |||||||||||
|
SOBJLAGE
Indicator: District Location of Object
|
RESOBJLAGE | TIV45 |
NUMC
|
2 | 0 | |||||||||||
|
RGEBART
Type of building
|
RGEBART | TIV5A |
NUMC
|
2 | 0 | |||||||||||
|
AZIMMV
Number of rooms from
|
AZIMMV |
DEC
|
3 | 1 | ||||||||||||
|
AZIMMB
Number of rooms up to
|
AZIMMB |
DEC
|
3 | 1 | ||||||||||||
|
FGROESA
Total area from
|
FGROES |
DEC
|
8 | 2 | ||||||||||||
|
FGROESB
Total area to
|
FGROESB |
DEC
|
8 | 2 | ||||||||||||
|
SALTNEU
Indicator old-/new building/initial occupancy
|
SALTNEU |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
JLIFT
Indicator: Elevator required
|
JLIFT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DBEZUA
Date for occupation as from
|
DBEZUA |
DATS
|
8 | 0 | ||||||||||||
|
DBEZUB
Move-in by date
|
DBEZUB |
DATS
|
8 | 0 | ||||||||||||
|
ASTELL
Number of parking spaces
|
ASTELL |
DEC
|
3 | 0 | ||||||||||||
|
BGESMIET
Rent total amount
|
BGESMIET |
CURR
|
11 | 2 | ||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||
|
SGWENR
Requested business entity
|
SGWENR | VIOB01 |
CHAR
|
8 | 0 | |||||||||||
|
SGME
Rental unit requested
|
SGME | VIMI01 |
CHAR
|
8 | 0 | |||||||||||
|
DEING
Date of receipt of rental request
|
DEING |
DATS
|
8 | 0 | ||||||||||||
|
DABSAG
Rejection date
|
DABSAG |
DATS
|
8 | 0 | ||||||||||||
|
AANGEB
Number of first-time offers
|
AANGEB |
DEC
|
3 | 0 | ||||||||||||
|
JMAXG
Indicator: Only top floor requested
|
JMAXG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
JLOESCH
Real Estate Deletion Indicator/Flag
|
JLOESCH |
CHAR
|
1 | 0 | ||||||||||||
|
FEINS
Area unit
|
FEINS | T006 |
UNIT
|
3 | 0 | |||||||||||
|
DENDB
Application valid to
|
VVDENDB |
DATS
|
8 | 0 | ||||||||||||
VIMI12 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| VIMI12 | BUKRS | VIMI12 | MANDT |
T001
Company Codes
|
MANDT |
| VIMI12 | BUKRS | VIMI12 | BUKRS |
T001
Company Codes
|
BUKRS |
| VIMI12 | FEINS | VIMI12 | MANDT |
T006
Units of Measurement
|
MANDT |
| VIMI12 | FEINS | VIMI12 | FEINS |
T006
Units of Measurement
|
MSEHI |
| VIMI12 | MANDT | VIMI12 | MANDT |
T000
Clients
|
MANDT |
| VIMI12 | RGEBART | VIMI12 | MANDT |
TIV5A
Classification of real estate objects
|
MANDT |
| VIMI12 | RGEBART | VIMI12 | RGEBART |
TIV5A
Classification of real estate objects
|
SOBJART |
| VIMI12 | SBWNR | VIMI12 | MANDT |
VIMI11
Applications - Real Estate Management
|
MANDT |
| VIMI12 | SBWNR | VIMI12 | SBWNR |
VIMI11
Applications - Real Estate Management
|
SBWNR |
| VIMI12 | SGME | VIMI12 | BUKRS |
VIMI01
Rental unit - Master data
|
BUKRS |
| VIMI12 | SGME | VIMI12 | SGWENR |
VIMI01
Rental unit - Master data
|
SWENR |
| VIMI12 | SGME | VIMI12 | SGME |
VIMI01
Rental unit - Master data
|
SMENR |
| VIMI12 | SGME | VIMI12 | MANDT |
VIMI01
Rental unit - Master data
|
MANDT |
| VIMI12 | SGWENR | VIMI12 | BUKRS |
VIOB01
Business entities
|
BUKRS |
| VIMI12 | SGWENR | VIMI12 | SGWENR |
VIOB01
Business entities
|
SWENR |
| VIMI12 | SGWENR | VIMI12 | MANDT |
VIOB01
Business entities
|
MANDT |
| VIMI12 | SNUNR | VIMI12 | MANDT |
TIV01
External usage types of rental unit
|
MANDT |
| VIMI12 | SNUNR | VIMI12 | SNUNR |
TIV01
External usage types of rental unit
|
SNUNR |
| VIMI12 | SOBJLAGE | VIMI12 | MANDT |
TIV45
District Location
|
MANDT |
| VIMI12 | SOBJLAGE | VIMI12 | SOBJLAGE |
TIV45
District Location
|
SOBJLAGE |
| VIMI12 | SVERKEHR | VIMI12 | MANDT |
TIV44
Transport connections
|
MANDT |
| VIMI12 | SVERKEHR | VIMI12 | SVERKEHR |
TIV44
Transport connections
|
SVERKEHR |
| VIMI12 | WAERS | VIMI12 | WAERS |
TCURC
Currency Codes
|
WAERS |
| VIMI12 | WAERS | VIMI12 | MANDT |
TCURC
Currency Codes
|
MANDT |