1. Home
  2. Resources
  3. SAP Tables
  4. FPAYH - Payment medium: Payment data

SAP Table FPAYH

Payment medium: Payment data

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

FPAYH table fields

Field Data element Checktable Datatype Length Decimals
LAUFD Date on Which the Program Is to Be Run LAUFD DATS 8 0
LAUFI Additional Identification LAUFI CHAR 6 0
XVORL Indicator: Proposal Run XVORL_FPM CHAR 1 0
X Yes
NULL No
DORIGIN Grouping Origin FIBL_DORIGIN CHAR 8 0
GRPNO Grouping Criterium for Payments GRPNO_FPM INT4 10 0
1 Exceptions
2 Zero balance
3 Intercompany billing
100 Groups of payments
SRTF1 Format-Specific Sorting of Payment Data SRTF1_FPM CHAR 30 0
SRTF2 User-Defined Sorting of Payment Data SRTF2_FPM CHAR 48 0
SRTF3 Format-Specific Sorting of Payment Data SRTF1_FPM CHAR 30 0
LFDNR Sequential Payment Number LFDNR_FPM NUMC 8 0
XCORR Indicator: Payment Correspondence XCORR_FPM CHAR 1 0
X Yes
NULL No
XAVIS Indicator: Separate Payment Advice XAVIS_FPM CHAR 1 0
X Yes
NULL No
XCOPM Payment Medium for Business Partner (Correspondence) XCOPM_FPM CHAR 1 0
NULL No payment medium for business partner
W Bills of exchange
S Check
GPA1T Category of Business Partner Receiving Payment GPA1T_FPM CHAR 2 0
01 Central business partner
11 Vendor, creditor
12 Customer, debtor
13 Branch
14 Business partner's CPD encryption
21 Personnel number
GPA1R Reference to Business Partner Receiving Payment GPA1R_FPM CHAR 16 0
ZADNR Address number AD_ADDRNUM ADRC CHAR 10 0
ZANRE Title of the payee DZANRE CHAR 15 0
ZNME1 Name of the Payee FPM_NAME CHAR 40 0
ZNME2 Name of the Payee FPM_NAME CHAR 40 0
ZNME3 Name of the Payee FPM_NAME CHAR 40 0
ZNME4 Name of the Payee FPM_NAME CHAR 40 0
ZSPRA Language Key SPRAS T002 LANG 1 0
ZLAND Country Key DZLAND T005 CHAR 3 0
ZREGI Regional code of the payee DZREGI T005S CHAR 3 0
ZORT1 City AD_CITY1 CHAR 40 0
ZORT2 District AD_CITY2 CHAR 40 0
ZPFOR PO Box city AD_POBXLOC CHAR 40 0
ZPSTL City postal code AD_PSTCD1 CHAR 10 0
ZPST2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
ZPST3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
ZPFAC PO Box AD_POBX CHAR 10 0
ZSTRA Street AD_STREET CHAR 60 0
ZTEL1 Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
ZTEL2 Telephone no.: Extension AD_TLXTNS CHAR 10 0
ZFAX1 Fax number: dialling code+number AD_FXNMBR CHAR 30 0
ZFAX2 Fax no.: Extension AD_FXXTNS CHAR 10 0
ZTELX Payee telex number TELEX_Z CHAR 30 0
STCD1 Payee's tax number 1 STCD1_Z CHAR 16 0
ZBNKS Country Key DZBNKS T005 CHAR 3 0
ZBNKY Bank key of the payee's bank DZBNKY CHAR 15 0
ZBNKL Bank number of the payee's bank DZBNKL CHAR 15 0
ZSWIF SWIFT/BIC for International Payments SWIFT CHAR 11 0
ZBNKN Bank Account Number of the Payee DZBNKN35 CHAR 35 0
ZBKON Bank Control Key of the Payee's Bank DZBKON CHAR 2 0
BKREF Reference specifications for bank details BKREF CHAR 20 0
ZIBAN IBAN of the Payee DZIBAN CHAR 34 0
KOINH Account Holder Name KOINH_FI CHAR 60 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
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
MGUID Globally Unique Identifier GUID RAW 16 0
ZBUKR Paying company code DZBUKR CHAR 4 0
ABSBU Sending company code ABSBU CHAR 4 0
HWAER Local Currency HWAER_FPM CUKY 5 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
HKTID ID for account details HKTID CHAR 5 0
UBHKT G/L Account Number for Our Bank Account / Bank Sub-Account UBHKT CHAR 10 0
BTYP1 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS1 Bank country key BANKS CHAR 3 0
BNKL1 Bank Keys BANKK CHAR 15 0
BNKN1 Bank account number BANKN35 CHAR 35 0
BKON1 Bank Control Key BKONT CHAR 2 0
BKRF1 Reference specifications for bank details BKREF CHAR 20 0
BSWIFT1 SWIFT/BIC for International Payments SWIFT CHAR 11 0
BTYP2 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS2 Bank country key BANKS CHAR 3 0
BNKL2 Bank Keys BANKK CHAR 15 0
BNKN2 Bank account number BANKN35 CHAR 35 0
BKON2 Bank Control Key BKONT CHAR 2 0
BKRF2 Reference specifications for bank details BKREF CHAR 20 0
BSWIFT2 SWIFT/BIC for International Payments SWIFT CHAR 11 0
BTYP3 Type of bank in a bank chain (correspondent, intermediary) BNTYP CHAR 1 0
1 Sender's correspondent bank
2 Intermediary bank
3 Recipient's correspondent bank
4 External house bank (use for in-house cash payments only)
BNKS3 Bank country key BANKS CHAR 3 0
BNKL3 Bank Keys BANKK CHAR 15 0
BNKN3 Bank account number BANKN35 CHAR 35 0
BKON3 Bank Control Key BKONT CHAR 2 0
BKRF3 Reference specifications for bank details BKREF CHAR 20 0
BSWIFT3 SWIFT/BIC for International Payments SWIFT CHAR 11 0
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
RFTTRN Payment code RFTTRN_BF CHAR 20 0
DOC1T Payment Document Category DOC1T_FPM CHAR 2 0
01 Document in Financial Accounting
02 Document in Contract Accounts Receivable/Payable
03 Payroll info
04 Payment order from AP/AR
05 Payment request from bank subledger
DOC1R Reference to Payment Document DOC1R_FPM CHAR 24 0
SRTGB Business Area GSBER CHAR 4 0
WAERS Currency Key WAERS CUKY 5 0
RWBTR Amount paid in transaction currency BF_RWBTR CURR 23 2
RWSKT Total Cash Discount in Payment (Transaction Currency) BF_RWSKT CURR 23 2
WQSTE Withholding Tax Amount (+/-) in Foreign Currency WQSTV_FPM CURR 23 2
WABZG Total Deductions (+/-) in Foreign Currency WABZV_FPM CURR 23 2
WRBTR Amount Before Deductions in Foreign Currency with +/- Signs WRBTV_FPM CURR 23 2
RBETR Amount Paid in Local Currency BF_RBETR CURR 23 2
RSKON Total Cash Discount Included in Payment (Local Currency) BF_RSKON CURR 23 2
XKDFB Indicator: Do Not Post any Exchange Rate Differences XKDFB_FPM CHAR 1 0
X Yes
NULL No
ZALDT Posting date of the payment document DZALDT_ZHL DATS 8 0
AUSFD Due date of the paid items AUSFD DATS 8 0
VALUT Value date VALUT DATS 8 0
CRVAL Value Date at Payee's Bank PRQ_CRVAL DATS 8 0
RPOST Number of Items paid BF_RPOST DEC 7 0
RTEXT Number of Text Lines for the Items Paid BF_RTEXT DEC 7 0
PAYGR Grouping Field for Automatic Payments PAYGR_FPM CHAR 20 0
WDATE Bill of Exchange Issue Date WDATE DATS 8 0
WEFAE Bill of Exchange Due Date WEFAE DATS 8 0
WEAMX Number of Bills of Exchange with Maximum Amount WEAMX DEC 3 0
WEFMX Maximum Amount per Bill of Exchange in Payment Currency WEFMX CURR 13 2
WEFRS Remaining Amount in Payment Crcy for Last Bill of Exchange WEFRS CURR 13 2
RZAWE Payment Method DZLSCH CHAR 1 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
AVISG Reason for Printing Payment Advice AVISG_FPM CHAR 1 0
INTRACOMP Intracompany Payment INTRACOMP_FPM CHAR 1 0
X Yes
NULL No
FORMZ Supplement for Payment Medium Format FORMZ_FPM CHAR 6 0
PURP_CODE SEPA Purpose Code: Classification of a Payment/Debit Memo FPM_PURP_CODE CHAR 4 0
UBUSA Accounting Clerk (Short Entry) UBUSA_FPM CHAR 35 0
SALUT Form of address text AD_TITLE_T CHAR 20 0
FNAME First name AD_NAMEFIR CHAR 40 0
LNAME Last name AD_NAMELAS CHAR 40 0
NAMP1 Full Name of Person AD_NAMTEXT CHAR 80 0
NAMP2 Name 2 NAME2_GP CHAR 35 0
ID_CODE Short name for correspondence AD_ID_CODE CHAR 10 0
SABSPRA Language Key SPRAS LANG 1 0
ABTEI Department AD_DPRTMNT CHAR 40 0
FUNCTION Function AD_FNCTN CHAR 40 0
ROOMN Room or Appartment Number AD_ROOMNUM CHAR 10 0
BUILD Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR_C Floor in building AD_FLOOR CHAR 10 0
IH_MAIL Int. mail postal code AD_IH_MAIL CHAR 10 0
TELF1 Addresses: telephone no. TLFNR CHAR 30 0
TEL_EXTEN1 First Telephone No.: Extension AD_TLXTNS1 CHAR 10 0
TELF2 Addresses: telephone no. TLFNR CHAR 30 0
TEL_EXTEN2 Telephone no.: Extension AD_TLXTNS CHAR 10 0
TELFX Fax Number TELFX CHAR 31 0
FAX_EXTENS First fax no.: extension AD_FXXTNS1 CHAR 10 0
INTAD Internet address of partner company clerk INTAD CHAR 130 0

FPAYH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FPAYH ZADNR * ADRC Addresses (Business Address Services) DATE_FROM
FPAYH ZADNR * ADRC Addresses (Business Address Services) NATION
FPAYH ZADNR SYST MANDT ADRC Addresses (Business Address Services) CLIENT
FPAYH ZADNR FPAYH ZADNR ADRC Addresses (Business Address Services) ADDRNUMBER
FPAYH ZBNKS SYST MANDT T005 Countries MANDT
FPAYH ZBNKS FPAYH ZBNKS T005 Countries LAND1
FPAYH ZLAND SYST MANDT T005 Countries MANDT
FPAYH ZLAND FPAYH ZLAND T005 Countries LAND1
FPAYH ZREGI SYST MANDT T005S Taxes: Region (Province) Key MANDT
FPAYH ZREGI FPAYH ZLAND T005S Taxes: Region (Province) Key LAND1
FPAYH ZREGI FPAYH ZREGI T005S Taxes: Region (Province) Key BLAND
FPAYH ZSPRA FPAYH ZSPRA T002 Language Keys (Component BC-I18) SPRAS