SAP ABAP Table IRTP_US_PLAN (Screen fields for a 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	Table Relationship Diagram
Short Description	Screen fields for a 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	NATURE	☐	RTP_US_NATURE	RTP_US_NATURE	CHAR	2	0	Nature of a retirement plan
13	CHNG_RES	☐	RTP_US_XIND_RESP	RTP_US_XIND	CHAR	1	0	Yes/No Indication responsible person may change accountholde
14	RES_TRANS	☐	RTP_US_XIND_TRANS	RTP_US_XIND	CHAR	1	0	Yes/No Indication responsible person remains responsible
15	DATE_MAR	☐	RTP_US_MATDAT	RTP_US_DATE	DATS	8	0	Date of maturity for the accountholder of a Coverdell ESA
16	OP_DAT	☐	RTP_US_OPDAT	RTP_US_DATE	DATS	8	0	Opening date
17	CLS_DAT	☐	RTP_US_CLSDAT	RTP_US_DATE	DATS	8	0	Closing date of the retirement plan
18	STATUS	☐	RTP_US_STATUS	RTP_US_STATUS	CHAR	1	0	Status of the retirement plan
19	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
20	CURRENCY	☐	RTP_US_CURRENCY	WAERS	CUKY	5	0	Currency of the retirement plan	TCURC
21	CURRENCY_DESCRIPTION	☐	KTEXT_CURT	TEXT15	CHAR	15	0	Short text
22	SEARCH1	☐	RTP_US_SEAR1	RTP_US_SEARCH	CHAR	20	0	Search item 1
23	SEARCH2	☐	RTP_US_SEAR2	RTP_US_SEARCH	CHAR	20	0	Search item 2
24	CHNG_USER	☐	RTP_US_CHUSR	RTP_US_USER	CHAR	12	0	Last changed by
25	CHNG_DATE	☐	RTP_US_CHDAT	RTP_US_DATE	DATS	8	0	Date last changed
26	CHNG_TIME	☐	RTP_US_CHTIM	RTP_US_TIME	TIMS	6	0	Time last changed
27	CR_USER	☐	RTP_US_CRUSR	RTP_US_USER	CHAR	12	0	Created by
28	CR_DATE	☐	RTP_US_CRDAT	RTP_US_DATE	DATS	8	0	Date created
29	CR_TIME	☐	RTP_US_CRTIM	RTP_US_TIME	TIMS	6	0	Time created
30	BP_TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
31	ADDNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
32	ADDRESS	☐	RTP_US_ADD	RTP_US_ADDRESS	CHAR	60	0	Full address of a business partner
33	SSN	☐	RTP_US_SSN	BPIDNUM	CHAR	60	0	Tax identification number (US): either SSN or TIN
34	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
35	DEATHDT	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
36	XCHNG	☐	RTP_US_XIND_CHANGE	RTP_US_XIND	CHAR	1	0	Indication retirement plan record has been changed.

Foreign Keys

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

History

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