FPAYHX SAP (Payment Medium: Prepared Data for Payment) Structure details
Description: Payment Medium: Prepared Data for Payment
Structure field list including key, data, relationships and ABAP select examples
FPAYHX is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Payment Medium: Prepared Data for Payment" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FPAYHX TYPE FPAYHX.
The FPAYHX table consists of various fields, each holding specific information or linking keys about Payment Medium: Prepared Data for Payment data available in SAP. These include ZNM1S (Name with Asterisks), ZNM2S (Name with Asterisks), ZPLOR (Postal Code/City of the Payee's Display Field), ZPFST (P.O. Box or Street for Postal Code/City).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FPAYHX structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ZNM1S | Name with Asterisks | NAMES_FPM | CHAR | 35 | TEXT35 | ||||
ZNM2S | Name with Asterisks | NAMES_FPM | CHAR | 35 | TEXT35 | ||||
ZPLOR | Postal Code/City of the Payee's Display Field | DZPLOR_FPM | CHAR | 46 | TEXT46 | ||||
ZPFST | P.O. Box or Street for Postal Code/City | PFSTR_FPM | CHAR | 35 | TEXT35 | ||||
ZLISO | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
ZLNDX | Name of the Payee's Country | DZLNDX | CHAR | 15 | TEXT15 | ||||
ZREGX | Name of the Payee Region | DZREGX_FPM | CHAR | 20 | TEXT20 | ||||
ZBANK | Payee Bank (Name and City) | EBANK_FPM | CHAR | 100 | TEXT100 | ||||
ZBREGX | Name of the Payee Bank Region | DZBREGX_FPM | CHAR | 20 | TEXT20 | ||||
ZBISO | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
ZBNKL_EXT | External Format of Bank Number (Electr. Transmission) | BANKL_EXT | CHAR | 15 | CHAR15 | ||||
ZBNKN_EXT | External Format of Acct No. (Electr. Transmission) | BANKN_EXT | CHAR | 35 | BANKN35 | ||||
ZBCOD_EXT | Ext. Representation of Clearing Cde (Electr. Transmission) | BCODE_EXT | CHAR | 2 | BCODE_EXT | ||||
HWISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
SPRAS | Language Key | LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
NAMEZ | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LDISO | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
ORT1Z | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
AUST1 | Issuer on the Form | AUSTX_042E | CHAR | 35 | TEXT35 | ||||
AUST2 | Issuer on the Form | AUSTX_042E | CHAR | 35 | TEXT35 | ||||
AUST3 | Issuer on the Form | AUSTX_042E | CHAR | 35 | TEXT35 | ||||
AUSTO | Issuer on the Form | AUSTX_042E | CHAR | 35 | TEXT35 | ||||
TXTID | Text ID | TDID | CHAR | 4 | Assigned to domain | TDID | |||
TXTKO | Text Element for Letter Header | TXTKO_FPM | CHAR | 16 | TDFORMNEW | ||||
TXTFU | Text Module for Footer | TXTFU_FPM | CHAR | 16 | TDFORMNEW | ||||
TXTUN | Text Module for Signature/Form of Greeting | TXTUN_FPM | CHAR | 16 | TDFORMNEW | ||||
TXTAB | Text Module for Sender in Letter Window | TXTAB_FPM | CHAR | 16 | TDFORMNEW | ||||
SF_HEADER | Smart Forms: Name of Header Text in Text Processing | FSF_HEADER | CHAR | 30 | Assigned to domain | TDSFNAME | |||
SF_FOOTER | Smart Forms: Name of Footer in Text Processing | FSF_FOOTER | CHAR | 30 | Assigned to domain | TDSFNAME | |||
SF_SENDER | Smart Forms: Name of Sender Text in Text Processing | FSF_SENDER | CHAR | 30 | Assigned to domain | TDSFNAME | |||
SF_GREETG | Smart Forms: Name of Greeting in Text Processing | FSF_GREETINGS | CHAR | 30 | Assigned to domain | TDSFNAME | |||
URL_LOGO | URL for PDF Logo | FURL_LOGO | CHAR | 255 | SSFURL | ||||
URL_GRAPH | URL for PDF Graphic | FURL_GRAPHIC | CHAR | 255 | SSFURL | ||||
UBNKA | Our Bank Name | UBNKA | CHAR | 60 | TEXT60 | ||||
UBSTR | Our Bank Street | UBSTR | CHAR | 35 | TEXT35 | ||||
UBORT | Our Bank City | UBORT | CHAR | 35 | TEXT35 | ||||
UBNKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
UBISO | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA | |||
UBNKY | Bank key of our bank | UBNKY | CHAR | 15 | BANKK | ||||
UBNKL | Bank number of our bank | UBNKL | CHAR | 15 | BANKL | ||||
UBKNT | Our Account Number at the Bank | UBKNT35 | CHAR | 35 | BANKN35 | ||||
UBKON | Bank control key at our bank | UBKON | CHAR | 2 | BKONT | ||||
UIBAN | IBAN at our House Bank | UIBAN | CHAR | 34 | IBAN | ||||
UBNKL_EXT | External Format of Bank Number (Electr. Transmission) | BANKL_EXT | CHAR | 15 | CHAR15 | ||||
UBKNT_EXT | External Format of Acct No. (Electr. Transmission) | BANKN_EXT | CHAR | 35 | BANKN35 | ||||
UBCOD_EXT | Ext. Representation of Clearing Cde (Electr. Transmission) | BCODE_EXT | CHAR | 2 | BCODE_EXT | ||||
UBWAE | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
USWIF | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
UBREG | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
UBREGX | Name of House Bank Region | UBREGX_FPM | CHAR | 20 | TEXT20 | ||||
UBANK | House Bank (Name and City) | UBANK | CHAR | 100 | TEXT100 | ||||
UBRCH | Bank Branch | BRNCH | CHAR | 40 | TEXT40 | ||||
UBTEL | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
UBNAM | Name of contact person | NAME1_A | CHAR | 30 | TEXT30 | ||||
UBSPR | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
XPGRO | Post Office Bank Current Account | XPGRO | CHAR | 1 | XFELD | ||||
DTVTA | Lead Days for Date of Execution | DTVTA_012D | NUMC | 2 | NUMC02 | ||||
DTELZ | Bank Number of the Bank Receiving the Data Medium | DTELZ | CHAR | 15 | BANKL | ||||
DTGLZ | Charge Account Bank Number | DTGLZ | CHAR | 15 | BANKL | ||||
DTGBK | Account Number of the Charge Account | DTGBK | CHAR | 18 | BANKN | ||||
DTGIS | ISO Currency Code for Charge Account | DTAT7A | CHAR | 3 | CHAR3 | ||||
DTFIN | Company Number of Ordering Party | DTFIN_012D | CHAR | 20 | CHAR20 | ||||
DTBID | DME Bank Identification | DTBID | CHAR | 5 | CHAR5 | ||||
DTKID | Customer ID at House Bank | DTKID | CHAR | 18 | CHAR18 | ||||
BNKL1_EXT | External Format of Bank Number (Electr. Transmission) | BANKL_EXT | CHAR | 15 | CHAR15 | ||||
BNKN1_EXT | External Format of Acct No. (Electr. Transmission) | BANKN_EXT | CHAR | 35 | BANKN35 | ||||
BCOD1_EXT | Ext. Representation of Clearing Cde (Electr. Transmission) | BCODE_EXT | CHAR | 2 | BCODE_EXT | ||||
BNKL2_EXT | External Format of Bank Number (Electr. Transmission) | BANKL_EXT | CHAR | 15 | CHAR15 | ||||
BNKN2_EXT | External Format of Acct No. (Electr. Transmission) | BANKN_EXT | CHAR | 35 | BANKN35 | ||||
BCOD2_EXT | Ext. Representation of Clearing Cde (Electr. Transmission) | BCODE_EXT | CHAR | 2 | BCODE_EXT | ||||
BNKL3_EXT | External Format of Bank Number (Electr. Transmission) | BANKL_EXT | CHAR | 15 | CHAR15 | ||||
BNKN3_EXT | External Format of Acct No. (Electr. Transmission) | BANKN_EXT | CHAR | 35 | BANKN35 | ||||
BCOD3_EXT | Ext. Representation of Clearing Cde (Electr. Transmission) | BCODE_EXT | CHAR | 2 | BCODE_EXT | ||||
DTKVS | Cost Allocation Key | DTAT21 | NUMC | 2 | NUMC02 | ||||
DTZUS | Instruction Key Additional Information | DTAT20 | CHAR | 25 | TEXT25 | ||||
DTKZA | Payment Type Indicator | DTAT22 | NUMC | 2 | NUMC02 | ||||
DTURG | Urgent Payment | DTURG | CHAR | 1 | XFELD | ||||
WAERS | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
XKDFB | Do not Post any Exchange Rate Differences | XKDFB_042E | CHAR | 1 | XFELD | ||||
OVBLN | Payment Document Number for OCRA Lines | OVBLN_FPM | NUMC | 13 | NUMC13 | ||||
XEINZ | Indicator: Payment Method Used for Incoming Payments? | XEINZ | CHAR | 1 | XFELD | ||||
XSCHK | Indicator: Is a Check Created Using This Payment Method? | XSCHK_042Z | CHAR | 1 | XFELD | ||||
XPGIR | Indicator: Payment Method for Post Office Bank | XPGIR | CHAR | 1 | XFELD | ||||
XEURO | Indicator: EU Internal Transfer w/o Reporting Section | XEURO | CHAR | 1 | XFELD | ||||
XEZER | Indicator: Must Collection Authorization Be Provided? | XEZER_042Z | CHAR | 1 | XFELD | ||||
ZFORN | Name of the Form for the Payment Transfer Medium | DZFORN | CHAR | 16 | TDFORM | ||||
WFORN | Name of Next Form | WFORN | CHAR | 16 | TDFORM | ||||
AFORN | Name of the Form for the Payment Advice | AFORN | CHAR | 16 | TDFORM | ||||
PDFFO | Name of the PDF-based Form for the Payment Medium | DZFORN_PDF | CHAR | 30 | FPNAME | FPWBFORM | HFPWBFORM | ||
PDFWF | Name of the Next PDF-based Form | WFORN_PDF | CHAR | 30 | FPNAME | FPWBFORM | HFPWBFORM | ||
PDFAF | Name of the PDF-based Form for the Payment Advice Note | AFORN_PDF | CHAR | 30 | FPNAME | FPWBFORM | HFPWBFORM | ||
FORMI | Payment Medium Format | FORMI_FPM | CHAR | 30 | Assigned to domain | FORMI_FPM | |||
FORMZ | Supplement for Payment Medium Format | FORMZ_FPM | CHAR | 6 | Assigned to domain | FORMZ_FPM | |||
PREFTYP | Note to Payee Type | PREFTYP_FPM | CHAR | 30 | PREFTYP_FPM | ||||
RENUM | Reference Number | RENUM_FPM | CHAR | 16 | TEXT16 | ||||
CHECK | Check number | CHECT | CHAR | 13 | CHCKN | CHK | |||
XFINAL | Indicator: Last Payment in a Physical File | 0 | |||||||
CURNO | Sequential Number | CURNO_FPM | NUMC | 12 | NUMC12 | ||||
REF01 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF02 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF03 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF04 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF05 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF06 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF07 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF08 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF09 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF10 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF11 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF12 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF13 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF14 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
REF15 | User-Defined Field (See Format Documentation) | REFER_FPM | CHAR | 132 | |||||
ZREF01 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF02 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF03 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF04 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF05 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF06 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF07 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF08 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF09 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
ZREF10 | User-Defined Text (Customer-Specific) | REFERZ_FPM | CHAR | 132 | |||||
MNDID | Mandate ID (SEPA) | FPM_MNDID | CHAR | 35 | |||||
SIGN_DATE | Date of Signature (Mandate) | FPM_MND_SIGN_DATE | DATS | 8 | DATUM | ||||
B2B | B2B Mandate | FPM_B2B | CHAR | 1 | BOOLEAN | ||||
REC_CRDID | Vendor ID (Unique Cross-Country) | FPM_CRDID | CHAR | 35 | |||||
SEQ_TYPE | Sequence Type for Automatic Debit | FPM_SEQ_TYPE | CHAR | 4 | FPM_SEQ_TYPE | ||||
INST_CODE | Local Instrument Code (Direct Debit Type) | FPM_INST_CODE | CHAR | 4 | CHAR4 | ||||
AMEND_IND | Amendment Indicator for Mandate | FPM_AMEND_IND | CHAR | 1 | BOOLEAN | ||||
ORIG_MNDID | Mandate ID (SEPA) | FPM_MNDID | CHAR | 35 | |||||
ORIG_REC_CRDID | Vendor ID (Unique Cross-Country) | FPM_CRDID | CHAR | 35 | |||||
ORIG_REC_NAME1 | Name of the Payee | FPM_NAME | CHAR | 40 | TEXT40 | ||||
ORIG_REC_NAME2 | Name of the Payee | FPM_NAME | CHAR | 40 | TEXT40 | ||||
ORIG_IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
ORIG_BIC | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
SND_DEBTOR_ID | Identification Number of Sender (Ext. Reference) | FPM_SND_DEBTOR_ID | CHAR | 35 | ID035 |
Key field | Non-key field |
How do I retrieve data from SAP structure FPAYHX using ABAP code?
As FPAYHX is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FPAYHX as there is no data to select.How to access SAP table FPAYHX
Within an ECC or HANA version of SAP you can also view further information about FPAYHX and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects