SAP VIMIMV Lease-Out Table data and field list

VIMIMV is a standard SAP Table which is used to store Lease-Out data in SAP systems, such as SAP R/3, S/4HANA, 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. .

VIMIMV table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VIMIMV table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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

< VIMIMELINE - RE: Data Lines of a MIME object VIMIMVKATE - Text Module in Dependence of Category and Rental Agreement >

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VIMIMV

    VZBAVV1 - Auxiliary table with end of validity
        VIOB01 - Business entities
            VIOB02 - Property master data
                VIGBA1 - Section 1 of land register
                VIGBA2 - Section 2 of land register
                VIGBA3 - Section 3 of land register
                VIGBUCH - Land Register
                    VISPRT1 - Partner data for properties
                    VIEIGE - Owners of real estate objects
                VIWEGR - Relation table between property and assets
                    VIANLGR - BAV Table - Properties from AM
        VWPBUKR - Company code position
            VISANS1 - Address data for objects (SANS1)
    V_VWPANLA - Generated table for viewl V_VWPANLA
        VWPAKTI - Stocks, subscription rights, investment certs.
        VWSPRT1 - Partner data WP (debtor-issuer) (SPRT1/SANS1
        VWPDEP1 - Securities account position (VWPDEPO) +add. fields
            VWZZBEPP - View of collectors VWBEPP, VWBEKI, VWBEPI
            VZZKOKO - Table condition header
                VZZKOPO - Table condition items
        V_VDARL - Generated table for view V_VDARL
            VDSPRT1 - Partner data DA (debtor) SPRT1/SANS1/PARZJ
            VDSDV4 - Loan collateral in acc. with BAV/PRF4
            VIMI01 - Rental unit - real estate
            VDSDV5 - Collateral in securities in acc. with BAV/PRF5
            VDSDV2 - Collateral in accordance with BAV/PRF2
            VDZZBEPP - View of collectors VDBEPP, VDBEKI, VDBEPI
            VDZZKOKO - Condition header for loans
                VDZZKOPO - Condition items for loan
        V_VTBFHA - Generated table for view V_VTBFHA
            VTBFHAPO - Financial transaction flow
            VTBFINKO - Financial transaction condition
    VIMIMV - Lease-Out
        VIZZKOKO - Real Estate condition header for BAV
            VIZZKOPO - Real Estate condition items for BAV
            VIOB03 - Real estate building master
                VIWEGB - Relation table between buildings and assets
                    VIANLGB - BAV table buildings from AM

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
                    VIGBSTD - Real Estate Register of Land Register
                        VIGBFLS - Parcels of Land for Property
                        VIGBZAB - Appreciation/Depreciation in Real Estate Register
                    VIGBA1 - Section 1 of Land Register
                    VIGBA2 - Section 2 of Land Register
                        VIGB2A - Changes in Section 2 of Land Register
                    VIGBA3 - Section 3 of Land Register
                        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
    BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-Dependent Adjustment Data
    BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Settl.: Assign RUs to part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship between Real Estate objs and SAP-PM
        VZSORT - Sort Values for Object

    VIGSMT - Keys for LDB IDF. NOTE DOCUMENTATION FOR LDB
        JEST - Individual Status per Object
        SANO1 - Address-Object Relationship
            SANS1 - Address Table
        VIOB01 - Business Entities
            VIOB24 - Rental Units per Usage Type (Plan)
            VIOB27 - Relationship between Properties and Buildings
            VIOB07 - Business Entity Option Rate
            VIOB02 - Property Master Data
                VIOB40_PY - Property Area
                VIOB06 - Property Option Rate
                VIGBUCH - Land Register
        VZGPO - Partner/Role Object Relationship
                    VIGBSTD - Real Estate Register of Land Register
                        VIGBFLS - Parcels of Land for Property
                        VIGBZAB - Appreciation/Depreciation in Real Estate Register
                    VIGBA1 - Section 1 of Land Register
                    VIGBA2 - Section 2 of Land Register
                        VIGB2A - Changes in Section 2 of Land Register
                    VIGBA3 - Section 3 of Land Register
                        VIGB3A - Changes/Deletions in Section 3 of Land Register
            VIOB03 - Real Estate Building Master
                VIOB40_BD - Areas of Building
    BP000 - Business Partner Master (General Data)
                VIOB04 - Buildings: Fixtures and Fittings Characteristics
                VIOB20 - Fixtures and Fittings Objects for Building
                VIOB05 - Building Option Rate
                VIOB22 - Rooms
                    VIOB11 - Allocation of Rooms to Rental Units
                    VIOB21 - Fixtures and Fittings Objects for Room
                    VIOB23 - Area per Room
            VIMI01 - Rental Unit - Real Estate
                VIMI03 - Occupancy Type History for Rental Unit
                VIMI08 - Apportionment Units per Rental Unit
    BPDADR - BP Structure: Address
                VIOB40 - Rental Unit Area
                RMEDAT - Rental Unit Area Data for Reference Area
                VIOB10 - Number of Rooms per Rental Unit
                VIMI38 - Cost Centers (RU / LO) Real Estate
                VIKOKO - Real Estate Condition Header
                    VZZKOPO - Condition Items Table
                        RBEZFLART - Result Structure Reference Area for Condition Type
                VIMIMV - Lease-Out
                    VIBEPP - Transaction Data - Plan Items for Real Estate Mgmt
                    VIMI54 - Real Estate: Time-dependent Adjustment Data
    BP030 - BP: Business Partner - Address
                    VIMI55 - Index Data for Lease-Out, Time-Dependent
                    VIMI07 - Reported Sales for Sales-Based Lease-Out
                    VIMI23 - Determination of Year and Percent for Sls-Bsd LO
                    VIMI24 - Percentage for Sales for Sales-Based Lease-Out
                    VIMI25 - Sales Reports
                    VIMI28 - Sales Settlement Histories
                    VIMI16 - Rent adjustments buffer
                    VIMI18 - Rent Adjustment History for Lease-Out
                    VIMI56 - LO: Adjustment Block for Condition Types
                    VIMI26 - Notice of rental agreement
        VIEIGE - Owners of Real Estate Objects
        VIAK03 - Settlement Unit Master Record
            VIAK05 - Assign Rental Units to Settlement Unit
                VIAK23_DB - Participant ID, Validity Period Not Adapted for DB
                    VIAK23 - Service Charge Stt.: Participant ID (No. of Part.)
                        VIAK24 - Service Charge Stt. Assign RUs to No. of Part.RUs
                            VIAKME - Rental Units for SU (for Logical Database)
            VIAK04 - Assign Settlement Variant to Settlement Unit
                VIAK21 - Split Heating Costs into Fixed and Variable Parts
            VIAK25 - Cost Collector for SU (per Settlement Period)
        RFVILSP - Parameters Statement in Lists for Documentation
        VIOB38 - Relationship Between Real Estate Objs and SAP-PS
        VIVW01 - Management Contract: General Data
            VIVW02 - Management Contract: Periodic Fee Types
                VIVW03_P - Management Contract: Periodic Fee Calc. Form
            VIVW06 - Management Contract: Event-Driven Fee Types
                VIVW03_E - Management Contract: Event-Driven Fee Calc. Form
            VIVW05 - Management Contract: Managed Objects
                VIVW07 - Management Contract: Real Estate Obj.Assign.Times
            VIVW08 - Management Contract: Related Events
            VIVW09 - Management Contract: Flow Record/Postings
        VIOB39 - Relationship Between Real Estate Objs and SAP-PM
        VZSORT - Sort Values for Object

    RECONTRACT_KEY - Root Node: Key Fields of LDB RECONTRACT
        VICN01 - Real Estate Contract: Contract Data
            VICN03 - Real Estate Contract: Posting Distribution
            VIKOKO - Real Estate Condition Header
                VZZKOPO - Condition Items Table
            VIMIUH - Sales-Based Rental Agreement: Contracted Sales
                VIMIUI - Sales-Based Grading Lease-Out Items
            VIMI54 - Real Estate: Time-dependent Adjustment Data
            VIMI55 - Index Data for Lease-Out (Time-Dependent)
            RFVILSP - Dummy Node: Time Dependence
            VZGPO - Partner/Role Object Relationship
            VIOB01 - Business Entities
                VIOB02 - Property Master Data
                VIOB03 - Real Estate Building Master
                VIMI01 - Rental Unit - Master Data
                    VIMIMV - Lease-Out
            VIOBOV - Assignment Table for RE to Standard Objects