SAP ABAP Table CRMS_ACCPL_IB_ACP_QUERY_ATTR (Attribute structure for the Query Account Plan BO)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ACP-APL (Application Component) Account Planner
     ⤷ CRM_ACCPL_IB_IMPL (Package) Internal BO package for Account Planning

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_ACCPL_IB_ACP_QUERY_ATTR	Table Relationship Diagram
Short Description	Attribute structure for the Query Account Plan BO

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	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
2	EXTERNAL_ID	☐	CRM_ACC_PL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Account Plan's CGPL External ID
3	TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
4	PERIOD	☐	CRM_ACC_PL_PERIOD	CRM_ACC_PL_PERIOD	CHAR	24	0	Planning Period	*
5	PLANSTART	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
6	PLANFINISH	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
7	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
8	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
9	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
10	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
11	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
12	CUSTOMER_ID	☐	CRM_ACC_PL_CUSTOMER_ID	CHAR20	CHAR	20	0	ID of Planning Customer
13	CUSTOMER_DESC	☐	CRM_ACC_PL_PLANCUST_DESC		CHAR	50	0	Account Planner : Planning Customer Description
14	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
15	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
16	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
17	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
18	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
19	NODE_ID	☐	CRM_ACC_PL_NODE_ID	CHAR20	CHAR	20	0	ID of Hierarchy Node
20	STATUS	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
21	TARGETGRP_DESCR	☐	CRM_MKTPL_SEGMENT_DESC	CRM_MARKETING_DESC	CHAR	72	0	Description of Segment
22	TG_AS_PC_DESC	☐	CRM_MKTPL_TARGETGRP_DESC	CRM_MARKETING_DESC	CHAR	72	0	Description of Target Group
23	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
24	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
25	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
26	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
27	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
28	.INCLUDE	☐				0	0	Extension Include - Account Plan Search
29	ACCPL_QUERY_ACP	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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