DPAYH

Payment program - data for payment | #transactional | #language | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT FK Client
LAUFD Date ID
LAUFI Identification for the payment run
ORIGN Source of the payment data Show values
XVORL Indicator: Only Proposal Run? Show values
PAYNO Sequential payment number
SUBNO Additional distinguishing criterion from payments
Column Name Description
💲 Currency Key (T001.WAERS):
RBETR Amount in Local Currency
RWBTR Amount Paid in the Payment Currency
RSKON Total Cash Discount for the Payment Trans. (Local Currency)
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency
DIFFB Difference Amount in Clearing Processing
RQSTW Withholding Tax In Payment Currency (Credit-Side)
RQSTH Withholding Tax In Local Currency (Credit-Side)
RQSEW Withholding Tax In Payment Currency (Debit-Side)
RQSEH Withholding Tax In Local Currency (Debit-Side)
Column Name Description
Column Name Description
LAUFD Date ID
ZALDT Posting Date of Payment Document
AUSFD Due date of the paid items
VALUT Value date
PRDAT Payment Date Promised
Column Name Description
ORIGN Source of the payment data Show values
XVORL Indicator: Only Proposal Run? Show values
GRPNO Grouping criterium for payments Show values
XAVIS Output payment advice Show values
ORG1T Type of Organization Show values
ORG2T Type of organization for which the payment is made Show values
GPA1T Business Partner Category Show values
ACC1T Contract Account Category Show values
DOC1T Payment document category Show values
MASTT Master record type for payment items Show values
AVISG Reason for Printing Payment Advice Show values
DTAMS Report key for data medium exchange Show values
ORIBD Payment Program: Origin of Business Partner Bank Data Show values
XNOLC Payment Program: Local Currency Amounts Incomplete Show values
ENCTP Type of Encryption Show values
PAY_TYPE SEPA: Payment Type Show values
SEQ_TYPE SEPA: Sequence Type Show values
B2B SEPA-Mandate: B2B Mandate Show values
INST_CODE Local Instrument Code (Direct Debit Type) Show values
Column Name Description Domain name
PMF_KEY Redundant Key for Payment Medium Print CHAR15
SRTF1 Format-specific sorting of payment data CHAR20
SRTF2 User-defined sorting of payment data CHAR48
ORG1R Reference for Organization CHAR8
ORG2R Reference to the Organization for Which the Payment is Made CHAR8
GPA1R Business Partner Reference CHAR12
ACC1R Reference to Contract Account CHAR18
DOC1R Reference to Payment Document CHAR24
MASTR Master Record Reference for Payment Item MASTR_KK
ZNME1 Name of the Payee TEXT40
ZNME2 Name of the Payee TEXT40
ZORT1 City TEXT40
ZORT2 District TEXT40
ZORTP PO Box city TEXT40
ZPST1 City postal code CHAR10
ZPST2 PO Box Postal Code CHAR10
ZPST3 Company Postal Code (for Large Customers) CHAR10
ZPFAC PO Box CHAR10
ZSTRA Street TEXT60
ZSTR1 House Number TEXT10
ZSTR2 House number supplement TEXT10
ZTEL1 Telephone no.: dialling code+number CHAR30
ZTEL2 Telephone no.: Extension CHAR10
ZFAX1 Fax number: dialling code+number CHAR30
ZFAX2 Fax no.: Extension CHAR10
ZBNKY Bank key of the payee's bank BANKK
ZBNKL Bank number of the payee's bank BANKL
ZSWIF SWIFT/BIC for International Payments SWIFT
ZBNKN Bank account number of the payee BANKN
ZBKON Bank Control Key of the Payee's Bank BKONT
ZBKRF Reference Details for Bank Details CHAR20
ZBKIN Name of Holder of Bank Account/Check Issuer/Cardholder KOINH
RPOST Number of Items Paid PACK3
RTEXT Number of Text Lines for the Items Paid PACK3
PYGRP Grouping field for automatic payments CHAR10
PAYGR Generated grouping field in payments CHAR50
EIGBV Own Bank Details EIGBV_KK
UBNKY Bank Key of Our Bank BANKK
UBNKL Bank number of our bank BANKL
UBKNT Our account number at the bank BANKN
UBKON Bank control key at our bank BKONT
TXTSL Text key for the code line on the form CHAR2
TXERG Text key supplement CHAR3
CCNUM Payment cards: Card number CCNUM
MASKED_ID Masked Payment Card Number ( Digital Payment ) DP_MASK_NUMBER
ZIBAN IBAN (International Bank Account Number) IBAN
PDKEY Number of Payment Specification PDKEY_KK
PDREF Reference Number of Payment Specification PDREF_KK
PPKEY Identification of Promise to Pay PPKEY_KK
MGUID Generic Data Element for GUID Fields (X16) GUID16
CGUID GUID of a Payment Card SYSUUID
MNDID Unique Reference to Mandate for each Payee ID035
RCRSP_CC Payment cards: Result of card check (response code) CHAR4
RTEXT_CC Payment cards: Result text TXT40
Master Data Relations Join Conditions
Company Code in Payment Document
  • DPAYH.MANDT == T001.MANDT
  • DPAYH.BBUKR == T001.BUKRS
Business area in payment document
  • DPAYH.MANDT == TGSB.MANDT
  • DPAYH.BGSBR == TGSB.GSBER
Payment Card Type
  • DPAYH.MANDT == TB033.MANDT
  • DPAYH.CCINS == TB033.CCINS
Instruction Key for Data Medium Exchange
  • Payment Method
  • Country/Region Key
  • Instruction Key for Data Medium Exchange
Short Key for a House Bank
  • Short Key for a House Bank
  • ?
  • DPAYH.MANDT == T012.MANDT
  • DPAYH.HBKID == T012.HBKID
  • DPAYH.[column in domain "BUKRS"] == T012.BUKRS
ID for Account Details
  • ?
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • DPAYH.[column in domain "BUKRS"] == T012K.BUKRS
  • DPAYH.HKTID == T012K.HKTID
  • DPAYH.MANDT == T012K.MANDT
  • DPAYH.HBKID == T012K.HBKID
Client DPAYH.MANDT == T000.MANDT
Payment Method
  • Payment Method
  • ?
  • Client
  • DPAYH.RZAWE == TFK042Z.ZLSCH
  • DPAYH.[column in domain "LAND1"] == TFK042Z.LAND1
  • DPAYH.MANDT == TFK042Z.MANDT
G/L Account Number for Our Bank Account / Bank Subaccount
  • ?
  • Client
  • G/L Account Number for Our Bank Account / Bank Subaccount
  • DPAYH.[column in domain "KTOPL"] == SKA1.KTOPL
  • DPAYH.MANDT == SKA1.MANDT
  • DPAYH.UBHKT == SKA1.SAKNR
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • DPAYH.UBNKS == T005.LAND1
  • DPAYH.MANDT == T005.MANDT
Payment method supplement
  • DPAYH.MANDT == T042F.MANDT
  • DPAYH.UZAWE == T042F.UZAWE
Currency Key
  • DPAYH.MANDT == TCURC.MANDT
  • DPAYH.WAERS == TCURC.WAERS
Address Number
  • Address Number
  • ?
  • ?
  • DPAYH.MANDT == ADRC.CLIENT
  • DPAYH.ZADNR == ADRC.ADDRNUMBER
  • DPAYH.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • DPAYH.[column in domain "AD_NATION"] == ADRC.NATION
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • DPAYH.ZBNKS == T005.LAND1
  • DPAYH.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • DPAYH.ZLAND == T005.LAND1
  • DPAYH.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • DPAYH.MANDT == T005S.MANDT
  • DPAYH.ZLAND == T005S.LAND1
  • DPAYH.ZREGI == T005S.BLAND
Language Key DPAYH.ZSPRA == T002.SPRAS