SAP VDZNB_USAGE Payment Postprocessing: Usage of a Payment Postpr. Activity Table

Overview

VDZNB_USAGE is a standard SAP S/4HANA table that stores Payment Postprocessing: Usage of a Payment Postpr. Activity data. There are total 83 fields in the VDZNB_USAGE table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VDZNB_USAGE belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).

In addition, following links provide an overview of foreign key relationships, if any, that link VDZNB_USAGE to other SAP tables and standard CDS views available based on VDZNB_USAGE table in S/4HANA 2020.

Techincal Settings of VDZNB_USAGE

Below are technical details of the table VDZNB_USAGE

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VDZNB_USAGE Fields

The following table gives you an overview of the fields available in VDZNB_USAGE

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
ZNB_KEYBusiness Operation Number (Loans)RBOCHAR15
LFDNRSequence NumberLFDNRCHAR3
POSFLAGItem Selection IndicatorNPOSFLAGCHAR1
BZBTYPName of processing categoryVVBZBTYPCHAR60
ZARTTarget object typeVVZARTCHAR1
ZOBJTarget objectVVZOBJCHAR13
SGTXTItem TextSGTXTCHAR50
ABETRAccepted amountVVABETRCURR13
WAERSCurrency KeyWAERSCUKY5
PARTNRBusiness Partner NumberBP_PARTNR_NEWCHAR10
PARTNAMEName 1 (surname for persons else company name)BP_NAME1CHAR40
WRBTRAmount in Document CurrencyWRBTR_CSCURR13
SHKZGDebit/Credit IndicatorSHKZGCHAR1
KUNNRCustomer NumberKUNNRCHAR10
HKONTGeneral Ledger AccountHKONTCHAR10
REBZTFollow-On Document TypeREBZTCHAR1
REBZJFiscal Year of the Relevant Invoice (for Credit Memo)REBZJNUMC4
REBZGDocument No. of the Invoice to Which the Transaction BelongsREBZGCHAR10
REBZZLine Item in the Relevant InvoiceREBZZNUMC3
BATYPProcessing categoryVVBATYPCHAR2
DTRANSREFFlow data key: System dateVVDTRANSDATS8
TTRANSREFTransaction data key: system timeVVTTRANSTIMS6
NTRANSREFTransaction data key: Consecutive numberVVNTRANSNUMC4
ZLSCHPayment MethodSCHZW_BSEGCHAR1
ZFBDTBaseline Date for Due Date CalculationDZFBDTDATS8
PARTNBusiness PartnerPARTN_EBCHAR55
BUKRSCompany CodeBUKRSCHAR4
BELNRAccounting Document NumberBELNR_DCHAR10
GJAHRFiscal YearGJAHRNUMC4
BUZEINumber of Line Item Within Accounting DocumentBUZEINUMC3
NAME1Name 1NAME1_GPCHAR35
NAME2Name 2NAME2_GPCHAR35
NAME3Name 3NAME3_GPCHAR35
NAME4Name 4NAME4_GPCHAR35
PSTLZPostal CodePSTLZCHAR10
ORT01CityORT01_GPCHAR35
LAND1Country KeyLAND1_GPCHAR3
STRASStreet and House NumberSTRAS_GPCHAR35
PFACHPO BoxPFACHCHAR10
PSTL2P.O. Box Postal CodePSTL2CHAR10
PSKTOPO Bank Current Acct No. or Building Society Ref. No.PSKTOCHAR16
BANKNBank account numberBANKNCHAR18
BANKLBank KeysBANKKCHAR15
BANKSBank country keyBANKSCHAR3
STCD1Tax Number 1STCD1CHAR16
STCD2Tax Number 2STCD2CHAR11
STKZULiable for VATSTKZUCHAR1
STKZAIndicator: Business Partner Subject to Equalization Tax?STKZACHAR1
REGIORegion (State Province County)REGIOCHAR3
BKONTBank Control KeyBKONTCHAR2
DTAWSInstruction key for data medium exchangeDTAWSCHAR2
DTAMSReport key for data medium exchangeDTAMSCHAR1
XCPDKIndicator: Is the account a one-time account?XCPDKCHAR1
EMPFGPayment Recipient CodeEMPFGCHAR16
SPRASLanguage KeySPRASLANG1
FITYPTax typeJ_1AFITP_DCHAR2
STCDTTax Number TypeJ_1ATOIDCHAR2
STKZNNatural PersonSTKZNCHAR1
STCD3Tax Number 3STCD3CHAR18
STCD4Tax Number 4STCD4CHAR18
BKREFReference specifications for bank detailsBKREFCHAR20
J_1KFREPREName of RepresentativeREPRESCHAR10
J_1KFTBUSType of BusinessGESTYPCHAR30
J_1KFTINDType of IndustryINDTYPCHAR30
ANREDTitleANREDCHAR15
DDISPOPayment DateDDISPODATS8
DFAELLDue date/calculation dateDFAELLIGDATS8
VBEWAFlow TypeSBEWARTCHAR4
BBWHRAmount in position currencyBBWHRCURR13
MANDTPClientMANDT*CLNT3
BUKRSPCompany CodeBUKRSCHAR4
RANLPContract NumberRANLCHAR13
DTRANSPFlow data key: System dateVVDTRANSDATS8
TTRANSPTransaction data key: system timeVVTTRANSTIMS6
NTRANSPTransaction data key: Consecutive numberVVNTRANSNUMC4
NVERFPDisposal number within an outpaymentNVERFNUMC2
IBANIBAN (International Bank Account Number)BU_IBANCHAR34
ZINKZExempted from Interest CalculationDZINKZCHAR2
REMIT_INFOPayment Notes InfoTB_REMIT_INFOCHAR140
HBKIDShort Key for a House BankHBKIDT012CHAR5
HKTIDID for Account DetailsHKTIDT012KCHAR5
DMBTRAmount in Local CurrencyDMBTR_CSCURR13

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDZNB_USAGE

Table NameFieldCardinalityCheck Table
VDZNB_USAGEHBKID:T012
VDZNB_USAGEHKTID:T012K
VDZNB_USAGERETURNKEY:VDSEPA_RETCODE
VDZNB_USAGERETURNRSN:VDSEPA_RETRSN

Other References