SAP VIMIMV Lease-Out Table
Overview
VIMIMV is a standard SAP S/4HANA table that stores Lease-Out data. There are total 106 fields in the VIMIMV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMIMV 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 VIMIMV to other SAP tables and standard CDS views available based on VIMIMV table in S/4HANA 2020.
Techincal Settings of VIMIMV
Below are technical details of the table VIMIMV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMIMV Fields
The following table gives you an overview of the fields available in VIMIMV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | VIMI01 | CHAR | 8 |
| VERKT_MV | Lease-Out Number | SMIVE | CHAR | 13 | |
| VERKT_WE | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| VERKT_ME | 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 | TIV18 | CHAR | 1 |
| DEINKUE | Date of receipt of notice | DEKUE | DATS | 8 | |
| DKUEZU | Contract Notice Per | DKUZU | DATS | 8 | |
| JMAHNSP | Dunning block indicator - no longer used! | JMASP | CHAR | 1 | |
| STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | |
| JMINDER | Rent reduction indicator | JMINDER | CHAR | 1 | |
| AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | |
| BUMSPROJ | not used (copy of BUMSPROJ) | BUMSPRNUSD | CURR | 13 | |
| BMINUMS | not used (copy of BUMSATZ1) | BUMS1NUSD | CURR | 13 | |
| PPROZ0 | Minimum percentage rate | PPROZ0 | DEC | 5 | |
| DSTAEN | Status change date | DSTAEN | DATS | 8 | |
| DAKTV | Contract activation | DAKTV | DATS | 8 | |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| BUSAB | Accounting Clerk Abbreviation | BUSAB | T001S | CHAR | 2 |
| 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 | |
| DABTR | Declaration of assignment | DABTR | DATS | 8 | |
| DFREIS | Exemption (bank) | DFREIS | DATS | 8 | |
| DABLF | Expiration Date | DABLF | DATS | 8 | |
| VERLG | Contract renewal by ... months | VERLG | NUMC | 3 | |
| ZSICH | Indicator that other collateral is available | VVZSICH | CHAR | 1 | |
| JBETRST | Security deposit granted | JBETRST | CHAR | 1 | |
| DBKERH | Cash deposit received on | DBKERH | DATS | 8 | |
| ABNNR | Identification of lease-out at settlement company | ABNNR | CHAR | 20 | |
| ABNUNR | Customer subnumber | ABNUNR | NUMC | 3 | |
| BANKKS | Bank Keys | BANKK | CHAR | 15 | |
| SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| KUNNR | Customer number main contract partner | VVRDEBIHVP | KNA1 | CHAR | 10 |
| SPARTNR | Alternative payer (partner number) | VVRPARTABW | CHAR | 10 | |
| GSART | Product Type | VVSART | TZPA | CHAR | 3 |
| MADAT | Date of Last Dunning Notice | MADAT | DATS | 8 | |
| MANST | Dunning Level | MAHNS_D | NUMC | 1 | |
| JBKRZ | Cash deposit instalment payment | VVJBKRZ | CHAR | 1 | |
| DEINZG | Move-In Date | VVDEINZG | DATS | 8 | |
| DAUSZG | Move-out date | VVDAUSZG | DATS | 8 | |
| JANPIB | Adjustment being processed (indicator) | VVJANPIB | CHAR | 1 | |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| MABER | Dunning: area | VVMABER | T047M | CHAR | 2 |
| PROFL | Settlement profile for costs | VVAPROF | TKB1A | CHAR | 6 |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| ZUSP | Subsidies available indicator | VVZUSP | CHAR | 1 | |
| REFNR | Reference number for collateral securities | VVREFNR | CHAR | 30 | |
| SBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | VVSBELEGNG | CHAR | 1 | |
| MANSP | Dunning: Blocking reason | VVMANSP | T040S | CHAR | 1 |
| DERSTDR | Date When the Lease-Out was First Printed | VVDERSTDR | DATS | 8 | |
| DAENDDR | Date When the Lease-Out was Changed and Printed Out | VVDAENDDR | DATS | 8 | |
| JMFREI | Condition is not checked | VVJMFREI | CHAR | 1 | |
| DVMUN | Contract signed by landlord | VVDVMUN | DATS | 8 | |
| JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | |
| TDNAME | Name | TDOBNAME | CHAR | 70 | |
| KBK_PARTNR | Partner number | SPARTNR | CHAR | 10 | |
| GERSTD | Jurisdiction | VVXGERSTD | CHAR | 35 | |
| KONDPJ | Conditions on lease-out effective per year (display) | VVKONDPJ | CHAR | 1 | |
| JMABGR | Accrual/deferral method | VVJMABGR | CHAR | 1 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| SKUEKEY | Notice rule | SKUEKEY | CHAR | 12 | |
| SKUEART | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | |
| E_SMIVE | Contract No. of Collective Lease-Outs | VVESMIVE | CHAR | 13 | |
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 |
| FEHLBEL | Reference code false occupancy charges | VVFEHLBEL | CHAR | 20 | |
| R1DATUM | 1st date for vacating | VVR1DATUM | DATS | 8 | |
| R2DATUM | 2nd date for vacating | VVR2DATUM | DATS | 8 | |
| KLDATUM | Date of complaint | VVKLDATUM | DATS | 8 | |
| KLAKTZEI | Complaint reference code | VVKLAKTZEI | CHAR | 20 | |
| IND_SECTOR | Industry of master tenant | VVMVINDSEC | T016 | CHAR | 4 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | |
| KOEIGR | Account determination key for account determination | VVWERTN_AD | TIVC6 | CHAR | 10 |
| BERGRP | Authorization group | VVBERGRP | CHAR | 40 | |
| KONTOBV | Bank procedure account number | VVIKONTOBV | CHAR | 10 | |
| OSMIVE | Number of old contract | VVOSMIVE | CHAR | 20 | |
| SDUNMOD | Dunning level for dunning of non-approved rent adjustments | VVRAMAHNVERF | TIVM7 | CHAR | 4 |
| CORRGROUP | Correspondence group | VVCORRGROUP | TIVCORRGRP | CHAR | 20 |
| 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 VIMIMV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMIMV | BUKRS | 1: CN | T001 |
| VIMIMV | BUSAB | 1: CN | T001S |
| VIMIMV | CORRGROUP | 1: CN | TIVCORRGRP |
| VIMIMV | GSART | 1: CN | TZPA |
| VIMIMV | GSBER | 1: CN | TGSB |
| VIMIMV | HBKID | : | T012 |
| VIMIMV | IND_SECTOR | : | T016 |
| VIMIMV | KOEIGR | 1: CN | TIVC6 |
| VIMIMV | KOKRS | C: CN | TKA01 |
| VIMIMV | KUNNR | 1: CN | KNA1 |
| VIMIMV | MABER | 1: CN | T047M |
| VIMIMV | MANSP | 1: CN | T040S |
| VIMIMV | PARTFROM | 1: CN | TIVP1 |
| VIMIMV | PARTWAY | 1: CN | TIVP3 |
| VIMIMV | PARTWHY | 1: CN | TIVP2 |
| VIMIMV | PRCTR | 1: CN | CEPC |
| VIMIMV | PROFL | C: CN | TKB1A |
| VIMIMV | SDUNMOD | 1: CN | TIVM7 |
| VIMIMV | SKAUTART | 1: CN | TIV18 |
| VIMIMV | SMENR | 1: CN | VIMI01 |
| VIMIMV | SMVANART | 1: CN | TIV27 |
| VIMIMV | SMVART | 1: CN | TIV26 |
| VIMIMV | SNKS | 1: CN | ONR00 |
| VIMIMV | SWENR | 1: CN | VIOB01 |
| VIMIMV | VERKT_ME | 1: CN | VIMI01 |
| VIMIMV | VERKT_WE | 1: CN | VIOB01 |