SAP VIMI33 Offers for a rental unit (-> VIMIMV) Table
Overview
VIMI33 is a standard SAP S/4HANA table that stores Offers for a rental unit (-> VIMIMV) data. There are total 65 fields in the VIMI33 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMI33 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 VIMI33 to other SAP tables and standard CDS views available based on VIMI33 table in S/4HANA 2020.
Techincal Settings of VIMI33
Below are technical details of the table VIMI33
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMI33 Fields
The following table gives you an overview of the fields available in VIMI33
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SMVANG | Lease-out - Offer | VVSMVANG | CHAR | 13 | |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 |
| DMIBEG | Rental start date | DMIBE | DATS | 8 | |
| DMIEND | Rental end date | DMIEN | DATS | 8 | |
| DERZAHL | Date of 1st debit position | DERZA | DATS | 8 | |
| SMVART | External Real Estate Contract Type | SMVART | TIV26 | CHAR | 4 |
| SMVANART | Lease-Out Adjustment Type | SMVAR | TIV27 | CHAR | 1 |
| DUNTBIS | Date provisional agreement from | DUNBI | DATS | 8 | |
| BKAUTION | Security deposit amount | BKAUT | CURR | 13 | |
| SKAUTART | Type of Rental Collateral | SKAUA | * | CHAR | 1 |
| STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | |
| JRECHT | Court case indicator | JRECHT | CHAR | 1 | |
| ASCHLU1 | Number of keys 1 | ASCHLU1 | DEC | 3 | |
| JRATEN | Instalment indicator | JRATEN | CHAR | 1 | |
| AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | |
| BUMSPROJ | Planned sales (Amount) | BUMSPROJ | CURR | 13 | |
| BMINUMS | Monetary minimum sales in the settlement period | BUMSATZ1 | CURR | 13 | |
| PPROZ0 | Minimum percentage rate | PPROZ0 | DEC | 5 | |
| STAMV | Status of data record | SSTATI | * | NUMC | 2 |
| STALT | Status of data record | SSTATI | * | NUMC | 2 |
| DSTAEN | Status change date | DSTAEN | DATS | 8 | |
| JVERL | Contract renewal | JVERL | CHAR | 1 | |
| JSKUEND | Special right of notice | JSKUEND | CHAR | 1 | |
| JKAUFOPT | Option to buy | JKAUFOPT | CHAR | 1 | |
| DKAUFOPT | Purchase option date | DKAUFOPT | DATS | 8 | |
| SNKS | Service Charge Collector Number | SNKS | ONR00 | CHAR | 22 |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| DKUEFR | Notice period in months | DKUEFR | NUMC | 2 | |
| ANKUEN | Notification until (for renewal of contract) | ANKUEN | NUMC | 2 | |
| VERLG | Contract renewal by ... months | VERLG | NUMC | 3 | |
| ZSICH | Indicator that other collateral is available | VVZSICH | CHAR | 1 | |
| BANKKS | Bank Keys | BANKK | CHAR | 15 | |
| SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | |
| MVIMKEY | Lease-Out -Real Estate Key | VVMVIMKEY | CHAR | 8 | |
| SPARTNR | Partner number | SPARTNR | SPRT1 | CHAR | 10 |
| GSART | Product Type | VVSART | TZPA | CHAR | 3 |
| BWIMKEY | Application real estate key | VVBWIMKEY | CHAR | 8 | |
| SMIWUNR | Rent request number | SMIWUNR | VIMI12 | NUMC | 3 |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| STMVA | Rental agreement offer status | VVSTMVA | TIV42 | NUMC | 4 |
| DANGST | Offer status valid from date | DANGST | DATS | 8 | |
| DGBI | Valid-to date | DGBI | DATS | 8 | |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| BWINTRENO | Application key | BVVINTRENO | CHAR | 13 | |
| MVINTRENO | Rental agreement key | MVVINTRENO | CHAR | 13 | |
| ARINTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| JMFREI | Condition is not checked | VVJMFREI | CHAR | 1 | |
| KONDPJ | Conditions on lease-out effective per year (display) | VVKONDPJ | CHAR | 1 | |
| SKUEKEY | Notice rule | SKUEKEY | CHAR | 12 | |
| SKUEART | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | |
| BERGRP | Authorization group | VVBERGRP | CHAR | 40 | |
| PARTFROM | Source of Prospect | VVIPARTFROM | TIVP1 | CHAR | 4 |
| PARTWHY | Reason for Acquisition | VVIPARTWHY | TIVP2 | CHAR | 4 |
| PARTWAY | Enquiry method | VVIWAY | TIVP3 | CHAR | 4 |
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 VIMI33
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMI33 | BUKRS | 1: CN | T001 |
| VIMI33 | GSART | 1: CN | TZPA |
| VIMI33 | MANDT | : | T000 |
| VIMI33 | PARTFROM | 1: CN | TIVP1 |
| VIMI33 | PARTWAY | 1: CN | TIVP3 |
| VIMI33 | PARTWHY | 1: CN | TIVP2 |
| VIMI33 | SMENR | 1: CN | VIMI01 |
| VIMI33 | SMIWUNR | C: CN | VIMI12 |
| VIMI33 | SMVANART | 1: CN | TIV27 |
| VIMI33 | SMVART | 1: CN | TIV26 |
| VIMI33 | SNKS | 1: CN | ONR00 |
| VIMI33 | SPARTNR | 1: CN | SPRT1 |
| VIMI33 | STMVA | : | TIV42 |
| VIMI33 | SWENR | 1: CN | VIOB01 |