SAP ABAP Table VDAUSZ_FIELDS (Loans: Payment Data Fields (Not Key Fields))

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_FIELDS	Table Relationship Diagram
Short Description	Loans: Payment Data Fields (Not Key Fields)

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	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
2	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
3	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
4	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
5	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
6	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
7	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
8	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
9	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
10	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
11	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
12	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
13	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
14	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
15	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
17	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
18	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
19	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
20	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
21	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
22	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
23	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
24	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
25	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
26	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
27	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
28	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
29	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
30	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
31	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
32	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
33	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
34	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
35	VCBTR	☐	VCBTR	WERTV7	CURR	13	2	Drawing Amount from Disbursement
36	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	*
37	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
38	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
39	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
40	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
41	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
42	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
43	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
44	DDISPO	☐	TB_DISB_DDISPO	DATUM	DATS	8	0	Payment Date (Drawing)
45	BUKRS_REPLACE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
46	RANL_REPLACE	☐	RANL	RANL	CHAR	13	0	Contract Number
47	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
48	.INCLUDE	☐				0	0	SEPA Remittance Information
49	REMIT_INFO	☐	TB_REMIT_INFO	T_REMIT_INFO	CHAR	140	0	SEPA Payment Notes Information
50	IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
51	.INCLUDE	☐				0	0	SEPA Return Information
52	TRANSID	☐	TB_SEPA_TRANSID		CHAR	35	0	SEPA Transaction ID
53	RETURNKEY	☐	TB_SEPA_RETCODES		CHAR	6	0	CML SEPA return codes	VDSEPA_RETCODE
54	RETURNRSN	☐	TB_SEPA_RETRSN		CHAR	4	0	CML: SEPA Return Reasons	VDSEPA_RETRSN
55	POREF	☐	TB_SEPA_PEREF		CHAR	26	0	SEPA Reference Field (Payment Engine)
56	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_FIELDS	RETURNKEY	VDSEPA_RETCODE	RETURNKEY
2	VDAUSZ_FIELDS	RETURNRSN	VDSEPA_RETRSN	RETURNRSN

History

Last changed by/on	SAP	20131127
SAP Release Created in