1. Home
  2. Resources
  3. SAP Tables
  4. FPAYP - Payment medium: Data on paid items

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.

Source: FPAYP (Payment medium: Data on paid items)

FPAYP 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: Only Proposal Run? XVORL CHAR 1 0
X Yes
NULL No
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
01 Central business partner
11 Vendor, creditor
12 Customer, debtor
13 Branch
14 Business partner's CPD encryption
21 Personnel number
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
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
DOC2R Reference to Paid Document DOC2R_FPM CHAR 24 0
VOR1T Activity Type VOR1T_FPM CHAR 2 0
01 Document type
02 Posting key and special G/L indicator
11 Main transaction
12 Sub-transaction
VOR1R Reference to Activity VOR1R_FPM CHAR 4 0
VOR2T Activity Type VOR1T_FPM CHAR 2 0
01 Document type
02 Posting key and special G/L indicator
11 Main transaction
12 Sub-transaction
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