VIMI33
Offers for a rental unit (-> VIMIMV)Explore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table VIMI33.
SAP table VIMI33 has 5 primary key fields: MANDT,BUKRS,SMVANG,SWENR,SMENR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
VIMI33 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||
| Key BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||
| Key SMVANG | Lease-out - Offer | CHAR | 13 | 0 | VVSMVANG | ||||||||||||
| Key SWENR | Business Entity Number | CHAR | 8 | 0 | VIOB01 | SWENR | |||||||||||
| Key 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 | ||||||||||||
| |||||||||||||||||
| 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 | ||||||||||||
| |||||||||||||||||
| 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 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| VIMI33 | BUKRS | T001 | Company Codes | BUKRS |
| VIMI33 | GSART | TZPA | Financial Assets Management Product Types | MANDT |
| VIMI33 | GSART | TZPA | Financial Assets Management Product Types | GSART |
| VIMI33 | MANDT | T000 | Clients | MANDT |
| VIMI33 | PARTFROM | TIVP1 | Acquisition From Where (Application, Rental Agreement) | PARTFROM |
| VIMI33 | PARTWAY | TIVP3 | Partner Acquisition: Why? | WAY |
| VIMI33 | PARTWHY | TIVP2 | Acquisition Reason (Application, Rental Agreement) | PARTWHY |
| VIMI33 | SMENR | VIMI01 | Rental unit - Master data | MANDT |
| VIMI33 | SMENR | VIMI01 | Rental unit - Master data | BUKRS |
| VIMI33 | SMENR | VIMI01 | Rental unit - Master data | SMENR |
| VIMI33 | SMIWUNR | VIMI12 | Rental requests in an application | MANDT |
| VIMI33 | SMIWUNR | VIMI12 | Rental requests in an application | SBWNR |
| VIMI33 | SMVART | TIV26 | Real Estate Contract Type (Entities) | MANDT |
| VIMI33 | SMVART | TIV26 | Real Estate Contract Type (Entities) | SMVART |
| VIMI33 | SNKS | ONR00 | General Object Number | MANDT |
| VIMI33 | SPARTNR | SPRT1 | Partner table | MANDT |
| VIMI33 | SPARTNR | SPRT1 | Partner table | PARTNR |
| VIMI33 | STMVA | TIV42 | Rental agreement offer status | MANDT |
| VIMI33 | STMVA | TIV42 | Rental agreement offer status | STMVA |
| VIMI33 | SWENR | VIOB01 | Business entities | MANDT |
| VIMI33 | SWENR | VIOB01 | Business entities | BUKRS |