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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
ASCHLU1
Number of keys 1
|
ASCHLU1 |
DEC
|
3 | 0 | ||||||||||||||||
|
JRATEN
Instalment indicator
|
JRATEN |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
AMELDIN
Sales reporting interval
|
AMELDIN |
NUMC
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
JSKUEND
Special right of notice
|
JSKUEND |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
JKAUFOPT
Option to buy
|
JKAUFOPT |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
BANKKS
Bank Keys
|
BANKK |
CHAR
|
15 | 0 | ||||||||||||||||
|
SKUEFR
Type of notice period
|
SKUEFR |
NUMC
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KONDPJ
Conditions on lease-out effective per year (display)
|
VVKONDPJ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
SKUEKEY
Notice rule
|
SKUEKEY |
CHAR
|
12 | 0 | ||||||||||||||||
|
SKUEART
Notice Type of Lease-Out
|
SMVKUEART |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | BUKRS |
T001
Company Codes
|
BUKRS |
| VIMI33 | BUKRS | VIMI33 | MANDT |
T001
Company Codes
|
MANDT |
| 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 | MANDT |
TIVP3
Partner Acquisition: Why?
|
MANDT |
| VIMI33 | PARTWAY | VIMI33 | PARTWAY |
TIVP3
Partner Acquisition: Why?
|
WAY |
| VIMI33 | PARTWHY | VIMI33 | PARTWHY |
TIVP2
Acquisition Reason (Application, Rental Agreement)
|
PARTWHY |
| VIMI33 | PARTWHY | VIMI33 | MANDT |
TIVP2
Acquisition Reason (Application, Rental Agreement)
|
MANDT |
| VIMI33 | SMENR | VIMI33 | BUKRS |
VIMI01
Rental unit - Master data
|
BUKRS |
| 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 | SMIWUNR | VIMI33 | SMIWUNR |
VIMI12
Rental requests in an application
|
SMIWUNR |
| VIMI33 | SMIWUNR | VIMI33 | MANDT |
VIMI12
Rental requests in an application
|
MANDT |
| VIMI33 | SMIWUNR | VIMI11 | SBWNR |
VIMI12
Rental requests in an application
|
SBWNR |
| 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 | MANDT |
TIV42
Rental agreement offer status
|
MANDT |
| VIMI33 | STMVA | VIMI33 | STMVA |
TIV42
Rental agreement offer status
|
STMVA |
| VIMI33 | SWENR | VIMI33 | MANDT |
VIOB01
Business entities
|
MANDT |
| VIMI33 | SWENR | VIMI33 | BUKRS |
VIOB01
Business entities
|
BUKRS |
| VIMI33 | SWENR | VIMI33 | SWENR |
VIOB01
Business entities
|
SWENR |