SAP ABAP Table FPAYH (Payment medium: Payment data)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-BL (Application Component) Bank Accounting
⤷ BFIBL_PAYM (Package) Payment medium
⤷ FI-BL (Application Component) Bank Accounting
⤷ BFIBL_PAYM (Package) Payment medium
Basic Data
Table Category | INTTAB | Structure |
Structure | FPAYH | Table Relationship Diagram |
Short Description | Payment medium: Payment data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | LAUFD | LAUFD | DATUM | DATS | 8 | 0 | Date on Which the Program Is to Be Run | ||
2 | LAUFI | LAUFI | LAUFI | CHAR | 6 | 0 | Additional Identification | ||
3 | XVORL | XVORL_FPM | XFELD | CHAR | 1 | 0 | Indicator: Proposal Run | ||
4 | DORIGIN | FIBL_DORIGIN | FIBL_ORIGIN | CHAR | 8 | 0 | Grouping Origin | * | |
5 | .INCLUDE | 0 | 0 | Payment Medium: Sorting and Control Fields | |||||
6 | GRPNO | GRPNO_FPM | GRPNO_FPM | INT4 | 10 | 0 | Grouping Criterium for Payments | ||
7 | SRTF1 | SRTF1_FPM | CHAR30 | CHAR | 30 | 0 | Format-Specific Sorting of Payment Data | ||
8 | SRTF2 | SRTF2_FPM | CHAR48 | CHAR | 48 | 0 | User-Defined Sorting of Payment Data | ||
9 | SRTF3 | SRTF1_FPM | CHAR30 | CHAR | 30 | 0 | Format-Specific Sorting of Payment Data | ||
10 | LFDNR | LFDNR_FPM | NUMC8 | NUMC | 8 | 0 | Sequential Payment Number | ||
11 | XCORR | XCORR_FPM | XFELD | CHAR | 1 | 0 | Indicator: Payment Correspondence | ||
12 | XAVIS | XAVIS_FPM | XFELD | CHAR | 1 | 0 | Indicator: Separate Payment Advice | ||
13 | XCOPM | XCOPM_FPM | XCOPM_FPM | CHAR | 1 | 0 | Payment Medium for Business Partner (Correspondence) | ||
14 | .INCLUDE | 0 | 0 | Payment Medium: Payee | |||||
15 | GPA1T | GPA1T_FPM | GPATP_FPM | CHAR | 2 | 0 | Category of Business Partner Receiving Payment | ||
16 | GPA1R | GPA1R_FPM | CHAR16 | CHAR | 16 | 0 | Reference to Business Partner Receiving Payment | ||
17 | ZADNR | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
18 | ZANRE | DZANRE | TEXT15 | CHAR | 15 | 0 | Title of the payee | ||
19 | ZNME1 | FPM_NAME | TEXT40 | CHAR | 40 | 0 | Name of the Payee | ||
20 | ZNME2 | FPM_NAME | TEXT40 | CHAR | 40 | 0 | Name of the Payee | ||
21 | ZNME3 | FPM_NAME | TEXT40 | CHAR | 40 | 0 | Name of the Payee | ||
22 | ZNME4 | FPM_NAME | TEXT40 | CHAR | 40 | 0 | Name of the Payee | ||
23 | ZSPRA | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
24 | ZLAND | DZLAND | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
25 | ZREGI | DZREGI | REGIO | CHAR | 3 | 0 | Regional code of the payee | T005S | |
26 | ZORT1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
27 | ZORT2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
28 | ZPFOR | AD_POBXLOC | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
29 | ZPSTL | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
30 | ZPST2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
31 | ZPST3 | AD_PSTCD3 | CHAR10 | CHAR | 10 | 0 | Company postal code (for large customers) | ||
32 | ZPFAC | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
33 | ZSTRA | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
34 | ZTEL1 | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
35 | ZTEL2 | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
36 | ZFAX1 | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
37 | ZFAX2 | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
38 | ZTELX | TELEX_Z | TEXT30 | CHAR | 30 | 0 | Payee telex number | ||
39 | STCD1 | STCD1_Z | STCD1 | CHAR | 16 | 0 | Payee's tax number 1 | ||
40 | .INCLUDE | 0 | 0 | Payment Medium: Payee Bank Information | |||||
41 | ZBNKS | DZBNKS | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
42 | ZBNKY | DZBNKY | BANKK | CHAR | 15 | 0 | Bank key of the payee's bank | ||
43 | ZBNKL | DZBNKL | BANKL | CHAR | 15 | 0 | Bank number of the payee's bank | ||
44 | ZSWIF | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
45 | ZBNKN | DZBNKN35 | BANKN35 | CHAR | 35 | 0 | Bank Account Number of the Payee | ||
46 | ZBKON | DZBKON | BKONT | CHAR | 2 | 0 | Bank Control Key of the Payee's Bank | ||
47 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
48 | ZIBAN | DZIBAN | IBAN | CHAR | 34 | 0 | IBAN of the Payee | ||
49 | KOINH | KOINH_FI | KOINH | CHAR | 60 | 0 | Account Holder Name | ||
50 | ZBNKA | DZBNKA | TEXT60 | CHAR | 60 | 0 | Name of the Payee's Bank | ||
51 | ZBSTR | DZBSTR | TEXT35 | CHAR | 35 | 0 | Street of the Payee's Bank | ||
52 | ZBORT | DZBORT | TEXT35 | CHAR | 35 | 0 | City of the Payee's Bank | ||
53 | ZBREG | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
54 | ZBRCH | BRNCH | TEXT40 | CHAR | 40 | 0 | Bank Branch | ||
55 | ZBPSK | PSKTO | PSKTO | CHAR | 16 | 0 | Account Number of Bank Account At Post Office | ||
56 | XPGRZ | XPGRO | XFELD | CHAR | 1 | 0 | Post Office Bank Current Account | ||
57 | MGUID | GUID | RAW | 16 | 0 | Globally Unique Identifier | |||
58 | .INCLUDE | 0 | 0 | Payment Medium: Payer | |||||
59 | ZBUKR | DZBUKR | BUKRS | CHAR | 4 | 0 | Paying company code | * | |
60 | ABSBU | ABSBU | BUKRS | CHAR | 4 | 0 | Sending company code | * | |
61 | HWAER | HWAER_FPM | WAERS | CUKY | 5 | 0 | Local Currency | * | |
62 | EIKTO | EIKTO | CHAR12 | CHAR | 12 | 0 | Shipper's (Our) Account Number at the Customer or Vendor | ||
63 | .INCLUDE | 0 | 0 | Payment Medium: Payer's Bank | |||||
64 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
65 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | * | |
66 | UBHKT | UBHKT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Our Bank Account / Bank Sub-Account | * | |
67 | .INCLUDE | 0 | 0 | Pymt Medium: Bank Chain (Intermediary and Corresp. Banks) | |||||
68 | BTYP1 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
69 | BNKS1 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
70 | BNKL1 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
71 | BNKN1 | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
72 | BKON1 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
73 | BKRF1 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
74 | BSWIFT1 | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
75 | BTYP2 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
76 | BNKS2 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
77 | BNKL2 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
78 | BNKN2 | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
79 | BKON2 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
80 | BKRF2 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
81 | BSWIFT2 | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
82 | BTYP3 | BNTYP | BNTYP | CHAR | 1 | 0 | Type of bank in a bank chain (correspondent, intermediary) | ||
83 | BNKS3 | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
84 | BNKL3 | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
85 | BNKN3 | BANKN35 | BANKN35 | CHAR | 35 | 0 | Bank account number | ||
86 | BKON3 | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
87 | BKRF3 | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
88 | BSWIFT3 | SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
89 | .INCLUDE | 0 | 0 | Payment Medium: Instructions for the Bank | |||||
90 | DTAWS | DTAWS | DTAWS | CHAR | 2 | 0 | Instruction key for data medium exchange | * | |
91 | DTAMS | DTAMS | DTAMS | CHAR | 1 | 0 | Report key for data medium exchange | ||
92 | DTWS1 | DTAT16 | DTWSX | NUMC | 2 | 0 | Instruction key 1 | * | |
93 | DTWS2 | DTAT17 | DTWSX | NUMC | 2 | 0 | Instruction key 2 | * | |
94 | DTWS3 | DTAT18 | DTWSX | NUMC | 2 | 0 | Instruction key 3 | * | |
95 | DTWS4 | DTAT19 | DTWSX | NUMC | 2 | 0 | Instruction key 4 | * | |
96 | RFTTRN | RFTTRN_BF | RFTTRN_BF | CHAR | 20 | 0 | Payment code | ||
97 | .INCLUDE | 0 | 0 | Payment Medium: Payment Document | |||||
98 | DOC1T | DOC1T_FPM | DOCTP_FPM | CHAR | 2 | 0 | Payment Document Category | ||
99 | DOC1R | DOC1R_FPM | CHAR24 | CHAR | 24 | 0 | Reference to Payment Document | ||
100 | SRTGB | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
101 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
102 | RWBTR | BF_RWBTR | WERTV12 | CURR | 23 | 2 | Amount paid in transaction currency | ||
103 | RWSKT | BF_RWSKT | WERTV12 | CURR | 23 | 2 | Total Cash Discount in Payment (Transaction Currency) | ||
104 | WQSTE | WQSTV_FPM | WERTV12 | CURR | 23 | 2 | Withholding Tax Amount (+/-) in Foreign Currency | ||
105 | WABZG | WABZV_FPM | WERTV12 | CURR | 23 | 2 | Total Deductions (+/-) in Foreign Currency | ||
106 | WRBTR | WRBTV_FPM | WERTV12 | CURR | 23 | 2 | Amount Before Deductions in Foreign Currency with +/- Signs | ||
107 | RBETR | BF_RBETR | WERTV12 | CURR | 23 | 2 | Amount Paid in Local Currency | ||
108 | RSKON | BF_RSKON | WERTV12 | CURR | 23 | 2 | Total Cash Discount Included in Payment (Local Currency) | ||
109 | XKDFB | XKDFB_FPM | XFELD | CHAR | 1 | 0 | Indicator: Do Not Post any Exchange Rate Differences | ||
110 | ZALDT | DZALDT_ZHL | DATUM | DATS | 8 | 0 | Posting date of the payment document | ||
111 | AUSFD | AUSFD | DATUM | DATS | 8 | 0 | Due date of the paid items | ||
112 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
113 | CRVAL | PRQ_CRVAL | DATUM | DATS | 8 | 0 | Value Date at Payee's Bank | ||
114 | RPOST | BF_RPOST | PACK4 | DEC | 7 | 0 | Number of Items paid | ||
115 | RTEXT | BF_RTEXT | PACK4 | DEC | 7 | 0 | Number of Text Lines for the Items Paid | ||
116 | PAYGR | PAYGR_FPM | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
117 | WDATE | WDATE | DATUM | DATS | 8 | 0 | Bill of Exchange Issue Date | ||
118 | WEFAE | WEFAE | DATUM | DATS | 8 | 0 | Bill of Exchange Due Date | ||
119 | WEAMX | WEAMX | PACK2 | DEC | 3 | 0 | Number of Bills of Exchange with Maximum Amount | ||
120 | WEFMX | WEFMX | WERT7 | CURR | 13 | 2 | Maximum Amount per Bill of Exchange in Payment Currency | ||
121 | WEFRS | WEFRS | WERT7 | CURR | 13 | 2 | Remaining Amount in Payment Crcy for Last Bill of Exchange | ||
122 | .INCLUDE | 0 | 0 | Payment Medium: Payment Method | |||||
123 | RZAWE | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
124 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
125 | AVISG | AVISG_FPM | CHAR1 | CHAR | 1 | 0 | Reason for Printing Payment Advice | ||
126 | INTRACOMP | INTRACOMP_FPM | XFELD | CHAR | 1 | 0 | Intracompany Payment | ||
127 | FORMZ | FORMZ_FPM | FORMZ_FPM | CHAR | 6 | 0 | Supplement for Payment Medium Format | * | |
128 | PURP_CODE | FPM_PURP_CODE | CHAR4 | CHAR | 4 | 0 | SEPA Purpose Code: Classification of a Payment/Debit Memo | ||
129 | .INCLUDE | 0 | 0 | Payment Medium: Accounting Clerk | |||||
130 | UBUSA | UBUSA_FPM | CHAR35 | CHAR | 35 | 0 | Accounting Clerk (Short Entry) | ||
131 | SALUT | AD_TITLE_T | TEXT20 | CHAR | 20 | 0 | Form of address text | ||
132 | FNAME | AD_NAMEFIR | TEXT40 | CHAR | 40 | 0 | First name | ||
133 | LNAME | AD_NAMELAS | TEXT40 | CHAR | 40 | 0 | Last name | ||
134 | NAMP1 | AD_NAMTEXT | TEXT80 | CHAR | 80 | 0 | Full Name of Person | ||
135 | NAMP2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
136 | ID_CODE | AD_ID_CODE | TEXT10 | CHAR | 10 | 0 | Short name for correspondence | ||
137 | SABSPRA | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
138 | ABTEI | AD_DPRTMNT | TEXT40 | CHAR | 40 | 0 | Department | ||
139 | FUNCTION | AD_FNCTN | TEXT40 | CHAR | 40 | 0 | Function | ||
140 | ROOMN | AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
141 | BUILD | AD_BLDNG | TEXT20 | CHAR | 20 | 0 | Building (Number or Code) | ||
142 | FLOOR_C | AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
143 | IH_MAIL | AD_IH_MAIL | TEXT10 | CHAR | 10 | 0 | Int. mail postal code | ||
144 | TELF1 | TLFNR | TEXT30 | CHAR | 30 | 0 | Addresses: telephone no. | ||
145 | TEL_EXTEN1 | AD_TLXTNS1 | CHAR10 | CHAR | 10 | 0 | First Telephone No.: Extension | ||
146 | TELF2 | TLFNR | TEXT30 | CHAR | 30 | 0 | Addresses: telephone no. | ||
147 | TEL_EXTEN2 | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
148 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
149 | FAX_EXTENS | AD_FXXTNS1 | CHAR10 | CHAR | 10 | 0 | First fax no.: extension | ||
150 | INTAD | INTAD | TXT130 | CHAR | 130 | 0 | Internet address of partner company clerk |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FPAYH | ZADNR | ADRC | ADDRNUMBER | |||
2 | FPAYH | ZBNKS | T005 | LAND1 | |||
3 | FPAYH | ZLAND | T005 | LAND1 | |||
4 | FPAYH | ZREGI | T005S | BLAND | |||
5 | FPAYH | ZSPRA | T002 | SPRAS |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |