1. Home
  2. Resources
  3. SAP Tables
  4. PAYH - Payment program - data for payment

SAP Table PAYH

Payment program - data for payment

PAYH (Payment program - data for payment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PAYH to other SAP tables.

PAYH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAUFD Date ID LAUFD_KK DATS 8 0
LAUFI Identification for the payment run LAUFI_PAY CHAR 5 0
ORIGN Source of the payment data ORIGN_PAY CHAR 1 0
NULL FI AP/AR Payment program for customers and vendors
* FI AP/AR Online check print for customers and vendors
O FI AP/AR Online check print (internal use)
P HR-PY/FI-TV Payroll and travel expenses
J IS-M Publishing
R FI-BL Payment program for payment requests
M FI-CA Payment program of contract accounts receivable
W FI-BL Bill of exchange accounting
X (Reserved for foreign currency valuation)
B FIN-BNK Bank Communication / payment status monitor
XVORL Indicator: Only Proposal Run? XVORL CHAR 1 0
X Yes
NULL No
PAYNO Sequential payment number PAYNO_PAY INT4 10 0
SUBNO Additional distinguishing criterion from payments SUBNO_PAY CHAR 6 0
PMF_KEY Redundant Key for Payment Medium Print PMFKEY_PAY CHAR 15 0
GRPNO Grouping criterium for payments GRPNO_PAY INT4 10 0
1 Exceptions
2 Zero balance
3 Internal Clearing
4 Payment cards
101 Groups of Payments
SRTF1 Format-specific sorting of payment data SRTF1_PAY CHAR 20 0
SRTF2 User-defined sorting of payment data SRTF2_PAY CHAR 48 0
XAVIS Indicator: Separate Payment Advice if Form is Full? XAVIS CHAR 1 0
X Yes
NULL No
ORG1T Type of Organization ORG1T_PAY CHAR 2 0
01 Company Code
ORG1R Reference for Organization ORG1R_PAY CHAR 8 0
ORG2T Type of organization for which the payment is made ORG2T_PAY CHAR 2 0
01 Company Code
ORG2R Reference to the Organization for Which the Payment is Made ORG2R_PAY CHAR 8 0
GPA1T Business Partner Category GPA1T_PAY CHAR 2 0
01 Central business partner
04 Repayment request in Contract Accounts Receivable/Payable
11 Vendor, creditor
12 Customer, debtor
13 Branch
21 Personnel number
GPA1R Business Partner Reference GPA1R_PAY CHAR 12 0
ACC1T Contract Account Category ACC1T_PAY CHAR 2 0
01 Contract Account
ACC1R Reference to Contract Account ACC1R_PAY CHAR 18 0
DOC1T Payment document category DOC1T_PAY CHAR 2 0
01 Document in Financial Accounting
02 Document in Contract Accounts Receivable/Payable
03 Settlement Result
04 Repayment Request in Contract Accounts Receivable/Payable
05 Payment Order in Contract Accounts Receivable/Payable
06 Direct Debit Pre-Notification
DOC1R Reference to Payment Document DOC1R_PAY CHAR 24 0
MASTT Master record type for payment items MASTT_KK CHAR 2 0
01 Contract Account
02 Contract
03 Payment Reference in Contract Account
MASTR Master Record Reference for Payment Item MASTR_KK CHAR 20 0
ZADNR Address number AD_ADDRNUM ADRC CHAR 10 0
ZNME1 Name of the Payee NAMEZ_KK CHAR 40 0
ZNME2 Name of the Payee NAMEZ_KK CHAR 40 0
ZSPRA Language Key SPRAS T002 LANG 1 0
ZLAND Country Key LAND1 T005 CHAR 3 0
ZREGI Region (State, Province, County) REGIO T005S CHAR 3 0
ZORT1 City AD_CITY1 CHAR 40 0
ZORT2 District AD_CITY2 CHAR 40 0
ZORTP PO Box city AD_POBXLOC CHAR 40 0
ZPST1 City postal code AD_PSTCD1 CHAR 10 0
ZPST2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
ZPST3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
ZPFAC PO Box AD_POBX CHAR 10 0
ZSTRA Street AD_STREET CHAR 60 0
ZSTR1 House Number AD_HSNM1 CHAR 10 0
ZSTR2 House number supplement AD_HSNM2 CHAR 10 0
ZTEL1 Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
ZTEL2 Telephone no.: Extension AD_TLXTNS CHAR 10 0
ZFAX1 Fax number: dialling code+number AD_FXNMBR CHAR 30 0
ZFAX2 Fax no.: Extension AD_FXXTNS CHAR 10 0
ZBNKS Bank country key BANKS T005 CHAR 3 0
ZBNKY Bank key of the payee's bank DZBNKY CHAR 15 0
ZBNKL Bank number of the payee's bank DZBNKL CHAR 15 0
ZSWIF SWIFT/BIC for International Payments SWIFT CHAR 11 0
ZBNKN Bank account number of the payee DZBNKN CHAR 18 0
ZBKON Bank Control Key of the Payee's Bank DZBKON CHAR 2 0
ZBKRF Reference specifications for bank details BKREF CHAR 20 0
ZBKIN Name of Holder of Bank Account/Check Issuer/Cardholder KOINH_KK CHAR 60 0
ZIBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
MGUID GUID in 'RAW' format GUID_16 RAW 16 0
BBUKR Company Code in Payment Document BUKRS_PAY T001 CHAR 4 0
BGSBR Business area in payment document GSBER_PAY TGSB CHAR 4 0
WAERS Currency Key WAERS TCURC CUKY 5 0
RBETR Amount in Local Currency RBETR CURR 13 2
RWBTR Amount Paid in the Payment Currency RWBTR CURR 13 2
RSKON Total Cash Discount for the Payment Trans. (Local Currency) RSKON CURR 13 2
RWSKT Total Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKT CURR 13 2
ZALDT Posting date of the payment document DZALDT_ZHL DATS 8 0
DIFFB Difference Amount in Clearing Processing DIFFB_KK CURR 13 2
AUSFD Due date of the paid items AUSFD DATS 8 0
VALUT Value date VALUT DATS 8 0
RZAWE Payment Method PYMET_KK TFK042Z CHAR 1 0
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
AVISG Reason for Printing Payment Advice AVISG CHAR 1 0
A Zero balance notification
V Clearing (payment and notification already made)
RPOST Number of Items Paid RPOST DEC 5 0
RTEXT Number of Text Lines for the Items Paid RTEXT_D DEC 5 0
PYGRP Grouping field for automatic payments PYGRP_KK CHAR 10 0
PAYGR Generated grouping field in payments PAYGR_PAY CHAR 50 0
XNOLC Payment Program: Local Currency Amounts Incomplete XNOLC_KK CHAR 1 0
X Yes
NULL No
PDKEY Number of Payment Specification PDKEY_KK NUMC 12 0
PDREF Reference Number of Payment Specification PDREF_KK CHAR 16 0
PPKEY Identification of Promise to Pay PPKEY_KK CHAR 12 0
PRDAT Payment Date Promised PRODT_KK DATS 8 0
EIGBV Own Bank Details EIGBV_KK CHAR 25 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
HKTID ID for account details HKTID T012K CHAR 5 0
UBNKS Bank country key BANKS T005 CHAR 3 0
UBNKY Bank key of our bank UBNKY CHAR 15 0
UBNKL Bank number of our bank UBNKL CHAR 15 0
UBKNT Our account number at the bank UBKNT CHAR 18 0
UBKON Bank control key at our bank UBKON CHAR 2 0
UBHKT G/L Account Number for Our Bank Account / Bank Sub-Account UBHKT SKA1 CHAR 10 0
DTAWS Instruction key for data medium exchange DTAWS T015W CHAR 2 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
TXTSL Text key for the code line on the form TXTSL_042Z CHAR 2 0
TXERG Text key supplement TXERG CHAR 3 0
CCINS Payment card type CC_INSTITUTE TB033 CHAR 4 0
CCNUM Payment cards: Card number CCNUM CHAR 25 0
RQSTW Withholding Tax In Payment Currency (Credit-Side) RQSTW CURR 13 2
RQSTH Withholding Tax In Local Currency (Credit-Side) RQSTH CURR 13 2
RQSEW Withholding Tax In Payment Currency (Debit-Side) RQSEW CURR 13 2
RQSEH Withholding Tax In Local Currency (Debit-Side) RQSEH CURR 13 2
ORIBD Payment Program: Origin of Business Partner Bank Data ORIBD_KK CHAR 1 0
1 Contract Account
2 Contract
3 Document
4 Determined via Event 0652
5 Payment Specification
6 Prepaid Account
CGUID GUID of a Payment Card CARD_GUID RAW 16 0
ENCTP Type of Encryption CCSECA_ENCTYPE CHAR 1 0
1 Data in PCA_SECURITY_RAW
2 Data in CCSEC_ENC or CCSEC_ENCV
3 Data in CCARDEC
PAY_TYPE SEPA: Transaction Type SEPA_PAY_TYPE CHAR 1 0
1 One-Time Mandate
N Recurring Use Mandate
SEQ_TYPE SEPA: Sequence Type SEPA_SEQ_TYPE CHAR 4 0
OOFF One-Time Collection
FRST First Recurring Collection
RCUR Recurring Collection
FNAL Last Recurring Collection
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1 0
X Yes
NULL No
INST_CODE Local Instrument Code (Direct Debit Type) FSEPA_INST_CODE CHAR 4 0
CORE SEPA Core Direct Debit
COR1 SEPA Core Direct Debit with D 1 Agreement
B2B SEPA Business-to-Business Direct Debit

PAYH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PAYH BBUKR SYST MANDT T001 Company Codes MANDT
PAYH BBUKR PAYH BBUKR T001 Company Codes BUKRS
PAYH BGSBR SYST MANDT TGSB Business Areas MANDT
PAYH BGSBR PAYH BGSBR TGSB Business Areas GSBER
PAYH CCINS SYST MANDT TB033 Payment Cards: Type MANDT
PAYH CCINS PAYH CCINS TB033 Payment Cards: Type CCINS
PAYH DTAWS PAYH DTAWS T015W Instruction keys DTAWS
PAYH DTAWS SYST MANDT T015W Instruction keys MANDT
PAYH DTAWS * T015W Instruction keys BANKS
PAYH DTAWS * T015W Instruction keys ZLSCH
PAYH HBKID SYST MANDT T012 House Banks MANDT
PAYH HBKID T001 BUKRS T012 House Banks BUKRS
PAYH HBKID PAYH HBKID T012 House Banks HBKID
PAYH HKTID T001 BUKRS T012K House Bank Accounts BUKRS
PAYH HKTID PAYH HBKID T012K House Bank Accounts HBKID
PAYH HKTID PAYH HKTID T012K House Bank Accounts HKTID
PAYH HKTID SYST MANDT T012K House Bank Accounts MANDT
PAYH MANDT PAYH MANDT T000 Clients MANDT
PAYH RZAWE SYST MANDT TFK042Z Payment Program: Additional Specifications for Payt Methods MANDT
PAYH RZAWE T001 LAND1 TFK042Z Payment Program: Additional Specifications for Payt Methods LAND1
PAYH RZAWE PAYH RZAWE TFK042Z Payment Program: Additional Specifications for Payt Methods ZLSCH
PAYH UBHKT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
PAYH UBHKT T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
PAYH UBHKT PAYH UBHKT SKA1 G/L Account Master (Chart of Accounts) SAKNR
PAYH UBNKS SYST MANDT T005 Countries MANDT
PAYH UBNKS PAYH UBNKS T005 Countries LAND1
PAYH UZAWE SYST MANDT T042F Payment method supplements MANDT
PAYH UZAWE PAYH UZAWE T042F Payment method supplements UZAWE
PAYH WAERS SYST MANDT TCURC Currency Codes MANDT
PAYH WAERS PAYH WAERS TCURC Currency Codes WAERS
PAYH ZADNR * ADRC Addresses (Business Address Services) NATION
PAYH ZADNR SYST MANDT ADRC Addresses (Business Address Services) CLIENT
PAYH ZADNR PAYH ZADNR ADRC Addresses (Business Address Services) ADDRNUMBER
PAYH ZADNR * ADRC Addresses (Business Address Services) DATE_FROM
PAYH ZBNKS PAYH ZBNKS T005 Countries LAND1
PAYH ZBNKS SYST MANDT T005 Countries MANDT
PAYH ZLAND SYST MANDT T005 Countries MANDT
PAYH ZLAND PAYH ZLAND T005 Countries LAND1
PAYH ZREGI PAYH ZREGI T005S Taxes: Region (Province) Key BLAND
PAYH ZREGI SYST MANDT T005S Taxes: Region (Province) Key MANDT
PAYH ZREGI PAYH ZLAND T005S Taxes: Region (Province) Key LAND1
PAYH ZSPRA PAYH ZSPRA T002 Language Keys (Component BC-I18) SPRAS