VDARLSIC SAP table for – Collateral for loan (relationship table)

Here we would like to draw your attention to VDARLSIC table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDARLSIC is a SAP standard transp table used for storing Collateral for loan (relationship table) related data in SAP. It comes under the package FVVD.

SAP VDARLSIC table

Table VDARLSIC technical data

TableVDARLSIC
Data storingCollateral for loan (relationship table)
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDARLSIC Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDARLSIC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RANL : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • RSICHER : Collateral reference number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • SSICH : Collateral type
    Its data type is CHAR (Character String) with field length 4
  • SSICHART : Category Of Collateral Group (Internal)
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • BHAFTUNG : Value of assigned rights from collateral
    Its data type is CURR (Currency Field) with field length 13
  • BHAFTWHR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DABTRET : Date of assignment for collateral security
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBESTAET : Assignment confirmation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DANZEIGE : Assignment display date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XURK : Document number
    Its data type is CHAR (Character String) with field length 15
  • SDOKUART : Indicator for the type of document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DURK : Document date/expert opinion date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • JPROL : Indicator: Taken into consideration for rollover
    Its data type is CHAR (Character String) with field length 1
  • DBEBEZ : Date of start of relationship
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DENBEZ : Date of end of relationship
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • JHAUPT : Primary collateral indicator
    Its data type is CHAR (Character String) with field length 1