VIRPS406 SAP (Rental units) Table details

Dictionary Type: Table
Description: Rental units




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




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

VIRPS406 is a standard SAP Table which is used to store Rental units data and is available within R/3 SAP systems depending on the version and release level.

The VIRPS406 table consists of various fields, each holding specific information or linking keys about Rental units data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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: Not classified


SAP VIRPS406 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
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
BUKRS_01Company Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBER_02Business Area GSBERCHAR4TGSBGSBERGSB
SWENR_03Site Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SGRNR_04Property Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
SGENR_05Building Number SGENRCHAR8VIOB03SGENRSGENRGEBMCGE
SMENR_06Number of Rental Unit SMENRCHAR8VIMI01SMENRSMENRMEHMCME
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
SGRNRProperty Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
SGENRBuilding: number VVSGENRCHAR8VIOB03SGENRSGENRGEB
SMENRRental unit: number VVSMENRCHAR8VIMI01SMENRSMENRMEH
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
USRUNIT1User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USRUNIT2User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USRCUKY1User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USRCUKY2User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
FEINSArea unit FEINSUNIT3T006CUNITMEINSFEH
REINSUnit for cubic volume REINSUNIT3T006CUNITMEINS
XORTAddress: City VVXORTCHAR35TEXT35
XPLZAddress: Postal code VVXPLZCHAR10PSTLZ
XSTRASSEAddress: Street/house number VVXSTRASSECHAR35TEXT35
ANZMENumber of rental units VVAMEDEC6DEC6
USR02User-defined field 1 for 10 characters USRCHAR101CHAR10USRCHAR10
USR03User-defined field 2 for 10 characters USRCHAR102CHAR10USRCHAR10
USR00User-defined field 1 for 20 characters USRCHAR201CHAR20USRCHAR20
USR01User field 2 for 20 characters USRCHAR202CHAR20USRCHAR20
USR08User field 1 for date USRDATE1DATS8USRDATE
USR09User field 2 for date USRDATE2DATS8USRDATE
USR10User field 1 indicator for evaluations USRFLAG1CHAR1FLAG
USR11User field 2 indicator for evaluations USRFLAG2CHAR1FLAG
USR04User field 1 for set (length 10,3) USRQUAN131QUAN13(3) USRQUAN13
USR05User field 2 for set (length 10.3) USRQUAN132QUAN13(3) USRQUAN13
USR06User field 1 for values (length 10.3) USRCURR131CURR13(3) USRCURR13
USR07User field 2 for values (length 10.3) USRCURR132CURR13(3) USRCURR13
FBEZUGReference area for calculation of amounts per area unit VVFBEZUGQUAN15(2) VVFBEZUG
FQMFLARTArea of area type VVBFLARTQUAN14(4) VVBFLART
DSFLARTArea: effective from VVDSFLARTDATS8DATS
SFLARTArea type SFLARTNUMC4TIV08SFLART
KOSTLCost center: name VVXKOSTLCHAR10Assigned to domainALPHAKOSTLKOS
DATABCost center: effective from_ VVDKOSTLDATS8DATUM
ADRNRObject number (virtual object) SOBJNRNUMC10Assigned to domainSOBJNR
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
STTXT_EXTStatus: Set by user VVXSTXTEXTCHAR40CHAR40
STTXT_INTStatus: Set by system VVXSTTXTINCHAR40CHAR40
XMETXTText for rental unit VVXMETXTCHAR30XMBEZ
SKOARTCondition: Type VVSKOARTNUMC4TZK01SKOARTUMK
BKONDCondition: amount VVBKONDCURR13(2) WRTV7
DGULTABCondition: effective from VVDKONDDATS8DDAT
SNUNRRental unit external usage type SNUNRNUMC4TIV01SNUNR
XNUNRRental unit usage type (text) VVXNUNRCHAR30CHAR30
SALTNRNumber of rental unit in existing real estate system SALTNRCHAR20SALTNR
SRAARTRoom type SRAARTNUMC2TIV09SRAART
BRAARTNumber of rooms per room type BRAARTDEC3DEC3
SMERKMAFixtures and Fittings Characteristics SMERKMANUMC3TIV71SMERKMA
XMERKMACharacteristic VVXMERKMACHAR30XTEXT30
SSTOCKWFloor VVSSTOCKWNUMC3TIV37VVSSTOCKW
XSTOCKWFloor (text) VVXSTOCKWCHAR15CHAR15
RLGESCHLocation on Floor RLGESCHCHAR2TIV38ALPHARLGESCH
XLGESCHLocation in floor (text) VVXLGESCHCHAR15CHAR15
DBEZUDate: First usage VVDBEZUDATS8DDAT
SABRGApportionment unit: type VVSABRG2NUMC4TIV07SABRGARG
DGABApportionment unit: effective from VVDGAB2DATS8DDAT
BABREApportionment units VVBUMLEINHQUAN6(2) VVBUMLEINH
TXT04Occupancy type: short text VVXJ_TXT04CHAR4CHAR04
TXT30Occupancy type (text) VVXJ_TXT30CHAR30CHAR30
BELEABOccupancy type: effet.from VVDBELEABDATS8DATUM
BELEBISOccupancy type: eff. to VVDBELEBISDATS8DATUM
DBEGEHLast access: date VVDBEGEHDATS8DDAT
XBEGEHLast inspection: by VVXBEGEHCHAR15XKBEZ
PERHOEIncrease: percentage VVPERHOE2DEC10(2) DEC8_2
RPROZGRDIncrease: Reason for difference VVRPROZGRDCHAR2TIV43RPROZGRD
XPROZGRDIncrease: Reason for difference VVXPROZGRDCHAR15CHAR15
SMOEBLFurniture indicator SMOEBCHAR1SMOEB
AZIMMNumber of rooms VVAZIMMDEC6DEC6
AHALBZINumber of half rooms VVAHALBZIDEC6DEC6
XSTANDNRNumber of garage / parking space VVXSTANDNRCHAR5ALPHAVVXSTANDNR
JEIGWOHNRental Unit in Separate Ownership (COA) VVJEIGWOHNCHAR1JANE
ABNNRSettlement firm: number VVABNNRCHAR20TEXT20
STECHEMSettlement firm: Evaluation group VVSTECHEMCHAR13STECHEM
SSTCKBISFor RUs with Multiple Floors: Top Floor of RU VVSSTCKBISNUMC3TIV37VVSSTOCKW
JVORSTEIGInput tax deduction for vacancy JVORSTEIGCHAR1OPTIERT
RFAKTConversion factor for fractional share of property VVXFAKTCHAR6CHAR6
JKONDMVCond.transfer RA: indicator VVJKONDMV2CHAR1XFELD
PKONDMVCond.transfer LO: percent VVPKONDMV2DEC5(2) PRZ32
DFSTRBISDate: Cash flow until VVDFSTRBI2DATS8DATUM
JRMSCHPRTenant service charge settlement? VVJRMSCHPRCHAR1XFELD
DHPZSAKTCH rent adj.:Date of mort.loan rate status for current rent VVDHPZSAK2DATS8DATUM
DUTBKAKTCH rnt adj.:Dte maint./oper.costs index status for new rent VVDUTBKAK2DATS8DATUM
DTEURAKTCH rnt adj.:Dte of living stndrd index status for curr.rent VVDTEURAK2DATS8DATUM
SMIETSPRepresentative list of rents assignment SMIETSPCHAR6TIV20SMIETSP
XMIETSPRepresentative list of rents: allocation VVXMIETSPCHAR15CHAR15
PZUABSPRepresentative list of rents: surcharge/reduction VVPZUABSP2DEC10(2) DEC8_2
SLAGKLocation class SLAGKNUMC2TIV22SLAGK
XLAGKRepresentative list of rents: locat.class VVXLAGKCHAR30XMBEZ
SAUSTKLFixtures and fittings category SAUSKLNUMC2TIV23SAUSKL
XAUSTKLRepresent. list of rents: Fixture/fitting category VVXXAUSTKLCHAR15CHAR15
DWTVERMDate: Subsequent rental DWTVERMDATS8DATUM
RBELBINDOccupancy obligation key RBELBINDCHAR4TIV31RBELBIND
XBELBINDOccupancy obligation: to VVXBELBINDCHAR15CHAR15
DBINDBISOccupancy obligation: until VVDBINDBISDATS8DATUM
SBWNRReservation application number of a rental unit VVXBWNRCHAR7VVXBWNROWK
SPARTNRPartner number SPARTNRCHAR10SPRT1SPARTNRPNN
XPARTNRName of applicant for a rental unit VVXPARTNRBCHAR35CHAR35
XNNPARTLast name of applicant VVNNPARTCHAR20TEXT20
DRESABDate: Reserved from DRESADATS8DDAT
DRESBISDate: Reserved upto DRESBDATS8DDAT
UMBRAUMCubic Volume VVBUBRAQUAN11(3) VVBUBRA
SGEBTPart of Building SGEBTCHAR2TIV12SGEBT
XGEBTBuilding: part VVXGEBTCHAR15CHAR15

Key field Non-key field



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

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

SELECT SINGLE *
FROM VIRPS406
INTO CORRESPONDING FIELDS OF WA_VIRPS406
WHERE...

How to access SAP table VIRPS406

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