VDBLSWT

Collateral Value Real Value Resid. Prop./Part-Owners. | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
RBLNR FK Collateral Number
Column Name Description
💲 Currency Key (VDHOBJBL.SBELWHR):
BGEH Price per garage/unit
BSTEH Price per parking space/unit
BZWG Present value of garages
BZWST Present value of parking spaces
BZWAUSS Present value of external area
BSIAB Collateral markdown amount
BAUEH Price per unit of measurement for external area
BSAOSI Asset value without collateral markdown
BSZWGT Total current market value of building parts
BSNEUGT Building parts new value total
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
Column Name Description
SZUSTAND Condition of Building for Determining Building Value Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
FAUSSEN External area FLAE
AGARAGE Number of garages DEC5
ASTELL Number of parking spaces DEC5
PSWIND Asset value index 1914 (Basis 1914=100) DEC3_7
PSIAB Collateral markdown in % DEC3_7
PABZERB Price reduction in % for heritable building DEC3_7
Master Data Relations Join Conditions
Client VDBLSWT.MANDT == T000.MANDT
Collateral Number
Currency Key
  • VDBLSWT.MANDT == TCURC.MANDT
  • VDBLSWT.SBELWHR == TCURC.WAERS
Valuation can be qualified
  • VDBLSWT.MANDT == TDO3.MANDT
  • VDBLSWT.SBESNACH == TDO3.SBESNACH
Area unit
  • VDBLSWT.MANDT == T006.MANDT
  • VDBLSWT.SUFLAE == T006.MSEHI