Menu

SAP Table VIRPS407

Rental agreements

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table VIRPS407 (Rental agreements) is a standard table in SAP ERP. It belongs to the package FVVI.

Technical Information

Table VIRPS407
Short Text Rental agreements
Package FVVI
Table Type Transparent Table

Fields for Table VIRPS407

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