SAP ABAP Table CRM_ACC_PL_ACPELEMENT (ACP: Account Planner Element Attribute)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_ACC_PL_ACPELEMENT	Table Relationship Diagram
Short Description	ACP: Account Planner Element Attribute

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
2	EXTERNAL_ID	☐	CRM_BSP_ACC_PL_EXT_ID	CGPL_EXTID	CHAR	24	0	Project ID
3	TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
4	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
5	PARENT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	HAS_CHILDREN	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
7	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
8	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
9	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
10	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
11	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
12	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
13	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
14	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
15	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
16	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
17	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
18	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
19	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
20	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
21	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
22	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
23	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
24	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
25	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
26	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
27	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
28	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
29	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
30	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
31	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
32	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
33	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
34	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
35	APPLICATION	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
36	FORECAST_START	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
37	FORECAST_FINISH	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
38	.INCLUDE	☐				0	0	CRM Account Planning: Include Structure Appl. Attrtibutes
39	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
40	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
41	AUTH_GROUP	☐	CRM_ACC_PL_AUTH_GROUP	CRM_ACC_PL_AUTH_GROUP	CHAR	4	0	Authorization Group	*
42	PERIOD	☐	CRM_ACC_PL_PERIOD	CRM_ACC_PL_PERIOD	CHAR	24	0	Planning Period	*
43	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
44	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
45	SALES_ORG	☐	CRMT_ACC_PL_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization
46	DIVISION	☐	CRMT_ACC_PL_DIVISION	CRM_ACC_PL_DIVISION	CHAR	2	0	Division
47	DIS_CHANNEL	☐	CRMT_ACC_PL_DISTR_CHANNEL	CRM_ACC_PL_DISTR_CHANNEL	CHAR	2	0	Distribution Channel
48	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
49	CREATED_ONLINE	☐	CRM_ACC_PL_CREATED_ONLINE	FLAG	CHAR	1	0	Created Online
50	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
51	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
52	PLANBASIS	☐	CRM_ACC_PL_PLAN_BASIS	CRM_ACC_PL_PLAN_BASIS	CHAR	1	0	Planning Basis (Product or Product Category)
53	PLANNED_BY	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
54	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
55	ACTION_PROFILE	☐	CRM_ACC_PL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	Account Planner: Name of Action Profile	*
56	ORIG_SYSTEM	☐	CRM_MKTPL_ORIG_SYST	CHAR1	CHAR	1	0	CRM Marketing Planning - Campaign Original System
57	TIME_ZONE	☐	SYSTZONLO	SYCHAR06	CHAR	6	0	Time Zone
58	PROD_PL_BASIS	☐	CRM_MKTSS_PL_BASIS	CRM_MKTSS_PL_BASIS	NUMC	3	0	Product Planning Basis
59	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
60	.INCLUDE	☐				0	0	Extension Include - Account Plan Header
61	ACCPL_HEADER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
62	PLAN_DATA_VERSION	☐	CRM_MKTPL_SEM_VERSION	CRM_MKTPL_SEM_VERSION	CHAR	10	0	CRM Marketing SEM Version
63	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
64	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - External
65	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
66	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
67	CHANNEL_DESC2	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
68	DIVISION_DESC2	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_ACC_PL_ACPELEMENT	CURRENCY	TCURC	WAERS
2	CRM_ACC_PL_ACPELEMENT	PRIORITY	CGPL_PRIO	PRIORITY	KEY

History

Last changed by/on	SAP	20130604
SAP Release Created in	500