VDZV SAP table for – Payment Details for the Loan

Here we would like to draw your attention to VDZV 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). VDZV is a SAP standard transp table used for storing Payment Details for the Loan related data in SAP. It comes under the package FVVZ.

SAP VDZV table

Table VDZV technical data

TableVDZV
Data storingPayment Details for the Loan
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVZ
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDZV 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 VDZV 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
  • RFHA : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • SSIGN : Direction of flow
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its a key field. Its data type is CUKY (Currency key for a currency field) with field length 5
  • DZVERB : Payment details effective from
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBEWART : Flow Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CRUSER : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DCRDAT : Entered On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TCRTIM : Entry Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UPUSER : Last Changed by
    Its data type is CHAR (Character String) with field length 12
  • DUPDAT : Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TUPTIM : Time changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • HKTID : ID for account details
    Its data type is CHAR (Character String) with field length 5
  • RPZAHL : Payer/payee
    Its data type is CHAR (Character String) with field length 10
  • RPBANK : Partner bank details
    Its data type is CHAR (Character String) with field length 4
  • SZART : Payment transaction
    Its data type is CHAR (Character String) with field length 1
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • SPAYRQ : Generate payment request
    Its data type is CHAR (Character String) with field length 1
  • SPRSNG : Individual payment
    Its data type is CHAR (Character String) with field length 1
  • SPRGRD : Determine grouping definition
    Its data type is CHAR (Character String) with field length 1
  • SCSPAY : Same direction necessary for joint payment?
    Its data type is CHAR (Character String) with field length 1
  • ZWELS : List of the Payment Methods to be Considered
    Its data type is CHAR (Character String) with field length 10
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35