SAP ABAP Table CRMT_ACC_PL_ATTR (Account Plan Attributes)

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	CRMT_ACC_PL_ATTR	Table Relationship Diagram
Short Description	Account Plan Attributes

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
3	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
4	.INCLUDE	☐				0	0	CRM Account Planning: Include Structure Appl. Attrtibutes
5	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
6	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
7	AUTH_GROUP	☐	CRM_ACC_PL_AUTH_GROUP	CRM_ACC_PL_AUTH_GROUP	CHAR	4	0	Authorization Group	*
8	PERIOD	☐	CRM_ACC_PL_PERIOD	CRM_ACC_PL_PERIOD	CHAR	24	0	Planning Period	*
9	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
10	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
11	SALES_ORG	☐	CRMT_ACC_PL_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization
12	DIVISION	☐	CRMT_ACC_PL_DIVISION	CRM_ACC_PL_DIVISION	CHAR	2	0	Division
13	DIS_CHANNEL	☐	CRMT_ACC_PL_DISTR_CHANNEL	CRM_ACC_PL_DISTR_CHANNEL	CHAR	2	0	Distribution Channel
14	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
15	CREATED_ONLINE	☐	CRM_ACC_PL_CREATED_ONLINE	FLAG	CHAR	1	0	Created Online
16	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
17	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
18	PLANBASIS	☐	CRM_ACC_PL_PLAN_BASIS	CRM_ACC_PL_PLAN_BASIS	CHAR	1	0	Planning Basis (Product or Product Category)
19	PLANNED_BY	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
20	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
21	ACTION_PROFILE	☐	CRM_ACC_PL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	Account Planner: Name of Action Profile	*
22	ORIG_SYSTEM	☐	CRM_MKTPL_ORIG_SYST	CHAR1	CHAR	1	0	CRM Marketing Planning - Campaign Original System
23	TIME_ZONE	☐	SYSTZONLO	SYCHAR06	CHAR	6	0	Time Zone
24	PROD_PL_BASIS	☐	CRM_MKTSS_PL_BASIS	CRM_MKTSS_PL_BASIS	NUMC	3	0	Product Planning Basis
25	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
26	.INCLUDE	☐				0	0	Extension Include - Account Plan Header
27	ACCPL_HEADER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
28	PLAN_DATA_VERSION	☐	CRM_MKTPL_SEM_VERSION	CRM_MKTPL_SEM_VERSION	CHAR	10	0	CRM Marketing SEM Version
29	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
30	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - External
31	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
32	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
33	CHANNEL_DESC2	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
34	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	CRMT_ACC_PL_ATTR	CURRENCY	TCURC	WAERS

History

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