SAP table PAYP (Payment program - data on paid item)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LAUFD Date ID DATS 8 0 LAUFD_KK
LAUFI Identification for the payment run CHAR 5 0 LAUFI_PAY
ORIGN Source of the payment data CHAR 1 0 ORIGN_PAY
XVORL Indicator: Only Proposal Run? CHAR 1 0 XVORL
PAYNO Sequential payment number INT4 10 0 PAYNO_PAY
SUBNO Additional distinguishing criterion from payments CHAR 6 0 SUBNO_PAY
DOC2T Category for paid document CHAR 2 0 DOC2T_PAY
DOC2R Reference to Paid Document CHAR 24 0 DOC2R_PAY
GPA2T Category of business partner making a payment CHAR 2 0 GPA2T_PAY
GPA2R Reference to Business Partner Giving Payment Instruction CHAR 12 0 GPA2R_PAY
ACC1T Contract Account Category CHAR 2 0 ACC1T_PAY
ACC1R Reference to Contract Account CHAR 18 0 ACC1R_PAY
VOR1T Activity type CHAR 2 0 VOR1T_PAY
VOR1R Reference to Main Transaction CHAR 4 0 VOR1R_PAY
VOR2T Activity type CHAR 2 0 VOR1T_PAY
VOR2R Reference to Main Transaction CHAR 4 0 VOR1R_PAY
TXT1T Long text type CHAR 2 0 TXT1T_PAY
TXT1R Long text reference CHAR 30 0 TXT1R_PAY
SUBAP Subapplication in Contract Accounts Receivable and Payable CHAR 1 0 SUBAP_KK
No Contract Reference/Primary Contract
9 Real Estate
ADRNR Address Number CHAR 10 0 ADRC AD_ADDRNUM
NAME1 Name 1 CHAR 40 0 AD_NAME1
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
ORT01 City CHAR 40 0 AD_CITY1
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
FAEDT Due Date of Payment DATS 8 0 FAEDT_F110
SKTPA Accepted cash discount rate DEC 5 3 SKTPA_KK
WAERS Currency Key CUKY 5 0 TCURC WAERS
BETRW Amount in Transaction Currency with +/- Sign CURR 13 2 BETRW_KK
AUGBH Clearing amount in local currency with +/- sign CURR 13 2 AUGBH_KK
AUGBW Clearing Amount in Transaction Currency (With +/- Sign) CURR 13 2 AUGBW_KK
ASKTH Proportional cash discount in local currency CURR 13 2 ASKTH_KK
ASKTW Proportional Cash Discount in Transaction Currency CURR 13 2 ASKTW_KK
STTAX Tax Amount as Statistical Information in Document Currency CURR 13 2 STTAX_KK
POKEN Item indicator in payment program NUMC 3 0 TFKPK POKEN_PAY
001 SAP FI-CA (Standard)
100 SAP FS-CD (Application V)
150 SAP IS-U (Application Area R)
200 SAP IS-T (Application Area T)
250 SAP IS-PS-CA (Application Area P)
300 SAP IS-M-CA (Application ARea M)
350 SAP FI-CAX (Application Area S)
400 Reserved for SAP
900 Reserved for customers (application X)
ZLSPR Lock Reason for Automatic Payment CHAR 1 0 TFK008 SPZAH_KK
CLRLO Clearing Lock Reason CHAR 1 0 * CLRLO_KK
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
C4EYE Check Reason for Workflows Acc. to Dual Control Principle CHAR 2 0 * C4EYE_KK
OPTXT Item Text CHAR 50 0 SGTXT
REF1T Reference information type CHAR 2 0 REFIT_PAY
01 Reference document number in FI document
02 ISR Number
03 Payment reference (customer ID number)
REF1R Reference information CHAR 40 0 REFIN_PAY
REF2T Reference information type CHAR 2 0 REFIT_PAY
01 Reference document number in FI document
02 ISR Number
03 Payment reference (customer ID number)
REF2R Reference information CHAR 40 0 REFIN_PAY
REF3T Reference information type CHAR 2 0 REFIT_PAY
01 Reference document number in FI document
02 ISR Number
03 Payment reference (customer ID number)
REF3R Reference information CHAR 40 0 REFIN_PAY
VTREF Reference Specifications from Contract CHAR 20 0 VTREF_KK
VTRE2 Reference Specifications from Contract CHAR 20 0 VTREF_KK
LZBKZ State Central Bank Indicator CHAR 3 0 T015L LZBKZ
LANDL Supplying Country/Region CHAR 3 0 T005 LANDL
STCD1 Tax Number 1 CHAR 16 0 STCD1
AQSBW Proportional Withholding Tax Amount In Transaction Currency CURR 13 2 AQSBW_KK
AQSBH Proportional Withholding Tax Amount In Local Currency CURR 13 2 AQSBH_KK
QSSKZ Withholding Tax Code CHAR 2 0 * QSSKZ
STAKZ Type of statistical item CHAR 1 0 STAKZ_KK
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
M Collaborative Liability
P Budget Billing Plan Item
Q Expected withholding tax deduction
R Installment Plan Item
S Collective Bill Item
T Statisitcal receivable for other taxes
Z Payment Request
VKBEZ Contract account name CHAR 35 0 VKBEZ_KK
EXVKO Reference number for business partner CHAR 25 0 EXVKO_KK
STXTACT Text for Transaction CHAR 10 0 STXTACT_KK
OPBUK Company Code for Automatic Payment Transactions CHAR 4 0 * PYBUK_KK
BLART Document Type CHAR 2 0 * BLART_KK
SPART Division CHAR 2 0 SPART
VTEXT Name CHAR 20 0 VTXTK

PAYP foreign key relationships

Table Field Check Table Check Field
0 PAYP ADRNR ADRC Addresses (Business Address Services) DATE_FROM
0 PAYP ADRNR ADRC Addresses (Business Address Services) NATION
1 PAYP BUKRS T001 Company Codes BUKRS
0 PAYP GSBER TGSB Business Areas MANDT
0 PAYP GSBER TGSB Business Areas GSBER
1 PAYP LAND1 T005 Countries MANDT
1 PAYP LAND1 T005 Countries LAND1
0 PAYP LANDL T005 Countries MANDT
0 PAYP LANDL T005 Countries LAND1
1 PAYP LZBKZ T015L SCB Ratios LZBKZ
0 PAYP MANDT T000 Clients MANDT
1 PAYP REGIO T005S Taxes: Region (Province) Key LAND1
0 PAYP WAERS TCURC Currency Codes MANDT
0 PAYP WAERS TCURC Currency Codes WAERS
1 PAYP ZLSPR TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS