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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
SBWNR
Application number
|
SBWNR |
NUMC
|
7 | 0 | ||||||||||||
|
SBWSTA
Applicant status
|
SBWSTA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VADRNR
Business Partner Number
|
BP_PARTNR | BP000 |
CHAR
|
10 | 0 | |||||||||||
|
SBWTYP
Applicant category
|
SBWTYP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | MANDT |
TIVC1
Rental Request: Processing Indicator
|
MANDT |
| VIMI11 | BEARKZ | VIMI11 | BEARKZ |
TIVC1
Rental Request: Processing Indicator
|
BEARKZ |
| 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 | PARTFROM |
TIVP1
Acquisition From Where (Application, Rental Agreement)
|
PARTFROM |
| VIMI11 | PARTFROM | VIMI11 | MANDT |
TIVP1
Acquisition From Where (Application, Rental Agreement)
|
MANDT |
| VIMI11 | PARTWAY | VIMI11 | MANDT |
TIVP3
Partner Acquisition: Why?
|
MANDT |
| VIMI11 | PARTWAY | VIMI11 | PARTWAY |
TIVP3
Partner Acquisition: Why?
|
WAY |
| 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 | XSTAAT |
T005
Countries
|
LAND1 |
| VIMI11 | XSTAAT | VIMI11 | MANDT |
T005
Countries
|
MANDT |