SAP ABAP View V_RTP_US_PLAN (Database view for table rtp_us_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

View Type	D	Database View
Database View	V_RTP_US_PLAN
Short Description	Database view for table rtp_us_plan
Root table	RTP_US_BP_PLAN	Business partners associated with a retirement plan

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	RTP_US_BP_PLAN	RTP_US_BP_PLAN
2	BUT000
3	BUT100
4	RTP_US_PLAN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BUT000	PARTNER	JL	EQ				0	0
2	RTP_US_BP_PLAN	PARTNER	JR	EQ			AND	0	0
3	BUT000	CLIENT	JL	EQ				0	0
4	BUT100	MANDT	JR	EQ			AND	0	0
5	BUT000	PARTNER	JL	EQ				0	0
6	BUT100	PARTNER	JR	EQ			AND	0	0
7	RTP_US_PLAN	CLIENT	JL	EQ				0	0
8	RTP_US_BP_PLAN	CLIENT	JR	EQ			AND	0	0
9	RTP_US_PLAN	BKKRS	JL	EQ				0	0
10	RTP_US_BP_PLAN	BKKRS	JR	EQ			AND	0	0
11	RTP_US_PLAN	PLAN_NUMBER	JL	EQ				0	0
12	RTP_US_BP_PLAN	PLAN_NUMBER	JR	EQ			AND	0	0
13	BUT000	CLIENT	JL	EQ				0	0
14	RTP_US_BP_PLAN	CLIENT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	RTP_US_PLAN	CLIENT		☐	MANDT	☐	Client
2	BKKRS	RTP_US_PLAN	BKKRS		☐	BKK_BKKRS	☐	Bank Area
3	PLAN_NUMBER	RTP_US_PLAN	PLAN_NUMBER		☐	RTP_US_NUMB	☐	Plan number of a retirement plan
4	PARTNER	BUT000	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
5	DFVAL	BUT100	DFVAL		☐	BU_DFVAL	☐	BP: Differentiation type value
6	RLTYP	BUT100	RLTYP		☐	BU_PARTNERROLE	☐	BP Role
7	TYPE_CODE	RTP_US_PLAN	TYPE_CODE		☐	RTP_US_TYPE	☐	Type code for a retirement plan
8	NATURE	RTP_US_PLAN	NATURE		☐	RTP_US_NATURE	☐	Nature of a retirement plan
9	PLAN_NAME	RTP_US_PLAN	PLAN_NAME		☐	RTP_US_NAME	☐	Plan name of the retirement plan
10	STATUS	RTP_US_PLAN	STATUS		☐	RTP_US_STATUS	☐	Status of the retirement plan
11	SEARCH1	RTP_US_PLAN	SEARCH1		☐	RTP_US_SEAR1	☐	Search item 1
12	SEARCH2	RTP_US_PLAN	SEARCH2		☐	RTP_US_SEAR2	☐	Search item 2
13	CR_USER	RTP_US_PLAN	CR_USER		☐	RTP_US_CRUSR	☐	Created by

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	Display/Maintenance Allowed with Restrictions

History

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