SAP VDAUSZ Drawings on Disbursement Table
Overview
VDAUSZ is a standard SAP S/4HANA table that stores Drawings on Disbursement data. There are total 58 fields in the VDAUSZ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDAUSZ belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDAUSZ to other SAP tables and standard CDS views available based on VDAUSZ table in S/4HANA 2020.
Techincal Settings of VDAUSZ
Below are technical details of the table VDAUSZ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDAUSZ Fields
The following table gives you an overview of the fields available in VDAUSZ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | |
| TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
| NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| NVERF | Disposal number within an outpayment | NVERF | NUMC | 2 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| SANLF | Product Category | SANLF | * | NUMC | 3 |
| NAME1 | Name 1 | NAME1_GP | CHAR | 35 | |
| NAME2 | Name 2 | NAME2_GP | CHAR | 35 | |
| NAME3 | Name 3 | NAME3_GP | CHAR | 35 | |
| NAME4 | Name 4 | NAME4_GP | CHAR | 35 | |
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | |
| ORT01 | City | ORT01_GP | CHAR | 35 | |
| LAND1 | Country Key | LAND1_GP | T005 | CHAR | 3 |
| STRAS | Street and House Number | STRAS_GP | CHAR | 35 | |
| PFACH | PO Box | PFACH | CHAR | 10 | |
| PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | |
| PSKTO | PO Bank Current Acct No. or Building Society Ref. No. | PSKTO | CHAR | 16 | |
| BANKN | Bank account number | BANKN | CHAR | 18 | |
| BANKL | Bank number | BANKL | CHAR | 15 | |
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 |
| STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | |
| STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | |
| STKZU | Liable for VAT | STKZU | CHAR | 1 | |
| STKZN | Natural Person | STKZN | CHAR | 1 | |
| STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | |
| REGIO | Region (State Province County) | REGIO | T005S | CHAR | 3 |
| BKONT | Bank Control Key | BKONT | CHAR | 2 | |
| BKREF | Reference Details for Bank Details | BU_BKREF | CHAR | 20 | |
| DTAWS | Instruction key for data medium exchange | DTAWS | T015W | CHAR | 2 |
| DTAMS | Report key for data medium exchange | DTAMS | CHAR | 1 | |
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | |
| EMPFG | Payment Recipient Code | EMPFG | CHAR | 16 | |
| VCBTR | Drawing Amount from Disbursement | VCBTR | CURR | 13 | |
| SCWHR | Settlement Currency | SCWHR | TCURC | CUKY | 5 |
| BHWHR | Amount in local currency | BHWHR | CURR | 13 | |
| ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 |
| PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| SPRAS | Language Key | SPRAS | LANG | 1 | |
| ANRED | Title | ANRED | CHAR | 15 | |
| DDISPO | Payment Date (Drawing) | TB_DISB_DDISPO | DATS | 8 | |
| BUKRS_REPLACE | Company Code | BUKRS | CHAR | 4 | |
| RANL_REPLACE | Contract Number | RANL | CHAR | 13 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | |
| IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR | 34 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDAUSZ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDAUSZ | BANKS | 1: 1 | T005 |
| VDAUSZ | BUKRS | 1: 1 | T001 |
| VDAUSZ | DTAWS | : | T015W |
| VDAUSZ | LAND1 | 1: 1 | T005 |
| VDAUSZ | MANDT | 1: 1 | T000 |
| VDAUSZ | REGIO | 1: 1 | T005S |
| VDAUSZ | RETURNKEY | : | VDSEPA_RETCODE |
| VDAUSZ | RETURNRSN | : | VDSEPA_RETRSN |
| VDAUSZ | SCWHR | 1: CN | TCURC |
| VDAUSZ | ZLSCH | : | T042Z |