S407

Rental agreements | #transactional | Component: Real Estate Management
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
BUKRS_01 FK Company Code
GSBER_02 FK Business Area
SWENR_03 FK Business Entity Number
SGRNR_04 FK Land Number for BE
SGENR_05 FK Building Number
SMENR_06 FK Number of Rental Unit
SMIVE_07 Lease-Out Number
Column Name Description
💲 User field: Unit for value fields (USRCUKY1):
USR06 User field 1 for values (length 10.3)
💲 User field: Unit for value fields (USRCUKY2):
USR07 User field 2 for values (length 10.3)
💲 Currency Key (WAERS):
BKONDQM Currency amount per area unit
BKAUTION Deposit: amount
BKOND Condition item currency amount
BMWST Value-added tax amount included
BMINUMS Sales: minimum
BUMSPROJ Sales: plan
BZUBETR Subsidy/allowance amount
BMAXBETR Subsidy/grant maximum amount
Column Name Description
📏 User field: Unit for quantity fields (USRUNIT1):
USR04 User Field 1 for Set (Length 12,3)
📏 User field: Unit for quantity fields (USRUNIT2):
USR05 User Field 2 for Set (Length 12,3)
📏 Area Unit (FEINS):
FBEZUG Reference area for calculation of amounts per area unit
FKONDFLA Area for condition type
📏 Base Unit of Measure (MEINS):
BABRE Settlement units
Column Name Description
SPTAG Period to analyze - current date
DERSTDR Date When the Lease-Out was First Printed
DASPVON Adjustment block as from
DASPBIS Adjustment block until
DBKERH Cash deposit received on
USR08 User field 1 for date
USR09 User field 2 for date
DERZAHL Date: 1st debit position
DAKTV Date: Activation
DAUSZG Date: Move-out
DEINZG Date: Move-in
DKUEZU Date: Notice
DMIBEG Date: Start of rent
DMIEND Date: rental end
DUNTBIS Date: Provisional agreement from
DKAUFOPT Purchase option: date
DGULTAB Condition: effective from
DATAB Cost center: effective from_
MADAT Date of last dunning letter
DGABANRT44 Secondary adjustment type valid from
DBISANRT44 Secondary adjustment type valid until
DGAB Date when the apportionment factor becomes valid
DVMUN Contract signed by landlord
DGUELTAB Date as from when subsidy valid
DGUELBIS Date up to when subsidy valid
DFAELL Subsidy due date
DAENDDR Date When the Lease-Out was Changed and Printed Out
DMIENKUE End Date of Lease-Out
R1DATUM 1st date for vacating
R2DATUM 2nd date for vacating
KLDATUM Date of complaint
DFLOWFIX Flows fixed upto
DGUELAB Date when the rent adjustment becomes valid
Column Name Description
SKUEFR Type of notice period Show values
SBELEGNG RU occupancy by LO (used by third-prty/private/corp.grp) Show values
USR10 User field 1 indicator for evaluations Show values
USR11 User field 2 indicator for evaluations Show values
JBETRST Security deposit granted Show values
JKAUFOPT Purchase option: indicator Show values
JMFREI Condition is not checked Show values
JMAHNMSP Dunning: Block indicator Show values
AMELDIN Sales reporting interval Show values
FLG_MITARB Employee indicator Show values
JBKRZ Cash deposit instalment payment Show values
JRMSCHPR Tenant service charge settlement? Show values
JSKUEND Special right of notice Show values
JVERL Contract renewal Show values
ZUSP Subsidies available, indicator Show values
JVSTOPT Input tax opting (indicator) Show values
SKUEART Notice Type of Lease-Out Show values
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
ABNNR Settlement firm: number TEXT20
STECHEM Settlement firm: Evaluation group STECHEM
ABNUNR Settlement company: subnumber NUM3
XNNPARTABW Alternative payer: surname TEXT20
XPARTNRABW Alternative payer: name CHAR35
XORT Address: City TEXT35
XPLZ Address: Postal code PSTLZ
XSTRASSE Address: Street/house number TEXT35
ANKUEN Notification until (for renewal of contract) NUMC2
XMVANART Lease-out primary adjustment type CHAR15
XMVANART44 Lease-Out Secondary Adjustment Type XKBEZ
ANZMV No. of lease-outs VVDEC6
AZIMM Number of rooms DEC6
AHALBZI Number of half rooms DEC6
BANKKS Bank Keys BANKK
XBELEGNG RU occupancy by LO (used by third-prty/private/corp.grp) CHAR30
USR02 User-defined field 1 for 10 characters USRCHAR10
USR03 User-defined field 2 for 10 characters USRCHAR10
USR00 User-defined field 1 for 20 characters USRCHAR20
USR01 User field 2 for 20 characters USRCHAR20
PERHOE Percentage rate increase DEC8_2
XGEBT Building: part CHAR15
GERSTD Jurisdiction TEXT35
XSTOCKW Floor (text) CHAR15
XASPGRD Reason for adjustment block (text) XTEXT30
XMANSP Dunning block reason CHAR30
XNNPART Master tenant: last name TEXT20
XPARTNR Master tenant: name CHAR35
INTRENO Internal Real Estate Master Data Code VVINTRENO
KOSTL Cost center: name KOSTL
XKUEFR Type of notice period CHAR30
DKUEFR Notice period: months DEC06
XLGESCH Location in floor (text) CHAR15
MABER Dunning: area MABER
MANST Dunning: level MAHNS
XMBEZ Reason for rent reduction XMBEZ
XKAUTART Deposit: type CHAR15
XAUSTKL Represent. list of rents: Fixture/fitting category CHAR15
XLAGK Representative list of rents: locat.class XMBEZ
XMIETSP Representative list of rents: allocation CHAR15
SMIVE Lease-Out Number VVSMIVE
XMVART Lease out: Type CHAR15
SPARTNR Partner number VVSPARTNR
PRCTR Profit Center PRCTR
SICHGEB Guarantor TEXT30
STTXT_EXT Status: Set by user CHAR40
STTXT_INT Status: Set by system CHAR40
PPROZ0 Sales: minimum percentage DEC3_2
VERLG Contract renewal by ... months NUMC3
XGZLSCH Payment method for credit memos CHAR30
ZLSCH Payment Method ZLSCH
XZLSCH Payment method CHAR30
GZLSCH Payment method for credit memos ZLSCH
PZUABSP Surcharge or reduction for representative list of rents DEC8_2
PROZTEIL Subsidy percentage rate DECV5_2
XZUSPKUNNR Subsidizer CHAR35
SPARTNRABW Alternative payer (partner number) SPARTNR
E_SMIVE Contract No. of Collective Lease-Outs VVSMIVE
IND_SECTOR Industry of master tenant BRSCH
XIND_SECT Industry of master tenant TEXT20
MWSKZ Tax on sales/purchases code MWSKZ
SVSTSOND Input tax opting reason SVSTSOND
XVSTSOND Input tax opting reason TEXT20
SKUEKEY Notice rule SKUEKEY
XKUEART Notice Type of Lease-Out TEXT20
HBKID Short Key for a House Bank HBKID
FEHLBEL Reference code false occupancy charges VVFEHLBEL
KLAKTZEI Complaint reference code CHAR20
TXJCD Tax Jurisdiction TXJCD
KONTOBV Bank procedure account number VVIKONTOBV
ZLSCH_DEB Customer payment methods ZWELS
GZLSCH_DEB Payment methods for customer credit memos ZWELS
XSTANDNR Number of garage / parking space VVXSTANDNR
OSMIVE Number of old contract VVOSMIVE
SDUNMOD Dunning level for dunning of non-approved rent adjustments CHAR004
SKOTYP Condition category SKOTYP
DUMMYFIELD Single-Character Flag CHAR1
SNUNR Rental unit external usage type SNUNR
XNUNR Rental unit usage type (text) CHAR30
Master Data Relations Join Conditions
Company Code
  • S407.MANDT == T001.MANDT
  • S407.BUKRS == T001.BUKRS
Company code
  • S407.MANDT == T001.MANDT
  • S407.BUKRS_01 == T001.BUKRS
Area Unit
  • S407.MANDT == T006.MANDT
  • S407.FEINS == T006.MSEHI
Business Area
  • S407.MANDT == TGSB.MANDT
  • S407.GSBER == TGSB.GSBER
Business Area
  • S407.MANDT == TGSB.MANDT
  • S407.GSBER_02 == TGSB.GSBER
Main tenant: Customer number
  • S407.MANDT == KNA1.MANDT
  • S407.KUNNR == KNA1.KUNNR
Client S407.MANDT == T000.MANDT
Dunning: Blocking reason
  • S407.MANDT == T040S.MANDT
  • S407.MANSP == T040S.MANSP
Base Unit of Measure
  • S407.MANDT == T006.MANDT
  • S407.MEINS == T006.MSEHI
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S407.PERIV == T009.PERIV
  • S407.MANDT == T009.MANDT
Settlement profile for costs
  • Settlement profile for costs
  • Client
  • S407.PROFL == TKB1A.APROF
  • S407.MANDT == TKB1A.MANDT
Unit for cubic volume
  • S407.MANDT == T006.MANDT
  • S407.REINS == T006.MSEHI
Location on Floor
  • S407.MANDT == TIV38.MANDT
  • S407.RLGESCH == TIV38.RLGESCH
Apportionment unit
  • S407.MANDT == TIV07.MANDT
  • S407.SABRG == TIV07.SABRG
Reason for adjustment block
  • S407.MANDT == TIV14.MANDT
  • S407.SASPGRD == TIV14.SASPGRD
Fixtures and fittings category
  • Fixtures and fittings category
  • Client
  • Representative list of rents assignment
  • S407.SAUSTKL == TIV23.SMKLASS
  • S407.MANDT == TIV23.MANDT
  • S407.SMIETSP == TIV23.SMIETSP
Part of Building
  • S407.MANDT == TIV12.MANDT
  • S407.SGEBT == TIV12.SGEBT
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
Land Number for BE
  • Company Code
  • Land Number for BE
  • Client
  • Business Entity Number
Land Number for BE
  • Company Code
  • Land Number for BE
  • Client
  • Business Entity Number
Type of Rental Collateral
  • Type of Rental Collateral
  • Client
  • S407.SKAUTART == TIV18.SKAUTART
  • S407.MANDT == TIV18.MANDT
Condition Type (Smallest Subdivision of Condition Records)
  • Condition Type (Smallest Subdivision of Condition Records)
  • ?
  • S407.MANDT == TZK01.MANDT
  • S407.SKOART == TZK01.SKOART
  • S407.[column in domain "RANTYP"] == TZK01.RANTYP
Location class
  • Representative list of rents assignment
  • Client
  • Location class
  • S407.SMIETSP == TIV22.SMIETSP
  • S407.MANDT == TIV22.MANDT
  • S407.SLAGK == TIV22.SLAGK
Number of Rental Unit
  • Company Code
  • Business Entity Number
  • Number of Rental Unit
Number of Rental Unit
  • Company Code
  • Business Entity Number
  • Number of Rental Unit
Representative list of rents assignment
  • S407.MANDT == TIV20.MANDT
  • S407.SMIETSP == TIV20.SMIETSP
Rental agreement primary adjustment type
  • S407.MANDT == TIV27.MANDT
  • S407.SMVANART == TIV27.SMVANART
Rental agreement secondary adjustment type
  • S407.MANDT == TIV27.MANDT
  • S407.SMVANART44 == TIV27.SMVANART
External Real Estate Contract Type
  • S407.MANDT == TIV26.MANDT
  • S407.SMVART == TIV26.SMVART
Floor
  • S407.MANDT == TIV37.MANDT
  • S407.SSTOCKW == TIV37.SSTOCKW
Business Entity Number
  • Company Code
  • Business Entity Number
Business Entity Number
  • Company Code
  • Business Entity Number
User field: Unit for value fields
  • S407.MANDT == TCURC.MANDT
  • S407.USRCUKY1 == TCURC.WAERS
User field: Unit for value fields
  • S407.MANDT == TCURC.MANDT
  • S407.USRCUKY2 == TCURC.WAERS
User field: Unit for quantity fields
  • S407.MANDT == T006.MANDT
  • S407.USRUNIT1 == T006.MSEHI
User field: Unit for quantity fields
  • S407.MANDT == T006.MANDT
  • S407.USRUNIT2 == T006.MSEHI
Currency Key
  • S407.MANDT == TCURC.MANDT
  • S407.WAERS == TCURC.WAERS
Subsidizer: Customer number
  • S407.MANDT == KNA1.MANDT
  • S407.ZUSPKUNNR == KNA1.KUNNR