SAP VDSDV5 Collateral in securities in acc. with BAV/PRF5 Table data and field list

VDSDV5 is a standard SAP Table which is used to store Collateral in securities in acc. with BAV/PRF5 data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDSDV5 table consists of various fields, each holding specific information or linking keys about Collateral in securities in acc. with BAV/PRF5 data available in SAP. These include RSICHER (Collateral reference number), RERF (Entered by), DERF (First Entered on), TERF (Time of Initial Entry)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VDSDV5 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP VDSDV5 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDSDV5 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
RSICHER	Collateral reference number	RSICHER	NUMC	8			NUMC8
RERF	Entered by	RERF	CHAR	12			SYCHAR12
DERF	First Entered on	DERF	DATS	8			DATUM
TERF	Time of Initial Entry	TERF	TIMS	6			TIMES
REHER	Source of initial entry	REHER	CHAR	10			CHAR10
RBEAR	Employee ID	RBEAR	CHAR	12			SYCHAR12
DBEAR	Last Edited on	DBEAR	DATS	8			DATUM
TBEAR	Last Edited at	TBEAR	TIMS	6			TIMES
RBHER	Editing Source	RBHER	CHAR	10			CHAR10
SSICH	Collateral type	SSICH	CHAR	4	TD01		SSICH
SSICHART	Category Of Collateral Group (Internal)	SSICHART	NUMC	2			SSICHART
XWPKN	Securities ID number (Display PRF5)	XWPKN	CHAR	15			XKBEZ
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
BKURSWRT	Market value of a security according to stmnt in PRF5	BKURSWRT	CURR	13(2)			BWHR
DKURSWRT	Date of valuation at market value	DKURSWRT	DATS	8			DATUM
BNEWE	Nominal value per share	BNEWE	CURR	10(2)			VVBNENNW
BWKUR	Security price for unit quotation	BWKURS	CURR	13(2)			BWKURS
PKUR	Price in percent	PKUR	DEC	10(7)			DEC3_7
ASTUECK	Number of units for unit-quoted securities	ASTUECK	DEC	15(5)			ASTUECK
BNOMS	Nominal value	BNOMS	CURR	13(2)			BWHR
XALKZ	Short name	XALKZ	CHAR	15			XKBEZ
XALLB	Long name	XALLB	CHAR	60			XLBEZ
XEMIT	Name of issuer (info)	XEMIT	CHAR	50			XDOKBS
PNOMZINS	Nominal interest rate	PNOMZINS	DEC	10(7)			DEC3_7
DEBEG	Issue start date	DEBEG	DATS	8			DATUM
XSERIE	Issue serial number	XSERIE	CHAR	15			XKBEZ
XREIHE	Issue Series	XREIHE	CHAR	15			XKBEZ
SVERWA	Custody type	SVERWA	CHAR	1	Assigned to domain		SVERWA
XDKBZ	Sec.acct position short description	XDKBZ	CHAR	15			XKBEZ
DBLFZ	Start of Term	DBLFZ	DATS	8			DATUM
DELFZ	End of Term	DELFZ	DATS	8			DATUM
XAKT	File Number	XAKT	CHAR	32			CHAR32
KOMM1	Name	XLBEZ	CHAR	50			XTEXT50
KOMM2	Name	XLBEZ	CHAR	50			XTEXT50
RLDEPO	Securities Account	RLDEPO	CHAR	10	Assigned to domain		RLDEPO	DEP	ACC_CCD_CORE
DURUEB	Date of document transfer/date of entry in debt register	VVDURUEB	DATS	8			DATS
BBWHR	Amount in position currency	BBWHR	CURR	13(2)			WERTV7
SLAENDER	Country ID	SLAENDER	CHAR	3	T005		LAND1

Key field

Non-key field

< VDSDV4 - Loan collateral in acc. with BAV/PRF4 VDSEPA_AUTODEB - Records for new auto debit (SEPA direct debit) >

How do I retrieve data from SAP table VDSDV5 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDSDV5 to SELECT all data from the table
DATA: WA_VDSDV5 TYPE VDSDV5.

SELECT SINGLE *
FROM VDSDV5
INTO CORRESPONDING FIELDS OF WA_VDSDV5
WHERE...

How to access SAP table VDSDV5

Within an ECC or HANA version of SAP you can also view further information about VDSDV5 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VDSDV5

    VZBAVV1 - Auxiliary table with end of validity
        VIOB01 - Business entities
            VIOB02 - Property master data
                VIGBA1 - Section 1 of land register
                VIGBA2 - Section 2 of land register
                VIGBA3 - Section 3 of land register
                VIGBUCH - Land Register
                    VISPRT1 - Partner data for properties
                    VIEIGE - Owners of real estate objects
                VIWEGR - Relation table between property and assets
                    VIANLGR - BAV Table - Properties from AM
        VWPBUKR - Company code position
            VISANS1 - Address data for objects (SANS1)
    V_VWPANLA - Generated table for viewl V_VWPANLA
        VWPAKTI - Stocks, subscription rights, investment certs.
        VWSPRT1 - Partner data WP (debtor-issuer) (SPRT1/SANS1
        VWPDEP1 - Securities account position (VWPDEPO) +add. fields
            VWZZBEPP - View of collectors VWBEPP, VWBEKI, VWBEPI
            VZZKOKO - Table condition header
                VZZKOPO - Table condition items
        V_VDARL - Generated table for view V_VDARL
            VDSPRT1 - Partner data DA (debtor) SPRT1/SANS1/PARZJ
            VDSDV4 - Loan collateral in acc. with BAV/PRF4
            VIMI01 - Rental unit - real estate
            VDSDV5 - Collateral in securities in acc. with BAV/PRF5
            VDSDV2 - Collateral in accordance with BAV/PRF2
            VDZZBEPP - View of collectors VDBEPP, VDBEKI, VDBEPI
            VDZZKOKO - Condition header for loans
                VDZZKOPO - Condition items for loan
        V_VTBFHA - Generated table for view V_VTBFHA
            VTBFHAPO - Financial transaction flow
            VTBFINKO - Financial transaction condition
    VIMIMV - Lease-Out
        VIZZKOKO - Real Estate condition header for BAV
            VIZZKOPO - Real Estate condition items for BAV
            VIOB03 - Real estate building master
                VIWEGB - Relation table between buildings and assets
                    VIANLGB - BAV table buildings from AM