1. SAP Tutorial
  2. Financial Services

VDZNB_USAGE SAP table for – Payment Postprocessing: Usage of a Payment Postpr. Activity

Here we would like to draw your attention to VDZNB_USAGE table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDZNB_USAGE is a SAP standard transp table used for storing Payment Postprocessing: Usage of a Payment Postpr. Activity related data in SAP. It comes under the package FVVD.

SAP VDZNB_USAGE table

Table VDZNB_USAGE technical data

TableVDZNB_USAGE
Data storingPayment Postprocessing: Usage of a Payment Postpr. Activity
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDZNB_USAGE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDZNB_USAGE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ZNB_KEY : Business Operation Number (Loans)
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • LFDNR : Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • POSFLAG : Item Selection Indicator
    Its data type is CHAR (Character String) with field length 1
  • BZBTYP : Name of processing category
    Its data type is CHAR (Character String) with field length 60
  • ZART : Target object type
    Its data type is CHAR (Character String) with field length 1
  • ZOBJ : Target object
    Its data type is CHAR (Character String) with field length 13
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • ABETR : Accepted amount
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PARTNR : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • PARTNAME : Name 1 (surname for persons, otherwise company name)
    Its data type is CHAR (Character String) with field length 40
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • REBZT : Follow-On Document Type
    Its data type is CHAR (Character String) with field length 1
  • REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • REBZZ : Line Item in the Relevant Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BATYP : Processing category
    Its data type is CHAR (Character String) with field length 2
  • DTRANSREF : Flow data key: System date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TTRANSREF : Transaction data key: system time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • NTRANSREF : Transaction data key: Consecutive number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ZLSCH : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PARTN : Business Partner
    Its data type is CHAR (Character String) with field length 55
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NAME1 : Name 1
    Its data type is CHAR (Character String) with field length 35
  • NAME2 : Name 2
    Its data type is CHAR (Character String) with field length 35
  • NAME3 : Name 3
    Its data type is CHAR (Character String) with field length 35
  • NAME4 : Name 4
    Its data type is CHAR (Character String) with field length 35
  • PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • ORT01 : City
    Its data type is CHAR (Character String) with field length 35
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • STRAS : House number and street
    Its data type is CHAR (Character String) with field length 35
  • PFACH : PO Box
    Its data type is CHAR (Character String) with field length 10
  • PSTL2 : P.O. Box Postal Code
    Its data type is CHAR (Character String) with field length 10
  • PSKTO : Account Number of Bank Account At Post Office
    Its data type is CHAR (Character String) with field length 16
  • BANKN : Bank account number
    Its data type is CHAR (Character String) with field length 18
  • BANKL : Bank Keys
    Its data type is CHAR (Character String) with field length 15
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • STCD1 : Tax Number 1
    Its data type is CHAR (Character String) with field length 16
  • STCD2 : Tax Number 2
    Its data type is CHAR (Character String) with field length 11
  • STKZU : Liable for VAT
    Its data type is CHAR (Character String) with field length 1
  • STKZA : Indicator: Business Partner Subject to Equalization Tax?
    Its data type is CHAR (Character String) with field length 1
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • BKONT : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • DTAWS : Instruction key for data medium exchange
    Its data type is CHAR (Character String) with field length 2
  • DTAMS : Report key for data medium exchange
    Its data type is CHAR (Character String) with field length 1
  • XCPDK : Indicator: Is the account a one-time account?
    Its data type is CHAR (Character String) with field length 1
  • EMPFG : Payee code
    Its data type is CHAR (Character String) with field length 16
  • SPRAS : Language Key
    Its data type is LANG (Language key character with length 1) with field length 1
  • FITYP : Tax type
    Its data type is CHAR (Character String) with field length 2
  • STCDT : Tax Number Type
    Its data type is CHAR (Character String) with field length 2
  • STKZN : Natural Person
    Its data type is CHAR (Character String) with field length 1
  • STCD3 : Tax Number 3
    Its data type is CHAR (Character String) with field length 18
  • STCD4 : Tax Number 4
    Its data type is CHAR (Character String) with field length 18
  • BKREF : Reference specifications for bank details
    Its data type is CHAR (Character String) with field length 20
  • J_1KFREPRE : Name of Representative
    Its data type is CHAR (Character String) with field length 10
  • J_1KFTBUS : Type of Business
    Its data type is CHAR (Character String) with field length 30
  • J_1KFTIND : Type of Industry
    Its data type is CHAR (Character String) with field length 30
  • ANRED : Title
    Its data type is CHAR (Character String) with field length 15
  • DDISPO : Payment Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFAELL : Due date/calculation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBEWA : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • BBWHR : Amount in position currency
    Its data type is CURR (Currency Field) with field length 13
  • .INCLU-P : Payments: Key Fields
  • MANDTP : Client
    Its data type is CLNT (Character with length 3) with field length 3
  • BUKRSP : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RANLP : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • DTRANSP : Flow data key: System date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TTRANSP : Transaction data key: system time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • NTRANSP : Transaction data key: Consecutive number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • NVERFP : Disposal number within an outpayment
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • IBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • .INCLUDE : SEPA Return Information
  • TRANSID : SEPA Transaction ID
    Its data type is CHAR (Character String) with field length 35
  • RETURNKEY : CML SEPA return codes
    Its data type is CHAR (Character String) with field length 6
  • RETURNRSN : CML: SEPA Return Reasons
    Its data type is CHAR (Character String) with field length 4
  • POREF : SEPA Reference Field (Payment Engine)
    Its data type is CHAR (Character String) with field length 26
  • PIREF : SEPA Reference Field (Payment Engine)
    Its data type is CHAR (Character String) with field length 26
  • ZINKZ : Exempted from Interest Calculation
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : SEPA Remittance Information
  • REMIT_INFO : SEPA Payment Notes Information
    Its data type is CHAR (Character String) with field length 140

    • VDZNB_USAGE related tables

    • VDMEPOM : Condition Table: Modification Item
    • TDDG1 : Value table 1 User-specific loans key
    • VDZKP : Assign Partner / Correspondence Class not Required
    • TDL1 : Collat.securities preferential treatment ID table
    • TD01 : Table for collateral keys
    • VDARL_RP : Loan Contract – Data of Repayment Plan
    • TDFLOW_EXT : Permitted Flow Types Per Region
    • TDP2T : File Functions Texts
    • TDL21 : Indicator Table Guarantee Type 2
    • TDB08 : Flow Types per Posting Application Additional Data
    • TDA11 : Allocation of OK-codes to the trans.codes
    • TDO7T : Text table for administration cost elements
    • TRISKCLASS_T : Description of Risk Classes TRISKCLASS
    • VDBOHEAD : Business Operation: Header
    • VDHOKO : Main file header
    • VDSEPA_AUTODEB_O : Records for new auto debit (SEPA direct debit)
    • VDCHK_GROSS_NET : Data Storage for Report RFVD_GROSS_TO_NET
    • TD47D : Form selection legal dunning procedure in loans
    • VDPOPO : File item
    • TD28T : Notice arrangements (lender)

    VDZNB_USAGE related transaction codes under SAP package FVVD

    • S_ALR_87004277 : IMG Activity: SIMG_CFMENUFNMCFZW0
    • S_ALR_87004557 : IMG Activity: SIMG_CFMENUFNMCFOCP
    • FN31 : Change policy interested party
    • S_ALR_87004593 : IMG Activity: SIMG_CFMENUFNMCFZ18
    • FNV3 : Display mortgage contract
    • FNX1 : Rollover: Create Table
    • FNK0 : Multimillion Loan Display (GBA14)
    • FNVS : Display Contract
    • S_ALR_87004644 : IMG Activity: SIMG_CFMENUFNMCFNCK
    • FN1V : Create other loan contract
    • FNWF_REP : Release Workflow: Synchronization
    • FNAI : Reactivate deleted other loan cntrct
    • FNX8 : Rollover: Print Table
    • S_ALR_87004436 : IMG Activity: SIMG_CFMENUFNMCFWR1
    • FMN8 : Loans: Due Date List for Plan. Recs
    • S_ALR_87004063 : IMG Activity: SIMG_CFMENUFNMCFODQ
    • FN09 : Create Borrower’s Note Order
    • S_ALR_87003698 : IMG Activity: VORGANGORDNER
    • FNASL : Loans: Account Analysis
    • S_ALR_87003870 : IMG Activity: SIMG_CFMENUFNMCFNFA

    Related References

    Related Tutorials

    VDZNB_PAYINFO SAP table for – Payment Postprocessing: Payment Inform. for a PPP Activity

    VDZNB_PAYINFO table in SAP FS (Loans Management in FS) module. This table is used for storing data of Payment Postprocessing:...

    VDZNB_HEAD SAP table for – Pmnt Postproc.: Header for a Payment Postprocessing Activity

    VDZNB_HEAD table in SAP FS (Loans Management in FS) module. This table is used for storing data of Pmnt Postproc.:...

    VDZNB_PAYMENT SAP table for – Payment Postprocessing: Payments for a PPP Activity

    VDZNB_PAYMENT table in SAP FS (Loans Management in FS) module. This table is used for storing data of Payment Postprocessing:...

    TDMAZNB SAP table for – Customizing: Automatic Incoming Payment Postprocessing

    TDMAZNB table in SAP FS (Loans Management in FS) module. This table is used for storing data of Customizing: Automatic...

    FZNB SAP tcode for – Payment Postprocessing

    FZNB tcode in SAP FS (Loans Management in FS) module. This transaction code is used for Payment Postprocessing. See the...

    TZB34 SAP table for – Payment PP: Default Payment Meth. for Refund by Bank Transf.

    TZB34 table in SAP FS (Loans Management in FS) module. This table is used for storing data of Payment PP:...

    VDSEPA_PM SAP table for – CML specific Customizing for Payment Method (SEPA)

    VDSEPA_PM table in SAP FS (Loans Management in FS) module. This table is used for storing data of CML specific...

    «
    »