VDARLSIC

Collateral for loan (relationship table) | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
RANL Contract Number
RSICHER Collateral reference number
Column Name Description
💲 Currency (BHAFTWHR):
BHAFTUNG Value of assigned rights from collateral
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DABTRET Date of assignment for collateral security
DBESTAET Assignment confirmation date
DANZEIGE Assignment display date
DURK Document date/expert opinion date
DBEBEZ Date of start of relationship
DENBEZ Date of end of relationship
Column Name Description
SSICHART Category Of Collateral Group (Internal) Show values
SDOKUART Indicator for the type of document Show values
JPROL Indicator: Taken into consideration for rollover Show values
JHAUPT Primary collateral indicator 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
XURK Document number CHAR15
Master Data Relations Join Conditions
Currency
  • VDARLSIC.MANDT == TCURC.MANDT
  • VDARLSIC.BHAFTWHR == TCURC.WAERS
Company code
  • VDARLSIC.MANDT == T001.MANDT
  • VDARLSIC.BUKRS == T001.BUKRS
Client VDARLSIC.MANDT == T000.MANDT
Collateral key
  • VDARLSIC.MANDT == TD01.MANDT
  • VDARLSIC.SSICH == TD01.SSICH