SAP ABAP View V_RTP_US_PLAN_AC (Database view for search help retirement plan BCA acct no.)

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

View Type	D	Database View
Database View	V_RTP_US_PLAN_AC
Short Description	Database view for search help retirement plan BCA acct no.
Root table	RTP_US_ACC	Linking table between a retirement plan and an account

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	RTP_US_ACC	RTP_US_ACC
2	BKK40
3	BKK42
4	FIPR_PRODUCT
5	TBKK47T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	RTP_US_ACC	CLIENT	JL	EQ				0	0
2	BKK40	MANDT	JR	EQ			AND	0	0
3	RTP_US_ACC	BKKRS	JL	EQ				0	0
4	BKK40	BKKRS	JR	EQ			AND	0	0
5	RTP_US_ACC	ACNUM_INT	JL	EQ				0	0
6	BKK40	ACNUM_INT	JR	EQ			AND	0	0
7	BKK40	MANDT	JL	EQ				0	0
8	BKK42	MANDT	JR	EQ			AND	0	0
9	BKK40	BKKRS	JL	EQ				0	0
10	BKK42	BKKRS	JR	EQ			AND	0	0
11	BKK40	ACNUM_INT	JL	EQ				0	0
12	BKK42	ACNUM_INT	JR	EQ			AND	0	0
13	BKK42	MANDT	JL	EQ				0	0
14	FIPR_PRODUCT	MANDT	JR	EQ			AND	0	0
15	BKK42	PRODINT	JL	EQ				0	0
16	FIPR_PRODUCT	PRODINT	JR	EQ			AND	0	0
17	BKK40	MANDT	JL	EQ				0	0
18	TBKK47T	MANDT	JR	EQ			AND	0	0
19	BKK40	STATUS_ADD	JL	EQ				0	0
20	TBKK47T	STATUS_ADD	JR	EQ			AND	0	0
21	RTP_US_ACC	ACC_TYPE		EQ	'01'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	RTP_US_ACC	CLIENT		☐	MANDT	☐	Client
2	BKKRS	RTP_US_ACC	BKKRS		☐	BKK_BKKRS	☐	Bank Area
3	PLAN_NUMBER	RTP_US_ACC	PLAN_NUMBER		☐	RTP_US_NUMB	☐	Plan number of a retirement plan
4	ACC_TYPE	RTP_US_ACC	ACC_TYPE		☐	RTP_US_ACC_TYPE	☐	Account type
5	ACNUM_INT	RTP_US_ACC	ACNUM_INT		☐	RTP_US_ACC_NUMB	☐	Retirement plan: Internal account number
6	ACNUM_EXT	BKK42	ACNUM_EXT		☐	BKK_ACEXT	☐	Account number for current account
7	PRODINT	BKK42	PRODINT		☐	BKK_PRODINT	☐	Internal Product ID
8	PRODEXT	FIPR_PRODUCT	PRODEXT		☐	FIPR_PRODEXT	☐	External Product ID
9	SEARCH1	BKK40	SEARCH1		☐	BKK_SEAR1	☐	Search term 1
10	SEARCH2	BKK40	SEARCH2		☐	BKK_SEAR2	☐	Search term 2
11	STATUS_ADD	BKK40	STATUS_ADD		☐	BKK_STATAD	☐	Account Status Enhancement
12	T_STATUSAD	TBKK47T	T_STATUSAD		☐	BKK_T_STAD	☐	Description Account Status
13	SPRAS	TBKK47T	SPRAS		☐	SPRAS	☐	Language Key
14	ACTEXT	BKK42	ACTEXT		☐	BKK_ACTEXT	☐	Account Description for Current Account

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	N	Display/Maintenance Not Allowed

History

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