SAP ABAP Table IRTP_US_PLAN_REPORT (Structure for reporting of master data retirement plan)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-BCA (Application Component) Bank Customer Accounts
     ⤷ BCA_US (Package) BCA modification for US specific requirements

Basic Data

Table Category	INTTAB	Structure
Structure	IRTP_US_PLAN_REPORT	Table Relationship Diagram
Short Description	Structure for reporting of master data retirement plan

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Screen fields for the identification of a retirement plan
2	BKKRS	☐	BKK_BKKRS	BKK_BKKRS	CHAR	4	0	Bank Area	TBKK01
3	T_BKKRS	☐	BKK_T_BKRS	TEXT25	CHAR	25	0	Description Bank Area
4	PLAN_NUMBER	☐	RTP_US_NUMB	RTP_US_NUMB	CHAR	15	0	Plan number of a retirement plan	RTP_US_PLAN
5	TYPE_CODE	☐	RTP_US_TYPE	RTP_US_TYPE	CHAR	2	0	Type code for a retirement plan	TRTP_US_PLANTYPE
6	TYPE_DESCRIPTION	☐	RTP_US_DESC_TYPE	RTP_US_SHORT_DESCRIPTION	CHAR	20	0	Description of the retirement plan type
7	PLAN_NAME	☐	RTP_US_NAME	RTP_US_NAME	CHAR	30	0	Plan name of the retirement plan
8	.INCLUDE	☐				0	0	business partner identification
9	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
10	NAME	☐	RTP_US_BP_NAME	RTP_US_BP_NAME	CHAR	60	0	Full name of business partner
11	ROLE	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	*
12	CONTRIB_LIM_CODE	☑	RTP_US_LIM_CODE	RTP_US_LIMIT_CODE	CHAR	2	0	Contribution limit code	TRTP_US_LIM_ID
13	CONTRIB_LIM_DESCRIPTION	☐	RTP_US_DESC_LIM	RTP_US_DESCRIPTION	CHAR	50	0	Description of the contribution limit code
14	CALENDAR_YEAR	☑	RTP_US_YEAR	RTP_US_DATE_YEAR	NUMC	4	0	Calendar year
15	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
16	CURRENT_FMV	☐	RTP_US_CFMV_AMOUNT	RTP_US_TOT_AMT	CURR	23	2	This year's Fair Market Value
17	PREVIOUS_FMV	☐	RTP_US_PFMV_AMOUNT	RTP_US_TOT_AMT	CURR	23	2	Previous year's Fair Market Value
18	AGE_ACCOUNTHOLDER	☐	RTP_US_AGE_ACCOUNTHOLDER	RTP_US_AGE_C	NUMC	3	0	Accountholder's age
19	AGE_LOW	☐	RTP_US_AGE_LOW	RTP_US_AGE	DEC	4	1	Lower age
20	AGE_HIGH	☐	RTP_US_AGE_HIGH	RTP_US_AGE	DEC	4	1	Upper age
21	AMOUNT_CONTRIBUTION	☐	RTP_US_C_AMOUNT	RTP_US_AMOUNT	CURR	17	2	Aggregated contribution amount
22	MAX_CONT	☐	RTP_US_MAX_CON	RTP_US_AMOUNT	CURR	17	2	Maximum allowed contribution
23	AMOUNT_DISTRIBUTION	☐	RTP_US_D_AMOUNT	RTP_US_AMOUNT	CURR	17	2	Aggregated distribution amount
24	RMD	☐	RTP_US_RMD_AMOUNT	RTP_US_AMOUNT	CURR	17	2	Amount of the Required Minimum Distribution
25	STORED_FMV	☐	RTP_US_RFMV_AMOUNT	RTP_US_TOT_AMT	CURR	23	2	Stored Fair Market Value
26	CALCULATED_FMV	☐	RTP_US_HFMV_AMOUNT	RTP_US_TOT_AMT	CURR	23	2	Calculated Fair Market Value
27	FMV_STATUS	☐	RTP_US_FMV_STATUS	CHAR50	CHAR	50	0	Status of the fair market value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IRTP_US_PLAN_REPORT	BKKRS	TBKK01	BKKRS	KEY	1	CN
2	IRTP_US_PLAN_REPORT	CONTRIB_LIM_CODE	TRTP_US_LIM_ID	CONTRIB_LIM_CODE	KEY	1	CN
3	IRTP_US_PLAN_REPORT	CURRENCY	TCURC	WAERS	KEY	1	CN
4	IRTP_US_PLAN_REPORT	PLAN_NUMBER	RTP_US_PLAN	PLAN_NUMBER	KEY	1	CN
5	IRTP_US_PLAN_REPORT	TYPE_CODE	TRTP_US_PLANTYPE	TYPE_CODE	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	110