SAP Table VDARLSIC - Collateral for loan (relationship table)

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
RANL X RANL CHAR 7 13 0 Contract Number
RSICHER X RSICHER NUMC 20 8 0 Collateral reference number
RERF RERF CHAR 28 12 0 Entered by
DERF DERF DATS 40 8 0 First Entered on
TERF TERF TIMS 48 6 0 Time of Initial Entry
REHER REHER CHAR 54 10 0 Source of initial entry
RBEAR RBEAR CHAR 64 12 0 Employee ID
DBEAR DBEAR DATS 76 8 0 Last Edited on
TBEAR TBEAR TIMS 84 6 0 Last Edited at
RBHER RBHER CHAR 90 10 0 Editing Source
SSICH SSICH CHAR 100 4 0 TD01 Collateral type
SSICHART SSICHART NUMC 104 2 0 Category Of Collateral Group (Internal)
BHAFTUNG BHAFTUNG CURR 106 13 2 Value of assigned rights from collateral
BHAFTWHR SWHR CUKY 113 5 0 TCURC Currency
DABTRET DABTRET DATS 118 8 0 Date of assignment for collateral security
DBESTAET VVDABBST DATS 126 8 0 Assignment confirmation date
DANZEIGE VVDABANZ DATS 134 8 0 Assignment display date
XURK XURK CHAR 142 15 0 Document number
SDOKUART SDOKUART NUMC 157 3 0 Indicator for the type of document
DURK DURK DATS 160 8 0 Document date/expert opinion date
JPROL VVJPROL CHAR 168 1 0 Indicator: Taken into consideration for rollover
DBEBEZ DBEBEZ DATS 169 8 0 Date of start of relationship
DENBEZ DENBEZ DATS 177 8 0 Date of end of relationship
JHAUPT VVJHSICH CHAR 185 1 0 Primary collateral indicator

443208EUR:expiring currencies in the loan
423914EUR: euro changeover of collaterals
90300Number ranges in Treasury: overview