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 |
Possible values
|
||||||||||||||
| ASCHLU1 | Number of keys 1 | ASCHLU1 | DEC | 3 | 0 | |||||||||||||||
| JRATEN | Instalment indicator | JRATEN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | 0 |
Possible values
|
||||||||||||||
| 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 |
Possible values
|
||||||||||||||
| JSKUEND | Special right of notice | JSKUEND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| JKAUFOPT | Option to buy | JKAUFOPT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| 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 |
Possible values
|
||||||||||||||
| BANKKS | Bank Keys | BANKK | CHAR | 15 | 0 | |||||||||||||||
| SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | 0 |
Possible values
|
||||||||||||||
| 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 |
Possible values
|
||||||||||||||
| KONDPJ | Conditions on lease-out effective per year (display) | VVKONDPJ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| SKUEKEY | Notice rule | SKUEKEY | CHAR | 12 | 0 | |||||||||||||||
| SKUEART | Notice Type of Lease-Out | SMVKUEART | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| 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 |
