SAP table PAYH (Payment program - data for payment)

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

PAYH foreign key relationships

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