SAP ABAP View BBPV_CM_INP_SRCH (View for Initiative POCA search)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-CM (Application Component) SRM Category Management
     ⤷ BBP_CM (Package) OBSOLETE !!!!! Category Management

Basic Data

View Type	D	Database View
Database View	BBPV_CM_INP_SRCH
Short Description	View for Initiative POCA search
Root table	BBPD_CM_POCA	Program Objective Category Allocation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BBPD_CM_POCA	BBPD_CM_POCA
2	BBPD_CM_IPOCAMAP
3	BBPD_CM_INIT
4	BBPD_CM_PROGRAM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BBPD_CM_POCA	CM_MANDT	JL	EQ				0	0
2	BBPD_CM_INIT	CM_MANDT	JR	EQ			AND	0	0
3	BBPD_CM_IPOCAMAP	CM_MANDT	JL	EQ				0	0
4	BBPD_CM_INIT	CM_MANDT	JR	EQ			AND	0	0
5	BBPD_CM_PROGRAM	CM_MANDT	JL	EQ				0	0
6	BBPD_CM_INIT	CM_MANDT	JR	EQ			AND	0	0
7	BBPD_CM_IPOCAMAP	CM_POCA_GUID	JL	EQ				0	0
8	BBPD_CM_POCA	CM_POCA_GUID	JR	EQ			AND	0	0
9	BBPD_CM_INIT	CM_INIT_GUID	JL	EQ				0	0
10	BBPD_CM_IPOCAMAP	CM_INIT_GUID	JR	EQ			AND	0	0
11	BBPD_CM_PROGRAM	CM_PROG_GUID	JL	EQ				0	0
12	BBPD_CM_POCA	CM_PROG_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CM_MANDT	BBPD_CM_INIT	CM_MANDT		☐	MANDT	☐	Client
2	CM_INIT_GUID	BBPD_CM_INIT	CM_INIT_GUID		☐	BBP_CM_GUID	☐	Unique Identifier
3	CM_POCA_GUID	BBPD_CM_POCA	CM_POCA_GUID		☐	BBP_CM_GUID	☐	Unique Identifier
4	CM_PROG_GUID	BBPD_CM_PROGRAM	CM_PROG_GUID		☐	BBP_CM_GUID	☐	Unique Identifier
5	CM_INIT_ID	BBPD_CM_INIT	CM_INIT_ID		☐	BBP_CM_INIT_ID	☐	Initiative ID
6	CM_INIT_NAME	BBPD_CM_INIT	CM_INIT_NAME		☐	BBP_CM_INIT_NAME	☐	Initiative Name
7	CM_INIT_PSTDATE	BBPD_CM_INIT	CM_INIT_PSTDATE		☐	BBP_CM_INIT_PSTDATE	☐	Initiative planned activation date
8	CM_INIT_PENDATE	BBPD_CM_INIT	CM_INIT_PENDATE		☐	BBP_CM_INIT_PENDATE	☐	Initiative planned completion date
9	CM_INIT_ASTDATE	BBPD_CM_INIT	CM_INIT_ASTDATE		☐	BBP_CM_INIT_ASTDATE	☐	Initiative actual activation date
10	CM_INIT_AENDATE	BBPD_CM_INIT	CM_INIT_AENDATE		☐	BBP_CM_INIT_AENDATE	☐	Initiative actual completion date
11	CM_INIT_STATUS	BBPD_CM_INIT	CM_INIT_STATUS		☐	BBP_CM_OBJ_STATE	☐	State of the Object
12	CM_CROOM_ID	BBPD_CM_INIT	CM_CROOM_ID		☐	BBP_CM_METH_CROOM_ID	☐	Collaboration Room Identifier for Category Management
13	CM_EXEC_TYPE	BBPD_CM_INIT	CM_EXEC_TYPE		☐	BBP_CM_EXEC_TYPE	☐	Execution Modes
14	CM_CPROJ_GUID	BBPD_CM_INIT	CM_CPROJ_GUID		☐	BBP_CM_PROJ_KEY	☐	cProject GUID
15	CM_INIT_RISK	BBPD_CM_INIT	CM_INIT_RISK		☐	BBP_CM_RISK	☐	Risk Level
16	CM_INIT_PRIO	BBPD_CM_INIT	CM_INIT_PRIO		☐	BBP_CM_PRIORITY	☐	Priorities for Documents
17	CM_METH_GUID	BBPD_CM_INIT	CM_METH_GUID		☐	BBP_CM_GUID	☐	Unique Identifier
18	CM_IS_AUTO_ACTI	BBPD_CM_INIT	CM_IS_AUTO_ACTI		☐	BBP_CM_ACTIVATION_TYPE	☐	Activation Type (Automatic, Manual)
19	CM_ALLOC_SPEND	BBPD_CM_IPOCAMAP	CM_ALLOC_SPEND		☐	BBP_CM_ALLOC_SPEND	☐	Planned Spending Value
20	CM_ALLOC_OBJTV	BBPD_CM_IPOCAMAP	CM_ALLOC_OBJTV		☐	BBP_CM_ALLOC_OBJTV	☐	Objective Breakdown
21	CM_NEGO_OBJTV	BBPD_CM_IPOCAMAP	CM_NEGO_OBJTV		☐	BBP_CM_ALLOC_OBJTV	☐	Objective Breakdown
22	CM_ACTU_OBJTV	BBPD_CM_IPOCAMAP	CM_ACTU_OBJTV		☐	BBP_CM_ALLOC_OBJTV	☐	Objective Breakdown
23	CM_CURRENCY	BBPD_CM_IPOCAMAP	CM_CURRENCY		☐	WAERS	☐	Currency Key
24	CM_OBJ_INVST	BBPD_CM_IPOCAMAP	CM_OBJ_INVST		☐	BBP_CM_ALLOC_OBJTV	☐	Objective Breakdown
25	CM_PROG_ID	BBPD_CM_PROGRAM	CM_PROG_ID		☐	BBP_CM_PROG_ID	☐	Identifier for a program
26	CM_PROG_NAME	BBPD_CM_PROGRAM	CM_PROG_NAME		☐	BBP_CM_PROG_NAME	☐	Program Name
27	CM_PROG_PSDATE	BBPD_CM_PROGRAM	CM_PROG_PSDATE		☐	BBP_CM_PROG_STARTDT	☐	Program Activation Date
28	CM_PROG_PEDATE	BBPD_CM_PROGRAM	CM_PROG_PEDATE		☐	BBP_CM_PROG_ENDDT	☐	Completion Date of Program
29	CM_PROG_ASDATE	BBPD_CM_PROGRAM	CM_PROG_ASDATE		☐	BBP_CM_PROG_ASTARTDT	☐	Actual Program Activation Date
30	CM_PROG_AEDATE	BBPD_CM_PROGRAM	CM_PROG_AEDATE		☐	BBP_CM_PROG_AENDDT	☐	Actual Completion Date of Program
31	CM_PROG_STATUS	BBPD_CM_PROGRAM	CM_PROG_STATUS		☐	BBP_CM_OBJ_STATE	☐	State of the Object
32	CM_PROG_BASELIN	BBPD_CM_PROGRAM	CM_PROG_BASELIN		☐	BBP_CM_ALLOC_SPEND	☐	Planned Spending Value
33	CM_PROG_CURR	BBPD_CM_PROGRAM	CM_PROG_CURR		☐	WAERS	☐	Currency Key
34	CM_PROG_CROOM_ID	BBPD_CM_PROGRAM	CM_CROOM_ID		☐	BBP_CM_METH_CROOM_ID	☐	Collaboration Room Identifier for Category Management
35	CM_PROG_PRIO	BBPD_CM_PROGRAM	CM_PROG_PRIO		☐	BBP_CM_PRIORITY	☐	Priorities for Documents
36	CM_PROG_RISK	BBPD_CM_PROGRAM	CM_PROG_RISK		☐	BBP_CM_RISK	☐	Risk Level
37	CM_PROG_ACTTYPE	BBPD_CM_PROGRAM	CM_PROG_ACTTYPE		☐	BBP_CM_ACTIVATION_TYPE	☐	Activation Type (Automatic, Manual)
38	CM_CATEGORY_GUID	BBPD_CM_POCA	CM_CATEGORY_GUID		☐	BBP_CATEGORY_GUID_RAW	☐	Product Category GUID
39	CM_ORG_UNIT	BBPD_CM_POCA	CM_ORG_UNIT		☐	HROBJID	☐	Object ID
40	CM_INIT_CREATOR	BBPD_CM_INIT	CM_CREATED_BY		☐	UNAME	☐	User Name

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