SAP Table FPAYP
Payment medium: Data on paid items
FPAYP (Payment medium: Data on paid items) 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 FPAYP to other SAP tables.
FPAYP 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: Only Proposal Run?
|
XVORL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
ORIGIN
Origin Indicator
|
FIBL_ORIGIN |
CHAR
|
8 | 0 | ||||||||||||||||
|
LFDNR
Sequential Payment Number
|
LFDNR_FPM |
NUMC
|
8 | 0 | ||||||||||||||||
|
SRTF3
Sorting of Item
|
SRTF3_FPM |
CHAR
|
48 | 0 | ||||||||||||||||
|
GPA2T
Category of Business Partner Making a Payment
|
GPA2T_FPM |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
GPA2R
Reference to Business Partner Making a Payment
|
GPA2R_FPM |
CHAR
|
12 | 0 | ||||||||||||||||
|
ADRNR
Address number
|
AD_ADDRNUM |
CHAR
|
10 | 0 | ||||||||||||||||
|
NAME1
Name 1
|
AD_NAME1 |
CHAR
|
40 | 0 | ||||||||||||||||
|
LAND1
Country Key
|
LAND1 |
CHAR
|
3 | 0 | ||||||||||||||||
|
REGIO
Region (State, Province, County)
|
REGIO |
CHAR
|
3 | 0 | ||||||||||||||||
|
ORT01
City
|
AD_CITY1 |
CHAR
|
40 | 0 | ||||||||||||||||
|
DOC2T
Category for Paid Document
|
DOC2T_FPM |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
DOC2R
Reference to Paid Document
|
DOC2R_FPM |
CHAR
|
24 | 0 | ||||||||||||||||
|
VOR1T
Activity Type
|
VOR1T_FPM |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VOR1R
Reference to Activity
|
VOR1R_FPM |
CHAR
|
4 | 0 | ||||||||||||||||
|
VOR2T
Activity Type
|
VOR1T_FPM |
CHAR
|
2 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
VOR2R
Reference to Activity
|
VOR1R_FPM |
CHAR
|
4 | 0 | ||||||||||||||||
|
BLDAT
Document Date in Document
|
BLDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
FAEDT
Due Date of Payment
|
FAEDT_FPM |
DATS
|
8 | 0 | ||||||||||||||||
|
HWAER
Local Currency
|
HWAER_FPM |
CUKY
|
5 | 0 | ||||||||||||||||
|
DMBTR
Amount Before Deductions in Local Currency with +/- Signs
|
DMBTV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
SKNTO
Cash Discount Amount (+/-) in Local Currency
|
SKNTV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
QSTEU
Withholding Tax Amount (+/-) in Local Currency
|
QSTEV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
NETTO
Net Amount in Local Currency with +/- Signs
|
NETTV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
ABZUG
Total Deductions (+/-) in Local Currency
|
ABZGV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
ZBDXP
Selected cash discount percentage rate
|
DZBDXP |
DEC
|
5 | 3 | ||||||||||||||||
|
WAERS
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||||||||||
|
WRBTR
Amount Before Deductions in Foreign Currency with +/- Signs
|
WRBTV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
WSKTO
Cash Discount Amount in Foreign Currency with +/- Signs
|
WSKTV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
WQSTE
Withholding Tax Amount (+/-) in Foreign Currency
|
WQSTV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
WNETT
Net Amount in Foreign Currency with +/- Signs
|
WNETV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
WABZG
Total Deductions (+/-) in Foreign Currency
|
WABZV_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
PSWSL
Update Currency for General Ledger Transaction Figures
|
PSWSL_FPM |
CUKY
|
5 | 0 | ||||||||||||||||
|
PSWBT
Amount for Updating in General Ledger
|
PSWBT_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
PSSKT
Cash Discount Deduction for the Item
|
PSSKT_FPM |
CURR
|
23 | 2 | ||||||||||||||||
|
POKEN
Item Indicator in Payment Program
|
POKEN_FPM |
NUMC
|
3 | 0 | ||||||||||||||||
|
ZLSPR
Block Reason for Automatic Payment
|
SPRZL_FPM |
CHAR
|
1 | 0 | ||||||||||||||||
|
BUKRS
Company Code
|
BUKRS |
CHAR
|
4 | 0 | ||||||||||||||||
|
BNAME
Name 1
|
AD_NAME1 |
CHAR
|
40 | 0 | ||||||||||||||||
|
BORT1
City
|
AD_CITY1 |
CHAR
|
40 | 0 | ||||||||||||||||
|
BLAND
Country Key
|
LAND1 |
CHAR
|
3 | 0 | ||||||||||||||||
|
BSTRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||||||||||
|
GSBER
Business Area
|
GSBER |
CHAR
|
4 | 0 | ||||||||||||||||
|
SGTXT
Item Text
|
SGTXT |
CHAR
|
50 | 0 | ||||||||||||||||
|
XBLNR
Reference Document Number
|
XBLNR1 |
CHAR
|
16 | 0 | ||||||||||||||||
|
STRFR
Structured Invoice Reference
|
STRFR_FPM |
CHAR
|
40 | 0 | ||||||||||||||||
|
XREF1
Business partner reference key
|
XREF1 |
CHAR
|
12 | 0 | ||||||||||||||||
|
XREF2
Business partner reference key
|
XREF2 |
CHAR
|
12 | 0 | ||||||||||||||||
|
XREF3
Reference key for line item
|
XREF3 |
CHAR
|
20 | 0 | ||||||||||||||||
|
VTREF
Contract Reference
|
VTREF_FPM |
CHAR
|
20 | 0 | ||||||||||||||||
|
LZBKZ
State Central Bank Indicator
|
LZBKZ |
CHAR
|
3 | 0 | ||||||||||||||||
|
LANDL
Supplying Country
|
LANDL |
CHAR
|
3 | 0 | ||||||||||||||||
|
STCEG
VAT Registration Number
|
STCEG |
CHAR
|
20 | 0 | ||||||||||||||||
|
DIEKZ
Service Indicator (Foreign Payment)
|
DIEKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
REF01
User-Defined Field (See Format Documentation)
|
REFER_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
REF02
User-Defined Field (See Format Documentation)
|
REFER_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
REF03
User-Defined Field (See Format Documentation)
|
REFER_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
REF04
User-Defined Field (See Format Documentation)
|
REFER_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
REF05
User-Defined Field (See Format Documentation)
|
REFER_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
ZREF01
User-Defined Text (Customer-Specific)
|
REFERZ_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
ZREF02
User-Defined Text (Customer-Specific)
|
REFERZ_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
ZREF03
User-Defined Text (Customer-Specific)
|
REFERZ_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
ZREF04
User-Defined Text (Customer-Specific)
|
REFERZ_FPM |
CHAR
|
132 | 0 | ||||||||||||||||
|
ZREF05
User-Defined Text (Customer-Specific)
|
REFERZ_FPM |
CHAR
|
132 | 0 | ||||||||||||||||