TRPRT_PAYMENTS SAP (Persistent Data for Payment Requests) Table details

Dictionary Type: Table
Description: Persistent Data for Payment Requests




ABAP Code to SELECT data from TRPRT_PAYMENTS
Related tables to TRPRT_PAYMENTS
Access table TRPRT_PAYMENTS




Table field list including key, data, relationships and ABAP select examples

TRPRT_PAYMENTS is a standard SAP Table which is used to store Persistent Data for Payment Requests data and is available within R/3 SAP systems depending on the version and release level.

The TRPRT_PAYMENTS table consists of various fields, each holding specific information or linking keys about Persistent Data for Payment Requests data available in SAP. These include OS_GUID (Globally Unique Identifier), COMPANY_CODE (Company Code), PRQ_KEYNO (Key Number for Payment Request), PAYMENT_AWKEY (Payment Reference Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP TRPRT_PAYMENTS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
OS_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
PRQ_KEYNOKey Number for Payment Request PRQ_KEYNOCHAR10Assigned to domainALPHAPRQ_KEYNO
PAYMENT_AWKEYPayment Reference Key TPM_PAYMENT_AWKEYCHAR20AWKEY
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3Assigned to domainTPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
ITEM_NUMBERAccounting Document Line Item Number POSNR_ACCNUMC10POSNR_ACC
FLOW_NUMBERNumber of a Distributor Flow TPM_TRDFLOWNRINT410TPM_TRDFLOWNR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
POSTING_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PAYMENT_CURRPayment Currency TPM_PAYMENT_CURRCUKY5Assigned to domainWAERS
PAYMENT_AMTPayment Amount TPM_PAYMENT_AMTCURR21(2) TPM_AMOUNT
PAYMENT_DATEPayment Date TPM_PAYMENT_DATEDATS8TPM_POSITION_DATE
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
SPRSNGIndividual payment required TB_SPRSNGCHAR1T_SPAYRQ
SCSPAYSame direction necessary for joint payment? TB_SCSPAYCHAR1XFELD
SIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
SPRGRDDetermine grouping definition TB_SPRGRDCHAR1T_SPRGRD
PAYGRGrouping Field for Automatic Payments PAYGRCHAR20CHAR20
HOUSE_BANKShort key for own house bank TB_RHABKICHAR5Assigned to domainHBKID
HOUSE_BANK_ACCShort key for house bank account TB_RHKTIDCHAR5Assigned to domainHKTID
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
RPCODERepetitive Code RPCODECHAR20Assigned to domainALPHARPCODEFIBL_RPCODE
RP_TEXTReference Text for Repetitive Code RPCODE_TEXTCHAR50XTEXT50
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
CLEARING_ACCG/L Account for Bank Clearing Account PRQ_BKHBKCHAR10Assigned to domainALPHASAKNR
FI_REV_REASONReason for Reversal STGRDCHAR2Assigned to domainSTGRDFSG
TR_REV_REASONReason for Reversal SSTOGRDCHAR2Assigned to domainSSTOGRD
REVERSAL_DATEPosting Date in the Document BUDATDATS8DATUM
PAYMENT_STATEStatus of Payment Request TPM_TRPRSTATECHAR1TPM_TRPRSTATE
RELEASE_STATERelease Status for Payment Requests TPM_TRPR_RELSTATECHAR1TPM_TRPR_RELSTATE
SGTXTItem Text SGTXTCHAR50TEXT50
SWIFT_TEXTSwift Text PRQ_SWTXTCHAR140PRQ_SWTXT
URGENTIndicator: Extremely Urgent Payment PRQ_XURGECHAR1X
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
DTWS1Instruction key 1 DTAT16NUMC2Assigned to domainDTWSX
DTWS2Instruction key 2 DTAT17NUMC2Assigned to domainDTWSX
DTWS3Instruction key 3 DTAT18NUMC2Assigned to domainDTWSX
DTWS4Instruction key 4 DTAT19NUMC2Assigned to domainDTWSX
SUB_FLOW_NUMBERNumber of a Distributor Flow TPM_TRDFLOWNRINT410TPM_TRDFLOWNR
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
CLASS_OIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
POSITION_OIDObject Identity in Database Format TPM_DB_OS_GUIDCHAR32TPM_DB_OS_GUID
CREATE_NAMEEntered by RERFCHAR12SYCHAR12
CREATE_DATEFirst Entered on DERFDATS8DATUM
CREATE_TIMETime of Initial Entry TERFTIMS6TIMES
CREATE_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
CHANGE_NAMEEmployee ID RBEARCHAR12SYCHAR12
CHANGE_DATELast Edited on DBEARDATS8DATUM
CHANGE_TIMELast Edited at TBEARTIMS6TIMES
CHANGE_TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035

Key field Non-key field



How do I retrieve data from SAP table TRPRT_PAYMENTS using ABAP code

The following ABAP code Example will allow you to do a basic selection on TRPRT_PAYMENTS to SELECT all data from the table
DATA: WA_TRPRT_PAYMENTS TYPE TRPRT_PAYMENTS.

SELECT SINGLE *
FROM TRPRT_PAYMENTS
INTO CORRESPONDING FIELDS OF WA_TRPRT_PAYMENTS
WHERE...

How to access SAP table TRPRT_PAYMENTS

Within an ECC or HANA version of SAP you can also view further information about TRPRT_PAYMENTS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!