TRPRT_PAYMENTS - Persistent Data for Payment Requests

Persistent Data for Payment Requests information is stored in SAP table TRPRT_PAYMENTS.
It is part of development package FTR_PAYMENT_REQUEST in software component FIN-FSCM-TRM-TM-AC. This development package consists of objects that can be grouped under "CFM-TM: Payment with Payment Requests".

Fields for table TRPRT_PAYMENTS

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
OS_GUID	Globally Unique Identifier	X	OS_GUID	RAW	16
COMPANY_CODE	Company Code		BUKRS	CHAR	8
PRQ_KEYNO	Key Number for Payment Request		PRQ_KEYNO	CHAR	20
PAYMENT_AWKEY	Payment Reference Key		TPM_PAYMENT_AWKEY	CHAR	40
BUSTRANSID	Identifier of the Distributor Business Transaction		TPM_BUSTRANSID	RAW	16
VALUATION_AREA	Treasury Valuation Area		TPM_VAL_AREA	CHAR	6
ITEM_NUMBER	Accounting Document Line Item Number		POSNR_ACC	NUMC	20
FLOW_NUMBER	Number of a Distributor Flow		TPM_TRDFLOWNR	INT4	4
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
POSTING_YEAR	Fiscal Year		GJAHR	NUMC	8
PAYMENT_CURR	Payment Currency		TPM_PAYMENT_CURR	CUKY	10
PAYMENT_AMT	Payment Amount		TPM_PAYMENT_AMT	CURR	11
PAYMENT_DATE	Payment Date		TPM_PAYMENT_DATE	DATS	16
SPAYRQ	Generate Payment Request		TB_SPAYRQK	CHAR	2
SPRSNG	Individual payment required		TB_SPRSNG	CHAR	2
SCSPAY	Same Direction Necessary for Joint Payment?		TB_SCSPAY	CHAR	2
SIGN	Direction of Flow		TB_SSIGN	CHAR	2
SPRGRD	Determine Grouping Definition		TB_SPRGRD	CHAR	2
PAYGR	Grouping Field for Automatic Payments		PAYGR	CHAR	40
HOUSE_BANK	Short Key for Own House Bank		TB_RHABKI	CHAR	10
HOUSE_BANK_ACC	Short Key for House Bank Account		TB_RHKTID	CHAR	10
RPZAHL	Payer/Payee		TB_RPZAHL_NEW	CHAR	20
RPBANK	Partner Bank Details		TB_RPBANK	CHAR	8
RPCODE	Repetitive Code		RPCODE	CHAR	40
RP_TEXT	Reference Text for Repetitive Code		RPCODE_TEXT	CHAR	100
KUNNR	Customer Number		KUNNR	CHAR	20
GL_ACCOUNT	General Ledger Account		HKONT	CHAR	20
CLEARING_ACC	G/L Account for Bank Clearing Account		PRQ_BKHBK	CHAR	20
FI_REV_REASON	Reason for Reversal or Inverse Posting		STGRD	CHAR	4
TR_REV_REASON	Reason for Reversal		SSTOGRD	CHAR	4
REVERSAL_DATE	Posting Date in the Document		BUDAT	DATS	16
PAYMENT_STATE	Status of Payment Request		TPM_TRPRSTATE	CHAR	2
RELEASE_STATE	Release Status for Payment Requests		TPM_TRPR_RELSTATE	CHAR	2
SGTXT	Item Text		SGTXT	CHAR	100
SWIFT_TEXT	SWIFT Text		PRQ_SWTXT	CHAR	280
URGENT	Indicator: Extremely Urgent Payment		PRQ_XURGE	CHAR	2
DTAMS	Report key for data medium exchange		DTAMS	CHAR	2
DTAWS	Instruction Key for Data Medium Exchange		DTAWS	CHAR	4
DTWS1	Instruction Key 1		DTAT16	NUMC	4
DTWS2	Instruction Key 2		DTAT17	NUMC	4
DTWS3	Instruction key 3		DTAT18	NUMC	4
DTWS4	Instruction key 4		DTAT19	NUMC	4
SUB_FLOW_NUMBER	Number of a Distributor Flow		TPM_TRDFLOWNR	INT4	4
UZAWE	Payment method supplement		UZAWE	CHAR	4
CLASS_OID	Globally Unique Identifier		OS_GUID	RAW	16
POSITION_OID	Object Identity in Database Format		TPM_DB_OS_GUID	CHAR	64
.INCLUDE				TRGS_USER_DATA_INCL	0
CREATE_NAME	Entered By		RERF	CHAR	24
CREATE_DATE	First Entered On		DERF	DATS	16
CREATE_TIME	Time of Creation		TERF	TIMS	12
CREATE_TCODE	Transaction Code		TCODE	CHAR	40
CHANGE_NAME	Employee ID		RBEAR	CHAR	24
CHANGE_DATE	Last Edited On		DBEAR	DATS	16
CHANGE_TIME	Last Edited At		TBEAR	TIMS	12
CHANGE_TCODE	Transaction Code		TCODE	CHAR	40
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
PAYMENT_CAT	Payment Request Category		TPM_PAYMENT_CAT	CHAR	2