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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
DORIGIN
Grouping Origin
|
FIBL_DORIGIN |
CHAR
|
8 | 0 | ||||||||||||||||
|
GRPNO
Grouping Criterium for Payments
|
GRPNO_FPM |
INT4
|
10 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
XAVIS
Indicator: Separate Payment Advice
|
XAVIS_FPM |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
XCOPM
Payment Medium for Business Partner (Correspondence)
|
XCOPM_FPM |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
GPA1T
Category of Business Partner Receiving Payment
|
GPA1T_FPM |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | SYST | MANDT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| FPAYH | ZADNR | FPAYH | ZADNR |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| FPAYH | ZADNR | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| FPAYH | ZADNR | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| FPAYH | ZBNKS | FPAYH | ZBNKS |
T005
Countries
|
LAND1 |
| FPAYH | ZBNKS | SYST | MANDT |
T005
Countries
|
MANDT |
| FPAYH | ZLAND | SYST | MANDT |
T005
Countries
|
MANDT |
| FPAYH | ZLAND | FPAYH | ZLAND |
T005
Countries
|
LAND1 |
| FPAYH | ZREGI | FPAYH | ZREGI |
T005S
Taxes: Region (Province) Key
|
BLAND |
| FPAYH | ZREGI | SYST | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| FPAYH | ZREGI | FPAYH | ZLAND |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| FPAYH | ZSPRA | FPAYH | ZSPRA |
T002
Language Keys (Component BC-I18)
|
SPRAS |