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