SAP VIMI12 Rental requests in an application Table
Overview
VIMI12 is a standard SAP S/4HANA table that stores Rental requests in an application data. There are total 28 fields in the VIMI12 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMI12 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIMI12 to other SAP tables and standard CDS views available based on VIMI12 table in S/4HANA 2020.
Techincal Settings of VIMI12
Below are technical details of the table VIMI12
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMI12 Fields
The following table gives you an overview of the fields available in VIMI12
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SBWNR | Application number | SBWNR | VIMI11 | NUMC | 7 |
| SMIWUNR | Rent request number | SMIWUNR | NUMC | 3 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SNUNR | Rental unit external usage type | SNUNR | TIV01 | NUMC | 4 |
| SVERKEHR | Transport Connections of Business Entity | SVERKEHR | TIV44 | CHAR | 1 |
| SOBJLAGE | Indicator: District Location of Object | RESOBJLAGE | TIV45 | NUMC | 2 |
| RGEBART | Type of building | RGEBART | TIV5A | NUMC | 2 |
| AZIMMV | Number of rooms from | AZIMMV | DEC | 3 | |
| AZIMMB | Number of rooms up to | AZIMMB | DEC | 3 | |
| FGROESA | Total area from | FGROES | DEC | 8 | |
| FGROESB | Total area to | FGROESB | DEC | 8 | |
| SALTNEU | Indicator old-/new building/initial occupancy | SALTNEU | CHAR | 1 | |
| JLIFT | Indicator: Elevator required | JLIFT | CHAR | 1 | |
| DBEZUA | Date for occupation as from | DBEZUA | DATS | 8 | |
| DBEZUB | Move-in by date | DBEZUB | DATS | 8 | |
| ASTELL | Number of parking spaces | ASTELL | DEC | 3 | |
| BGESMIET | Rent total amount | BGESMIET | CURR | 11 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| SGWENR | Requested business entity | SGWENR | VIOB01 | CHAR | 8 |
| SGME | Rental unit requested | SGME | VIMI01 | CHAR | 8 |
| DEING | Date of receipt of rental request | DEING | DATS | 8 | |
| DABSAG | Rejection date | DABSAG | DATS | 8 | |
| AANGEB | Number of first-time offers | AANGEB | DEC | 3 | |
| JMAXG | Indicator: Only top floor requested | JMAXG | CHAR | 1 | |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| FEINS | Area Unit | FEINS | T006 | UNIT | 3 |
| DENDB | Application valid to | VVDENDB | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIMI12
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMI12 | BUKRS | : | T001 |
| VIMI12 | FEINS | 1: CN | T006 |
| VIMI12 | MANDT | 1: CN | T000 |
| VIMI12 | RGEBART | : | TIV5A |
| VIMI12 | SBWNR | 1: CN | VIMI11 |
| VIMI12 | SGME | : | VIMI01 |
| VIMI12 | SGWENR | : | VIOB01 |
| VIMI12 | SNUNR | 1: CN | TIV01 |
| VIMI12 | SOBJLAGE | 1: CN | TIV45 |
| VIMI12 | SVERKEHR | 1: CN | TIV44 |
| VIMI12 | WAERS | C: CN | TCURC |