SAP ABAP Table CRMT_ACC_PL_QUERY (Search Structure for Account Planning objects)

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_QUERY	Table Relationship Diagram
Short Description	Search Structure for Account Planning objects

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_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	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
5	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
6	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
7	CREATED_ON	☐	CRM_ACC_PL_CREATED_FROM		DATS	8	0	Created On - From
8	CREATED_ON2	☐	CRM_ACC_PL_CREATED_TO	DATUM	DATS	8	0	Created On - To
9	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	CHANGED_ON	☐	CRM_ACC_PL_CHANGED_FROM	DATUM	DATS	8	0	Changed On - From
11	CHANGED_ON2	☐	CRM_ACC_PL_CHANGED_TO	DATUM	DATS	8	0	Changed On - To
12	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
13	STATUS	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
14	.INCLUDE	☐				0	0	CRM Account Planning: Include Structure Appl. Attrtibutes
15	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
16	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - Internal
17	AUTH_GROUP	☐	CRM_ACC_PL_AUTH_GROUP	CRM_ACC_PL_AUTH_GROUP	CHAR	4	0	Authorization Group	*
18	PERIOD	☐	CRM_ACC_PL_PERIOD	CRM_ACC_PL_PERIOD	CHAR	24	0	Planning Period	*
19	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
20	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
21	SALES_ORG	☐	CRMT_ACC_PL_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization
22	DIVISION	☐	CRMT_ACC_PL_DIVISION	CRM_ACC_PL_DIVISION	CHAR	2	0	Division
23	DIS_CHANNEL	☐	CRMT_ACC_PL_DISTR_CHANNEL	CRM_ACC_PL_DISTR_CHANNEL	CHAR	2	0	Distribution Channel
24	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
25	CREATED_ONLINE	☐	CRM_ACC_PL_CREATED_ONLINE	FLAG	CHAR	1	0	Created Online
26	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
27	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
28	PLANBASIS	☐	CRM_ACC_PL_PLAN_BASIS	CRM_ACC_PL_PLAN_BASIS	CHAR	1	0	Planning Basis (Product or Product Category)
29	PLANNED_BY	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
30	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
31	ACTION_PROFILE	☐	CRM_ACC_PL_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	Account Planner: Name of Action Profile	*
32	ORIG_SYSTEM	☐	CRM_MKTPL_ORIG_SYST	CHAR1	CHAR	1	0	CRM Marketing Planning - Campaign Original System
33	TIME_ZONE	☐	SYSTZONLO	SYCHAR06	CHAR	6	0	Time Zone
34	PROD_PL_BASIS	☐	CRM_MKTSS_PL_BASIS	CRM_MKTSS_PL_BASIS	NUMC	3	0	Product Planning Basis
35	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
36	.INCLUDE	☐				0	0	Extension Include - Account Plan Header
37	ACCPL_HEADER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
38	PLAN_DATA_VERSION	☐	CRM_MKTPL_SEM_VERSION	CRM_MKTPL_SEM_VERSION	CHAR	10	0	CRM Marketing SEM Version
39	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
40	.INCLUDE	☐				0	0	ACP: Include Structure Appl. Attrtibutes - External
41	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
42	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
43	CHANNEL_DESC2	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
44	DIVISION_DESC2	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
45	.INCLUDE	☐				0	0	CRM Account Planning- External Format of Attribute
46	CUSTOMER_ID	☐	CRM_ACC_PL_CUSTOMER_ID	CHAR20	CHAR	20	0	ID of Planning Customer
47	CUSTOMER_DESC	☐	CRM_ACC_PL_PLANCUST_DESC		CHAR	50	0	Account Planner : Planning Customer Description
48	PERIOD_DESC	☐	CRM_ACC_PL_PERIOD_DESC	CRM_ACC_PL_PERIOD_DESC	CHAR	40	0	Description of Planning Period
49	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
50	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
51	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
52	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
53	PLANSTART_IO	☐	DATS	DATS	DATS	8	0	Field of type DATS
54	PLANFINISH_IO	☐	DATS	DATS	DATS	8	0	Field of type DATS
55	PPR_TYPE_DESC	☐	CRMT_PRP_TYPE_DESCRIPTION	CRM_PRP_DESCRIPTION	CHAR	40	0	Description of a PPR Type
56	NODE_DESCR	☐	BU_NODE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of a Hierarchy Node
57	PLANBASIS_DESC	☐	CRM_ACC_PL_PLAN_BASIS_DESC	CHAR20	CHAR	20	0	Description of Planning Basis in Account Plan
58	CUSTOMER_TYPE	☐	CRM_ACC_PL_PLCUST_TYPE	CRM_ACC_PL_PLCUST_TYPE	CHAR	2	0	ACP: Type of Planning Customer (BP, Hierarchy Node, TG)
59	PROD_PL_BASIS_TEXT	☐	CRM_MKTSS_PL_BASIS_TEXT	CRM_MKTSS_PL_BASIS_TEXT	CHAR	40	0	Description of Product Planning Basis
60	PLANGROUP_DESC	☐	CGPL_SEM_PLGRPT	TEXT40	CHAR	40	0	Description of Planning Profile Group
61	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
62	PRODUCT_CATEGORY	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
63	PRODUCT_GROUP	☐	CRM_MKTPL_PROD_GROUP		CHAR	3	0	Product Group

Foreign Keys

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

History

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