SAP ABAP View V_SCRMACP_BW_P (ACP: Selection View for BW Initial Filling (Projects))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ACP-APL (Application Component) Account Planner
     ⤷ CRM_ACCOUNT_PLANNING (Package) CRM account planning

Basic Data

View Type	D	Database View
Database View	V_SCRMACP_BW_P
Short Description	ACP: Selection View for BW Initial Filling (Projects)
Root table	CGPL_PROJECT	Project Planning: Attribute Table for Project Headers

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CGPL_PROJECT	CGPL_PROJECT
2	CRMD_ACC_PL_ATTR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CGPL_PROJECT	CLIENT	JL	EQ				0	0
2	CRMD_ACC_PL_ATTR	CLIENT	JR	EQ			AND	0	0
3	CGPL_PROJECT	GUID	JL	EQ				0	0
4	CRMD_ACC_PL_ATTR	GUID	JR	EQ			AND	0	0
5	CGPL_PROJECT	OBJECT_TYPE		EQ	'ACP'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CGPL_PROJECT	CLIENT		☐	MANDT	☐	Client
2	GUID	CGPL_PROJECT	GUID		☐	CGPL_PROJECT_GUID	☐	Project Planning: 16 Character GUID for Projects
3	EXTERNAL_ID	CGPL_PROJECT	EXTERNAL_ID		☐	CGPL_EXTID	☐	Project Planning: External Indentifier of an Element
4	PLANSTARTDATE	CGPL_PROJECT	PLANSTART		☐	CGPL_PLANSTART	☐	Planned start date
5	PLANFINISHDATE	CGPL_PROJECT	PLANFINISH		☐	CGPL_PLANFINISH	☐	Planned Finish Date
6	CREATED_BY	CGPL_PROJECT	CREATED_BY		☐	CGPL_CREATED_BY	☐	Name of Person Who Created Object
7	CREATED_ON	CGPL_PROJECT	CREATED_ON		☐	CGPL_CREATED_ON	☐	Date on Which the Object was Created
8	CHANGED_BY	CGPL_PROJECT	CHANGED_BY		☐	CGPL_CHANGED_BY	☐	Name of Person Who Changed Object
9	CHANGED_ON	CGPL_PROJECT	CHANGED_ON		☐	CGPL_CHANGED_ON	☐	Date on Which Object Was Last Changed
10	PLANGROUP	CGPL_PROJECT	PLANGROUP		☐	CGPL_SEM_PLGRP	☐	Planning Profile Group
11	PERIOD	CRMD_ACC_PL_ATTR	PERIOD		☐	CRM_ACC_PL_PERIOD	☐	Planning Period
12	CURRENCY	CRMD_ACC_PL_ATTR	CURRENCY		☐	CRM_MKTPL_CUKY	☐	MKTPL: Currency Object
13	TERR_GUID	CRMD_ACC_PL_ATTR	TERR_PATH_GUID		☐	CRMT_TERRITORY_PATH_GUID	☐	Territory Path GUID
14	AUTH_GROUP	CRMD_ACC_PL_ATTR	AUTH_GROUP		☐	CRM_ACC_PL_AUTH_GROUP	☐	Authorization Group
15	PLANNED_BY	CRMD_ACC_PL_ATTR	PLANNED_BY		☐	BU_PARTNER_GUID	☐	Business Partner GUID
16	BP_GUID	CRMD_ACC_PL_ATTR	BP_GUID		☐	BU_PARTNER_GUID	☐	Business Partner GUID
17	NODE_GUID	CRMD_ACC_PL_ATTR	NODE_GUID		☐	BU_NODE_GUID	☐	GUID of Hierarchy Node
18	SALES_ORG	CRMD_ACC_PL_ATTR	SALES_ORG		☐	CRMT_ACC_PL_SALES_ORG	☐	Sales Organization
19	DIVISION	CRMD_ACC_PL_ATTR	DIVISION		☐	CRMT_ACC_PL_DIVISION	☐	Division
20	DIS_CHANNEL	CRMD_ACC_PL_ATTR	DIS_CHANNEL		☐	CRMT_ACC_PL_DISTR_CHANNEL	☐	Distribution Channel

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