SAP RTP_US_PLAN Retirement plan data (US enhancement) Table data and field list

RTP_US_PLAN is a standard SAP Table which is used to store Retirement plan data (US enhancement) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The RTP_US_PLAN table consists of various fields, each holding specific information or linking keys about Retirement plan data (US enhancement) data available in SAP. These include BKKRS (Bank Area), PLAN_NUMBER (Plan number of a retirement plan), TYPE_CODE (Type code for a retirement plan), NATURE (Nature of a retirement plan)... 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_PLAN 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: Can be enhanced (character-type)


SAP RTP_US_PLAN 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_PLAN 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 MANDTCLNT3Assigned to domainMANDT
BKKRSBank Area BKK_BKKRSCHAR4TBKK01BKK_BKKRSBNS
PLAN_NUMBERPlan number of a retirement plan RTP_US_NUMBCHAR15ALPHARTP_US_NUMBRTPN
TYPE_CODEType code for a retirement plan RTP_US_TYPECHAR2TRTP_US_PLANTYPERTP_US_TYPE
NATURENature of a retirement plan RTP_US_NATURECHAR2RTP_US_NATURE
PLAN_NAMEPlan name of the retirement plan RTP_US_NAMECHAR30RTP_US_NAME
CHNG_RESYes/No Indication responsible person may change accountholde RTP_US_XIND_RESPCHAR1RTP_US_XIND
RES_TRANSYes/No Indication responsible person remains responsible RTP_US_XIND_TRANSCHAR1RTP_US_XIND
DATE_MARDate of maturity for the accountholder of a Coverdell ESA RTP_US_MATDATDATS8RTP_US_DATE
OP_DATOpening date RTP_US_OPDATDATS8RTP_US_DATERTPDAT
CLS_DATClosing date of the retirement plan RTP_US_CLSDATDATS8RTP_US_DATE
STATUSStatus of the retirement plan RTP_US_STATUSCHAR1RTP_US_STATUS
AUGRPAuthorization Group BU_AUGRPCHAR4TB037BU_AUGRP
CURRENCYCurrency of the retirement plan RTP_US_CURRENCYCUKY5TCURCWAERS
SEARCH1Search item 1 RTP_US_SEAR1CHAR20RTP_US_SEARCH
SEARCH2Search item 2 RTP_US_SEAR2CHAR20RTP_US_SEARCH
CHNG_USERLast changed by RTP_US_CHUSRCHAR12RTP_US_USER
CHNG_DATEDate last changed RTP_US_CHDATDATS8RTP_US_DATE
CHNG_TIMETime last changed RTP_US_CHTIMTIMS6RTP_US_TIME
CR_USERCreated by RTP_US_CRUSRCHAR12RTP_US_USER
CR_DATEDate created RTP_US_CRDATDATS8RTP_US_DATE
CR_TIMETime created RTP_US_CRTIMTIMS6RTP_US_TIME

Key field Non-key field



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

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

SELECT SINGLE *
FROM RTP_US_PLAN
INTO CORRESPONDING FIELDS OF WA_RTP_US_PLAN
WHERE...

How to access SAP table RTP_US_PLAN

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

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