VIRPS407 SAP (Rental agreements) Table details
Dictionary Type: Table
Description: Rental agreements
Description: Rental agreements
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
BUKRS_01 | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
GSBER_02 | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SWENR_03 | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
SGRNR_04 | Property Number for BE | SGRNR | CHAR | 8 | VIOB02 | SGRNR | SGRNR | GRS | MCGR |
SGENR_05 | Building Number | SGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | MCGE |
SMENR_06 | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
SMIVE_07 | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
USRUNIT | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USRCUKY | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
FEINS | Area unit | FEINS | UNIT | 3 | T006 | CUNIT | MEINS | FEH | |
DERSTDR | Date When the Lease-Out was First Printed | VVDERSTDR | DATS | 8 | DATUM | ||||
PROFL | Settlement profile for costs | VVAPROF | CHAR | 6 | TKB1A | ALPHA | APROF | ||
ABNNR | Settlement firm: number | VVABNNR | CHAR | 20 | TEXT20 | ||||
STECHEM | Settlement firm: Evaluation group | VVSTECHEM | CHAR | 13 | STECHEM | ||||
ABNUNR | Settlement company: subnumber | VVABNUNR | NUMC | 3 | NUM3 | ||||
XNNPARTABW | Alternative payer: surname | VVNNPARTBA | CHAR | 20 | TEXT20 | ||||
XPARTNRABW | Alternative payer: name | VVXPARTNRA | CHAR | 35 | CHAR35 | ||||
XORT | Address: City | VVXORT | CHAR | 35 | TEXT35 | ||||
XPLZ | Address: Postal code | VVXPLZ | CHAR | 10 | PSTLZ | ||||
XSTRASSE | Address: Street/house number | VVXSTRASSE | CHAR | 35 | TEXT35 | ||||
ANKUEN | Notification until (for renewal of contract) | ANKUEN | NUMC | 2 | NUMC2 | ||||
XMVANART | Lease-out primary adjustment type | VVXMVANPPR | CHAR | 15 | CHAR15 | ||||
XMVANART44 | Lease-Out Secondary Adjustment Type | VVXMVANART | CHAR | 15 | XKBEZ | ||||
DASPVON | Adjustment block as from | VVDASPVON | DATS | 8 | DATUM | ||||
DASPBIS | Adjustment block until | VVDASPBIS | DATS | 8 | DATUM | ||||
ANZMV | No. of lease-outs | VVAMV | DEC | 6 | VVDEC6 | ||||
AZIMM | Number of rooms | VVAZIMM | DEC | 6 | DEC6 | ||||
AHALBZI | Number of half rooms | VVAHALBZI | DEC | 6 | DEC6 | ||||
SKUEFR | Type of notice period | SKUEFR | NUMC | 1 | SKUEFR | ||||
SAUSTKL | Fixtures and fittings category | SAUSKL | NUMC | 2 | TIV23 | SAUSKL | |||
BANKKS | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
DBKERH | Cash deposit received on | VVDBKERH | DATS | 8 | DATUM | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
XBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | VVSBELEGN2 | CHAR | 30 | CHAR30 | ||||
SBELEGNG | RU occupancy by LO (used by third-prty/private/corp.grp) | VVSBELEGNG | CHAR | 1 | VVSBELEGNG | ||||
USR02 | User-defined field 1 for 10 characters | USRCHAR101 | CHAR | 10 | USRCHAR10 | ||||
USR03 | User-defined field 2 for 10 characters | USRCHAR102 | CHAR | 10 | USRCHAR10 | ||||
USR00 | User-defined field 1 for 20 characters | USRCHAR201 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field 2 for 20 characters | USRCHAR202 | CHAR | 20 | USRCHAR20 | ||||
USR08 | User field 1 for date | USRDATE1 | DATS | 8 | USRDATE | ||||
USR09 | User field 2 for date | USRDATE2 | DATS | 8 | USRDATE | ||||
USRUNIT1 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USRCUKY2 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USRCUKY1 | User field: Unit for value fields | USRCUKY | CUKY | 5 | TCURC | WAERS | |||
USRUNIT2 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
USR10 | User field 1 indicator for evaluations | USRFLAG1 | CHAR | 1 | FLAG | ||||
USR11 | User field 2 indicator for evaluations | USRFLAG2 | CHAR | 1 | FLAG | ||||
USR04 | User field 1 for set (length 10,3) | USRQUAN131 | QUAN | 13(3) | USRQUAN13 | ||||
USR05 | User field 2 for set (length 10.3) | USRQUAN132 | QUAN | 13(3) | USRQUAN13 | ||||
USR06 | User field 1 for values (length 10.3) | USRCURR131 | CURR | 13(3) | USRCURR13 | ||||
USR07 | User field 2 for values (length 10.3) | USRCURR132 | CURR | 13(3) | USRCURR13 | ||||
JBETRST | Security deposit granted | JBETRST | CHAR | 1 | JANEI | ||||
BKONDQM | Currency amount per area unit | BKONDQM | CURR | 13(2) | WRTV7 | ||||
FBEZUG | Reference area for calculation of amounts per area unit | VVFBEZUG | QUAN | 15(2) | VVFBEZUG | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
DERZAHL | Date: 1st debit position | VVDERZA | DATS | 8 | DDAT | ||||
DAKTV | Date: Activation | VVDAKTV | DATS | 8 | DATUM | ||||
DAUSZG | Date: Move-out | VVDAUSZG2 | DATS | 8 | DATS | ||||
DEINZG | Date: Move-in | VVDEINZG2 | DATS | 8 | DATS | ||||
DKUEZU | Date: Notice | VVDKUZU2 | DATS | 8 | DATS | ||||
DMIBEG | Date: Start of rent | VVDMIBE | DATS | 8 | DDAT | ||||
DMIEND | Date: rental end | VVDMIEN | DATS | 8 | DDAT | ||||
DUNTBIS | Date: Provisional agreement from | VVDUNBI | DATS | 8 | DDAT | ||||
ZUSPKUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
BABRE | Settlement units | VVBABRE | QUAN | 14(4) | VVBABRE | ||||
PERHOE | Percentage rate increase | VVPERHOE | DEC | 10(2) | DEC8_2 | ||||
FKONDFLA | Area for condition type | VVFKONDFLA | QUAN | 15(2) | VVFKONDFLA | ||||
SGENR | Building Number | SGENR | CHAR | 8 | VIOB03 | SGENR | SGENR | GEB | MCGE |
XGEBT | Building: part | VVXGEBT | CHAR | 15 | CHAR15 | ||||
SGEBT | Part of Building | SGEBT | CHAR | 2 | TIV12 | SGEBT | |||
GERSTD | Jurisdiction | VVXGERSTD | CHAR | 35 | TEXT35 | ||||
SSTOCKW | Floor | VVSSTOCKW | NUMC | 3 | TIV37 | VVSSTOCKW | |||
XSTOCKW | Floor (text) | VVXSTOCKW | CHAR | 15 | CHAR15 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
XASPGRD | Reason for adjustment block (text) | VVXASPGRD | CHAR | 30 | XTEXT30 | ||||
XMANSP | Dunning block reason | VVXMANSP | CHAR | 30 | CHAR30 | ||||
SASPGRD | Reason for adjustment block | VVSASPGRD | NUMC | 2 | TIV14 | VVSASPGRD | |||
SGRNR | Property Number for BE | SGRNR | CHAR | 8 | VIOB02 | SGRNR | SGRNR | GRS | MCGR |
KUNNR | Main tenant: Customer number | VVRDEBIHV2 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
XNNPART | Master tenant: last name | VVNNPARTB | CHAR | 20 | TEXT20 | ||||
XPARTNR | Master tenant: name | VVXPARTNR | CHAR | 35 | CHAR35 | ||||
INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | VVINTRENO | ||||
DKAUFOPT | Purchase option: date | VVDKAUFOPT | DATS | 8 | DDAT | ||||
JKAUFOPT | Purchase option: indicator | VVJKAUFOPT | CHAR | 1 | JANEI | ||||
BKAUTION | Deposit: amount | VVBKAUTART | CURR | 13(2) | WRTV7 | ||||
JMFREI | Condition is not checked | VVJMFREI | CHAR | 1 | JANE | ||||
DGULTAB | Condition: effective from | VVDKOND | DATS | 8 | DDAT | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | TZK01 | SKOART | |||
BKOND | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
KOSTL | Cost center: name | VVXKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
DATAB | Cost center: effective from_ | VVDKOSTL | DATS | 8 | DATUM | ||||
XKUEFR | Type of notice period | VVXKUEFR | CHAR | 30 | CHAR30 | ||||
DKUEFR | Notice period: months | VVAKUEFR2 | DEC | 6 | DEC06 | ||||
XLGESCH | Location in floor (text) | VVXLGESCH | CHAR | 15 | CHAR15 | ||||
RLGESCH | Location on Floor | RLGESCH | CHAR | 2 | TIV38 | ALPHA | RLGESCH | ||
SLAGK | Location class | SLAGK | NUMC | 2 | TIV22 | SLAGK | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
JMAHNMSP | Dunning block indicator - no longer used! | JMASP | CHAR | 1 | JANE | ||||
MABER | Dunning: area | VVMABER | CHAR | 2 | Assigned to domain | MABER | |||
MADAT | Date of last dunning letter | VVDMADAT | DATS | 8 | DATUM | ||||
MANST | Dunning: level | VVMAHNS | NUMC | 1 | MAHNS | ||||
BMWST | Value-added tax amount included | BMWST | CURR | 13(2) | WRTV7 | ||||
AMELDIN | Sales reporting interval | AMELDIN | NUMC | 2 | INTVJ | ||||
SMENR | Number of Rental Unit | SMENR | CHAR | 8 | VIMI01 | SMENR | SMENR | MEH | MCME |
XMBEZ | Reason for rent reduction | VVMMXMBEZ | CHAR | 30 | XMBEZ | ||||
SKAUTART | Type of Rental Collateral | SKAUA | CHAR | 1 | TIV18 | SKAUA | |||
XKAUTART | Deposit: type | VVXKAUTART | CHAR | 15 | CHAR15 | ||||
XAUSTKL | Represent. list of rents: Fixture/fitting category | VVXXAUSTKL | CHAR | 15 | CHAR15 | ||||
XLAGK | Representative list of rents: locat.class | VVXLAGK | CHAR | 30 | XMBEZ | ||||
XMIETSP | Representative list of rents: allocation | VVXMIETSP | CHAR | 15 | CHAR15 | ||||
SMIETSP | Representative list of rents assignment | SMIETSP | CHAR | 6 | TIV20 | SMIETSP | |||
SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
XMVART | Lease out: Type | VVXMVART | CHAR | 15 | CHAR15 | ||||
FLG_MITARB | Employee indicator | VVSMITARB2 | CHAR | 1 | XFELD | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
SPARTNR | Partner number | SPARTNR | CHAR | 10 | SPRT1 | SPARTNR | PNN | ||
SMVANART | Rental agreement primary adjustment type | SMVAR04 | CHAR | 1 | TIV27 | SMVAR | |||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
JBKRZ | Cash deposit instalment payment | VVJBKRZ | CHAR | 1 | JANEI | ||||
REINS | Unit for cubic volume | REINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
JRMSCHPR | Tenant service charge settlement? | VVJRMSCHPR | CHAR | 1 | XFELD | ||||
DGABANRT44 | Secondary adjustment type valid from | VVDGABANR2 | DATS | 8 | DATUM | ||||
DBISANRT44 | Secondary adjustment type valid until | VVDBISANR2 | DATS | 8 | DATUM | ||||
SMVANART44 | Rental agreement secondary adjustment type | SMVAR44 | CHAR | 1 | TIV27 | SMVAR | |||
SICHGEB | Guarantor | VVXSICHGEB | CHAR | 30 | TEXT30 | ||||
JSKUEND | Special right of notice | JSKUEND | CHAR | 1 | JANEI | ||||
STTXT_EXT | Status: Set by user | VVXSTXTEXT | CHAR | 40 | CHAR40 | ||||
STTXT_INT | Status: Set by system | VVXSTTXTIN | CHAR | 40 | CHAR40 | ||||
DGAB | Date when the apportionment factor becomes valid | VVDUMLGA | DATS | 8 | DDAT | ||||
SABRG | Apportionment unit | SABRG | NUMC | 4 | TIV07 | SABRG | ARG | ||
PPROZ0 | Sales: minimum percentage | VVPPROZ0 | DEC | 5(2) | DEC3_2 | ||||
BMINUMS | Sales: minimum | VVBUMSATZ1 | CURR | 13(2) | WRTV7 | ||||
BUMSPROJ | Sales: plan | VVBUMSPROJ | CURR | 13(2) | WRTV7 | ||||
DVMUN | Contract signed by landlord | VVDVMUN | DATS | 8 | DATUM | ||||
VERLG | Contract renewal by ... months | VERLG | NUMC | 3 | NUMC3 | ||||
SMVART | External Real Estate contract type | SMVART | CHAR | 4 | TIV26 | SMVART | RECNTYPE | ||
JVERL | Contract renewal | JVERL | CHAR | 1 | VVVERL | ||||
SWENR | Site Number | SWENR | CHAR | 8 | VIOB01 | SWENR | SWENR | WEH | MCWE |
XGZLSCH | Payment method for credit memos | VVXGZLSCH | CHAR | 30 | CHAR30 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
XZLSCH | Payment method | VVXZLSCH | CHAR | 30 | CHAR30 | ||||
GZLSCH | Payment method for credit memos | VVGZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
PZUABSP | Surcharge or reduction for representative list of rents | VVPZUABSP | DEC | 10(2) | DEC8_2 | ||||
PROZTEIL | Subsidy percentage rate | VVPZUSP | DEC | 5(2) | DECV5_2 | ||||
DGUELTAB | Date as from when subsidy valid | VVDZUSPAB | DATS | 8 | DATUM | ||||
DGUELBIS | Date up to when subsidy valid | VVDZUSPBIS | DATS | 8 | DATUM | ||||
DFAELL | Subsidy due date | VVDZUSPFAE | DATS | 8 | DATUM | ||||
BZUBETR | Subsidy/allowance amount | VVZUBETR | CURR | 13(2) | WERTV7 | ||||
XZUSPKUNNR | Subsidizer | VVXZUSPPRT | CHAR | 35 | CHAR35 | ||||
ZUSP | Subsidies available, indicator | VVZUSP | CHAR | 1 | JANE | ||||
SPARTNRABW | Alternative payer (partner number) | VVRPARTABW | CHAR | 10 | SPRT1 | SPARTNR | |||
DAENDDR | Date When the Lease-Out was Changed and Printed Out | VVDAENDDR | DATS | 8 | DATUM | ||||
DMIENKUE | End Date of Lease-Out | VVDMIENKUE | DATS | 8 | DATS |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects