1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to DPAYP 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). DPAYP is a SAP standard transp table used for storing Payment program – data on paid item related data in SAP. It comes under the package FKKB.

SAP DPAYP table

Table DPAYP technical data

TableDPAYP
Data storingPayment program – data on paid item
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DPAYP 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 DPAYP 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
  • DOC2T : Category for paid document
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • DOC2R : Reference to Paid Document
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • GPA2T : Category of business partner making a payment
    Its data type is CHAR (Character String) with field length 2
  • GPA2R : Reference to Business Partner Giving Payment Instruction
    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
  • VOR1T : Activity type
    Its data type is CHAR (Character String) with field length 2
  • VOR1R : Reference to Main Transaction
    Its data type is CHAR (Character String) with field length 4
  • VOR2T : Activity type
    Its data type is CHAR (Character String) with field length 2
  • VOR2R : Reference to Subtransaction
    Its data type is CHAR (Character String) with field length 4
  • TXT1T : Long text type
    Its data type is CHAR (Character String) with field length 2
  • TXT1R : Long text reference
    Its data type is CHAR (Character String) with field length 30
  • ADRNR : Address number
    Its data type is CHAR (Character String) with field length 10
  • NAME1 : Name 1
    Its data type is CHAR (Character String) with field length 40
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • ORT01 : City
    Its data type is CHAR (Character String) with field length 40
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDT : Due Date of Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKTPA : Accepted cash discount rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • AUGBH : Clearing amount in local currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • AUGBW : Clearing Amount in Transaction Currency (With +/- Sign)
    Its data type is CURR (Currency Field) with field length 13
  • ASKTH : Proportional cash discount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • ASKTW : Proportional cash discount in transaction currency
    Its data type is CURR (Currency Field) with field length 13
  • POKEN : Item indicator in payment program
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ZLSPR : Lock Reason for Automatic Payment
    Its data type is CHAR (Character String) with field length 1
  • CLRLO : Clearing Lock Reason
    Its data type is CHAR (Character String) with field length 1
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • C4EYE : Check Reason for Workflows Acc. to Dual Control Principle
    Its data type is CHAR (Character String) with field length 2
  • OPTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • REF1T : Reference information type
    Its data type is CHAR (Character String) with field length 2
  • REF1R : Reference information
    Its data type is CHAR (Character String) with field length 40
  • REF2T : Reference information type
    Its data type is CHAR (Character String) with field length 2
  • REF2R : Reference information
    Its data type is CHAR (Character String) with field length 40
  • REF3T : Reference information type
    Its data type is CHAR (Character String) with field length 2
  • REF3R : Reference information
    Its data type is CHAR (Character String) with field length 40
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • VTRE2 : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • LZBKZ : State central bank indicator
    Its data type is CHAR (Character String) with field length 3
  • LANDL : Supplying Country
    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
  • AQSBW : Proportional Withholding Tax Amount In Transaction Currency
    Its data type is CURR (Currency Field) with field length 13
  • AQSBH : Proportional Withholding Tax Amount In Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • STAKZ : Type of statistical item
    Its data type is CHAR (Character String) with field length 1
  • SUBAP : Subapplication in Contract Accounts Receivable and Payable
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : IS-U-Specific Fields: Number Program, Where-Used List
  • .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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : IS-SI-Specific Fields for Payment Program Where-Used List

    • DPAYP related tables

    • TFK053R02 : Follow-Up Actions: Delete Activity Variants for Locks
    • TFKAUTH_EBPP : Processing Functions with Authorization Protection (BD)
    • DFKKCR : Repository For Checks
    • TFK002FT : Texts on partner account agreements
    • TFK033C : Account determination: Control
    • TFK007FKT : Tax Item Categories for Other Tax Code
    • DFKKCR2P : Check Repository: Additional Payees
    • FKKDIJOB : FI-CA: Distrib. of intervals – table of jobs
    • DFKKTRACEP : FKKTRACE: Item Data
    • TFK123 : Payment Run: Assign General Grouping Variants
    • TFK001AT : Clearing reasons (text table)
    • TFKRESOB : Check Function Modules for Reconciliation Key
    • DFKKRAP : Clearing/Reversal History (Line Item Level) < 4.62
    • TFK033E : Account determination: Choice of key used
    • TFK022A : Screen variants for document posting
    • DFKKKO_WF : Header Data for Contract Accting Doc. (Workflow Parameters)
    • TFK053CT : Change Payment Data: Texts for Processing Variants
    • TFKIVV : Assignment of Internal Transactions to External Transactions
    • TFK021SVT : Sorting variants (description)
    • TFKDDA : Debit Memo Notification: General Settings

    DPAYP related transaction codes under SAP package FKKB

    • S_KK4_74002135 : IMG Activity: _FICABTPY_SWLD1
    • FQZH : FI-CA: Acct Maint. Default Entries
    • FQZ06 : FI-CA: Installm.Plan Inact. Dunn.Run
    • FP_DEL_DFKKREP01 : Deletion of Tax Rep. Data (Belgium)
    • FPPARHID : Hide Parameter Records
    • FPCR2 : Change Creditworthiness
    • FPW2 : Log Records for For. Crcy Valuations
    • S_KK4_74002211 : IMG Activity: _FICAEURO_FPO2(1)
    • FPU5 : Transfer Documents to Another Acct
    • FQZ04S : Write-Offs: Specif. and Default Vals
    • FQZ15 : FI-CA: Coll. Agency Specifications
    • FPCJ : Cash Journal
    • FQCC : Maintain Bank Sel. IDs for Pymt Run
    • S_KK4_74002089 : IMG Activity: _FICABTPYPC_FQZV
    • S_KK4_74002412 : IMG Activity: _ISISFICA_V_TFK002AV
    • S_KK4_74002193 : IMG Activity: _FICACLRE_FPU1
    • FPDR : Trans.Postg Run for Deferred Revenue
    • FPCVS_EXAM : Monitoring of Third Party Payments
    • FPCF : Transfer Data to Cash Management
    • FQZ1 : FI-CA: Account Balance Line Layout

    Related References

    Related Tutorials

    DPAYH SAP table for – Payment program – data for payment

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

    DFKKPOP SAP table for – Payment Order: Item Data

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

    DFKKPC_LOGI SAP table for – Payment Cards: Billing Log (Paid Items)

    DFKKPC_LOGI 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...

    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...

    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...

    «
    »