1. Home
  2. Resources
  3. SAP Tables
  4. PAYP - Payment program - data on paid item

SAP Table PAYP

Payment program - data on paid item

PAYP (Payment program - data on paid item) 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 PAYP to other SAP tables.

PAYP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAUFD Date ID LAUFD_KK DATS 8 0
LAUFI Identification for the payment run LAUFI_PAY CHAR 5 0
ORIGN Source of the payment data ORIGN_PAY CHAR 1 0
NULL FI AP/AR Payment program for customers and vendors
* FI AP/AR Online check print for customers and vendors
O FI AP/AR Online check print (internal use)
P HR-PY/FI-TV Payroll and travel expenses
J IS-M Publishing
R FI-BL Payment program for payment requests
M FI-CA Payment program of contract accounts receivable
W FI-BL Bill of exchange accounting
X (Reserved for foreign currency valuation)
B FIN-BNK Bank Communication / payment status monitor
XVORL Indicator: Only Proposal Run? XVORL CHAR 1 0
X Yes
NULL No
PAYNO Sequential payment number PAYNO_PAY INT4 10 0
SUBNO Additional distinguishing criterion from payments SUBNO_PAY CHAR 6 0
DOC2T Category for paid document DOC2T_PAY CHAR 2 0
01 Document in Financial Accounting
02 Document in Contract Accounts Receivable/Payable
03 Settlement Result
04 Repayment Request in Contract Accounts Receivable/Payable
05 Payment Order in Contract Accounts Receivable/Payable
06 Direct Debit Pre-Notification
DOC2R Reference to Paid Document DOC2R_PAY CHAR 24 0
GPA2T Category of business partner making a payment GPA2T_PAY CHAR 2 0
01 Central business partner
04 Repayment request in Contract Accounts Receivable/Payable
11 Vendor, creditor
12 Customer, debtor
13 Branch
21 Personnel number
GPA2R Reference to Business Partner Giving Payment Instruction GPA2R_PAY CHAR 12 0
ACC1T Contract Account Category ACC1T_PAY CHAR 2 0
01 Contract Account
ACC1R Reference to Contract Account ACC1R_PAY CHAR 18 0
VOR1T Activity type VOR1T_PAY CHAR 2 0
01 Document Type
02 Posting key and special G/L indicator
11 Main Transaction
12 Subtransaction
VOR1R Reference to Main Transaction VOR1R_PAY CHAR 4 0
VOR2T Activity type VOR1T_PAY CHAR 2 0
01 Document Type
02 Posting key and special G/L indicator
11 Main Transaction
12 Subtransaction
VOR2R Reference to Main Transaction VOR1R_PAY CHAR 4 0
TXT1T Long text type TXT1T_PAY CHAR 2 0
TXT1R Long text reference TXT1R_PAY CHAR 30 0
SUBAP Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
LAND1 Country Key LAND1 T005 CHAR 3 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
ORT01 City AD_CITY1 CHAR 40 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_F110 DATS 8 0
SKTPA Accepted cash discount rate SKTPA_KK DEC 5 3
WAERS Currency Key WAERS TCURC CUKY 5 0
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
AUGBH Clearing amount in local currency with +/- sign AUGBH_KK CURR 13 2
AUGBW Clearing Amount in Transaction Currency (With +/- Sign) AUGBW_KK CURR 13 2
ASKTH Proportional cash discount in local currency ASKTH_KK CURR 13 2
ASKTW Proportional cash discount in transaction currency ASKTW_KK CURR 13 2
POKEN Item indicator in payment program POKEN_PAY TFKPK NUMC 3 0
ZLSPR Lock Reason for Automatic Payment SPZAH_KK TFK008 CHAR 1 0
CLRLO Clearing Lock Reason CLRLO_KK CHAR 1 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
C4EYE Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK CHAR 2 0
OPTXT Item Text SGTXT CHAR 50 0
REF1T Reference information type REFIT_PAY CHAR 2 0
01 Reference document number in FI document
02 ISR Number
03 Payment reference (customer ID number)
REF1R Reference information REFIN_PAY CHAR 40 0
REF2T Reference information type REFIT_PAY CHAR 2 0
01 Reference document number in FI document
02 ISR Number
03 Payment reference (customer ID number)
REF2R Reference information REFIN_PAY CHAR 40 0
REF3T Reference information type REFIT_PAY CHAR 2 0
01 Reference document number in FI document
02 ISR Number
03 Payment reference (customer ID number)
REF3R Reference information REFIN_PAY CHAR 40 0
VTREF Reference Specifications from Contract VTREF_KK CHAR 20 0
VTRE2 Reference Specifications from Contract VTREF_KK CHAR 20 0
LZBKZ State Central Bank Indicator LZBKZ T015L CHAR 3 0
LANDL Supplying Country LANDL T005 CHAR 3 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
AQSBW Proportional Withholding Tax Amount In Transaction Currency AQSBW_KK CURR 13 2
AQSBH Proportional Withholding Tax Amount In Local Currency AQSBH_KK CURR 13 2
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
STAKZ Type of statistical item STAKZ_KK CHAR 1 0
A Down Payment Request
B Quotation
G Other statistical receivable (charges,interest)
H Cash Security Deposit Request
I Down Payment Request from Invoicing
J Payment Request from Invoicing
K Correspondence Request
R Installment Plan Item
S Collective Bill Item
P Budget Billing Plan Item
Q Expected withholding tax deduction
T Statisitcal receivable for other taxes
Z Payment Request

PAYP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PAYP ADRNR SYST MANDT ADRC Addresses (Business Address Services) CLIENT
PAYP ADRNR PAYP ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
PAYP ADRNR * ADRC Addresses (Business Address Services) DATE_FROM
PAYP ADRNR * ADRC Addresses (Business Address Services) NATION
PAYP BUKRS SYST MANDT T001 Company Codes MANDT
PAYP BUKRS PAYP BUKRS T001 Company Codes BUKRS
PAYP GSBER SYST MANDT TGSB Business Areas MANDT
PAYP GSBER PAYP GSBER TGSB Business Areas GSBER
PAYP LAND1 SYST MANDT T005 Countries MANDT
PAYP LAND1 PAYP LAND1 T005 Countries LAND1
PAYP LANDL PAYP LANDL T005 Countries LAND1
PAYP LANDL SYST MANDT T005 Countries MANDT
PAYP LZBKZ PAYP LZBKZ T015L SCB Ratios LZBKZ
PAYP LZBKZ SYST MANDT T015L SCB Ratios MANDT
PAYP MANDT PAYP MANDT T000 Clients MANDT
PAYP POKEN PAYP POKEN TFKPK Item indicator in payments POKEN
PAYP REGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
PAYP REGIO PAYP LAND1 T005S Taxes: Region (Province) Key LAND1
PAYP REGIO PAYP REGIO T005S Taxes: Region (Province) Key BLAND
PAYP WAERS SYST MANDT TCURC Currency Codes MANDT
PAYP WAERS PAYP WAERS TCURC Currency Codes WAERS
PAYP ZLSPR SYST MANDT TFK008 Locking Reasons for Automatic Payment Transactions MANDT
PAYP ZLSPR PAYP ZLSPR TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS