SAP VDZNB_USAGE Payment Postprocessing: Usage of a Payment Postpr. Activity Table data and field list

VDZNB_USAGE is a standard SAP Table which is used to store Payment Postprocessing: Usage of a Payment Postpr. Activity data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDZNB_USAGE table consists of various fields, each holding specific information or linking keys about Payment Postprocessing: Usage of a Payment Postpr. Activity data available in SAP. These include ZNB_KEY (Business Operation Number (Loans)), LFDNR (Sequence Number), POSFLAG (Item Selection Indicator), BZBTYP (Name of processing category)... 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. .

VDZNB_USAGE table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP VDZNB_USAGE table 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 VDZNB_USAGE 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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
ZNB_KEY	Business Operation Number (Loans)	RBO	CHAR	15			RBO
LFDNR	Sequence Number	LFDNR	CHAR	3			LFDNR
POSFLAG	Item Selection Indicator	NPOSFLAG	CHAR	1			CHAR1
BZBTYP	Name of processing category	VVBZBTYP	CHAR	60			DDTEXT
ZART	Target object type	VVZART	CHAR	1			VVZART
ZOBJ	Target object	VVZOBJ	CHAR	13			TEXT13
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
ABETR	Accepted amount	VVABETR	CURR	13(2)			WERT7
WAERS	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
PARTNR	Business Partner Number	BP_PARTNR_NEW	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
PARTNAME	Name 1 (surname for persons, otherwise company name)	BP_NAME1	CHAR	40			TEXT40
WRBTR	Amount in document currency	WRBTR	CURR	13(2)			WERT7
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
HKONT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
REBZT	Follow-On Document Type	REBZT	CHAR	1			REBZT
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
BATYP	Processing category	VVBATYP	CHAR	2	Assigned to domain		VVBATYP
DTRANSREF	Flow data key: System date	VVDTRANS	DATS	8			DATUM
TTRANSREF	Transaction data key: system time	VVTTRANS	TIMS	6			UZEIT
NTRANSREF	Transaction data key: Consecutive number	VVNTRANS	NUMC	4			NUMC4
ZLSCH	Payment Method	SCHZW_BSEG	CHAR	1	Assigned to domain		ZLSCH
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
PARTN	Business Partner	PARTN_EB	CHAR	55			CHAR55
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
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 Keys	BANKK	CHAR	15			BANKK	BNK
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
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
SPRAS	Language Key	SPRAS	LANG	1	Assigned to domain	ISOLA	SPRAS	SPR	H_T002
FITYP	Tax type	J_1AFITP_D	CHAR	2	Assigned to domain		J_1AFITP
STCDT	Tax Number Type	J_1ATOID	CHAR	2	Assigned to domain		J_1ATOID
STKZN	Natural Person	STKZN	CHAR	1			STKZN
STCD3	Tax Number 3	STCD3	CHAR	18			CHAR18
STCD4	Tax Number 4	STCD4	CHAR	18			CHAR18
BKREF	Reference specifications for bank details	BKREF	CHAR	20			CHAR20
J_1KFREPRE	Name of Representative	REPRES	CHAR	10			REPRES
J_1KFTBUS	Type of Business	GESTYP	CHAR	30	Assigned to domain		GESTYP
J_1KFTIND	Type of Industry	INDTYP	CHAR	30	Assigned to domain		INDTYP
ANRED	Title	ANRED	CHAR	15			TEXT15
DDISPO	Payment Date	DDISPO	DATS	8			DATUM
DFAELL	Due date/calculation date	DFAELLIG	DATS	8			DATUM
VBEWA	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
BBWHR	Amount in position currency	BBWHR	CURR	13(2)			WERTV7
.INCLU-P				0
MANDTP	Client	MANDT	CLNT	3	Assigned to domain		MANDT
BUKRSP	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
RANLP	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
DTRANSP	Flow data key: System date	VVDTRANS	DATS	8			DATUM
TTRANSP	Transaction data key: system time	VVTTRANS	TIMS	6			UZEIT
NTRANSP	Transaction data key: Consecutive number	VVNTRANS	NUMC	4			NUMC4
NVERFP	Disposal number within an outpayment	NVERF	NUMC	2			NUM2
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
ZINKZ	Exempted from interest calculation	DZINKZ	CHAR	2			ZINKZ
REMIT_INFO	Payment Notes Info	TB_REMIT_INFO	CHAR	140			T_REMIT_INFO

Key field

Non-key field

< VDZNB_SEPA - Pmnt Postproc.: Storage of SEPA Return Data VDZNH - Payment Postprocessing Header Data: Module Pool TRDZ >

How do I retrieve data from SAP table VDZNB_USAGE using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDZNB_USAGE to SELECT all data from the table
DATA: WA_VDZNB_USAGE TYPE VDZNB_USAGE.

SELECT SINGLE *
FROM VDZNB_USAGE
INTO CORRESPONDING FIELDS OF WA_VDZNB_USAGE
WHERE...

How to access SAP table VDZNB_USAGE

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

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