1. Home
  2. Resources
  3. SAP Tables
  4. FPAYHX - Payment Medium: Prepared Data for Payment

SAP Table FPAYHX

Payment Medium: Prepared Data for Payment

FPAYHX (Payment Medium: Prepared 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 FPAYHX to other SAP tables.

FPAYHX table fields

Field Data element Checktable Datatype Length Decimals
ZNM1S Name with Asterisks NAMES_FPM CHAR 35 0
ZNM2S Name with Asterisks NAMES_FPM CHAR 35 0
ZPLOR Postal Code/City of the Payee's Display Field DZPLOR_FPM CHAR 46 0
ZPFST P.O. Box or Street for Postal Code/City PFSTR_FPM CHAR 35 0
ZLISO Country ISO code INTCA CHAR 2 0
ZLNDX Name of the Payee's Country DZLNDX CHAR 15 0
ZREGX Name of the Payee Region DZREGX_FPM CHAR 20 0
ZBANK Payee Bank (Name and City) EBANK_FPM CHAR 100 0
ZBREGX Name of the Payee Bank Region DZBREGX_FPM CHAR 20 0
ZBISO Country ISO code INTCA CHAR 2 0
ZBNKL_EXT External Format of Bank Number (Electr. Transmission) BANKL_EXT CHAR 15 0
ZBNKN_EXT External Format of Acct No. (Electr. Transmission) BANKN_EXT CHAR 35 0
ZBCOD_EXT Ext. Representation of Clearing Cde (Electr. Transmission) BCODE_EXT CHAR 2 0
AT Bank number (Austria)
AU Bank state (Australia)
BL Bank number (Germany)
CC Canadian payments association (Canada)
CH CHIPS universal identifier (USA)
CP CHIPS participant code (USA)
ES Spanish domestic (Spain)
FW Fedwire routing number (USA)
IT Italian domestic (Italy)
SC CHAPS branch sort code (United Kingdom and Ireland)
SW Swiss clearing code (Switzerland)
HWISO ISO currency code ISOCD CHAR 3 0
SPRAS Language Key LANGU LANG 1 0
STCEG VAT Registration Number STCEG CHAR 20 0
NAMEZ Name 1 AD_NAME1 CHAR 40 0
LAND1 Country Key LAND1 CHAR 3 0
LDISO Country ISO code INTCA CHAR 2 0
ORT1Z City AD_CITY1 CHAR 40 0
ADRNR Address ADRNR CHAR 10 0
AUST1 Issuer on the Form AUSTX_042E CHAR 35 0
AUST2 Issuer on the Form AUSTX_042E CHAR 35 0
AUST3 Issuer on the Form AUSTX_042E CHAR 35 0
AUSTO Issuer on the Form AUSTX_042E CHAR 35 0
TXTID Text ID TDID CHAR 4 0
TXTKO Text Element for Letter Header TXTKO_FPM CHAR 16 0
TXTFU Text Module for Footer TXTFU_FPM CHAR 16 0
TXTUN Text Module for Signature/Form of Greeting TXTUN_FPM CHAR 16 0
TXTAB Text Module for Sender in Letter Window TXTAB_FPM CHAR 16 0
SF_HEADER Smart Forms: Name of Header Text in Text Processing FSF_HEADER CHAR 30 0
SF_FOOTER Smart Forms: Name of Footer in Text Processing FSF_FOOTER CHAR 30 0
SF_SENDER Smart Forms: Name of Sender Text in Text Processing FSF_SENDER CHAR 30 0
SF_GREETG Smart Forms: Name of Greeting in Text Processing FSF_GREETINGS CHAR 30 0
URL_LOGO URL for PDF Logo FURL_LOGO CHAR 255 0
URL_GRAPH URL for PDF Graphic FURL_GRAPHIC CHAR 255 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
UBNKS Bank country key BANKS CHAR 3 0
UBISO Country ISO code INTCA CHAR 2 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 UBKNT35 CHAR 35 0
UBKON Bank control key at our bank UBKON CHAR 2 0
UIBAN IBAN at our House Bank UIBAN CHAR 34 0
UBNKL_EXT External Format of Bank Number (Electr. Transmission) BANKL_EXT CHAR 15 0
UBKNT_EXT External Format of Acct No. (Electr. Transmission) BANKN_EXT CHAR 35 0
UBCOD_EXT Ext. Representation of Clearing Cde (Electr. Transmission) BCODE_EXT CHAR 2 0
AT Bank number (Austria)
AU Bank state (Australia)
BL Bank number (Germany)
CC Canadian payments association (Canada)
CH CHIPS universal identifier (USA)
CP CHIPS participant code (USA)
ES Spanish domestic (Spain)
FW Fedwire routing number (USA)
IT Italian domestic (Italy)
SC CHAPS branch sort code (United Kingdom and Ireland)
SW Swiss clearing code (Switzerland)
UBWAE ISO currency code ISOCD CHAR 3 0
USWIF SWIFT/BIC for International Payments SWIFT CHAR 11 0
UBREG Region (State, Province, County) REGIO CHAR 3 0
UBREGX Name of House Bank Region UBREGX_FPM CHAR 20 0
UBANK House Bank (Name and City) UBANK CHAR 100 0
UBRCH Bank Branch BRNCH CHAR 40 0
UBTEL First telephone number TELF1 CHAR 16 0
UBNAM Name of contact person NAME1_A CHAR 30 0
UBSPR Language Key SPRAS LANG 1 0
XPGRO Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
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
BNKL1_EXT External Format of Bank Number (Electr. Transmission) BANKL_EXT CHAR 15 0
BNKN1_EXT External Format of Acct No. (Electr. Transmission) BANKN_EXT CHAR 35 0
BCOD1_EXT Ext. Representation of Clearing Cde (Electr. Transmission) BCODE_EXT CHAR 2 0
AT Bank number (Austria)
AU Bank state (Australia)
BL Bank number (Germany)
CC Canadian payments association (Canada)
CH CHIPS universal identifier (USA)
CP CHIPS participant code (USA)
ES Spanish domestic (Spain)
FW Fedwire routing number (USA)
IT Italian domestic (Italy)
SC CHAPS branch sort code (United Kingdom and Ireland)
SW Swiss clearing code (Switzerland)
BNKL2_EXT External Format of Bank Number (Electr. Transmission) BANKL_EXT CHAR 15 0
BNKN2_EXT External Format of Acct No. (Electr. Transmission) BANKN_EXT CHAR 35 0
BCOD2_EXT Ext. Representation of Clearing Cde (Electr. Transmission) BCODE_EXT CHAR 2 0
AT Bank number (Austria)
AU Bank state (Australia)
BL Bank number (Germany)
CC Canadian payments association (Canada)
CH CHIPS universal identifier (USA)
CP CHIPS participant code (USA)
ES Spanish domestic (Spain)
FW Fedwire routing number (USA)
IT Italian domestic (Italy)
SC CHAPS branch sort code (United Kingdom and Ireland)
SW Swiss clearing code (Switzerland)
BNKL3_EXT External Format of Bank Number (Electr. Transmission) BANKL_EXT CHAR 15 0
BNKN3_EXT External Format of Acct No. (Electr. Transmission) BANKN_EXT CHAR 35 0
BCOD3_EXT Ext. Representation of Clearing Cde (Electr. Transmission) BCODE_EXT CHAR 2 0
AT Bank number (Austria)
AU Bank state (Australia)
BL Bank number (Germany)
CC Canadian payments association (Canada)
CH CHIPS universal identifier (USA)
CP CHIPS participant code (USA)
ES Spanish domestic (Spain)
FW Fedwire routing number (USA)
IT Italian domestic (Italy)
SC CHAPS branch sort code (United Kingdom and Ireland)
SW Swiss clearing code (Switzerland)
DTKVS Cost Allocation Key DTAT21 NUMC 2 0
DTZUS Instruction Key Additional Information DTAT20 CHAR 25 0
DTKZA Payment Type Indicator DTAT22 NUMC 2 0
DTURG Urgent Payment DTURG CHAR 1 0
X Yes
NULL No
WAERS ISO currency code ISOCD CHAR 3 0
XKDFB Do not Post any Exchange Rate Differences XKDFB_042E CHAR 1 0
X Yes
NULL No
OVBLN Payment Document Number for OCRA Lines OVBLN_FPM NUMC 13 0
XEINZ Indicator: Payment Method Used for Incoming Payments? XEINZ 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
XPGIR Indicator: Payment Method for Post Office Bank XPGIR CHAR 1 0
X Yes
NULL No
XEURO Indicator: EU Internal Transfer w/o Reporting Section XEURO CHAR 1 0
X Yes
NULL No
XEZER Indicator: Must Collection Authorization Be Provided? XEZER_042Z CHAR 1 0
X Yes
NULL No
ZFORN Name of the Form for the Payment Transfer Medium DZFORN CHAR 16 0
WFORN Name of Next Form WFORN CHAR 16 0
AFORN Name of the Form for the Payment Advice AFORN CHAR 16 0
PDFFO Name of the PDF-based Form for the Payment Medium DZFORN_PDF CHAR 30 0
PDFWF Name of the Next PDF-based Form WFORN_PDF CHAR 30 0
PDFAF Name of the PDF-based Form for the Payment Advice Note AFORN_PDF CHAR 30 0
FORMI Payment Medium Format FORMI_FPM CHAR 30 0
FORMZ Supplement for Payment Medium Format FORMZ_FPM CHAR 6 0
PREFTYP Note to Payee Type PREFTYP_FPM CHAR 30 0
RENUM Reference Number RENUM_FPM CHAR 16 0
CHECK Check number CHECT CHAR 13 0
XFINAL CHAR 1 0
CURNO Sequential Number CURNO_FPM NUMC 12 0
REF01 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF02 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF03 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF04 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF05 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF06 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF07 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF08 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF09 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF10 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF11 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF12 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF13 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF14 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
REF15 User-Defined Field (See Format Documentation) REFER_FPM CHAR 132 0
ZREF01 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF02 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF03 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF04 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF05 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF06 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF07 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF08 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF09 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
ZREF10 User-Defined Text (Customer-Specific) REFERZ_FPM CHAR 132 0
MNDID Mandate ID (SEPA) FPM_MNDID CHAR 35 0
SIGN_DATE Date of Signature (Mandate) FPM_MND_SIGN_DATE DATS 8 0
B2B B2B Mandate FPM_B2B CHAR 1 0
X true
- false
NULL unknown
REC_CRDID Vendor ID (Unique Cross-Country) FPM_CRDID CHAR 35 0
SEQ_TYPE Sequence Type for Automatic Debit FPM_SEQ_TYPE CHAR 4 0
OOFF One-Time Collection
FRST First Recurring Collection
RCUR Recurring Collection
FNAL Last Recurring Collection
INST_CODE Local Instrument Code (Direct Debit Type) FPM_INST_CODE CHAR 4 0
AMEND_IND Amendment Indicator for Mandate FPM_AMEND_IND CHAR 1 0
X true
- false
NULL unknown
ORIG_MNDID Mandate ID (SEPA) FPM_MNDID CHAR 35 0
ORIG_REC_CRDID Vendor ID (Unique Cross-Country) FPM_CRDID CHAR 35 0
ORIG_REC_NAME1 Name of the Payee FPM_NAME CHAR 40 0
ORIG_REC_NAME2 Name of the Payee FPM_NAME 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
SND_DEBTOR_ID Identification Number of Sender (Ext. Reference) FPM_SND_DEBTOR_ID CHAR 35 0