SAP RTP_US_TOT Total amounts for a retirement plan Table data and field list

RTP_US_TOT is a standard SAP Table which is used to store Total amounts for a retirement plan data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The RTP_US_TOT table consists of various fields, each holding specific information or linking keys about Total amounts for a retirement plan data available in SAP. These include BKKRS (Bank Area), PLAN_NUMBER (Plan number of a retirement plan), TAX_YEAR (Tax-year), AMOUNT_ID (Amount identifier code)... 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. .

RTP_US_TOT table Technical Details:

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


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the RTP_US_TOT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
BKKRSBank Area BKK_BKKRSCHAR4TBKK01BKK_BKKRSBNS
PLAN_NUMBERPlan number of a retirement plan RTP_US_NUMBCHAR15RTP_US_PLANALPHARTP_US_NUMBRTPN
TAX_YEARTax-year RTP_US_TAXYEARNUMC4RTP_US_DATE_YEAR
AMOUNT_IDAmount identifier code RTP_US_AMN_IDCHAR2TRTP_US_AMNTIDRTP_US_AMN_ID
CONTRIB_IDContribution identifier RTP_US_CON_IDCHAR2TRTP_US_CONTRTP_US_CON_ID
IRS_DCODERetirement plan distribution code RTP_US_IRSCHAR1TRTP_US_DIST_SRTP_US_IRS
IRS_SCODERetirement plan distribution sub-code RTP_US_IRS_SUBCHAR1TRTP_US_DIST_SRTP_US_IRS
CURRENCYCurrency of the retirement plan RTP_US_CURRENCYCUKY5TCURCWAERS
AMOUNTTotal amount of specific type RTP_US_TOT_AMOUNTCURR23(2) RTP_US_TOT_AMT

Key field Non-key field



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

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

SELECT SINGLE *
FROM RTP_US_TOT
INTO CORRESPONDING FIELDS OF WA_RTP_US_TOT
WHERE...

How to access SAP table RTP_US_TOT

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

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