SAP VIMI11 Applications - Real Estate Management Table

Overview

VIMI11 is a standard SAP S/4HANA table that stores Applications - Real Estate Management data. There are total 49 fields in the VIMI11 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIMI11 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).

In addition, following links provide an overview of foreign key relationships, if any, that link VIMI11 to other SAP tables and standard CDS views available based on VIMI11 table in S/4HANA 2020.

Techincal Settings of VIMI11

Below are technical details of the table VIMI11

Buffering not allowed
No buffering
Storage type is Column Store

List of VIMI11 Fields

The following table gives you an overview of the fields available in VIMI11

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	CLNT	3
SBWNR	Application number	SBWNR		NUMC	7
SBWSTA	Applicant status	SBWSTA		CHAR	1
VADRNR	Business Partner Number	BP_PARTNR	BP000	CHAR	10
SBWTYP	Applicant category	SBWTYP		CHAR	1
XANSPRP	Contact person	XANSPRP		CHAR	30
XSTAAT	Nationality	XSTAAT	T005	CHAR	3
XPASSNR	Passport number	XPASSNR		CHAR	18
DPASSV	Date of submission of passport	DPASSV		DATS	8
XARBSTR	Employer street	XARBSTR		CHAR	35
XARBORT	Employer postcode/city	XARBORT		CHAR	35
XAVERM	Current landlord	XAVERM		CHAR	50
XAVSTR	Landlord street	XAVSTR		CHAR	35
XAORT	Postal code/city current landlord	XAORT		CHAR	35
XREFEREN	Applicant reference data	XREFEREN		CHAR	35
SBONI	Credit standing application	SBONI	TIV62	NUMC	2
XWBONI	Reason for credit standing	XWBONI		CHAR	50
XALTSEX	Age/sex of children	XALTSEX		CHAR	35
APERS	Number of persons	APERS		DEC	3
SBUEADR	Guarantor address	SBUEADR	SPRT1	CHAR	10
XTIER1	Domestic animal description	XTIERE		CHAR	35
XABSAGE	Reason for rejection	XABSAGE		CHAR	60
DABSAGE	Rejection date	DABSAGE		DATS	8
XSITZ	Company head office	XSITZ		CHAR	35
JOPTIO	Opting approved	JOPTIO		CHAR	1
RERF	Entered By	RERF		CHAR	12
DERF	First Entered On	DERF		DATS	8
TERF	Time of Creation	TERF		TIMS	6
REHER	Source of Initial Entry	REHER		CHAR	10
RBEAR	Employee ID	RBEAR		CHAR	12
DBEAR	Last Edited On	DBEAR		DATS	8
TBEAR	Last Edited At	TBEAR		TIMS	6
RBHER	Editing Source	RBHER		CHAR	10
DEINB	Date application was received	DEINB		DATS	8
JLOESCH	Real Estate Deletion Indicator/Flag	JLOESCH		CHAR	1
IMKEY	Internal Key for Real Estate Object	IMKEY		CHAR	8
INTRENO	Internal Real Estate Master Data Code	VVINTRENO		CHAR	13
RBELBIND1	Occupancy obligation key	RBELBIND	*	CHAR	4
RBELBIND2	Occupancy obligation key	RBELBIND	*	CHAR	4
RBELBIND3	Occupancy obligation key	RBELBIND	*	CHAR	4
RBELBIND4	Occupancy obligation key	RBELBIND	*	CHAR	4
DENDB	Application valid to	VVDENDB		DATS	8
BEARKZ	Processing Indicator for Rental Request	VVIBEARKZ	TIVC1	CHAR	4
VORMKZ	Preselection Indicator for Rental Request	VVIVORMKZ	TIVC2	CHAR	4
BSTAT	Rental Request Processing Status	VVIBSTAT	TIVC3	CHAR	4
BERGRP	Authorization group	VVBERGRP		CHAR	40
PARTFROM	Source of Prospect	VVIPARTFROM	TIVP1	CHAR	4
PARTWHY	Reason for Acquisition	VVIPARTWHY	TIVP2	CHAR	4
PARTWAY	Enquiry method	VVIWAY	TIVP3	CHAR	4

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIMI11

Table Name	Field	Cardinality	Check Table
VIMI11	BEARKZ	1: CN	TIVC1
VIMI11	BSTAT	1: CN	TIVC3
VIMI11	MANDT	1: CN	T000
VIMI11	PARTFROM	1: CN	TIVP1
VIMI11	PARTWAY	1: CN	TIVP3
VIMI11	PARTWHY	1: CN	TIVP2
VIMI11	SBONI	:	TIV62
VIMI11	SBUEADR	:	SPRT1
VIMI11	VADRNR	1: CN	BP000
VIMI11	VORMKZ	1: CN	TIVC2
VIMI11	XSTAAT	C: CN	T005

SAP VIMI11 Applications - Real Estate Management Table

Overview

Techincal Settings of VIMI11

List of VIMI11 Fields

Foreign Key Relationships

Other References