RTP_US_HIST

Retirement plan history and audit table | #masterdata | Component: Bank Customer Accounts
Column Name Description
CLIENT FK Client
BKKRS FK Bank Area
PLAN_NUMBER FK Plan number of a retirement plan
TRANS_DATE Transaction date
SEQ_NUMB Sequence number of the transaction made that day
Column Name Description
💲 Currency of the retirement plan (CURRENCY):
AMOUNT Transaction amount
Column Name Description
Column Name Description
TRANS_DATE Transaction date
Column Name Description
Column Name Description Domain name
TAX_YEAR Tax-year RTP_US_DATE_YEAR
Master Data Relations Join Conditions
Amount identifier code
Bank Area
  • RTP_US_HIST.CLIENT == TBKK01.MANDT
  • RTP_US_HIST.BKKRS == TBKK01.BKKRS
Client RTP_US_HIST.CLIENT == T000.MANDT
Contribution identifier
Currency of the retirement plan
  • RTP_US_HIST.CLIENT == TCURC.MANDT
  • RTP_US_HIST.CURRENCY == TCURC.WAERS
Retirement plan distribution code RTP_US_HIST.IRS_DCODE == TRTP_US_DIST_S.IRS_CODE
Retirement plan distribution sub-code RTP_US_HIST.IRS_SCODE == TRTP_US_DIST_S.IRS_CODE
Plan number of a retirement plan
  • Bank Area
  • Client
  • Plan number of a retirement plan