SAP ABAP View V_IVP_PR (Relevant WBS elem/proj. master data for investment program)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ AIP (Package) IM capital investment prog.(master data, budget, info syst.)

Basic Data

View Type	D	Database View
Database View	V_IVP_PR
Short Description	Relevant WBS elem/proj. master data for investment program
Root table	IMPR	Investment Program Positions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	IMPR	IMPR
2	IMZO
3	ONRPR
4	PRPS
5	PROJ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	IMPR	MANDT	JL	EQ				0	0
2	IMZO	MANDT	JR	EQ			AND	0	0
3	IMPR	POSNR	JL	EQ				0	0
4	IMZO	POSNR	JR	EQ			AND	0	0
5	IMZO	MANDT	JL	EQ				0	0
6	ONRPR	MANDT	JR	EQ			AND	0	0
7	IMZO	OBJNR	JL	EQ				0	0
8	ONRPR	OBJNR	JR	EQ			AND	0	0
9	ONRPR	MANDT	JL	EQ				0	0
10	PRPS	MANDT	JR	EQ			AND	0	0
11	ONRPR	PSPNR	JL	EQ				0	0
12	PRPS	PSPNR	JR	EQ			AND	0	0
13	PRPS	MANDT	JL	EQ				0	0
14	PROJ	MANDT	JR	EQ			AND	0	0
15	PRPS	PSPHI	JL	EQ				0	0
16	PROJ	PSPNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	IMPR	MANDT		☐	MANDT	☐	Client
2	PRNAM	IMPR	PRNAM		☐	IM_PRNAM	☐	Investment program name
3	GJAHR	IMPR	GJAHR		☐	IM_GNJHR	☐	Approval year of the investment program
4	POSNR	IMPR	POSNR		☐	IM_POSNR	☐	Position number
5	PSPNR	PRPS	PSPNR		☐	PS_POSNR	☐	WBS Element
6	POSID	PRPS	POSID		☐	PS_POSID	☐	Work Breakdown Structure Element (WBS Element)
7	POST1	PRPS	POST1		☐	PS_POST1	☐	PS: Short description (first text line)
8	OBJNR	PRPS	OBJNR		☐	J_OBJNR	☐	Object number
9	VERNR	PRPS	VERNR		☐	PS_VERNR	☐	Number of the responsible person (project manager)
10	PBUKR	PRPS	PBUKR		☐	PS_PBUKR	☐	Company code for WBS element
11	PGSBR	PRPS	PGSBR		☐	PS_PGSBR	☐	Business area for WBS element
12	PKOKR	PRPS	PKOKR		☐	PS_PKOKR	☐	Controlling area for WBS element
13	PRCTR	PRPS	PRCTR		☐	PRCTR	☐	Profit Center
14	PRART	PRPS	PRART		☐	PS_PRART	☐	Project type
15	STUFE	PRPS	STUFE		☐	PS_STUFE	☐	Level in project hierarchy
16	AKOKR	PRPS	AKOKR		☐	PS_AKOKR	☐	Controlling area of requesting cost center
17	AKSTL	PRPS	AKSTL		☐	PS_AKSTL	☐	Requesting cost center
18	WERKS	PRPS	WERKS		☐	WERKS_D	☐	Plant
19	SCOPE	PRPS	SCOPE		☐	SCOPE_CV	☐	Object Class
20	XSTAT	PRPS	XSTAT		☐	PS_XSTAT	☐	Statistical WBS element
21	PROJ_PSPNR	PROJ	PSPNR		☐	PS_INTNR	☐	Current number for project or project item
22	PSPID	PROJ	PSPID		☐	PS_PSPID	☐	Project definition
23	PROJ_POST1	PROJ	POST1		☐	PS_POST1	☐	PS: Short description (first text line)
24	PLFAZ	PROJ	PLFAZ		☐	PS_PLFAZ	☐	Project planned start date
25	PLSEZ	PROJ	PLSEZ		☐	PS_PLSEZ	☐	Project planned finish date

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	20130529
SAP Release Created in