SAP ABAP Table CRMD_ACC_PL_ATTR (Account Planning 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	TRANSP	Transparent table
Transparent table	CRMD_ACC_PL_ATTR	Table Relationship Diagram
Short Description	Account Planning account plan attributes

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
4	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
5	AUTH_GROUP	☐	CRM_ACC_PL_AUTH_GROUP	CRM_ACC_PL_AUTH_GROUP	CHAR	4	0	Authorization Group	*
6	PERIOD	☐	CRM_ACC_PL_PERIOD	CRM_ACC_PL_PERIOD	CHAR	24	0	Planning Period	*
7	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
8	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
9	SALES_ORG	☐	CRMT_ACC_PL_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization
10	DIVISION	☐	CRMT_ACC_PL_DIVISION	CRM_ACC_PL_DIVISION	CHAR	2	0	Division
11	DIS_CHANNEL	☐	CRMT_ACC_PL_DISTR_CHANNEL	CRM_ACC_PL_DISTR_CHANNEL	CHAR	2	0	Distribution Channel
12	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
13	CREATED_ONLINE	☐	CRM_ACC_PL_CREATED_ONLINE	FLAG	CHAR	1	0	Created Online
14	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
15	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
16	PLANBASIS	☐	CRM_ACC_PL_PLAN_BASIS	CRM_ACC_PL_PLAN_BASIS	CHAR	1	0	Planning Basis (Product or Product Category)
17	PLANNED_BY	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
18	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
19	ACTION_PROFILE	☐	CRM_ACC_PL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	Account Planner: Name of Action Profile	*
20	ORIG_SYSTEM	☐	CRM_MKTPL_ORIG_SYST	CHAR1	CHAR	1	0	CRM Marketing Planning - Campaign Original System
21	TIME_ZONE	☐	SYSTZONLO	SYCHAR06	CHAR	6	0	Time Zone
22	PROD_PL_BASIS	☐	CRM_MKTSS_PL_BASIS	CRM_MKTSS_PL_BASIS	NUMC	3	0	Product Planning Basis
23	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
24	.INCLUDE	☐				0	0	Extension Include - Account Plan Header
25	ACCPL_HEADER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
26	PPR_TYPE	☐	CRM_ACC_PL_PPR_TYPE	CRM_ACC_PL_PPR_TYPE	CHAR	4	0	PPR Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_ACC_PL_ATTR	CURRENCY	TCURC	WAERS

History

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