SAP ABAP Table CRMT_IP_ATTRIBUTES (IP Attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH (Application Component) Pharmaceuticals
     ⤷ CRM_IP_APPLICATION (Package) Incentive Program Main Application Package

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IP_ATTRIBUTES	Table Relationship Diagram
Short Description	IP 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	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
2	.INCLUDE	☐				0	0	IP BO Attributes Structure
3	EXTERNAL_ID	☐	CRM_IP_EXT_ID	CGPL_EXTID	CHAR	24	0	Project ID
4	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
5	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
6	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
8	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
9	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
10	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
11	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
14	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
15	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
16	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
17	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
18	CREATED_IN_BW	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
19	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
21	UPDATED_IN_BW	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
22	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
23	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group	CGPL_PLANGRP
24	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
25	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
26	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
27	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
28	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
29	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
30	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
31	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
32	APPLICATION	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
33	FORECAST_START	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
34	FORECAST_FINISH	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
35	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
36	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
37	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
38	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
39	CURRENCY	☐	CRM_IP_CUKY	WAERS	CUKY	5	0	IP: Currency Object	*
40	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
41	IP_DOC_TYPE	☐	CRMT_IP_DOC_TYPE	CRM_IP_DOC_TYPE	CHAR	2	0	IP Document Type
42	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
43	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
44	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
45	IP_TYPE	☐	CRMT_IP_TYPE	CRM_IP_TYPE	CHAR	1	0	IP Type
46	IP_CALC_TYPE	☐	CRMT_IP_CALC_TYPE	CRM_IP_CALC_TYPE	CHAR	1	0	IP Calculation Type
47	IP_FEE_INDICATOR	☐	CRMT_IP_FEE_INDICATOR	XFELD	CHAR	1	0	IP Admin fee indicator
48	BP_AGGR_LEVEL	☐	CMST_BPAGGR_LEVEL	CMST_BPAGGR_LEVEL	CHAR	3	0	Account Hierarchie Level
49	EXT_REF	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
50	TEMPLATE_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	VALID_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
52	VALID_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
53	CONDITION_TYPE	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
54	COND_GEN_TYPE	☐	CRMT_CGEN_TYPE	CRM_CGEN_TYPE	CHAR	4	0	Condition Generation Type
55	ACTION_PROFILE	☐	CRMT_IP_ACTION_PROFILE	PPFDCNTXT	CHAR	30	0	IP: Name of Action Profile	*
56	AUTH_GROUP	☐	CRMT_IP_AUTH_GROUP	CRM_IP_AUTH_GROUP	CHAR	4	0	Authorization Group
57	BP_BRF_EVENT	☐	BRF_EVENT	BRF_EVENT	CHAR	20	0	Name of Event	*
58	PROD_BRF_EVENT	☐	BRF_EVENT	BRF_EVENT	CHAR	20	0	Name of Event	*
59	ERR_PROC	☐	CRMT_IP_ERR_PROC	CRM_IP_ERR_PROC	CHAR	4	0	Incompletness Control: Procedures	*
60	CUSTOMER_ID	☐	CRM_MKTPL_CUSTOMER_ID	CHAR20	CHAR	20	0	Planning Account ID
61	CUSTOMER_DESC	☐	CRM_ACC_PL_PLANCUST_DESC		CHAR	50	0	Account Planner : Planning Customer Description
62	TARGETGRP_DESC	☐	CRMT_MKTTG_TG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description of a Target Group
63	CUSTOMER_TYPE	☐	CRM_IP_CUST_TYPE	CRM_IP_CUST_TYPE	CHAR	2	0	Data Element for Customer Type (IP)
64	PAYEE_LEVEL	☐	CMST_BPAGGR_LEVEL	CMST_BPAGGR_LEVEL	CHAR	3	0	Account Hierarchie Level
65	.INCLUDE	☐				0	0	Generic include for OrgData (external)
66	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
67	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
68	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
69	.INCLUDE	☐				0	0	Structure for IP Header
70	IP_HEADER_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
71	CURRENCY_TEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
72	TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_IP_ATTRIBUTES	LANGU	T002	SPRAS
2	CRMT_IP_ATTRIBUTES	PLANGROUP	CGPL_PLANGRP	PLANGRP	KEY
3	CRMT_IP_ATTRIBUTES	PRIORITY	CGPL_PRIO	PRIORITY	KEY

History

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