RTP_US_PLAN

Retirement plan data (US enhancement) | #masterdata | Component: Bank Customer Accounts
Column Name Description
CLIENT Client
BKKRS FK Bank Area
PLAN_NUMBER Plan number of a retirement plan
Column Name Description
Column Name Description
Column Name Description
DATE_MAR Date of maturity for the accountholder of a Coverdell ESA
OP_DAT Opening date
CLS_DAT Closing date of the retirement plan
CHNG_DATE Date last changed
CHNG_TIME Time last changed
CR_DATE Date created
CR_TIME Time created
Column Name Description
NATURE Nature of a retirement plan Show values
CHNG_RES Yes/No Indication responsible person may change accountholde Show values
RES_TRANS Yes/No Indication responsible person remains responsible Show values
STATUS Status of the retirement plan Show values
Column Name Description Domain name
PLAN_NAME Plan name of the retirement plan RTP_US_NAME
SEARCH1 Search item 1 RTP_US_SEARCH
SEARCH2 Search item 2 RTP_US_SEARCH
CHNG_USER Last changed by RTP_US_USER
CR_USER Created by RTP_US_USER
Master Data Relations Join Conditions
Authorization Group
  • Authorization Group
  • ?
  • RTP_US_PLAN.CLIENT == TB037.CLIENT
  • RTP_US_PLAN.AUGRP == TB037.AUGRP
  • RTP_US_PLAN.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Bank Area
  • RTP_US_PLAN.CLIENT == TBKK01.MANDT
  • RTP_US_PLAN.BKKRS == TBKK01.BKKRS
Currency of the retirement plan
  • RTP_US_PLAN.CLIENT == TCURC.MANDT
  • RTP_US_PLAN.CURRENCY == TCURC.WAERS
Type code for a retirement plan RTP_US_PLAN.TYPE_CODE == TRTP_US_PLANTYPE.TYPE_CODE