SAP Table PAYHX

Payment medium: payment data format

PAYHX (Payment medium: payment data format) 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 PAYHX to other SAP tables.

PAYHX table fields

Field Data element Checktable Datatype Length Decimals
ZNM1S Name with Asterisks NAME1S CHAR 35 0
ZNM2S Name with Asterisks NAME1S CHAR 35 0
ZPLOR Postal Code/City of the Payee's Display Field DZPLOR CHAR 46 0
ZPFST P.O. Box or Street for Postal Code/City PFSTR CHAR 35 0
ZLNDX Name of the Payee's Country DZLNDX CHAR 15 0
ZLISO Country ISO code INTCA CHAR 2 0
ZREGX Region REGIX CHAR 20 0
ZSPRA Language Key SPRAS LANG 1 0
ZBNKA Name of the Payee's Bank DZBNKA CHAR 60 0
ZBSTR Street of the Payee's Bank DZBSTR CHAR 35 0
ZBORT City of the Payee's Bank DZBORT CHAR 35 0
ZBREG Region (State, Province, County) REGIO CHAR 3 0
ZBANK Payee Bank (Name and City) EBANK CHAR 100 0
ZBRCH Bank Branch BRNCH CHAR 40 0
ZBPSK Account Number of Bank Account At Post Office PSKTO CHAR 16 0
XPGRZ Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
OZBKT Account Number of Customer/Vendor for OCRA Line OZBKT NUMC 18 0
OZBKL Bank Number of Customer/Vendor Bank for OCRA Line OZBKL NUMC 15 0
ZIBAN IBAN of the Payee DZIBAN CHAR 34 0
HWAER Local Currency HWAER CUKY 5 0
HWISO ISO currency code ISOCD CHAR 3 0
SPRAS Language Key LANGU LANG 1 0
STCEG VAT Registration Number STCEG CHAR 20 0
ADRNR Address ADRNR CHAR 10 0
AUST1 Issuer Details on the Payment Medium AUSTX_PAY CHAR 35 0
AUST2 Issuer Details on the Payment Medium AUSTX_PAY CHAR 35 0
AUST3 Issuer Details on the Payment Medium AUSTX_PAY CHAR 35 0
AUSTO Issuer Details on the Payment Medium AUSTX_PAY CHAR 35 0
TXTKO Text Element for Letter Header TXTKO_042T CHAR 16 0
TXTFU Footer TXTFU_042T CHAR 16 0
TXTUN Signature/Form of Greeting TXTUN_042T CHAR 16 0
TXTAB Sender in Letter Window TXTAB_042T CHAR 16 0
UBNKA Our Bank Name UBNKA CHAR 60 0
UBSTR Our Bank Street UBSTR CHAR 35 0
UBORT Our Bank City UBORT CHAR 35 0
UBREG Region (State, Province, County) REGIO CHAR 3 0
UBANK House Bank (Name and City) UBANK CHAR 100 0
UBRCH Bank Branch BRNCH CHAR 40 0
XPGRU Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
OBNKL Bank Number of our Bank for OCRA Lines OBNKL NUMC 15 0
OBKNT Our Account Number at the Bank for OCRA Lines OBKNT NUMC 18 0
UIBAN IBAN at our House Bank UIBAN CHAR 34 0
DTVTA Lead Days for Date of Execution DTVTA_012D NUMC 2 0
DTELZ Bank Number of the Bank Receiving the Data Medium DTELZ CHAR 15 0
DTGLZ Charge Account Bank Number DTGLZ CHAR 15 0
DTGBK Account Number of the Charge Account DTGBK CHAR 18 0
DTGIS ISO Currency Code for Charge Account DTAT7A CHAR 3 0
DTFIN Company Number of Ordering Party DTFIN_012D CHAR 20 0
DTBID DME Bank Identification DTBID CHAR 5 0
DTKID Customer ID at House Bank DTKID CHAR 18 0
FORMI Payment medium format FORMI_PAY CHAR 30 0
FORMZ Supplement for payment medium format FORMZ_PAY CHAR 6 0
PREFTYP Category of Note to Payee PREFTYP_PAY CHAR 10 0
ZFORN Name of the Form for the Payment Transfer Medium DZFORN CHAR 16 0
WFORN Form for Additional Payment Medium WFORN_PAY CHAR 16 0
DFORN Accompanying Sheet Form for Payment Orders Without Documents DFORN_PAY CHAR 16 0
PDFDF Name of PDF-Based Form for Accompanying Sheet PDFDF_KK CHAR 30 0
ANZPO Number of information lines on payment medium form ANZPO_PAY NUMC 3 0
ANZP2 Number of information lines on payment medium form ANZPO_PAY NUMC 3 0
XADVS Payment advice if info lines overflow XADVS_PAY CHAR 1 0
X Yes
NULL No
XADVA Always Output Payment Advice Notes XADVA_PAY CHAR 1 0
X Yes
NULL No
XEINZ Indicator: Payment Method Used for Incoming Payments? XEINZ CHAR 1 0
X Yes
NULL No
XPGIR Payment method for post office bank account XPGIR_PAY CHAR 1 0
X Yes
NULL No
XSCHK Indicator: Is a Check Created Using This Payment Method? XSCHK_042Z CHAR 1 0
X Yes
NULL No
XEURO Indicator: EU Internal Transfer w/o Reporting Section XEURO CHAR 1 0
X Yes
NULL No
XNOPO Payment Order Instead of Payment Posting XNOPO_KK CHAR 1 0
X Yes
NULL No
XEBPP Payment Method for FSCM Biller Direct XEBPP_KK CHAR 1 0
X Web
C Cash Desk
E Collection Authorization
XESRD ISR Procedure XESRD_KK CHAR 1 0
X Yes
NULL No
WAERS ISO currency code ISOCD CHAR 3 0
OVBLN Payment Document Number for OCRA Lines OVBLN NUMC 13 0
RENUM Reference Number RENUM CHAR 16 0
NWBTR Net Payment Amount NWBTR_KK CURR 13 2
NWWAERS Currency Key WAERS CUKY 5 0
NWBTRS Amount with Protective Asterisks NWBTRS_KK CHAR 13 0
XKDFB Do not Post any Exchange Rate Differences XKDFB_042E CHAR 1 0
X Yes
NULL No
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
NUMBER Whole digits of the amount converted IN_NUMBERS NUMC 15 0
DECIMAL Decimal places of the amount converted IN_DECI NUMC 3 0
CURRDEC Number of decimal places CURRDEC INT1 3 0
WORD Amount in words IN_WORDS CHAR 255 0
DECWORD Decimal places in words DECWORD CHAR 128 0
DIG01 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG02 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG03 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG04 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG05 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG06 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG07 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG08 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG09 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG10 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG11 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG12 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG13 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG14 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIG15 Figure in words (units, tens, ...) DZWORT CHAR 7 0
DIL01 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL02 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL03 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL04 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL05 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL06 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL07 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL08 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL09 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL10 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL11 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL12 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL13 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL14 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
DIL15 Figure in Words (ones, tens, ...), Longer DZWORT_L CHAR 25 0
CHECF Payment Medium ID Number CRZTNUM CHAR 13 0
BETRS Amount with Protective Asterisks BTRSS_KK CHAR 18 0
X01 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X02 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X03 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X04 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X05 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X06 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X07 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X08 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X09 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X10 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X11 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X12 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X13 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X14 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X15 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X16 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X17 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X18 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X19 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
X20 Cross in Payment Form (see Report Documentation) XRFFO CHAR 1 0
X Yes
NULL No
TEXT1 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT2 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT3 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT4 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT5 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT6 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT7 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT8 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT9 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT10 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT11 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT12 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT13 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT14 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT15 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT16 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT17 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT18 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXT19 Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
TEXTHR Text in Payment Form (see Report Documentation) TRFFO CHAR 132 0
MNDID Unique Referene to Mandate per Payment Recipient SEPA_MNDID CHAR 35 0
SIGN_DATE Date of Signature SEPA_SIGN_DATE DATS 8 0
B2B SEPA-Mandate: B2B Mandate SEPA_B2B CHAR 1 0
X Yes
NULL No
REC_CRDID Creditor Identification Number SEPA_CRDID CHAR 35 0
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
AMEND_IND SEPA Amendment Indicator for Mandate SEPA_AMEND_IND CHAR 1 0
X true
- false
NULL unknown
ORIG_MNDID SEPA Mandate: Original Mandate of Mandate SEPA_MNDID_ORIGIN CHAR 35 0
ORIG_REC_CRDID SEPA Mandate: Original Creditor ID of Mandate SEPA_CRDID_ORIGIN CHAR 35 0
ORIG_REC_NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
ORIG_REC_NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
ORIG_IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
ORIG_BIC SWIFT/BIC for International Payments SWIFT CHAR 11 0
XSEPA SEPA Mandate Required XSEPA_KK CHAR 1 0
X Yes
NULL No
SND_DEBTOR_ID SEPA: ID Number of Sender (External Reference) SEPA_SND_DEBTOR_ID_KK CHAR 35 0
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