VDSDV5 SAP table for – Collateral in securities in acc. with BAV/PRF5

Here we would like to draw your attention to VDSDV5 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). VDSDV5 is a SAP standard transp table used for storing Collateral in securities in acc. with BAV/PRF5 related data in SAP. It comes under the package FVVD.

SAP VDSDV5 table

Table VDSDV5 technical data

TableVDSDV5
Data storingCollateral in securities in acc. with BAV/PRF5
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDSDV5 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 VDSDV5 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • 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
  • XWPKN : Securities ID number (Display PRF5)
    Its data type is CHAR (Character String) with field length 15
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BKURSWRT : Market value of a security according to stmnt in PRF5
    Its data type is CURR (Currency Field) with field length 13
  • DKURSWRT : Date of valuation at market value
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BNEWE : Nominal value per share
    Its data type is CURR (Currency Field) with field length 10
  • BWKUR : Security price for unit quotation
    Its data type is CURR (Currency Field) with field length 13
  • PKUR : Price in percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • ASTUECK : Number of units for unit-quoted securities
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • BNOMS : Nominal value
    Its data type is CURR (Currency Field) with field length 13
  • XALKZ : Short name
    Its data type is CHAR (Character String) with field length 15
  • XALLB : Long name
    Its data type is CHAR (Character String) with field length 60
  • XEMIT : Name of issuer (info)
    Its data type is CHAR (Character String) with field length 50
  • PNOMZINS : Nominal interest rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DEBEG : Issue start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XSERIE : Issue serial number
    Its data type is CHAR (Character String) with field length 15
  • XREIHE : Issue Series
    Its data type is CHAR (Character String) with field length 15
  • SVERWA : Custody type
    Its data type is CHAR (Character String) with field length 1
  • XDKBZ : Sec.acct position short description
    Its data type is CHAR (Character String) with field length 15
  • DBLFZ : Start of Term
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DELFZ : End of Term
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XAKT : File Number
    Its data type is CHAR (Character String) with field length 32
  • KOMM1 : Name
    Its data type is CHAR (Character String) with field length 50
  • KOMM2 : Name
    Its data type is CHAR (Character String) with field length 50
  • RLDEPO : Securities Account
    Its data type is CHAR (Character String) with field length 10
  • DURUEB : Date of document transfer/date of entry in debt register
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BBWHR : Amount in position currency
    Its data type is CURR (Currency Field) with field length 13
  • SLAENDER : Country ID
    Its data type is CHAR (Character String) with field length 3