VIGW_R_VIMVF03 SAP () Structure details

Dictionary Type: Structure
Description:




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




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

VIGW_R_VIMVF03 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VIGW_R_VIMVF03 TYPE VIGW_R_VIMVF03.

The VIGW_R_VIMVF03 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include MANDT (Client), BUKRS (Company Code), SWENR (Site Number), SMENR (Number of Rental Unit).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIGW_R_VIMVF03 structure 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 MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SWENRSite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
SMENRNumber of Rental Unit SMENRCHAR8Assigned to domainSMENRSMENRMEHMCME
SGRNRProperty Number for BE SGRNRCHAR8Assigned to domainSGRNRSGRNRGRSMCGR
SGENRBuilding Number SGENRCHAR8Assigned to domainSGENRSGENRGEBMCGE
SGEBSWENRBE no.of rental unit to which the RU is linked SGEBSWENRCHAR8Assigned to domainSWENRSWENR
SGEBSMENRRU no. of rental unit to which the RU is linked SGEBSMENRCHAR8Assigned to domainSMENRSMENR
SHEIZNRReal Estate heating system number SHEIZNRNUMC4SHEIZNR
SNUNRRental unit external usage type SNUNRNUMC4TIV01SNUNR
DBEZUDate of initial usage DBEZUDATS8DDAT
DWTVERMDate: Subsequent rental DWTVERMDATS8DATUM
UMBRAUMCubic Volume BUBRADEC11(3) DEC8_3
AZIMMNumber of rooms AZIMMDEC3DEC3
AHALBZINumber of half rooms AHALBZIDEC2DEC2
STOCKDummy (previously storey, replaced by VVSSTOCKW) RGESCHCHAR2CHAR2
SBELARTOccupancy type indicator SBELANUMC1SBELA
SHEIZARTHeating type SHEIZCHAR1SHEIZ
DRESABDate: Reserved from DRESADATS8DDAT
DRESBISDate: Reserved upto DRESBDATS8DDAT
SGEBTPart of Building SGEBTCHAR2TIV12SGEBT
SBWNRApplication number SBWNRNUMC7VIMI11SBWNROWK
XAUSTKLFixtures and fittings category SAUSKLNUMC2Assigned to domainSAUSKL
XLAGELocation class SLAGKNUMC2Assigned to domainSLAGK
SMOEBLFurniture indicator SMOEBCHAR1SMOEB
SALTNRNumber of rental unit in existing real estate system SALTNRCHAR20SALTNR
DBEGEHDate of last RU inspection DBEGEHDATS8DDAT
XBEGEHInspected by XBEGEHCHAR15XKBEZ
PZUABSPSurcharge or reduction for representative list of rents PZUABSPDEC4(2) PZUABSP
PERHOEPercentage rate increase PERHOEDEC5(2) DEC3_2
RPROZGRDReason for variance in rate of percentage increase RPROZGRDCHAR2TIV43RPROZGRD
DBINDBISObligation period until DBINDBISDATS8DATUM
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
RBELBINDOccupancy obligation key RBELBINDCHAR4TIV31RBELBIND
RLIFTType of elevator installation RLIFTNUMC2TIV32RLIFT
RMEDIENMedia reception RMEDIENNUMC3TIV33RMEDIEN
RWASSERType of water mains connection RWASSERNUMC2TIV34RWASSER
RLGESCHLocation on Floor RLGESCHCHAR2TIV38ALPHARLGESCH
JVORSTEIGInput tax deduction for vacancy JVORSTEIGCHAR1OPTIERT
SADRMEObject number of rental unit for address purposes SADRMENUMC10Assigned to domainSOBJNR
XSTANDNRNumber of garage / parking space VVXSTANDNRCHAR5ALPHAVVXSTANDNR
JEIGWOHNRental Unit in Separate Ownership (COA) VVJEIGWOHNCHAR1JANE
RFAKTConversion factor for fractional share of property VVRFAKTNUMC6VVRFAKT
SSTOCKWFloor VVSSTOCKWNUMC3TIV37VVSSTOCKW
JKONDMVTransfer conditions to RU when lease-out expires? VVJKONDMVCHAR1XFELD
PKONDMVPercentage rate for transfer of terms from LO to RU VVPKONDMVDEC5(2) PRZ32
DFSTRBISDate up to when the rental unit cash flow is created VVDFSTRBISDATS8DATUM
SSTCKBISFor RUs with Multiple Floors: Top Floor of RU VVSSTCKBISNUMC3TIV37VVSSTOCKW
DHPZSAKTCH rent adj.:Date of mort.loan rate status for current rent VVDHPZSAKTDATS8DATUM
DUTBKAKTCH rnt adj.:Dte maint./oper.costs index status for new rent VVDUTBKAKTDATS8DATUM
DTEURAKTCH rnt adj.:Dte of living stndrd index status for curr.rent VVDTEURAKTDATS8DATUM
BRDBRTZZCH rent adj: Actual gross yield earned VVBRDBRTZZDEC10(7) DECV3_7
BRDBRTKDMarginal Gross Yield VVBRDBRTKDDEC10(7) DECV3_7
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
XMETXTText for rental unit VVXMETXT2CHAR30XMBEZ
SBASTEUSwiss rent adj.: Base year for standard of living index VVSBASTEUNUMC4Assigned to domainGJAHRBASJHR
DRESTAURDate of reconstruction/extensive modernization VVDRESTAURDATS8DATUM
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
VERKT_MVLease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
VERKT_WESite Number SWENRCHAR8Assigned to domainSWENRSWENRWEHMCWE
VERKT_MENumber of Rental Unit SMENRCHAR8Assigned to domainSMENRSMENRMEHMCME
DMIBEGRental start date DMIBEDATS8DDAT
DMIENDRental end date DMIENDATS8DDAT
DERZAHLDate of 1st debit position DERZADATS8DDAT
SMVARTExternal Real Estate contract type SMVARTCHAR4TIV26SMVARTRECNTYPE
SMVANARTLease-Out Adjustment Type SMVARCHAR1TIV27SMVAR
DUNTBISDate provisional agreement from DUNBIDATS8DDAT
BKAUTIONSecurity deposit amount BKAUTCURR13(2) WRTV7
SKAUTARTType of Rental Collateral SKAUACHAR1TIV18SKAUA
DEINKUEDate of receipt of notice DEKUEDATS8DDAT
DKUEZUContract Notice Per DKUZUDATS8DDAT
JMAHNSPDunning block indicator - no longer used! JMASPCHAR1JANE
STECHEMHeating expenses settlement company evaluation group STECHEMCHAR13STECHEM
JMINDERRent reduction indicator JMINDERCHAR1JANEI
AMELDINSales reporting interval AMELDINNUMC2INTVJ
BUMSPROJnot used (copy of BUMSPROJ) BUMSPRNUSDCURR13(2) WRTV7
BMINUMSnot used (copy of BUMSATZ1) BUMS1NUSDCURR13(2) WRTV7
PPROZ0Minimum percentage rate PPROZ0DEC5(2) DEC3_2
DSTAENStatus change date DSTAENDATS8DSTAEN
DAKTVContract activation DAKTVDATS8DATUM
JLOESCHReal Estate Deletion Indicator/Flag JLOESCHCHAR1JLOESCH
BUSABAccounting clerk BUSABCHAR2Assigned to domainBUSAB
JVERLContract renewal JVERLCHAR1VVVERL
JSKUENDSpecial right of notice JSKUENDCHAR1JANEI
JKAUFOPTOption to buy JKAUFOPTCHAR1JANEI
DKAUFOPTPurchase option date DKAUFOPTDATS8DDAT
SNKSService Charge Collector Number SNKSCHAR22Assigned to domainJ_OBJNR
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
DKUEFRNotice period in months DKUEFRNUMC2NUMC2
ANKUENNotification until (for renewal of contract) ANKUENNUMC2NUMC2
DABTRDeclaration of assignment DABTRDATS8DATUM
DFREISExemption (bank) DFREISDATS8DATUM
DABLFExpiration Date DABLFDATS8DATUM
VERLGContract renewal by ... months VERLGNUMC3NUMC3
ZSICHIndicator that other collateral is available VVZSICHCHAR1JANEI
JBETRSTSecurity deposit granted JBETRSTCHAR1JANEI
DBKERHCash deposit received on DBKERHDATS8DATUM
ABNNRIdentification of lease-out at settlement company ABNNRCHAR20TEXT20
ABNUNRCustomer subnumber ABNUNRNUMC3NUM3
BANKKSBank Keys BANKKCHAR15BANKKBNK
SKUEFRType of notice period SKUEFRNUMC1SKUEFR
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
KUNNRCustomer number main contract partner VVRDEBIHVPCHAR10KNA1ALPHAKUNNR
SPARTNRAlternative payer (partner number) VVRPARTABWCHAR10SPRT1SPARTNR
GSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
MADATLast dunned on MADATDATS8DATUM
MANSTDunning level MAHNS_DNUMC1MAHNS
JBKRZCash deposit instalment payment VVJBKRZCHAR1JANEI
DEINZGMove-in date VVDEINZGDATS8DATS
DAUSZGMove-out date VVDAUSZGDATS8DATS
JANPIBAdjustment being processed (indicator) VVJANPIBCHAR1JANE
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
MABERDunning Area MABERCHAR2Assigned to domainMABER
PROFLSettlement profile for costs VVAPROFCHAR6TKB1AALPHAAPROF
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
ZUSPSubsidies available, indicator VVZUSPCHAR1JANE
REFNRReference number for collateral securities VVREFNRCHAR30TEXT30
SBELEGNGRU occupancy by LO (used by third-prty/private/corp.grp) VVSBELEGNGCHAR1VVSBELEGNG
MANSPDunning block MANSPCHAR1T040SMANSP
DERSTDRDate When the Lease-Out was First Printed VVDERSTDRDATS8DATUM
DAENDDRDate When the Lease-Out was Changed and Printed Out VVDAENDDRDATS8DATUM
JMFREICondition is not checked VVJMFREICHAR1JANE
DVMUNContract signed by landlord VVDVMUNDATS8DATUM
JRMSCHPRTenant service charge settlement? VVJRMSCHPRCHAR1XFELD
TDNAMEName TDOBNAMECHAR70TDOBNAME
KBK_PARTNRPartner number SPARTNRCHAR10SPRT1SPARTNRPNN
GERSTDJurisdiction VVXGERSTDCHAR35TEXT35
KONDPJConditions on lease-out effective per year (display) VVKONDPJCHAR1JFLAGG
JMABGRAccrual/deferral method VVJMABGRCHAR1JFLAGG
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
SKUEKEYNotice rule SKUEKEYCHAR12SKUEKEY
SKUEARTNotice Type of Lease-Out SMVKUEARTCHAR1SMVKUEART
E_SMIVEContract No. of Collective Lease-Outs VVESMIVECHAR13ALPHAVVSMIVEMVE
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
FEHLBELReference code false occupancy charges VVFEHLBELCHAR20VVFEHLBEL
R1DATUM1st date for vacating VVR1DATUMDATS8DATUM
R2DATUM2nd date for vacating VVR2DATUMDATS8DATUM
KLDATUMDate of complaint VVKLDATUMDATS8DATUM
KLAKTZEIComplaint reference code VVKLAKTZEICHAR20CHAR20
IND_SECTORIndustry of master tenant VVMVINDSECCHAR4T016BRSCH
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
DFLOWFIXFlows fixed upto VVDFLOWFIXDATS8DATUM
INTRENO_MFLInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
DGUELABValid-from date VIGWGUELABDATS8DDAT
DGUELBISDate: Valid To VIGWSGUELBISDATS8DDAT
FLG_LME VIGWFLGLMECHAR1JANE
GFLFAK VIGWGFLNUFAKQUAN12(2) VIGWGFLNUFAK
GFAKEH VIGWGFNFAKEHUNIT2VIGWQPROMILLE
AUTOTYP VIGWGFAUTOTYPCHAR1VIGWZUAUTOTYP

Key field Non-key field



How do I retrieve data from SAP structure VIGW_R_VIMVF03 using ABAP code?

As VIGW_R_VIMVF03 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VIGW_R_VIMVF03 as there is no data to select.

How to access SAP table VIGW_R_VIMVF03

Within an ECC or HANA version of SAP you can also view further information about VIGW_R_VIMVF03 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!