SAP ABAP Table IRTP_US_PLAN_DB (Database structure of a retirement plan & indicators)

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_DB	Table Relationship Diagram
Short Description	Database structure of a retirement plan & indicators

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	Retirement plan data (US enhancement)
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BKKRS	☐	BKK_BKKRS	BKK_BKKRS	CHAR	4	0	Bank Area	TBKK01
4	PLAN_NUMBER	☐	RTP_US_NUMB	RTP_US_NUMB	CHAR	15	0	Plan number of a retirement plan
5	TYPE_CODE	☐	RTP_US_TYPE	RTP_US_TYPE	CHAR	2	0	Type code for a retirement plan	TRTP_US_PLANTYPE
6	NATURE	☐	RTP_US_NATURE	RTP_US_NATURE	CHAR	2	0	Nature of a retirement plan
7	PLAN_NAME	☐	RTP_US_NAME	RTP_US_NAME	CHAR	30	0	Plan name of the retirement plan
8	CHNG_RES	☐	RTP_US_XIND_RESP	RTP_US_XIND	CHAR	1	0	Yes/No Indication responsible person may change accountholde
9	RES_TRANS	☐	RTP_US_XIND_TRANS	RTP_US_XIND	CHAR	1	0	Yes/No Indication responsible person remains responsible
10	DATE_MAR	☐	RTP_US_MATDAT	RTP_US_DATE	DATS	8	0	Date of maturity for the accountholder of a Coverdell ESA
11	OP_DAT	☐	RTP_US_OPDAT	RTP_US_DATE	DATS	8	0	Opening date
12	CLS_DAT	☐	RTP_US_CLSDAT	RTP_US_DATE	DATS	8	0	Closing date of the retirement plan
13	STATUS	☐	RTP_US_STATUS	RTP_US_STATUS	CHAR	1	0	Status of the retirement plan
14	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
15	CURRENCY	☐	RTP_US_CURRENCY	WAERS	CUKY	5	0	Currency of the retirement plan	TCURC
16	SEARCH1	☐	RTP_US_SEAR1	RTP_US_SEARCH	CHAR	20	0	Search item 1
17	SEARCH2	☐	RTP_US_SEAR2	RTP_US_SEARCH	CHAR	20	0	Search item 2
18	CHNG_USER	☐	RTP_US_CHUSR	RTP_US_USER	CHAR	12	0	Last changed by
19	CHNG_DATE	☐	RTP_US_CHDAT	RTP_US_DATE	DATS	8	0	Date last changed
20	CHNG_TIME	☐	RTP_US_CHTIM	RTP_US_TIME	TIMS	6	0	Time last changed
21	CR_USER	☐	RTP_US_CRUSR	RTP_US_USER	CHAR	12	0	Created by
22	CR_DATE	☐	RTP_US_CRDAT	RTP_US_DATE	DATS	8	0	Date created
23	CR_TIME	☐	RTP_US_CRTIM	RTP_US_TIME	TIMS	6	0	Time created
24	ACT_DB	☐	RTP_US_ACT_DB	RTP_US_ACT_DB	CHAR	1	0	Database activity
25	NRRANGENR	☐	NRNR	CHAR2	CHAR	2	0	Number range number
26	IND_EXT	☐	NRIND	XFELD	CHAR	1	0	Internal (' ') or external ('X') number range flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IRTP_US_PLAN_DB	AUGRP	TB037	AUGRP	REF	1	CN
2	IRTP_US_PLAN_DB	BKKRS	TBKK01	BKKRS	KEY	1	CN
3	IRTP_US_PLAN_DB	CURRENCY	TCURC	WAERS	KEY	1	CN
4	IRTP_US_PLAN_DB	TYPE_CODE	TRTP_US_PLANTYPE	TYPE_CODE	KEY	1	CN

History

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