VIMIMV SAP (Lease-Out) Table details
Dictionary Type: Table
Description: Lease-Out
Description: Lease-Out
Table field list including key, data, relationships and ABAP select examples
VIMIMV is a standard SAP Table which is used to store Lease-Out data and is available within R/3 SAP systems depending on the version and release level.
The VIMIMV table consists of various fields, each holding specific information or linking keys about Lease-Out data available in SAP. These include INTRENO (Internal Real Estate Master Data Code), BUKRS (Company Code), SMIVE (Lease-Out Number), SWENR (Site Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIMIMV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
SMENR | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
VERKT_MV | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
VERKT_WE | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
VERKT_ME | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
DMIBEG | Rental start date | DMIBE | DATS | 8 | DDAT | ||||
DMIEND | Rental end date | DMIEN | DATS | 8 | DDAT | ||||
DERZAHL | Date of 1st debit position | DERZA | DATS | 8 | DDAT | ||||
SMVART | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | SMVART | RECNTYPE | ||
SMVANART | Lease-Out Adjustment Type | SMVAR | CHAR | 1 | TIV27 | SMVAR | |||
DUNTBIS | Date provisional agreement from | DUNBI | DATS | 8 | DDAT | ||||
BKAUTION | Security deposit amount | BKAUT | CURR | 13(2) | WRTV7 | ||||
SKAUTART | Type of Rental Collateral | SKAUA | CHAR | 1 | TIV18 | SKAUA | |||
DEINKUE | Date of receipt of notice | DEKUE | DATS | 8 | DDAT | ||||
DKUEZU | Contract Notice Per | DKUZU | DATS | 8 | DDAT | ||||
JMAHNSP | Dunning block indicator - no longer used! | JMASP | CHAR | 1 | JANE | ||||
STECHEM | Heating expenses settlement company evaluation group | STECHEM | CHAR | 13 | STECHEM | ||||
JMINDER | Rent reduction indicator | JMINDER | CHAR | 1 | JANEI | ||||
AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | INTVJ | ||||
BUMSPROJ | not used (copy of BUMSPROJ) | BUMSPRNUSD | CURR | 13(2) | WRTV7 | ||||
BMINUMS | not used (copy of BUMSATZ1) | BUMS1NUSD | CURR | 13(2) | WRTV7 | ||||
PPROZ0 | Minimum percentage rate | PPROZ0 | DEC | 5(2) | DEC3_2 | ||||
DSTAEN | Status change date | DSTAEN | DATS | 8 | DSTAEN | ||||
DAKTV | Contract activation | DAKTV | DATS | 8 | DATUM | ||||
JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | JLOESCH | ||||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | T001S | BUSAB | |||
JVERL | Contract renewal | JVERL | CHAR | 1 | VVVERL | ||||
JSKUEND | Special right of notice | JSKUEND | CHAR | 1 | JANEI | ||||
JKAUFOPT | Option to buy | JKAUFOPT | CHAR | 1 | JANEI | ||||
DKAUFOPT | Purchase option date | DKAUFOPT | DATS | 8 | DDAT | ||||
SNKS | Service Charge Collector Number | SNKS | CHAR | 22 | ONR00 | J_OBJNR | |||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
DKUEFR | Notice period in months | DKUEFR | NUMC | 2 | NUMC2 | ||||
ANKUEN | Notification until (for renewal of contract) | ANKUEN | NUMC | 2 | NUMC2 | ||||
DABTR | Declaration of assignment | DABTR | DATS | 8 | DATUM | ||||
DFREIS | Exemption (bank) | DFREIS | DATS | 8 | DATUM | ||||
DABLF | Expiration Date | DABLF | DATS | 8 | DATUM | ||||
VERLG | Contract renewal by ... months | VERLG | NUMC | 3 | NUMC3 | ||||
ZSICH | Indicator that other collateral is available | VVZSICH | CHAR | 1 | JANEI | ||||
JBETRST | Security deposit granted | JBETRST | CHAR | 1 | JANEI | ||||
DBKERH | Cash deposit received on | DBKERH | DATS | 8 | DATUM | ||||
ABNNR | Identification of lease-out at settlement company | ABNNR | CHAR | 20 | TEXT20 | ||||
ABNUNR | Customer subnumber | ABNUNR | NUMC | 3 | NUM3 | ||||
BANKKS | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | SKUEFR | ||||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
KUNNR | Customer number main contract partner | VVRDEBIHVP | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
SPARTNR | Alternative payer (partner number) | VVRPARTABW | CHAR | 10 | SPRT1 | SPARTNR | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
JBKRZ | Cash deposit instalment payment | VVJBKRZ | CHAR | 1 | JANEI | ||||
DEINZG | Move-in date | VVDEINZG | DATS | 8 | DATS | ||||
DAUSZG | Move-out date | VVDAUSZG | DATS | 8 | DATS | ||||
JANPIB | Adjustment being processed (indicator) | VVJANPIB | CHAR | 1 | JANE | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
MABER | Dunning: area | VVMABER | CHAR | 2 | T047M | MABER | |||
PROFL | Settlement profile for costs | VVAPROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
ZUSP | Subsidies available, indicator | VVZUSP | CHAR | 1 | JANE | ||||
REFNR | Reference number for collateral securities | VVREFNR | CHAR | 30 | TEXT30 | ||||
SBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | VVSBELEGNG | CHAR | 1 | VVSBELEGNG | ||||
MANSP | Dunning: Blocking reason | VVMANSP | CHAR | 1 | T040S | MANSP | |||
DERSTDR | Date When the Lease-Out was First Printed | VVDERSTDR | DATS | 8 | DATUM | ||||
DAENDDR | Date When the Lease-Out was Changed and Printed Out | VVDAENDDR | DATS | 8 | DATUM | ||||
JMFREI | Condition is not checked | VVJMFREI | CHAR | 1 | JANE | ||||
DVMUN | Contract signed by landlord | VVDVMUN | DATS | 8 | DATUM | ||||
JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | XFELD | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
KBK_PARTNR | Partner number | SPARTNR | CHAR | 10 | SPRT1 | SPARTNR | PNN | ||
GERSTD | Jurisdiction | VVXGERSTD | CHAR | 35 | TEXT35 | ||||
KONDPJ | Conditions on lease-out effective per year (display) | VVKONDPJ | CHAR | 1 | JFLAGG | ||||
JMABGR | Accrual/deferral method | VVJMABGR | CHAR | 1 | JFLAGG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SKUEKEY | Notice rule | SKUEKEY | CHAR | 12 | SKUEKEY | ||||
SKUEART | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | SMVKUEART | ||||
E_SMIVE | Contract No. of Collective Lease-Outs | VVESMIVE | CHAR | 13 | ALPHA | VVSMIVE | MVE | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
FEHLBEL | Reference code false occupancy charges | VVFEHLBEL | CHAR | 20 | VVFEHLBEL | ||||
R1DATUM | 1st date for vacating | VVR1DATUM | DATS | 8 | DATUM | ||||
R2DATUM | 2nd date for vacating | VVR2DATUM | DATS | 8 | DATUM | ||||
KLDATUM | Date of complaint | VVKLDATUM | DATS | 8 | DATUM | ||||
KLAKTZEI | Complaint reference code | VVKLAKTZEI | CHAR | 20 | CHAR20 | ||||
IND_SECTOR | Industry of master tenant | VVMVINDSEC | CHAR | 4 | T016 | BRSCH | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
DFLOWFIX | Flows fixed upto | VVDFLOWFIX | DATS | 8 | DATUM | ||||
KOEIGR | Account determination key for account determination | VVWERTN_AD | CHAR | 10 | TIVC6 | VVWERTN_AD | |||
BERGRP | Authorization group | VVBERGRP | CHAR | 40 | VVBERGRP | ||||
KONTOBV | Bank procedure account number | VVIKONTOBV | CHAR | 10 | VVIKONTOBV | ||||
OSMIVE | Number of old contract | VVOSMIVE | CHAR | 20 | ALPHA | VVOSMIVE | |||
SDUNMOD | Dunning level for dunning of non-approved rent adjustments | VVRAMAHNVERF | CHAR | 4 | TIVM7 | CHAR004 | |||
CORRGROUP | Correspondence group | VVCORRGROUP | CHAR | 20 | TIVCORRGRP | VVCORRGROUP | |||
PARTFROM | Source of Prospect | VVIPARTFROM | CHAR | 4 | TIVP1 | CHAR4 | |||
PARTWHY | Reason for Acquisition | VVIPARTWHY | CHAR | 4 | TIVP2 | CHAR4 | |||
PARTWAY | Enquiry method | VVIWAY | CHAR | 4 | TIVP3 | CHAR4 |
Key field | Non-key field |
How do I retrieve data from SAP table VIMIMV using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIMIMV to SELECT all data from the tableDATA: WA_VIMIMV TYPE VIMIMV.
SELECT SINGLE *
FROM VIMIMV
INTO CORRESPONDING FIELDS OF WA_VIMIMV
WHERE...
How to access SAP table VIMIMV
Within an ECC or HANA version of SAP you can also view further information about VIMIMV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects