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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||
| JLIFT | Indicator: Elevator required | JLIFT | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| 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 | BUKRS | T001 | Company Codes | BUKRS |
| VIMI12 | BUKRS | VIMI12 | MANDT | T001 | Company Codes | MANDT |
| 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 | SGME | VIMI01 | Rental unit - Master data | SMENR |
| VIMI12 | SGME | VIMI12 | MANDT | VIMI01 | Rental unit - Master data | MANDT |
| VIMI12 | SGME | VIMI12 | BUKRS | VIMI01 | Rental unit - Master data | BUKRS |
| VIMI12 | SGME | VIMI12 | SGWENR | VIMI01 | Rental unit - Master data | SWENR |
| VIMI12 | SGWENR | VIMI12 | SGWENR | VIOB01 | Business entities | SWENR |
| VIMI12 | SGWENR | VIMI12 | MANDT | VIOB01 | Business entities | MANDT |
| VIMI12 | SGWENR | VIMI12 | BUKRS | VIOB01 | Business entities | BUKRS |
| 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 | SOBJLAGE | TIV45 | District Location | SOBJLAGE |
| VIMI12 | SOBJLAGE | VIMI12 | MANDT | TIV45 | District Location | MANDT |
| VIMI12 | SVERKEHR | VIMI12 | MANDT | TIV44 | Transport connections | MANDT |
| VIMI12 | SVERKEHR | VIMI12 | SVERKEHR | TIV44 | Transport connections | SVERKEHR |
| VIMI12 | WAERS | VIMI12 | MANDT | TCURC | Currency Codes | MANDT |
| VIMI12 | WAERS | VIMI12 | WAERS | TCURC | Currency Codes | WAERS |
