SAP Table TRPRT_PAYMENTS

Persistent Data for Payment Requests

The table TRPRT_PAYMENTS (Persistent Data for Payment Requests) is a standard table in SAP ERP. It belongs to the package FTR_PAYMENT_REQUEST.

Technical Information

Table	TRPRT_PAYMENTS
Short Text	Persistent Data for Payment Requests
Package	FTR_PAYMENT_REQUEST
Table Type	Transparent Table

Fields for Table TRPRT_PAYMENTS

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	*
OS_GUID	✔	Globally Unique Identifier	OS_GUID	RAW	16
COMPANY_CODE		Company Code	BUKRS	CHAR	4	*
PRQ_KEYNO		Key Number for Payment Request	PRQ_KEYNO	CHAR	10	*
PAYMENT_AWKEY		Payment Reference Key	TPM_PAYMENT_AWKEY	CHAR	20
BUSTRANSID		Identifier of the Distributor Business Transaction	TPM_BUSTRANSID	RAW	16
VALUATION_AREA		Valuation Area	TPM_VAL_AREA	CHAR	3	*
ITEM_NUMBER		Accounting Document Line Item Number	POSNR_ACC	NUMC	10
FLOW_NUMBER		Number of a Distributor Flow	TPM_TRDFLOWNR	INT4	10
BELNR		Accounting Document Number	BELNR_D	CHAR	10
BUZEI		Number of Line Item Within Accounting Document	BUZEI	NUMC	3
POSTING_YEAR		Fiscal Year	GJAHR	NUMC	4
PAYMENT_CURR		Payment Currency	TPM_PAYMENT_CURR	CUKY	5	*
PAYMENT_AMT		Payment Amount	TPM_PAYMENT_AMT	CURR	21
PAYMENT_DATE		Payment Date	TPM_PAYMENT_DATE	DATS	8
SPAYRQ		Generate payment request	TB_SPAYRQK	CHAR	1
SPRSNG		Individual payment required	TB_SPRSNG	CHAR	1
SCSPAY		Same direction necessary for joint payment?	TB_SCSPAY	CHAR	1
SIGN		Direction of flow	TB_SSIGN	CHAR	1
SPRGRD		Determine grouping definition	TB_SPRGRD	CHAR	1
PAYGR		Grouping Field for Automatic Payments	PAYGR	CHAR	20
HOUSE_BANK		Short key for own house bank	TB_RHABKI	CHAR	5	*
HOUSE_BANK_ACC		Short key for house bank account	TB_RHKTID	CHAR	5	*
RPZAHL		Payer/payee	TB_RPZAHL_NEW	CHAR	10	*
RPBANK		Partner bank details	TB_RPBANK	CHAR	4
ZWELS		List of the Payment Methods to be Considered	DZWELS	CHAR	10
RPCODE		Repetitive Code	RPCODE	CHAR	20	*
RP_TEXT		Reference Text for Repetitive Code	RPCODE_TEXT	CHAR	50
GL_ACCOUNT		General Ledger Account	HKONT	CHAR	10	*
CLEARING_ACC		G/L Account for Bank Clearing Account	PRQ_BKHBK	CHAR	10	*
FI_REV_REASON		Reason for Reversal	STGRD	CHAR	2	*
TR_REV_REASON		Reason for Reversal	SSTOGRD	CHAR	2	*
REVERSAL_DATE		Posting Date in the Document	BUDAT	DATS	8
PAYMENT_STATE		Status of Payment Request	TPM_TRPRSTATE	CHAR	1
RELEASE_STATE		Release Status for Payment Requests	TPM_TRPR_RELSTATE	CHAR	1
SGTXT		Item Text	SGTXT	CHAR	50
SWIFT_TEXT		Swift Text	PRQ_SWTXT	CHAR	140
URGENT		Indicator: Extremely Urgent Payment	PRQ_XURGE	CHAR	1
DTAMS		Indicator for Data Medium Exchange	DTAMS	CHAR	1
DTAWS		Instruction key for data medium exchange	DTAWS	CHAR	2	*
DTWS1		Instruction key 1	DTAT16	NUMC	2	*
DTWS2		Instruction key 2	DTAT17	NUMC	2	*
DTWS3		Instruction key 3	DTAT18	NUMC	2	*
DTWS4		Instruction key 4	DTAT19	NUMC	2	*
SUB_FLOW_NUMBER		Number of a Distributor Flow	TPM_TRDFLOWNR	INT4	10
UZAWE		Payment Method Supplement	UZAWE	CHAR	2	*
CLASS_OID		Globally Unique Identifier	OS_GUID	RAW	16
POSITION_OID		Object Identity in Database Format	TPM_DB_OS_GUID	CHAR	32
CREATE_NAME		Entered by	RERF	CHAR	12
CREATE_DATE		First Entered on	DERF	DATS	8
CREATE_TIME		Time of Initial Entry	TERF	TIMS	6
CREATE_TCODE		Transaction Code	TCODE	CHAR	20	*
CHANGE_NAME		Employee ID	RBEAR	CHAR	12
CHANGE_DATE		Last Edited on	DBEAR	DATS	8
CHANGE_TIME		Last Edited at	TBEAR	TIMS	6
CHANGE_TCODE		Transaction Code	TCODE	CHAR	20	*
MNDID		Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35