VDAUSZ SAP table for – Drawings on Disbursement

Here we would like to draw your attention to VDAUSZ 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). VDAUSZ is a SAP standard transp table used for storing Drawings on Disbursement related data in SAP. It comes under the package FVVD.

SAP VDAUSZ table

Table VDAUSZ technical data

TableVDAUSZ
Data storingDrawings on Disbursement
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

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

  • .INCLUDE : Payments: Key Fields
    Its a key field.
  • 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
  • DTRANS : Flow data key: System date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TTRANS : Transaction data key: system time
    Its a key field. Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • NTRANS : Transaction data key: Consecutive number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • NVERF : Disposal number within an outpayment
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Loans: Payment Data Fields (Not Key Fields)
  • 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
  • SBEWART : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • SANLF : Product Category
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NAME1 : Name 1
    Its data type is CHAR (Character String) with field length 35
  • NAME2 : Name 2
    Its data type is CHAR (Character String) with field length 35
  • NAME3 : Name 3
    Its data type is CHAR (Character String) with field length 35
  • NAME4 : Name 4
    Its data type is CHAR (Character String) with field length 35
  • PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • ORT01 : City
    Its data type is CHAR (Character String) with field length 35
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • STRAS : House number and street
    Its data type is CHAR (Character String) with field length 35
  • PFACH : PO Box
    Its data type is CHAR (Character String) with field length 10
  • PSTL2 : P.O. Box Postal Code
    Its data type is CHAR (Character String) with field length 10
  • PSKTO : Account Number of Bank Account At Post Office
    Its data type is CHAR (Character String) with field length 16
  • BANKN : Bank account number
    Its data type is CHAR (Character String) with field length 18
  • BANKL : Bank number
    Its data type is CHAR (Character String) with field length 15
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • STCD1 : Tax Number 1
    Its data type is CHAR (Character String) with field length 16
  • STCD2 : Tax Number 2
    Its data type is CHAR (Character String) with field length 11
  • STKZU : Liable for VAT
    Its data type is CHAR (Character String) with field length 1
  • STKZA : Indicator: Business Partner Subject to Equalization Tax?
    Its data type is CHAR (Character String) with field length 1
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • BKONT : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • DTAWS : Instruction key for data medium exchange
    Its data type is CHAR (Character String) with field length 2
  • DTAMS : Report key for data medium exchange
    Its data type is CHAR (Character String) with field length 1
  • XCPDK : Indicator: Is the account a one-time account?
    Its data type is CHAR (Character String) with field length 1
  • EMPFG : Payee code
    Its data type is CHAR (Character String) with field length 16
  • VCBTR : Drawing Amount from Disbursement
    Its data type is CURR (Currency Field) with field length 13
  • SCWHR : Settlement Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BHWHR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • PARTNR : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • BVTYP : Partner bank type
    Its data type is CHAR (Character String) with field length 4
  • SPRAS : Language Key
    Its data type is LANG (Language key character with length 1) with field length 1
  • ANRED : Title
    Its data type is CHAR (Character String) with field length 15
  • DDISPO : Payment Date (Drawing)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS_REPLACE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RANL_REPLACE : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • RBO : Business Operation Number (Loans)
    Its data type is CHAR (Character String) with field length 15
  • .INCLUDE : SEPA Remittance Information
  • REMIT_INFO : SEPA Payment Notes Information
    Its data type is CHAR (Character String) with field length 140
  • IBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • .INCLUDE : SEPA Return Information
  • TRANSID : SEPA Transaction ID
    Its data type is CHAR (Character String) with field length 35
  • RETURNKEY : CML SEPA return codes
    Its data type is CHAR (Character String) with field length 6
  • RETURNRSN : CML: SEPA Return Reasons
    Its data type is CHAR (Character String) with field length 4
  • POREF : SEPA Reference Field (Payment Engine)
    Its data type is CHAR (Character String) with field length 26
  • PIREF : SEPA Reference Field (Payment Engine)
    Its data type is CHAR (Character String) with field length 26