VIMI11
Applications - Real Estate ManagementExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table VIMI11.
SAP table VIMI11 has 2 primary key fields: MANDT,SBWNR.
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.
VIMI11 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||
| Key SBWNR | Application number | NUMC | 7 | 0 | SBWNR | ||||||
| SBWSTA | Applicant status | CHAR | 1 | 0 | SBWSTA | ||||||
| VADRNR | Business Partner Number | CHAR | 10 | 0 | BP000 | BP_PARTNR | |||||
| SBWTYP | Applicant category | CHAR | 1 | 0 | SBWTYP | ||||||
| |||||||||||
| XANSPRP | Contact person | CHAR | 30 | 0 | XANSPRP | ||||||
| XSTAAT | Nationality | CHAR | 3 | 0 | T005 | XSTAAT | |||||
| XPASSNR | Passport number | CHAR | 18 | 0 | XPASSNR | ||||||
| DPASSV | Date of submission of passport | DATS | 8 | 0 | DPASSV | ||||||
| XARBSTR | Employer street | CHAR | 35 | 0 | XARBSTR | ||||||
| XARBORT | Employer postcode/city | CHAR | 35 | 0 | XARBORT | ||||||
| XAVERM | Current landlord | CHAR | 50 | 0 | XAVERM | ||||||
| XAVSTR | Landlord street | CHAR | 35 | 0 | XAVSTR | ||||||
| XAORT | Postal code/city current landlord | CHAR | 35 | 0 | XAORT | ||||||
| XREFEREN | Applicant reference data | CHAR | 35 | 0 | XREFEREN | ||||||
| SBONI | Credit standing application | NUMC | 2 | 0 | TIV62 | SBONI | |||||
| XWBONI | Reason for credit standing | CHAR | 50 | 0 | XWBONI | ||||||
| XALTSEX | Age/sex of children | CHAR | 35 | 0 | XALTSEX | ||||||
| APERS | Number of persons | DEC | 3 | 0 | APERS | ||||||
| SBUEADR | Guarantor address | CHAR | 10 | 0 | SPRT1 | SBUEADR | |||||
| XTIER1 | Domestic animal description | CHAR | 35 | 0 | XTIERE | ||||||
| XABSAGE | Reason for rejection | CHAR | 60 | 0 | XABSAGE | ||||||
| DABSAGE | Rejection date | DATS | 8 | 0 | DABSAGE | ||||||
| XSITZ | Company head office | CHAR | 35 | 0 | XSITZ | ||||||
| JOPTIO | Opting approved | CHAR | 1 | 0 | JOPTIO | ||||||
| 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 | ||||||
| DEINB | Date application was received | DATS | 8 | 0 | DEINB | ||||||
| JLOESCH | Real Estate Deletion Indicator/Flag | CHAR | 1 | 0 | JLOESCH | ||||||
| IMKEY | Internal Key for Real Estate Object | CHAR | 8 | 0 | IMKEY | ||||||
| INTRENO | Internal Real Estate Master Data Code | CHAR | 13 | 0 | VVINTRENO | ||||||
| RBELBIND1 | Occupancy obligation key | CHAR | 4 | 0 | * | RBELBIND | |||||
| RBELBIND2 | Occupancy obligation key | CHAR | 4 | 0 | * | RBELBIND | |||||
| RBELBIND3 | Occupancy obligation key | CHAR | 4 | 0 | * | RBELBIND | |||||
| RBELBIND4 | Occupancy obligation key | CHAR | 4 | 0 | * | RBELBIND | |||||
| DENDB | Application valid to | DATS | 8 | 0 | VVDENDB | ||||||
| BEARKZ | Processing Indicator for Rental Request | CHAR | 4 | 0 | TIVC1 | VVIBEARKZ | |||||
| VORMKZ | Preselection Indicator for Rental Request | CHAR | 4 | 0 | TIVC2 | VVIVORMKZ | |||||
| BSTAT | Rental Request Processing Status | CHAR | 4 | 0 | TIVC3 | VVIBSTAT | |||||
| 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 | |||||
VIMI11 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| VIMI11 | BEARKZ | TIVC1 | Rental Request: Processing Indicator | BEARKZ |
| VIMI11 | BSTAT | TIVC3 | Rental Request Processing Status | BSTAT |
| VIMI11 | MANDT | T000 | Clients | MANDT |
| VIMI11 | PARTFROM | TIVP1 | Acquisition From Where (Application, Rental Agreement) | PARTFROM |
| VIMI11 | PARTWAY | TIVP3 | Partner Acquisition: Why? | WAY |
| VIMI11 | PARTWHY | TIVP2 | Acquisition Reason (Application, Rental Agreement) | PARTWHY |
| VIMI11 | SBONI | TIV62 | Credit standing for real estate application | MANDT |
| VIMI11 | SBONI | TIV62 | Credit standing for real estate application | SBONI |
| VIMI11 | SBUEADR | SPRT1 | Partner table | MANDT |
| VIMI11 | SBUEADR | SPRT1 | Partner table | PARTNR |
| VIMI11 | VADRNR | BP000 | Business Partner Master (General Data) | PARTNR |
| VIMI11 | VORMKZ | TIVC2 | Rental Request: Preselection Indicator | VORMKZ |
| VIMI11 | XSTAAT | T005 | Countries | MANDT |
| VIMI11 | XSTAAT | T005 | Countries | LAND1 |