VIMI11 SAP (Applications - Real Estate Management) Table details

Dictionary Type: Table
Description: Applications - Real Estate Management




ABAP Code to SELECT data from VIMI11
Related tables to VIMI11
Access table VIMI11




Table field list including key, data, relationships and ABAP select examples

VIMI11 is a standard SAP Table which is used to store Applications - Real Estate Management data and is available within R/3 SAP systems depending on the version and release level.

The VIMI11 table consists of various fields, each holding specific information or linking keys about Applications - Real Estate Management data available in SAP. These include SBWNR (Application number), SBWSTA (Applicant status), VADRNR (Business Partner Number), SBWTYP (Applicant category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIMI11 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SBWNRApplication number SBWNRNUMC7SBWNROWK
SBWSTAApplicant status SBWSTACHAR1SBWSTAT
VADRNRBusiness Partner Number BP_PARTNRCHAR10BP000ALPHABP_PARTNRBPN
SBWTYPApplicant category SBWTYPCHAR1SBWTYPOWT
XANSPRPContact person XANSPRPCHAR30XMBEZ
XSTAATNationality XSTAATCHAR3T005LAND1
XPASSNRPassport number XPASSNRCHAR18CHAR18
DPASSVDate of submission of passport DPASSVDATS8DDAT
XARBSTREmployer street XARBSTRCHAR35XCHA35
XARBORTEmployer postcode/city XARBORTCHAR35XCHA35
XAVERMCurrent landlord XAVERMCHAR50XCH50
XAVSTRLandlord street XAVSTRCHAR35XCHA35
XAORTPostal code/city current landlord XAORTCHAR35XCHA35
XREFERENApplicant reference data XREFERENCHAR35XCHA35
SBONICredit standing application SBONINUMC2TIV62SBONI
XWBONIReason for credit standing XWBONICHAR50XTEXT50
XALTSEXAge/sex of children XALTSEXCHAR35XCHA35
APERSNumber of persons APERSDEC3DEC3
SBUEADRGuarantor address SBUEADRCHAR10SPRT1SPARTNR
XTIER1Domestic animal description XTIERECHAR35XCHA35
XABSAGEReason for rejection XABSAGECHAR60XLBEZ
DABSAGERejection date DABSAGEDATS8DDAT
XSITZCompany head office XSITZCHAR35XCHA35
JOPTIOOpting approved JOPTIOCHAR1JANEI
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
DEINBDate application was received DEINBDATS8DDAT
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
RBELBIND1Occupancy obligation key RBELBINDCHAR4Assigned to domainRBELBIND
RBELBIND2Occupancy obligation key RBELBINDCHAR4Assigned to domainRBELBIND
RBELBIND3Occupancy obligation key RBELBINDCHAR4Assigned to domainRBELBIND
RBELBIND4Occupancy obligation key RBELBINDCHAR4Assigned to domainRBELBIND
DENDBApplication valid to VVDENDBDATS8DDAT
BEARKZProcessing Indicator for Rental Request VVIBEARKZCHAR4TIVC1CHAR4
VORMKZPreselection Indicator for Rental Request VVIVORMKZCHAR4TIVC2CHAR4
BSTATRental Request Processing Status VVIBSTATCHAR4TIVC3CHAR4
BERGRPAuthorization group VVBERGRPCHAR40VVBERGRP
PARTFROMSource of Prospect VVIPARTFROMCHAR4TIVP1CHAR4
PARTWHYReason for Acquisition VVIPARTWHYCHAR4TIVP2CHAR4
PARTWAYEnquiry method VVIWAYCHAR4TIVP3CHAR4

Key field Non-key field



How do I retrieve data from SAP table VIMI11 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIMI11 to SELECT all data from the table
DATA: WA_VIMI11 TYPE VIMI11.

SELECT SINGLE *
FROM VIMI11
INTO CORRESPONDING FIELDS OF WA_VIMI11
WHERE...

How to access SAP table VIMI11

Within an ECC or HANA version of SAP you can also view further information about VIMI11 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!