FPAYH SAP (Payment medium: Payment data) Structure details
Description: Payment medium: Payment data
Structure field list including key, data, relationships and ABAP select examples
FPAYH 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: Payment data" 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_FPAYH TYPE FPAYH.
The FPAYH table consists of various fields, each holding specific information or linking keys about Payment medium: Payment data data available in SAP. These include LAUFI (Additional Identification), XVORL (Indicator: Proposal Run), DORIGIN (Grouping Origin), GRPNO (Grouping Criterium for Payments).. 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 FPAYH 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 |
LAUFD | Date on Which the Program Is to Be Run | LAUFD | DATS | 8 | DATUM | ||||
LAUFI | Additional Identification | LAUFI | CHAR | 6 | LAUFI | ||||
XVORL | Indicator: Proposal Run | XVORL_FPM | CHAR | 1 | XFELD | ||||
DORIGIN | Grouping Origin | FIBL_DORIGIN | CHAR | 8 | Assigned to domain | FIBL_ORIGIN | |||
GRPNO | Grouping Criterium for Payments | GRPNO_FPM | INT4 | 10 | GRPNO_FPM | ||||
SRTF1 | Format-Specific Sorting of Payment Data | SRTF1_FPM | CHAR | 30 | CHAR30 | ||||
SRTF2 | User-Defined Sorting of Payment Data | SRTF2_FPM | CHAR | 48 | CHAR48 | ||||
SRTF3 | Format-Specific Sorting of Payment Data | SRTF1_FPM | CHAR | 30 | CHAR30 | ||||
LFDNR | Sequential Payment Number | LFDNR_FPM | NUMC | 8 | NUMC8 | ||||
XCORR | Indicator: Payment Correspondence | XCORR_FPM | CHAR | 1 | XFELD | ||||
XAVIS | Indicator: Separate Payment Advice | XAVIS_FPM | CHAR | 1 | XFELD | ||||
XCOPM | Payment Medium for Business Partner (Correspondence) | XCOPM_FPM | CHAR | 1 | XCOPM_FPM | ||||
GPA1T | Category of Business Partner Receiving Payment | GPA1T_FPM | CHAR | 2 | GPATP_FPM | ||||
GPA1R | Reference to Business Partner Receiving Payment | GPA1R_FPM | CHAR | 16 | CHAR16 | ||||
ZADNR | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
ZANRE | Title of the payee | DZANRE | CHAR | 15 | TEXT15 | ||||
ZNME1 | Name of the Payee | FPM_NAME | CHAR | 40 | TEXT40 | ||||
ZNME2 | Name of the Payee | FPM_NAME | CHAR | 40 | TEXT40 | ||||
ZNME3 | Name of the Payee | FPM_NAME | CHAR | 40 | TEXT40 | ||||
ZNME4 | Name of the Payee | FPM_NAME | CHAR | 40 | TEXT40 | ||||
ZSPRA | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
ZLAND | Country Key | DZLAND | CHAR | 3 | T005 | LAND1 | LND | ||
ZREGI | Regional code of the payee | DZREGI | CHAR | 3 | T005S | REGIO | |||
ZORT1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
ZORT2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
ZPFOR | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
ZPSTL | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
ZPST2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
ZPST3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
ZPFAC | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
ZSTRA | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
ZTEL1 | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
ZTEL2 | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
ZFAX1 | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
ZFAX2 | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
ZTELX | Payee telex number | TELEX_Z | CHAR | 30 | TEXT30 | ||||
STCD1 | Payee's tax number 1 | STCD1_Z | CHAR | 16 | STCD1 | ||||
ZBNKS | Country Key | DZBNKS | CHAR | 3 | T005 | LAND1 | LND | ||
ZBNKY | Bank key of the payee's bank | DZBNKY | CHAR | 15 | BANKK | ||||
ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15 | BANKL | ||||
ZSWIF | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
ZBNKN | Bank Account Number of the Payee | DZBNKN35 | CHAR | 35 | BANKN35 | ||||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2 | BKONT | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
ZIBAN | IBAN of the Payee | DZIBAN | CHAR | 34 | IBAN | ||||
KOINH | Account Holder Name | KOINH_FI | CHAR | 60 | KOINH | ||||
ZBNKA | Name of the Payee's Bank | DZBNKA | CHAR | 60 | TEXT60 | ||||
ZBSTR | Street of the Payee's Bank | DZBSTR | CHAR | 35 | TEXT35 | ||||
ZBORT | City of the Payee's Bank | DZBORT | CHAR | 35 | TEXT35 | ||||
ZBREG | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
ZBRCH | Bank Branch | BRNCH | CHAR | 40 | TEXT40 | ||||
ZBPSK | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | PSKTO | ||||
XPGRZ | Post Office Bank Current Account | XPGRO | CHAR | 1 | XFELD | ||||
MGUID | Globally Unique Identifier | GUID | RAW | 16 | |||||
ZBUKR | Paying company code | DZBUKR | CHAR | 4 | Assigned to domain | BUKRS | |||
ABSBU | Sending company code | ABSBU | CHAR | 4 | Assigned to domain | BUKRS | |||
HWAER | Local Currency | HWAER_FPM | CUKY | 5 | Assigned to domain | WAERS | |||
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | CHAR12 | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
HKTID | ID for account details | HKTID | CHAR | 5 | Assigned to domain | HKTID | |||
UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | UBHKT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
BTYP1 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1 | BNTYP | ||||
BNKS1 | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BNKL1 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BNKN1 | Bank account number | BANKN35 | CHAR | 35 | BANKN35 | ||||
BKON1 | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKRF1 | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
BSWIFT1 | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
BTYP2 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1 | BNTYP | ||||
BNKS2 | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BNKL2 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BNKN2 | Bank account number | BANKN35 | CHAR | 35 | BANKN35 | ||||
BKON2 | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKRF2 | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
BSWIFT2 | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
BTYP3 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | CHAR | 1 | BNTYP | ||||
BNKS3 | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BNKL3 | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BNKN3 | Bank account number | BANKN35 | CHAR | 35 | BANKN35 | ||||
BKON3 | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKRF3 | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
BSWIFT3 | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
RFTTRN | Payment code | RFTTRN_BF | CHAR | 20 | RFTTRN_BF | ||||
DOC1T | Payment Document Category | DOC1T_FPM | CHAR | 2 | DOCTP_FPM | ||||
DOC1R | Reference to Payment Document | DOC1R_FPM | CHAR | 24 | CHAR24 | ||||
SRTGB | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RWBTR | Amount paid in transaction currency | BF_RWBTR | CURR | 23(2) | WERTV12 | ||||
RWSKT | Total Cash Discount in Payment (Transaction Currency) | BF_RWSKT | CURR | 23(2) | WERTV12 | ||||
WQSTE | Withholding Tax Amount (+/-) in Foreign Currency | WQSTV_FPM | CURR | 23(2) | WERTV12 | ||||
WABZG | Total Deductions (+/-) in Foreign Currency | WABZV_FPM | CURR | 23(2) | WERTV12 | ||||
WRBTR | Amount Before Deductions in Foreign Currency with +/- Signs | WRBTV_FPM | CURR | 23(2) | WERTV12 | ||||
RBETR | Amount Paid in Local Currency | BF_RBETR | CURR | 23(2) | WERTV12 | ||||
RSKON | Total Cash Discount Included in Payment (Local Currency) | BF_RSKON | CURR | 23(2) | WERTV12 | ||||
XKDFB | Indicator: Do Not Post any Exchange Rate Differences | XKDFB_FPM | CHAR | 1 | XFELD | ||||
ZALDT | Posting date of the payment document | DZALDT_ZHL | DATS | 8 | DATUM | ||||
AUSFD | Due date of the paid items | AUSFD | DATS | 8 | DATUM | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
CRVAL | Value Date at Payee's Bank | PRQ_CRVAL | DATS | 8 | DATUM | ||||
RPOST | Number of Items paid | BF_RPOST | DEC | 7 | PACK4 | ||||
RTEXT | Number of Text Lines for the Items Paid | BF_RTEXT | DEC | 7 | PACK4 | ||||
PAYGR | Grouping Field for Automatic Payments | PAYGR_FPM | CHAR | 20 | CHAR20 | ||||
WDATE | Bill of Exchange Issue Date | WDATE | DATS | 8 | DATUM | ||||
WEFAE | Bill of Exchange Due Date | WEFAE | DATS | 8 | DATUM | ||||
WEAMX | Number of Bills of Exchange with Maximum Amount | WEAMX | DEC | 3 | PACK2 | ||||
WEFMX | Maximum Amount per Bill of Exchange in Payment Currency | WEFMX | CURR | 13(2) | WERT7 | ||||
WEFRS | Remaining Amount in Payment Crcy for Last Bill of Exchange | WEFRS | CURR | 13(2) | WERT7 | ||||
RZAWE | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
AVISG | Reason for Printing Payment Advice | AVISG_FPM | CHAR | 1 | CHAR1 | ||||
INTRACOMP | Intracompany Payment | INTRACOMP_FPM | CHAR | 1 | XFELD | ||||
FORMZ | Supplement for Payment Medium Format | FORMZ_FPM | CHAR | 6 | Assigned to domain | FORMZ_FPM | |||
PURP_CODE | SEPA Purpose Code: Classification of a Payment/Debit Memo | FPM_PURP_CODE | CHAR | 4 | CHAR4 | ||||
UBUSA | Accounting Clerk (Short Entry) | UBUSA_FPM | CHAR | 35 | CHAR35 | ||||
SALUT | Form of address text | AD_TITLE_T | CHAR | 20 | TEXT20 | ||||
FNAME | First name | AD_NAMEFIR | CHAR | 40 | TEXT40 | ||||
LNAME | Last name | AD_NAMELAS | CHAR | 40 | TEXT40 | ||||
NAMP1 | Full Name of Person | AD_NAMTEXT | CHAR | 80 | TEXT80 | ||||
NAMP2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
ID_CODE | Short name for correspondence | AD_ID_CODE | CHAR | 10 | TEXT10 | ||||
SABSPRA | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
ABTEI | Department | AD_DPRTMNT | CHAR | 40 | TEXT40 | ||||
FUNCTION | Function | AD_FNCTN | CHAR | 40 | TEXT40 | ||||
ROOMN | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
BUILD | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR_C | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
IH_MAIL | Int. mail postal code | AD_IH_MAIL | CHAR | 10 | TEXT10 | ||||
TELF1 | Addresses: telephone no. | TLFNR | CHAR | 30 | TEXT30 | ||||
TEL_EXTEN1 | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
TELF2 | Addresses: telephone no. | TLFNR | CHAR | 30 | TEXT30 | ||||
TEL_EXTEN2 | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
INTAD | Internet address of partner company clerk | INTAD | CHAR | 130 | TXT130 |
Key field | Non-key field |
How do I retrieve data from SAP structure FPAYH using ABAP code?
As FPAYH 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 FPAYH as there is no data to select.How to access SAP table FPAYH
Within an ECC or HANA version of SAP you can also view further information about FPAYH 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