VIRPS407 SAP (Rental agreements) Table details

Dictionary Type: Table
Description: Rental agreements




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




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

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

The VIRPS407 table consists of various fields, each holding specific information or linking keys about Rental agreements 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 VIRPS407 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
SMIVE_07Lease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
USRUNITUser field: Unit for quantity fields USRUNITUNIT3Assigned to domainCUNITMEINS
USRCUKYUser field: Unit for value fields USRCUKYCUKY5Assigned to domainWAERS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
FEINSArea unit FEINSUNIT3T006CUNITMEINSFEH
DERSTDRDate When the Lease-Out was First Printed VVDERSTDRDATS8DATUM
PROFLSettlement profile for costs VVAPROFCHAR6TKB1AALPHAAPROF
ABNNRSettlement firm: number VVABNNRCHAR20TEXT20
STECHEMSettlement firm: Evaluation group VVSTECHEMCHAR13STECHEM
ABNUNRSettlement company: subnumber VVABNUNRNUMC3NUM3
XNNPARTABWAlternative payer: surname VVNNPARTBACHAR20TEXT20
XPARTNRABWAlternative payer: name VVXPARTNRACHAR35CHAR35
XORTAddress: City VVXORTCHAR35TEXT35
XPLZAddress: Postal code VVXPLZCHAR10PSTLZ
XSTRASSEAddress: Street/house number VVXSTRASSECHAR35TEXT35
ANKUENNotification until (for renewal of contract) ANKUENNUMC2NUMC2
XMVANARTLease-out primary adjustment type VVXMVANPPRCHAR15CHAR15
XMVANART44Lease-Out Secondary Adjustment Type VVXMVANARTCHAR15XKBEZ
DASPVONAdjustment block as from VVDASPVONDATS8DATUM
DASPBISAdjustment block until VVDASPBISDATS8DATUM
ANZMVNo. of lease-outs VVAMVDEC6VVDEC6
AZIMMNumber of rooms VVAZIMMDEC6DEC6
AHALBZINumber of half rooms VVAHALBZIDEC6DEC6
SKUEFRType of notice period SKUEFRNUMC1SKUEFR
SAUSTKLFixtures and fittings category SAUSKLNUMC2TIV23SAUSKL
BANKKSBank Keys BANKKCHAR15BANKKBNK
DBKERHCash deposit received on VVDBKERHDATS8DATUM
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
XBELEGNGRU occupancy by LO (used by third-prty/private/corp.grp) VVSBELEGN2CHAR30CHAR30
SBELEGNGRU occupancy by LO (used by third-prty/private/corp.grp) VVSBELEGNGCHAR1VVSBELEGNG
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
USRUNIT1User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
USRCUKY2User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USRCUKY1User field: Unit for value fields USRCUKYCUKY5TCURCWAERS
USRUNIT2User field: Unit for quantity fields USRUNITUNIT3T006CUNITMEINS
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
JBETRSTSecurity deposit granted JBETRSTCHAR1JANEI
BKONDQMCurrency amount per area unit BKONDQMCURR13(2) WRTV7
FBEZUGReference area for calculation of amounts per area unit VVFBEZUGQUAN15(2) VVFBEZUG
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
DERZAHLDate: 1st debit position VVDERZADATS8DDAT
DAKTVDate: Activation VVDAKTVDATS8DATUM
DAUSZGDate: Move-out VVDAUSZG2DATS8DATS
DEINZGDate: Move-in VVDEINZG2DATS8DATS
DKUEZUDate: Notice VVDKUZU2DATS8DATS
DMIBEGDate: Start of rent VVDMIBEDATS8DDAT
DMIENDDate: rental end VVDMIENDATS8DDAT
DUNTBISDate: Provisional agreement from VVDUNBIDATS8DDAT
ZUSPKUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
BABRESettlement units VVBABREQUAN14(4) VVBABRE
PERHOEPercentage rate increase VVPERHOEDEC10(2) DEC8_2
FKONDFLAArea for condition type VVFKONDFLAQUAN15(2) VVFKONDFLA
SGENRBuilding Number SGENRCHAR8VIOB03SGENRSGENRGEBMCGE
XGEBTBuilding: part VVXGEBTCHAR15CHAR15
SGEBTPart of Building SGEBTCHAR2TIV12SGEBT
GERSTDJurisdiction VVXGERSTDCHAR35TEXT35
SSTOCKWFloor VVSSTOCKWNUMC3TIV37VVSSTOCKW
XSTOCKWFloor (text) VVXSTOCKWCHAR15CHAR15
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
XASPGRDReason for adjustment block (text) VVXASPGRDCHAR30XTEXT30
XMANSPDunning block reason VVXMANSPCHAR30CHAR30
SASPGRDReason for adjustment block VVSASPGRDNUMC2TIV14VVSASPGRD
SGRNRProperty Number for BE SGRNRCHAR8VIOB02SGRNRSGRNRGRSMCGR
KUNNRMain tenant: Customer number VVRDEBIHV2CHAR10KNA1ALPHAKUNNR
XNNPARTMaster tenant: last name VVNNPARTBCHAR20TEXT20
XPARTNRMaster tenant: name VVXPARTNRCHAR35CHAR35
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
DKAUFOPTPurchase option: date VVDKAUFOPTDATS8DDAT
JKAUFOPTPurchase option: indicator VVJKAUFOPTCHAR1JANEI
BKAUTIONDeposit: amount VVBKAUTARTCURR13(2) WRTV7
JMFREICondition is not checked VVJMFREICHAR1JANE
DGULTABCondition: effective from VVDKONDDATS8DDAT
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4TZK01SKOART
BKONDCondition item currency amount BKONDCURR13(2) WERTV7
KOSTLCost center: name VVXKOSTLCHAR10Assigned to domainALPHAKOSTLKOS
DATABCost center: effective from_ VVDKOSTLDATS8DATUM
XKUEFRType of notice period VVXKUEFRCHAR30CHAR30
DKUEFRNotice period: months VVAKUEFR2DEC6DEC06
XLGESCHLocation in floor (text) VVXLGESCHCHAR15CHAR15
RLGESCHLocation on Floor RLGESCHCHAR2TIV38ALPHARLGESCH
SLAGKLocation class SLAGKNUMC2TIV22SLAGK
MANSPDunning block MANSPCHAR1T040SMANSP
JMAHNMSPDunning block indicator - no longer used! JMASPCHAR1JANE
MABERDunning: area VVMABERCHAR2Assigned to domainMABER
MADATDate of last dunning letter VVDMADATDATS8DATUM
MANSTDunning: level VVMAHNSNUMC1MAHNS
BMWSTValue-added tax amount included BMWSTCURR13(2) WRTV7
AMELDINSales reporting interval AMELDINNUMC2INTVJ
SMENRNumber of Rental Unit SMENRCHAR8VIMI01SMENRSMENRMEHMCME
XMBEZReason for rent reduction VVMMXMBEZCHAR30XMBEZ
SKAUTARTType of Rental Collateral SKAUACHAR1TIV18SKAUA
XKAUTARTDeposit: type VVXKAUTARTCHAR15CHAR15
XAUSTKLRepresent. list of rents: Fixture/fitting category VVXXAUSTKLCHAR15CHAR15
XLAGKRepresentative list of rents: locat.class VVXLAGKCHAR30XMBEZ
XMIETSPRepresentative list of rents: allocation VVXMIETSPCHAR15CHAR15
SMIETSPRepresentative list of rents assignment SMIETSPCHAR6TIV20SMIETSP
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
XMVARTLease out: Type VVXMVARTCHAR15CHAR15
FLG_MITARBEmployee indicator VVSMITARB2CHAR1XFELD
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
SPARTNRPartner number SPARTNRCHAR10SPRT1SPARTNRPNN
SMVANARTRental agreement primary adjustment type SMVAR04CHAR1TIV27SMVAR
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
JBKRZCash deposit instalment payment VVJBKRZCHAR1JANEI
REINSUnit for cubic volume REINSUNIT3T006CUNITMEINS
JRMSCHPRTenant service charge settlement? VVJRMSCHPRCHAR1XFELD
DGABANRT44Secondary adjustment type valid from VVDGABANR2DATS8DATUM
DBISANRT44Secondary adjustment type valid until VVDBISANR2DATS8DATUM
SMVANART44Rental agreement secondary adjustment type SMVAR44CHAR1TIV27SMVAR
SICHGEBGuarantor VVXSICHGEBCHAR30TEXT30
JSKUENDSpecial right of notice JSKUENDCHAR1JANEI
STTXT_EXTStatus: Set by user VVXSTXTEXTCHAR40CHAR40
STTXT_INTStatus: Set by system VVXSTTXTINCHAR40CHAR40
DGABDate when the apportionment factor becomes valid VVDUMLGADATS8DDAT
SABRGApportionment unit SABRGNUMC4TIV07SABRGARG
PPROZ0Sales: minimum percentage VVPPROZ0DEC5(2) DEC3_2
BMINUMSSales: minimum VVBUMSATZ1CURR13(2) WRTV7
BUMSPROJSales: plan VVBUMSPROJCURR13(2) WRTV7
DVMUNContract signed by landlord VVDVMUNDATS8DATUM
VERLGContract renewal by ... months VERLGNUMC3NUMC3
SMVARTExternal Real Estate contract type SMVARTCHAR4TIV26SMVARTRECNTYPE
JVERLContract renewal JVERLCHAR1VVVERL
SWENRSite Number SWENRCHAR8VIOB01SWENRSWENRWEHMCWE
XGZLSCHPayment method for credit memos VVXGZLSCHCHAR30CHAR30
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
XZLSCHPayment method VVXZLSCHCHAR30CHAR30
GZLSCHPayment method for credit memos VVGZLSCHCHAR1Assigned to domainZLSCH
PZUABSPSurcharge or reduction for representative list of rents VVPZUABSPDEC10(2) DEC8_2
PROZTEILSubsidy percentage rate VVPZUSPDEC5(2) DECV5_2
DGUELTABDate as from when subsidy valid VVDZUSPABDATS8DATUM
DGUELBISDate up to when subsidy valid VVDZUSPBISDATS8DATUM
DFAELLSubsidy due date VVDZUSPFAEDATS8DATUM
BZUBETRSubsidy/allowance amount VVZUBETRCURR13(2) WERTV7
XZUSPKUNNRSubsidizer VVXZUSPPRTCHAR35CHAR35
ZUSPSubsidies available, indicator VVZUSPCHAR1JANE
SPARTNRABWAlternative payer (partner number) VVRPARTABWCHAR10SPRT1SPARTNR
DAENDDRDate When the Lease-Out was Changed and Printed Out VVDAENDDRDATS8DATUM
DMIENKUEEnd Date of Lease-Out VVDMIENKUEDATS8DATS

Key field Non-key field



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

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

SELECT SINGLE *
FROM VIRPS407
INTO CORRESPONDING FIELDS OF WA_VIRPS407
WHERE...

How to access SAP table VIRPS407

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