SAP ABAP Table VDAUSZ_OL (Loans: Payment Data with Text and Control Data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	INTTAB	Structure
Structure	VDAUSZ_OL	Table Relationship Diagram
Short Description	Loans: Payment Data with Text and Control Data

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
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 (Amount)
10	VCBTR	☐	BPAYMENT	WERTV7	CURR	13	2	Payment Amount
11	SCWHR	☐	SPAYMENT	WAERS	CUKY	5	0	Payment Currency	*
12	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
13	SHWHR	☐	SHWHR	WAERS	CUKY	5	0	Local currency	*
14	SGTXT	☐	XITEM	TEXT50	CHAR	50	0	Explanatory Text for Payment
15	.INCLUDE	☐				0	0	Loans: Payment Data (Business Partner) with Text
16	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
17	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
18	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
19	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
20	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
21	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
22	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
23	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
24	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
25	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
26	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
27	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
28	BEZEI	☐	BEZEI20	TEXT20	CHAR	20	0	Description
29	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
30	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
31	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
32	.INCLUDE	☐				0	0	Loans: Payment Data (Payment Details) with Texts
33	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
34	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
35	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
36	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
37	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
38	XBANKS	☐	LANDX	TEXT15	CHAR	15	0	Country Name
39	XBANK	☐	BANK_TXT	TEXT100	CHAR	100	0	Name and City of Bank
40	XZLSCH	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
41	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	T015W
42	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
43	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
44	SDIRECTION	☐	TB_DIRECTION	T_DIRECTION	CHAR	1	0	Payments: Direction of Payment Method
45	.INCLUDE	☐				0	0	SEPA Remittance Information
46	REMIT_INFO	☐	TB_REMIT_INFO	T_REMIT_INFO	CHAR	140	0	SEPA Payment Notes Information
47	IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
48	.INCLUDE	☐				0	0	SEPA Return Information
49	TRANSID	☐	TB_SEPA_TRANSID		CHAR	35	0	SEPA Transaction ID
50	RETURNKEY	☐	TB_SEPA_RETCODES		CHAR	6	0	CML SEPA return codes	VDSEPA_RETCODE
51	RETURNRSN	☐	TB_SEPA_RETRSN		CHAR	4	0	CML: SEPA Return Reasons	VDSEPA_RETRSN
52	POREF	☐	TB_SEPA_PEREF		CHAR	26	0	SEPA Reference Field (Payment Engine)
53	PIREF	☐	TB_SEPA_PEREF		CHAR	26	0	SEPA Reference Field (Payment Engine)
54	.INCLUDE	☐				0	0	Loans: Payment Data (Taxes)
55	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
56	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
57	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
58	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
59	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
60	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
61	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
62	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
63	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
64	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
65	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
66	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
67	.INCLUDE	☐				0	0	Loans: Payment Data (Information Fields)
68	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
69	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
70	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
71	.INCLUDE	☐				0	0	Loans: Payment Data (Control)
72	SFIELD	☐	NAME_FELD	FDNAME	CHAR	30	0	Field name	*
73	SCHECKED	☐	TB_CHECKED	T_CHECKED	CHAR	1	0	Check Status for a Data Record
74	SCHANGED	☐	TB_CHANGED	T_CHANGED	CHAR	1	0	Type of Change to Data Record
75	SKEYCHANGED	☐	TB_KEYCHANGED	T_KEYCHANGED	CHAR	1	0	Key for Changed Payment Data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDAUSZ_OL	DTAWS	T015W	DTAWS
2	VDAUSZ_OL	RETURNKEY	VDSEPA_RETCODE	RETURNKEY
3	VDAUSZ_OL	RETURNRSN	VDSEPA_RETRSN	RETURNRSN

History

Last changed by/on	SAP	20131127
SAP Release Created in