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
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| ZNB_KEY | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| LFDNR | Sequence Number | LFDNR | CHAR | 3 | |
| POSFLAG | Item Selection Indicator | NPOSFLAG | CHAR | 1 | |
| BZBTYP | Name of processing category | VVBZBTYP | CHAR | 60 | |
| ZART | Target object type | VVZART | CHAR | 1 | |
| ZOBJ | Target object | VVZOBJ | CHAR | 13 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| ABETR | Accepted amount | VVABETR | CURR | 13 | |
| WAERS | Currency Key | WAERS | CUKY | 5 | |
| PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | |
| PARTNAME | Name 1 (surname for persons else company name) | BP_NAME1 | CHAR | 40 | |
| WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 13 | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | |
| KUNNR | Customer Number | KUNNR | CHAR | 10 | |
| HKONT | General Ledger Account | HKONT | CHAR | 10 | |
| REBZT | Follow-On Document Type | REBZT | CHAR | 1 | |
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | |
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR | 10 | |
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | |
| BATYP | Processing category | VVBATYP | CHAR | 2 | |
| DTRANSREF | Flow data key: System date | VVDTRANS | DATS | 8 | |
| TTRANSREF | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
| NTRANSREF | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | |
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | |
| PARTN | Business Partner | PARTN_EB | CHAR | 55 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| NAME1 | Name 1 | NAME1_GP | CHAR | 35 | |
| NAME2 | Name 2 | NAME2_GP | CHAR | 35 | |
| NAME3 | Name 3 | NAME3_GP | CHAR | 35 | |
| NAME4 | Name 4 | NAME4_GP | CHAR | 35 | |
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | |
| ORT01 | City | ORT01_GP | CHAR | 35 | |
| LAND1 | Country Key | LAND1_GP | CHAR | 3 | |
| STRAS | Street and House Number | STRAS_GP | CHAR | 35 | |
| PFACH | PO Box | PFACH | CHAR | 10 | |
| PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | |
| PSKTO | PO Bank Current Acct No. or Building Society Ref. No. | PSKTO | CHAR | 16 | |
| BANKN | Bank account number | BANKN | CHAR | 18 | |
| BANKL | Bank Keys | BANKK | CHAR | 15 | |
| BANKS | Bank country key | BANKS | CHAR | 3 | |
| STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | |
| STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | |
| STKZU | Liable for VAT | STKZU | CHAR | 1 | |
| STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | |
| REGIO | Region (State Province County) | REGIO | CHAR | 3 | |
| BKONT | Bank Control Key | BKONT | CHAR | 2 | |
| DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | |
| DTAMS | Report key for data medium exchange | DTAMS | CHAR | 1 | |
| XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | |
| EMPFG | Payment Recipient Code | EMPFG | CHAR | 16 | |
| SPRAS | Language Key | SPRAS | LANG | 1 | |
| FITYP | Tax type | J_1AFITP_D | CHAR | 2 | |
| STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | |
| STKZN | Natural Person | STKZN | CHAR | 1 | |
| STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | |
| STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | |
| BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | |
| J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | |
| J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | |
| J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | |
| ANRED | Title | ANRED | CHAR | 15 | |
| DDISPO | Payment Date | DDISPO | DATS | 8 | |
| DFAELL | Due date/calculation date | DFAELLIG | DATS | 8 | |
| VBEWA | Flow Type | SBEWART | CHAR | 4 | |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| MANDTP | Client | MANDT | * | CLNT | 3 |
| BUKRSP | Company Code | BUKRS | CHAR | 4 | |
| RANLP | Contract Number | RANL | CHAR | 13 | |
| DTRANSP | Flow data key: System date | VVDTRANS | DATS | 8 | |
| TTRANSP | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
| NTRANSP | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| NVERFP | Disposal number within an outpayment | NVERF | NUMC | 2 | |
| IBAN | IBAN (International Bank Account Number) | BU_IBAN | CHAR | 34 | |
| ZINKZ | Exempted from Interest Calculation | DZINKZ | CHAR | 2 | |
| REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | |
| HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 |
| HKTID | ID for Account Details | HKTID | T012K | CHAR | 5 |
| DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 13 |
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 Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDZNB_USAGE | HBKID | : | T012 |
| VDZNB_USAGE | HKTID | : | T012K |
| VDZNB_USAGE | RETURNKEY | : | VDSEPA_RETCODE |
| VDZNB_USAGE | RETURNRSN | : | VDSEPA_RETRSN |