SAP VDAUSZ_FIELDS Loans: Payment Data Fields (Not Key Fields) Table data and field list

VDAUSZ_FIELDS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Loans: Payment Data Fields (Not Key Fields)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VDAUSZ_FIELDS TYPE VDAUSZ_FIELDS.

The VDAUSZ_FIELDS table consists of various fields, each holding specific information or linking keys about Loans: Payment Data Fields (Not Key Fields) data available in SAP. These include DERF (First Entered on), TERF (Time of Initial Entry), REHER (Source of initial entry), RBEAR (Employee ID)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VDAUSZ_FIELDS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP VDAUSZ_FIELDS structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDAUSZ_FIELDS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
RERF	Entered by	RERF	CHAR	12			SYCHAR12
DERF	First Entered on	DERF	DATS	8			DATUM
TERF	Time of Initial Entry	TERF	TIMS	6			TIMES
REHER	Source of initial entry	REHER	CHAR	10			CHAR10
RBEAR	Employee ID	RBEAR	CHAR	12			SYCHAR12
DBEAR	Last Edited on	DBEAR	DATS	8			DATUM
TBEAR	Last Edited at	TBEAR	TIMS	6			TIMES
RBHER	Editing Source	RBHER	CHAR	10			CHAR10
SBEWART	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
SANLF	Product Category	SANLF	NUMC	3	Assigned to domain		VVSANLF
NAME1	Name 1	NAME1_GP	CHAR	35			NAME
NAME2	Name 2	NAME2_GP	CHAR	35			NAME
NAME3	Name 3	NAME3_GP	CHAR	35			NAME
NAME4	Name 4	NAME4_GP	CHAR	35			NAME
PSTLZ	Postal Code	PSTLZ	CHAR	10			PSTLZ
ORT01	City	ORT01_GP	CHAR	35			TEXT35
LAND1	Country Key	LAND1_GP	CHAR	3	Assigned to domain		LAND1		C_LAND1
STRAS	House number and street	STRAS_GP	CHAR	35			TEXT35
PFACH	PO Box	PFACH	CHAR	10			PFACH
PSTL2	P.O. Box Postal Code	PSTL2	CHAR	10			PSTLZ
PSKTO	Account Number of Bank Account At Post Office	PSKTO	CHAR	16			PSKTO
BANKN	Bank account number	BANKN	CHAR	18			BANKN
BANKL	Bank number	BANKL	CHAR	15			BANKL	BLZ
BANKS	Bank country key	BANKS	CHAR	3	Assigned to domain		LAND1	BKL
STCD1	Tax Number 1	STCD1	CHAR	16			STCD1
STCD2	Tax Number 2	STCD2	CHAR	11			STCD2
STKZU	Liable for VAT	STKZU	CHAR	1			XFELD
STKZN	Natural Person	STKZN	CHAR	1			STKZN
STKZA	Indicator: Business Partner Subject to Equalization Tax?	STKZA	CHAR	1			STKZA
REGIO	STATE (State, Province, County)	REGIO	CHAR	3	Assigned to domain		REGIO
BKONT	Bank Control Key	BKONT	CHAR	2			BKONT
DTAWS	Instruction key for data medium exchange	DTAWS	CHAR	2	Assigned to domain		DTAWS
DTAMS	Indicator for Data Medium Exchange	DTAMS	CHAR	1			DTAMS
XCPDK	Indicator: Is the account a one-time account?	XCPDK	CHAR	1			XFELD
EMPFG	Payee code	EMPFG	CHAR	16			EMPFG
VCBTR	Drawing Amount from Disbursement	VCBTR	CURR	13(2)			WERTV7
SCWHR	Settlement Currency	SCWHR	CUKY	5	Assigned to domain		WAERS
BHWHR	Amount in local currency	BHWHR	CURR	13(2)			WERTV7
ZLSCH	Payment Method	DZLSCH	CHAR	1	Assigned to domain		ZLSCH
PARTNR	Business Partner Number	BP_PARTNR_NEW	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
BVTYP	Partner Bank Type	BVTYP	CHAR	4			BVTYP
SPRAS	Language Key	SPRAS	LANG	1	Assigned to domain	ISOLA	SPRAS	SPR	H_T002
ANRED	Title	ANRED	CHAR	15			TEXT15
DDISPO	Payment Date (Drawing)	TB_DISB_DDISPO	DATS	8			DATUM
BUKRS_REPLACE	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
RANL_REPLACE	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
RBO	Business Operation Number (Loans)	RBO	CHAR	15			RBO
REMIT_INFO	Payment Notes Info	TB_REMIT_INFO	CHAR	140			T_REMIT_INFO
IBAN	IBAN (International Bank Account Number)	BU_IBAN	CHAR	34			CHAR34
TRANSID	SEPA Transaction ID	TB_SEPA_TRANSID	CHAR	35
RETURNKEY	CML SEPA return codes	TB_SEPA_RETCODES	CHAR	6	VDSEPA_RETCODE
RETURNRSN	CML: SEPA Return Reason	TB_SEPA_RETRSN	CHAR	4	VDSEPA_RETRSN
POREF	SEPA Reference Field (Payment Engine)	TB_SEPA_PEREF	CHAR	26
PIREF	SEPA Reference Field (Payment Engine)	TB_SEPA_PEREF	CHAR	26

Key field

Non-key field

< VDAUSZ_EU - Disbursement Drawings Before EURO Conversion VDAUSZ_HEAD_OL - Loans: Payment Data (Header) >

How do I retrieve data from SAP structure VDAUSZ_FIELDS using ABAP code?

As VDAUSZ_FIELDS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VDAUSZ_FIELDS as there is no data to select.

How to access SAP table VDAUSZ_FIELDS

Within an ECC or HANA version of SAP you can also view further information about VDAUSZ_FIELDS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).