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

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