1. SAP Tutorial
  2. FI Module

DPAYH SAP table for – Payment program – data for payment

Here we would like to draw your attention to DPAYH table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DPAYH is a SAP standard transp table used for storing Payment program – data for payment related data in SAP. It comes under the package FKKB.

SAP DPAYH table

Table DPAYH technical data

TableDPAYH
Data storingPayment program – data for payment
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DPAYH 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 DPAYH table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LAUFD : Date ID
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI : Identification for the payment run
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • ORIGN : Source of the payment data
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • XVORL : Indicator: Only Proposal Run?
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • PAYNO : Sequential payment number
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SUBNO : Additional distinguishing criterion from payments
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • GRPNO : Grouping criterium for payments
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PMF_KEY : Redundant Key for Payment Medium Print
    Its data type is CHAR (Character String) with field length 15
  • SRTF1 : Format-specific sorting of payment data
    Its data type is CHAR (Character String) with field length 20
  • SRTF2 : User-defined sorting of payment data
    Its data type is CHAR (Character String) with field length 48
  • XAVIS : Output payment advice
    Its data type is CHAR (Character String) with field length 1
  • ORG1T : Type of Organization
    Its data type is CHAR (Character String) with field length 2
  • ORG1R : Reference for Organization
    Its data type is CHAR (Character String) with field length 8
  • ORG2T : Type of organization for which the payment is made
    Its data type is CHAR (Character String) with field length 2
  • ORG2R : Reference to the Organization for Which the Payment is Made
    Its data type is CHAR (Character String) with field length 8
  • GPA1T : Business Partner Category
    Its data type is CHAR (Character String) with field length 2
  • GPA1R : Business Partner Reference
    Its data type is CHAR (Character String) with field length 12
  • ACC1T : Contract Account Category
    Its data type is CHAR (Character String) with field length 2
  • ACC1R : Reference to Contract Account
    Its data type is CHAR (Character String) with field length 18
  • DOC1T : Payment document category
    Its data type is CHAR (Character String) with field length 2
  • DOC1R : Reference to Payment Document
    Its data type is CHAR (Character String) with field length 24
  • MASTT : Master record type for payment items
    Its data type is CHAR (Character String) with field length 2
  • MASTR : Master Record Reference for Payment Item
    Its data type is CHAR (Character String) with field length 20
  • ZADNR : Address number
    Its data type is CHAR (Character String) with field length 10
  • ZNME1 : Name of the Payee
    Its data type is CHAR (Character String) with field length 40
  • ZNME2 : Name of the Payee
    Its data type is CHAR (Character String) with field length 40
  • ZSPRA : Language Key
    Its data type is LANG (Language key character with length 1) with field length 1
  • ZLAND : Country Key
    Its data type is CHAR (Character String) with field length 3
  • ZREGI : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • ZORT1 : City
    Its data type is CHAR (Character String) with field length 40
  • ZORT2 : District
    Its data type is CHAR (Character String) with field length 40
  • ZORTP : PO Box city
    Its data type is CHAR (Character String) with field length 40
  • ZPST1 : City postal code
    Its data type is CHAR (Character String) with field length 10
  • ZPST2 : PO Box postal code
    Its data type is CHAR (Character String) with field length 10
  • ZPST3 : Company postal code (for large customers)
    Its data type is CHAR (Character String) with field length 10
  • ZPFAC : PO Box
    Its data type is CHAR (Character String) with field length 10
  • ZSTRA : Street
    Its data type is CHAR (Character String) with field length 60
  • ZSTR1 : House Number
    Its data type is CHAR (Character String) with field length 10
  • ZSTR2 : House number supplement
    Its data type is CHAR (Character String) with field length 10
  • ZTEL1 : Telephone no.: dialling code+number
    Its data type is CHAR (Character String) with field length 30
  • ZTEL2 : Telephone no.: Extension
    Its data type is CHAR (Character String) with field length 10
  • ZFAX1 : Fax number: dialling code+number
    Its data type is CHAR (Character String) with field length 30
  • ZFAX2 : Fax no.: Extension
    Its data type is CHAR (Character String) with field length 10
  • ZBNKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • ZBNKY : Bank key of the payee’s bank
    Its data type is CHAR (Character String) with field length 15
  • ZBNKL : Bank number of the payee’s bank
    Its data type is CHAR (Character String) with field length 15
  • ZSWIF : SWIFT/BIC for International Payments
    Its data type is CHAR (Character String) with field length 11
  • ZBNKN : Bank account number of the payee
    Its data type is CHAR (Character String) with field length 18
  • ZBKON : Bank Control Key of the Payee’s Bank
    Its data type is CHAR (Character String) with field length 2
  • ZBKRF : Reference specifications for bank details
    Its data type is CHAR (Character String) with field length 20
  • ZBKIN : Name of Holder of Bank Account/Check Issuer/Cardholder
    Its data type is CHAR (Character String) with field length 60
  • BBUKR : Company Code in Payment Document
    Its data type is CHAR (Character String) with field length 4
  • BGSBR : Business area in payment document
    Its data type is CHAR (Character String) with field length 4
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RBETR : Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • RWBTR : Amount Paid in the Payment Currency
    Its data type is CURR (Currency Field) with field length 13
  • RSKON : Total Cash Discount for the Payment Trans. (Local Currency)
    Its data type is CURR (Currency Field) with field length 13
  • RWSKT : Total Cash Discount for the Pmnt Transactn in Pmnt Currency
    Its data type is CURR (Currency Field) with field length 13
  • ZALDT : Posting date of the payment document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIFFB : Difference Amount in Clearing Processing
    Its data type is CURR (Currency Field) with field length 13
  • AUSFD : Due date of the paid items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RZAWE : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • AVISG : Reason for Printing Payment Advice
    Its data type is CHAR (Character String) with field length 1
  • RPOST : Number of Items Paid
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RTEXT : Number of Text Lines for the Items Paid
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PYGRP : Grouping field for automatic payments
    Its data type is CHAR (Character String) with field length 10
  • PAYGR : Generated grouping field in payments
    Its data type is CHAR (Character String) with field length 50
  • EIGBV : Own Bank Details
    Its data type is CHAR (Character String) with field length 25
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • HKTID : ID for account details
    Its data type is CHAR (Character String) with field length 5
  • UBNKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • UBNKY : Bank key of our bank
    Its data type is CHAR (Character String) with field length 15
  • UBNKL : Bank number of our bank
    Its data type is CHAR (Character String) with field length 15
  • UBKNT : Our account number at the bank
    Its data type is CHAR (Character String) with field length 18
  • UBKON : Bank control key at our bank
    Its data type is CHAR (Character String) with field length 2
  • UBHKT : G/L Account Number for Our Bank Account / Bank Sub-Account
    Its data type is CHAR (Character String) with field length 10
  • 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
  • TXTSL : Text key for the code line on the form
    Its data type is CHAR (Character String) with field length 2
  • TXERG : Text key supplement
    Its data type is CHAR (Character String) with field length 3
  • CCINS : Payment card type
    Its data type is CHAR (Character String) with field length 4
  • CCNUM : Payment cards: Card number
    Its data type is CHAR (Character String) with field length 25
  • RQSTW : Withholding Tax In Payment Currency (Credit-Side)
    Its data type is CURR (Currency Field) with field length 13
  • RQSTH : Withholding Tax In Local Currency (Credit-Side)
    Its data type is CURR (Currency Field) with field length 13
  • RQSEW : Withholding Tax In Payment Currency (Debit-Side)
    Its data type is CURR (Currency Field) with field length 13
  • RQSEH : Withholding Tax In Local Currency (Debit-Side)
    Its data type is CURR (Currency Field) with field length 13
  • ORIBD : Payment Program: Origin of Business Partner Bank Data
    Its data type is CHAR (Character String) with field length 1
  • XNOLC : Payment Program: Local Currency Amounts Incomplete
    Its data type is CHAR (Character String) with field length 1
  • ZIBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • PDKEY : Number of Payment Specification
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • PDREF : Reference Number of Payment Specification
    Its data type is CHAR (Character String) with field length 16
  • MGUID : Generic Data Element for GUID Fields (X16)
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Payment Cards: Data for Encryption
  • CGUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • ENCTP : Type of Encryption
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Payment Program – Data for Payment (SEPA Mandate)
  • PAY_TYPE : SEPA: Payment Type
    Its data type is CHAR (Character String) with field length 1
  • SEQ_TYPE : SEPA: Sequence Type
    Its data type is CHAR (Character String) with field length 4
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35
  • B2B : SEPA-Mandate: B2B Mandate
    Its data type is CHAR (Character String) with field length 1
  • INST_CODE : Local Instrument Code (Direct Debit Type)
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Insurance Industry Include for DPAYH
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • DPAYH related tables

    • FKKCLEBR : Auxillary Structure for Lock Object EFKKCLEBR
    • TFK056ST : Blocking Reasons for Interest Calculation (Text Table)
    • TFK053R04T : Follow-Up Actions: Texts for Returns Reversal Activity Var.
    • DFKKZP_ARCIND : Link between Document Number and Archived Payment Lot
    • TFKPAYMFBC : Payment Medium: Installation-Specific Modules
    • DFKKNRP : NOC Returns Lot: Item Data
    • TFKAUTHT_EBPP : Processing Functions with Authorization Protection (BD)
    • TFK044C : FI-CA Valuation Variant
    • DFKKPC_LOGP : Payment Cards: Billing Log (Payments)
    • DFKKIAPT : Interest Calculation: Log for Interest Run
    • TFK056T : Interest Key Text Table
    • TFK056A : Interest Key Table for FI-CA
    • TFKDO_TYP : Job Type Customizing
    • FKKMAHNV : Control records for the dunning program in FI-CA
    • DPAYCHKP : Header: Accounting Using Creation of Payment Media
    • DFKKCOLLP_IP_W : Buffer: Collection Agency Info File (Item for Payments)
    • TFK113Z : Clearing: Usage of Non-Assignable Payments
    • DFKKCUST_SHORT : Data Extract: Customizing
    • TFK044CT : Name of Valuation Variant
    • DFKKIH : FI-CA: Table with Interest History

    DPAYH related transaction codes under SAP package FKKB

    • FPAY9 : Reverse Item Preselection
    • S_KK4_74002115 : IMG Activity: _ISISFICA_VY6N(2)
    • FQKA : Document: Central Settings
    • S_KK4_74002174 : IMG Activity: _ISISFICA_V_TFK080R1
    • S_KK4_74002359 : IMG Activity: _ISUFICABFDP_000016
    • FPT7 : Statement Posting Totals
    • FQZD : FI-CA: AcctDet – Exchange Rate Diff.
    • FPB17 : Transfer MultiCash File (FI-CA)
    • S_KK4_74002132 : IMG Activity: _FICABTDU_V_TFK047H
    • S_KK4_74002638 : IMG Activity: _FICABFTX_FQZ04T
    • S_KK4_74002172 : IMG Activity: _ISISFICA_VYAF1
    • FQZL : FI-CA: Payment Program: Bank Accts
    • FPST : Preselection by Transaction Data
    • S_KK4_74002363 : IMG Activity: _ISUFICABFDP_000082
    • FQZ09 : FI-CA: Acct Det – Deferred Revenues
    • FPN6_10S : Number Range Maintenance: FKK_ED10S
    • FQC5 : C FKK Account Determination */0050
    • S_KK4_74002087 : IMG Activity: _FICABTPYPR
    • FPOR8 : Reverse Payment Order
    • FPAVDEL : Delete Payment Advice Note

    Related References

    Related Tutorials

    DPAYP SAP table for – Payment program – data on paid item

    DPAYP table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    TFK042E SAP table for – Payment program: company code payment method specifications

    TFK042E table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKIP_GRPH SAP table for – Payment Specification: Payment Data (History)

    DFKKIP_GRPH table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKCFPAYRUN2 SAP table for – Calrification Worklist: Payment Program (New Version)

    DFKKCFPAYRUN2 table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKZP SAP table for – Payment lot: Data for payment

    DFKKZP table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DPAYG SAP table for – Payment program – payment group

    DPAYG table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DPAYV SAP table for – Payment program: Variants for payment medium and list

    DPAYV table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    «
    »