VDBLEW

Revenue value collateral value | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
RBLNR FK Collateral Number
Column Name Description
💲 Currency Key (VDHOBJBL.SBELWHR):
BAFAW Depreciation amount
BAUMIETW External area rent per unit
BAUROHW External area monthly gross profit
BBETRIEBW Operating costs
BBEWIRTW Administration costs
BERTRAGW Revenue value
BGAROHW Garage monthly gross profit
BGAMIETW Rent pro garage
BSTROHW Monthly Gross Revenue per Parking Space
BSTMIETW Rent per parking space
BINSTANDW Maintenance costs
BVWKW Administration Costs
BJREINW Yearly net profit
BJROHW Yearly gross profit
BMIETAUSW Risk of rent loss
BMOROHW Monthly gross profit
BAFAG Depreciation amount
BAUMIETG External area rent per unit
BAUROHG External area monthly gross profit
BBETRIEBG Operating costs
BBEWIRTG Administration costs
BERTRAGG Revenue value
BGAROHG Garage monthly gross profit
BGAMIETG Rent pro garage
BSTROHG Monthly Gross Revenue per Parking Space
BSTMIETG Rent per parking space
BINSTANDG Maintenance costs
BVWKG Administration Costs
BJREING Yearly net profit
BJROHG Yearly gross profit
BMIETAUSG Risk of rent loss
BMOROHG Monthly gross profit
BGEROHER Total yearly gross profit
BSROHG Gross revenue per period
BSROHW Gross revenue per period
BERTRAG Revenue value
BSICHABW Collateral markdown
BSICHABG Collateral markdown
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
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
PAFAW Markdown in % DEC3_7
FAUSSENW External area FLAE
PBETRIEBW Operating costs in % DEC3_7
PBEWIRTW Administrative costs in % DEC3_7
AGARAGEW Number of garages DEC5
ASTELLW Number of parking spaces DEC5
PINSTANDW Maintenance costs in % DEC3_7
PVWKW Management costs in % DEC3_7
PZINSW Capitalization interest DEC4_5
FMIOAUSW Rental area without external area FLAE
PMIETAUSW Risk of rent loss in % DEC3_7
PAFAG Markdown in % DEC3_7
FAUSSENG External area FLAE
PBETRIEBG Operating costs in % DEC3_7
PBEWIRTG Administrative costs in % DEC3_7
AGARAGEG Number of garages DEC5
ASTELLG Number of parking spaces DEC5
PINSTANDG Maintenance costs in % DEC3_7
PVWKG Management costs in % DEC3_7
PZINSG Capitalization interest DEC4_5
FMIOAUSG Rental area without external area FLAE
PMIETAUSG Risk of rent loss in % DEC3_7
FGESMIET Total area for rent FLAE
FSNUTZG Building part usable space FLAE
FSNUTZW Building part usable space FLAE
PSICHABW Collateral markdown in % DEC3_3
PSICHABG Collateral markdown in % DEC3_3
ARNDG Remaining Life for Revenue Value Calculation DEC5
ARNDW Remaining Life for Revenue Value Calculation DEC5
Master Data Relations Join Conditions
Client VDBLEW.MANDT == T000.MANDT
Collateral Number
Currency Key
  • VDBLEW.MANDT == TCURC.MANDT
  • VDBLEW.SBELWHR == TCURC.WAERS
Area unit
  • VDBLEW.MANDT == T006.MANDT
  • VDBLEW.SUFLAE == T006.MSEHI