SAP ABAP Table VDAUSZ (Drawings on Disbursement)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD (Package) Treasury Loans
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD (Package) Treasury Loans
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VDAUSZ | Table Relationship Diagram |
Short Description | Drawings on Disbursement |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Payments: Key Fields | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | RANL | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
5 | DTRANS | VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
6 | TTRANS | VVTTRANS | UZEIT | TIMS | 6 | 0 | Transaction data key: system time | ||
7 | NTRANS | VVNTRANS | NUMC4 | NUMC | 4 | 0 | Transaction data key: Consecutive number | ||
8 | NVERF | NVERF | NUM2 | NUMC | 2 | 0 | Disposal number within an outpayment | ||
9 | .INCLUDE | 0 | 0 | Loans: Payment Data Fields (Not Key Fields) | |||||
10 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
11 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
12 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
13 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
14 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
15 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
16 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
17 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
18 | SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
19 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | * | |
20 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
21 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
22 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
23 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
24 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
25 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
26 | LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
27 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
28 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
29 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
30 | PSKTO | PSKTO | PSKTO | CHAR | 16 | 0 | Account Number of Bank Account At Post Office | ||
31 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
32 | BANKL | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
33 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
34 | STCD1 | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
35 | STCD2 | STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
36 | STKZU | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
37 | STKZA | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
38 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
39 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
40 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | T015W | |
41 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
42 | XCPDK | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
43 | EMPFG | EMPFG | EMPFG | CHAR | 16 | 0 | Payee code | ||
44 | VCBTR | VCBTR | WERTV7 | CURR | 13 | 2 | Drawing Amount from Disbursement | ||
45 | SCWHR | SCWHR | WAERS | CUKY | 5 | 0 | Settlement Currency | TCURC | |
46 | BHWHR | BHWHR | WERTV7 | CURR | 13 | 2 | Amount in local currency | ||
47 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
48 | PARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
49 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
50 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
51 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
52 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
53 | DDISPO | TB_DISB_DDISPO | DATUM | DATS | 8 | 0 | Payment Date (Drawing) | ||
54 | BUKRS_REPLACE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
55 | RANL_REPLACE | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
56 | RBO | RBO | RBO | CHAR | 15 | 0 | Business Operation Number (Loans) | ||
57 | .INCLUDE | 0 | 0 | SEPA Remittance Information | |||||
58 | REMIT_INFO | TB_REMIT_INFO | T_REMIT_INFO | CHAR | 140 | 0 | SEPA Payment Notes Information | ||
59 | IBAN | BU_IBAN | CHAR34 | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
60 | .INCLUDE | 0 | 0 | SEPA Return Information | |||||
61 | TRANSID | TB_SEPA_TRANSID | CHAR | 35 | 0 | SEPA Transaction ID | |||
62 | RETURNKEY | TB_SEPA_RETCODES | CHAR | 6 | 0 | CML SEPA return codes | VDSEPA_RETCODE | ||
63 | RETURNRSN | TB_SEPA_RETRSN | CHAR | 4 | 0 | CML: SEPA Return Reasons | VDSEPA_RETRSN | ||
64 | POREF | TB_SEPA_PEREF | CHAR | 26 | 0 | SEPA Reference Field (Payment Engine) | |||
65 | PIREF | TB_SEPA_PEREF | CHAR | 26 | 0 | SEPA Reference Field (Payment Engine) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VDAUSZ | BANKS | T005 | LAND1 | KEY | 1 | 1 |
2 | VDAUSZ | BUKRS | T001 | BUKRS | KEY | 1 | 1 |
3 | VDAUSZ | DTAWS | T015W | DTAWS | |||
4 | VDAUSZ | LAND1 | T005 | LAND1 | KEY | 1 | 1 |
5 | VDAUSZ | MANDT | T000 | MANDT | KEY | 1 | 1 |
6 | VDAUSZ | REGIO | T005S | BLAND | KEY | 1 | 1 |
7 | VDAUSZ | RETURNKEY | VDSEPA_RETCODE | RETURNKEY | |||
8 | VDAUSZ | RETURNRSN | VDSEPA_RETRSN | RETURNRSN | |||
9 | VDAUSZ | SCWHR | TCURC | WAERS | KEY | 1 | CN |
10 | VDAUSZ | ZLSCH | T042Z | ZLSCH |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |