SAP ABAP Table RTP_US_PLAN (Retirement plan data (US enhancement))

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	TRANSP	Transparent table
Transparent table	RTP_US_PLAN	Table Relationship Diagram
Short Description	Retirement plan data (US enhancement)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BKKRS	☑	BKK_BKKRS	BKK_BKKRS	CHAR	4	0	Bank Area	TBKK01
3	PLAN_NUMBER	☑	RTP_US_NUMB	RTP_US_NUMB	CHAR	15	0	Plan number of a retirement plan
4	TYPE_CODE	☐	RTP_US_TYPE	RTP_US_TYPE	CHAR	2	0	Type code for a retirement plan	TRTP_US_PLANTYPE
5	NATURE	☐	RTP_US_NATURE	RTP_US_NATURE	CHAR	2	0	Nature of a retirement plan
6	PLAN_NAME	☐	RTP_US_NAME	RTP_US_NAME	CHAR	30	0	Plan name of the retirement plan
7	CHNG_RES	☐	RTP_US_XIND_RESP	RTP_US_XIND	CHAR	1	0	Yes/No Indication responsible person may change accountholde
8	RES_TRANS	☐	RTP_US_XIND_TRANS	RTP_US_XIND	CHAR	1	0	Yes/No Indication responsible person remains responsible
9	DATE_MAR	☐	RTP_US_MATDAT	RTP_US_DATE	DATS	8	0	Date of maturity for the accountholder of a Coverdell ESA
10	OP_DAT	☐	RTP_US_OPDAT	RTP_US_DATE	DATS	8	0	Opening date
11	CLS_DAT	☐	RTP_US_CLSDAT	RTP_US_DATE	DATS	8	0	Closing date of the retirement plan
12	STATUS	☐	RTP_US_STATUS	RTP_US_STATUS	CHAR	1	0	Status of the retirement plan
13	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
14	CURRENCY	☐	RTP_US_CURRENCY	WAERS	CUKY	5	0	Currency of the retirement plan	TCURC
15	SEARCH1	☐	RTP_US_SEAR1	RTP_US_SEARCH	CHAR	20	0	Search item 1
16	SEARCH2	☐	RTP_US_SEAR2	RTP_US_SEARCH	CHAR	20	0	Search item 2
17	CHNG_USER	☐	RTP_US_CHUSR	RTP_US_USER	CHAR	12	0	Last changed by
18	CHNG_DATE	☐	RTP_US_CHDAT	RTP_US_DATE	DATS	8	0	Date last changed
19	CHNG_TIME	☐	RTP_US_CHTIM	RTP_US_TIME	TIMS	6	0	Time last changed
20	CR_USER	☐	RTP_US_CRUSR	RTP_US_USER	CHAR	12	0	Created by
21	CR_DATE	☐	RTP_US_CRDAT	RTP_US_DATE	DATS	8	0	Date created
22	CR_TIME	☐	RTP_US_CRTIM	RTP_US_TIME	TIMS	6	0	Time created

Foreign Keys

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

History

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