SAP Table VIRPS407 - Rental agreements

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
SSOUR X SSOUR CHAR 3 4 0 Statistic(s) origin
VRSIO X VRSIO CHAR 7 3 0 P44V Version number in the information structure
SPMON X SPMON NUMC 10 6 0 Period to analyze - month
SPTAG X SPTAG DATS 16 8 0 Period to analyze - current date
SPWOC X SPWOC NUMC 24 6 0 Period to analyze - week
SPBUP X SPBUP NUMC 30 6 0 Period to analyze - posting period
BUKRS_01 X BUKRS CHAR 36 4 0 T001 Company Code
GSBER_02 X GSBER CHAR 40 4 0 TGSB Business Area
SWENR_03 X SWENR CHAR 44 8 0 VIOB01 Business Entity Number
SGRNR_04 X SGRNR CHAR 52 8 0 Land Number for BE
SGENR_05 X SGENR CHAR 60 8 0 Building Number
SMENR_06 X SMENR CHAR 68 8 0 VIMI01 Number of Rental Unit
SMIVE_07 X SMIVE CHAR 76 13 0 Lease-Out Number
PERIV PERIV CHAR 89 2 0 Fiscal Year Variant
VWDAT VWDAT NUMC 91 10 0 Pointer to administrative data
USRUNIT USRUNIT UNIT 101 3 0 T006 User field: Unit for quantity fields
USRCUKY USRCUKY CUKY 104 5 0 TCURC User field: Unit for value fields
WAERS WAERS CUKY 109 5 0 TCURC Currency Key
FEINS FEINS UNIT 114 3 0 T006 Area unit
DERSTDR VVDERSTDR DATS 117 8 0 Date When the Lease-Out was First Printed
PROFL VVAPROF CHAR 125 6 0 TKB1A Settlement profile for costs
ABNNR VVABNNR CHAR 131 20 0 Settlement firm: number
STECHEM VVSTECHEM CHAR 151 13 0 Settlement firm: Evaluation group
ABNUNR VVABNUNR NUMC 164 3 0 Settlement company: subnumber
XNNPARTABW VVNNPARTBA CHAR 167 20 0 Alternative payer: surname
XPARTNRABW VVXPARTNRA CHAR 187 35 0 Alternative payer: name
XORT VVXORT CHAR 222 35 0 Address: City
XPLZ VVXPLZ CHAR 257 10 0 Address: Postal code
XSTRASSE VVXSTRASSE CHAR 267 35 0 Address: Street/house number
ANKUEN ANKUEN NUMC 302 2 0 Notification until (for renewal of contract)
XMVANART VVXMVANPPR CHAR 304 15 0 Lease-out primary adjustment type
XMVANART44 VVXMVANART CHAR 319 15 0 Lease-Out Secondary Adjustment Type
DASPVON VVDASPVON DATS 334 8 0 Adjustment block as from
DASPBIS VVDASPBIS DATS 342 8 0 Adjustment block until
ANZMV VVAMV DEC 350 6 0 No. of lease-outs
AZIMM VVAZIMM DEC 354 6 0 Number of rooms
AHALBZI VVAHALBZI DEC 358 6 0 Number of half rooms
SKUEFR SKUEFR NUMC 362 1 0 Type of notice period
SAUSTKL SAUSKL NUMC 363 2 0 Fixtures and fittings category
BANKKS BANKK CHAR 365 15 0 Bank Keys
DBKERH VVDBKERH DATS 380 8 0 Cash deposit received on
MEINS MEINS UNIT 388 3 0 T006 Base Unit of Measure
XBELEGNG VVSBELEGN2 CHAR 391 30 0 RU occupancy by LO (used by third-prty/private/corp.grp)
SBELEGNG VVSBELEGNG CHAR 421 1 0 RU occupancy by LO (used by third-prty/private/corp.grp)
USR02 USRCHAR101 CHAR 422 10 0 User-defined field 1 for 10 characters
USR03 USRCHAR102 CHAR 432 10 0 User-defined field 2 for 10 characters
USR00 USRCHAR201 CHAR 442 20 0 User-defined field 1 for 20 characters
USR01 USRCHAR202 CHAR 462 20 0 User field 2 for 20 characters
USR08 USRDATE1 DATS 482 8 0 User field 1 for date
USR09 USRDATE2 DATS 490 8 0 User field 2 for date
USRUNIT1 USRUNIT UNIT 498 3 0 T006 User field: Unit for quantity fields
USRCUKY2 USRCUKY CUKY 501 5 0 TCURC User field: Unit for value fields
USRCUKY1 USRCUKY CUKY 506 5 0 TCURC User field: Unit for value fields
USRUNIT2 USRUNIT UNIT 511 3 0 T006 User field: Unit for quantity fields
USR10 USRFLAG1 CHAR 514 1 0 User field 1 indicator for evaluations
USR11 USRFLAG2 CHAR 515 1 0 User field 2 indicator for evaluations
USR04 USRQUAN131 QUAN 516 13 3 User field 1 for set (length 10,3)
USR05 USRQUAN132 QUAN 523 13 3 User field 2 for set (length 10.3)
USR06 USRCURR131 CURR 530 13 3 User field 1 for values (length 10.3)
USR07 USRCURR132 CURR 537 13 3 User field 2 for values (length 10.3)
JBETRST JBETRST CHAR 544 1 0 Security deposit granted
BKONDQM BKONDQM CURR 545 13 2 Currency amount per area unit
FBEZUG VVFBEZUG QUAN 552 15 2 Reference area for calculation of amounts per area unit
BUKRS BUKRS CHAR 560 4 0 T001 Company Code
DERZAHL VVDERZA DATS 564 8 0 Date: 1st debit position
DAKTV VVDAKTV DATS 572 8 0 Date: Activation
DAUSZG VVDAUSZG2 DATS 580 8 0 Date: Move-out
DEINZG VVDEINZG2 DATS 588 8 0 Date: Move-in
DKUEZU VVDKUZU2 DATS 596 8 0 Date: Notice
DMIBEG VVDMIBE DATS 604 8 0 Date: Start of rent
DMIEND VVDMIEN DATS 612 8 0 Date: rental end
DUNTBIS VVDUNBI DATS 620 8 0 Date: Provisional agreement from
ZUSPKUNNR KUNNR CHAR 628 10 0 KNA1 Customer Number
BABRE VVBABRE QUAN 638 14 4 Settlement units
PERHOE VVPERHOE DEC 646 10 2 Percentage rate increase
FKONDFLA VVFKONDFLA QUAN 652 15 2 Area for condition type
SGENR SGENR CHAR 660 8 0 Building Number
XGEBT VVXGEBT CHAR 668 15 0 Building: part
SGEBT SGEBT CHAR 683 2 0 Part of Building
GERSTD VVXGERSTD CHAR 685 35 0 Jurisdiction
SSTOCKW VVSSTOCKW NUMC 720 3 0 TIV37 Floor
XSTOCKW VVXSTOCKW CHAR 723 15 0 Floor (text)
GSBER GSBER CHAR 738 4 0 TGSB Business Area
XASPGRD VVXASPGRD CHAR 742 30 0 Reason for adjustment block (text)
XMANSP VVXMANSP CHAR 772 30 0 Dunning block reason
SASPGRD VVSASPGRD NUMC 802 2 0 Reason for adjustment block
SGRNR SGRNR CHAR 804 8 0 Land Number for BE
KUNNR VVRDEBIHV2 CHAR 812 10 0 KNA1 Main tenant: Customer number
XNNPART VVNNPARTB CHAR 822 20 0 Master tenant: last name
XPARTNR VVXPARTNR CHAR 842 35 0 Master tenant: name
INTRENO VVINTRENO CHAR 877 13 0 Internal Real Estate Master Data Code
DKAUFOPT VVDKAUFOPT DATS 890 8 0 Purchase option: date
JKAUFOPT VVJKAUFOPT CHAR 898 1 0 Purchase option: indicator
BKAUTION VVBKAUTART CURR 899 13 2 Deposit: amount
JMFREI VVJMFREI CHAR 906 1 0 Condition is not checked
DGULTAB VVDKOND DATS 907 8 0 Condition: effective from
SKOART SKOART NUMC 915 4 0 TZK01 Condition Type (Smallest Subdivision of Condition Records)
BKOND BKOND CURR 919 13 2 Condition item currency amount
KOSTL VVXKOSTL CHAR 926 10 0 Cost center: name
DATAB VVDKOSTL DATS 936 8 0 Cost center: effective from_
XKUEFR VVXKUEFR CHAR 944 30 0 Type of notice period
DKUEFR VVAKUEFR2 DEC 974 6 0 Notice period: months
XLGESCH VVXLGESCH CHAR 978 15 0 Location in floor (text)
RLGESCH RLGESCH CHAR 993 2 0 Location on Floor
SLAGK SLAGK NUMC 995 2 0 Location class
MANSP MANSP CHAR 997 1 0 T040S Dunning Block
JMAHNMSP JMASP CHAR 998 1 0 Dunning block indicator - no longer used!
MABER VVMABER CHAR 999 2 0 T047M Dunning: area
MADAT VVDMADAT DATS 1001 8 0 Date of last dunning letter
MANST VVMAHNS NUMC 1009 1 0 Dunning: level
BMWST BMWST CURR 1010 13 2 Value-added tax amount included
AMELDIN AMELDIN NUMC 1017 2 0 Sales reporting interval
SMENR SMENR CHAR 1019 8 0 VIMI01 Number of Rental Unit
XMBEZ VVMMXMBEZ CHAR 1027 30 0 Reason for rent reduction
SKAUTART SKAUA CHAR 1057 1 0 TIV18 Type of Rental Collateral
XKAUTART VVXKAUTART CHAR 1058 15 0 Deposit: type
XAUSTKL VVXXAUSTKL CHAR 1073 15 0 Represent. list of rents: Fixture/fitting category
XLAGK VVXLAGK CHAR 1088 30 0 Representative list of rents: locat.class
XMIETSP VVXMIETSP CHAR 1118 15 0 Representative list of rents: allocation
SMIETSP SMIETSP CHAR 1133 6 0 TIV20 Representative list of rents assignment
SMIVE SMIVE CHAR 1139 13 0 Lease-Out Number
XMVART VVXMVART CHAR 1152 15 0 Lease out: Type
FLG_MITARB VVSMITARB2 CHAR 1167 1 0 Employee indicator
OBJNR J_OBJNR CHAR 1168 22 0 ONR00 Object number
SPARTNR SPARTNR CHAR 1190 10 0 Partner number
SMVANART SMVAR04 CHAR 1200 1 0 TIV27 Rental agreement primary adjustment type
PRCTR PRCTR CHAR 1201 10 0 Profit Center
JBKRZ VVJBKRZ CHAR 1211 1 0 Cash deposit instalment payment
REINS REINS UNIT 1212 3 0 T006 Unit for cubic volume
JRMSCHPR VVJRMSCHPR CHAR 1215 1 0 Tenant service charge settlement?
DGABANRT44 VVDGABANR2 DATS 1216 8 0 Secondary adjustment type valid from
DBISANRT44 VVDBISANR2 DATS 1224 8 0 Secondary adjustment type valid until
SMVANART44 SMVAR44 CHAR 1232 1 0 TIV27 Rental agreement secondary adjustment type
SICHGEB VVXSICHGEB CHAR 1233 30 0 Guarantor
JSKUEND JSKUEND CHAR 1263 1 0 Special right of notice
STTXT_EXT VVXSTXTEXT CHAR 1264 40 0 Status: Set by user
STTXT_INT VVXSTTXTIN CHAR 1304 40 0 Status: Set by system
DGAB VVDUMLGA DATS 1344 8 0 Date when the apportionment factor becomes valid
SABRG SABRG NUMC 1352 4 0 TIV07 Apportionment unit
PPROZ0 VVPPROZ0 DEC 1356 5 2 Sales: minimum percentage
BMINUMS VVBUMSATZ1 CURR 1359 13 2 Sales: minimum
BUMSPROJ VVBUMSPROJ CURR 1366 13 2 Sales: plan
DVMUN VVDVMUN DATS 1373 8 0 Contract signed by landlord
VERLG VERLG NUMC 1381 3 0 Contract renewal by ... months
SMVART SMVART CHAR 1384 4 0 TIV26 External Real Estate contract type
JVERL JVERL CHAR 1388 1 0 Contract renewal
SWENR SWENR CHAR 1389 8 0 VIOB01 Business Entity Number
XGZLSCH VVXGZLSCH CHAR 1397 30 0 Payment method for credit memos
ZLSCH DZLSCH CHAR 1427 1 0 T042E Payment Method
XZLSCH VVXZLSCH CHAR 1428 30 0 Payment method
GZLSCH VVGZLSCH CHAR 1458 1 0 T042E Payment method for credit memos
PZUABSP VVPZUABSP DEC 1459 10 2 Surcharge or reduction for representative list of rents
PROZTEIL VVPZUSP DEC 1465 5 2 Subsidy percentage rate
DGUELTAB VVDZUSPAB DATS 1468 8 0 Date as from when subsidy valid
DGUELBIS VVDZUSPBIS DATS 1476 8 0 Date up to when subsidy valid
DFAELL VVDZUSPFAE DATS 1484 8 0 Subsidy due date
BZUBETR VVZUBETR CURR 1492 13 2 Subsidy/allowance amount
XZUSPKUNNR VVXZUSPPRT CHAR 1499 35 0 Subsidizer
ZUSP VVZUSP CHAR 1534 1 0 Subsidies available, indicator
SPARTNRABW VVRPARTABW CHAR 1535 10 0 Alternative payer (partner number)
DAENDDR VVDAENDDR DATS 1545 8 0 Date When the Lease-Out was Changed and Printed Out
DMIENKUE VVDMIENKUE DATS 1553 8 0 End Date of Lease-Out