SAP table VIMI33 (Offers for a rental unit (-> VIMIMV))

SAP table VIMI33 has 5 primary key fields being MANDT,BUKRS,SMVANG,SWENR,SMENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
SMVANG Lease-out - Offer CHAR 13 0 VVSMVANG
SWENR Business Entity Number CHAR 8 0 VIOB01 SWENR
SMENR Number of Rental Unit CHAR 8 0 VIMI01 SMENR
DMIBEG Rental start date DATS 8 0 DMIBE
DMIEND Rental end date DATS 8 0 DMIEN
DERZAHL Date of 1st debit position DATS 8 0 DERZA
SMVART External Real Estate Contract Type CHAR 4 0 TIV26 SMVART
SMVANART Lease-Out Adjustment Type CHAR 1 0 TIV27 SMVAR
DUNTBIS Date provisional agreement from DATS 8 0 DUNBI
BKAUTION Security deposit amount CURR 13 2 BKAUT
SKAUTART Type of Rental Collateral CHAR 1 0 * SKAUA
STECHEM Heating expenses settlement company evaluation group CHAR 13 0 STECHEM
JRECHT Court case indicator CHAR 1 0 JRECHT
ASCHLU1 Number of keys 1 DEC 3 0 ASCHLU1
JRATEN Instalment indicator CHAR 1 0 JRATEN
AMELDIN Sales reporting interval NUMC 2 0 AMELDIN
BUMSPROJ Planned sales (Amount) CURR 13 2 BUMSPROJ
BMINUMS Monetary minimum sales in the settlement period CURR 13 2 BUMSATZ1
PPROZ0 Minimum percentage rate DEC 5 2 PPROZ0
STAMV Status of data record NUMC 2 0 * SSTATI
STALT Status of data record NUMC 2 0 * SSTATI
DSTAEN Status change date DATS 8 0 DSTAEN
JVERL Contract renewal CHAR 1 0 JVERL
JSKUEND Special right of notice CHAR 1 0 JSKUEND
JKAUFOPT Option to buy CHAR 1 0 JKAUFOPT
DKAUFOPT Purchase option date DATS 8 0 DKAUFOPT
SNKS Service Charge Collector Number CHAR 22 0 ONR00 SNKS
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
DKUEFR Notice period in months NUMC 2 0 DKUEFR
ANKUEN Notification until (for renewal of contract) NUMC 2 0 ANKUEN
VERLG Contract renewal by ... months NUMC 3 0 VERLG
ZSICH Indicator that other collateral is available CHAR 1 0 VVZSICH
BANKKS Bank Keys CHAR 15 0 BANKK
SKUEFR Type of notice period NUMC 1 0 SKUEFR
0 No period of notice
1 Legal period of notice
2 Extraordinary period of notice
3 Different period of notice
MVIMKEY Lease-Out -Real Estate Key CHAR 8 0 VVMVIMKEY
SPARTNR Partner number CHAR 10 0 SPRT1 SPARTNR
GSART Product Type CHAR 3 0 TZPA VVSART
BWIMKEY Application real estate key CHAR 8 0 VVBWIMKEY
SMIWUNR Rent request number NUMC 3 0 VIMI12 SMIWUNR
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
JLOESCH Real Estate Deletion Indicator/Flag CHAR 1 0 JLOESCH
STMVA Rental agreement offer status NUMC 4 0 TIV42 VVSTMVA
DANGST Offer status valid from date DATS 8 0 DANGST
DGBI Valid-to date DATS 8 0 DGBI
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
BWINTRENO Application key CHAR 13 0 BVVINTRENO
MVINTRENO Rental agreement key CHAR 13 0 MVVINTRENO
ARINTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
JMFREI Condition is not checked CHAR 1 0 VVJMFREI
KONDPJ Conditions on lease-out effective per year (display) CHAR 1 0 VVKONDPJ
SKUEKEY Notice rule CHAR 12 0 SKUEKEY
SKUEART Notice Type of Lease-Out CHAR 1 0 SMVKUEART
No period of notice
1 Period reg.
2 Deadline reg.
3 free period reg.
4 free deadline reg.
BERGRP Authorization group CHAR 40 0 VVBERGRP
PARTFROM Source of Prospect CHAR 4 0 TIVP1 VVIPARTFROM
PARTWHY Reason for Acquisition CHAR 4 0 TIVP2 VVIPARTWHY
PARTWAY Enquiry method CHAR 4 0 TIVP3 VVIWAY

VIMI33 foreign key relationships

Table Field Check Table Check Field
0 VIMI33 BUKRS T001 Company Codes BUKRS
1 VIMI33 GSART TZPA Financial Assets Management Product Types MANDT
1 VIMI33 GSART TZPA Financial Assets Management Product Types GSART
0 VIMI33 MANDT T000 Clients MANDT
1 VIMI33 PARTFROM TIVP1 Acquisition From Where (Application, Rental Agreement) PARTFROM
0 VIMI33 PARTWAY TIVP3 Partner Acquisition: Why? WAY
1 VIMI33 PARTWHY TIVP2 Acquisition Reason (Application, Rental Agreement) PARTWHY
0 VIMI33 SMENR VIMI01 Rental unit - Master data MANDT
0 VIMI33 SMENR VIMI01 Rental unit - Master data BUKRS
0 VIMI33 SMENR VIMI01 Rental unit - Master data SMENR
1 VIMI33 SMIWUNR VIMI12 Rental requests in an application MANDT
1 VIMI33 SMIWUNR VIMI12 Rental requests in an application SBWNR
0 VIMI33 SMVART TIV26 Real Estate Contract Type (Entities) MANDT
0 VIMI33 SMVART TIV26 Real Estate Contract Type (Entities) SMVART
1 VIMI33 SNKS ONR00 General Object Number MANDT
0 VIMI33 SPARTNR SPRT1 Partner table MANDT
0 VIMI33 SPARTNR SPRT1 Partner table PARTNR
1 VIMI33 STMVA TIV42 Rental agreement offer status MANDT
1 VIMI33 STMVA TIV42 Rental agreement offer status STMVA
0 VIMI33 SWENR VIOB01 Business entities MANDT
0 VIMI33 SWENR VIOB01 Business entities BUKRS