SAP Tabel VIMI11 (Applications - Real Estate Management)

SAP table VIMI11 has 2 primary key fields being MANDT,SBWNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
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
0 Commercial
1 Non-commercial
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 foreign key relationships

Table Field Check Table Check Field
0 VIMI11 BEARKZ TIVC1 Rental Request: Processing Indicator BEARKZ
1 VIMI11 BSTAT TIVC3 Rental Request Processing Status BSTAT
0 VIMI11 MANDT T000 Clients MANDT
1 VIMI11 PARTFROM TIVP1 Acquisition From Where (Application, Rental Agreement) PARTFROM
0 VIMI11 PARTWAY TIVP3 Partner Acquisition: Why? WAY
1 VIMI11 PARTWHY TIVP2 Acquisition Reason (Application, Rental Agreement) PARTWHY
0 VIMI11 SBONI TIV62 Credit standing for real estate application MANDT
0 VIMI11 SBONI TIV62 Credit standing for real estate application SBONI
1 VIMI11 SBUEADR SPRT1 Partner table MANDT
1 VIMI11 SBUEADR SPRT1 Partner table PARTNR
0 VIMI11 VADRNR BP000 Business Partner Master (General Data) PARTNR
1 VIMI11 VORMKZ TIVC2 Rental Request: Preselection Indicator VORMKZ
0 VIMI11 XSTAAT T005 Countries MANDT
0 VIMI11 XSTAAT T005 Countries LAND1