1. Home
  2. Resources
  3. SAP Tables
  4. VIMI33 - Offers for a rental unit (-> VIMIMV)

SAP Table VIMI33

Offers for a rental unit (-> VIMIMV)

VIMI33 (Offers for a rental unit (-> VIMIMV)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VIMI33 to other SAP tables.

VIMI33 table fields

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

VIMI33 foreign key relationships

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