SAP ABAP Table CRMS_LOY_IB_RRG (Reward Rule Group IB Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT (Application Component) Marketing
     ⤷ CRM_MKTPL_IB_RRG (Package) CRM Marketing: IBOM for Reward Rule Group

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_LOY_IB_RRG	Table Relationship Diagram
Short Description	Reward Rule Group IB Structure

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	.INCLUDE	☐				0	0	Generic include for Basic Data
2	GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
3	EXTERNAL_ID	☐	CRM_MKTPL_TRADEID	CGPL_EXTID	CHAR	24	0	Trade Promotion
4	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
5	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
6	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
8	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
9	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
10	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	TCURC
11	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	BWIDENTIFIER	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
14	PARENT_GUID	☐	CRM_MKTPL_IB_MKTPROJECT_GUID		RAW	16	0	Marketing Project
15	NO_R3_INT	☐	CRM_MKTPL_NO_R3_INT	CHAR1	CHAR	1	0	Marketing Planning: Object Not Integrated into ERP PS
16	EXCL_IND	☐	CRM_MKTPL_EXCL_IND	CRM_MKTPL_EXCL_IND	CHAR	1	0	Indicator: Marketing Project Is Exclusive
17	INACTIVE	☐	CRMT_MKTPL_INACTIVE	CHAR1	CHAR	1	0	Inactive Marketing Project
18	BPAT_TYPE	☐	CRM_MKTPL_DEF_BPAT_TYPE	CRM_MKTPL_DEF_BPAT_TYPE	CHAR	3	0	Type of Buying Pattern
19	ADI_FLAG	☐	CRM_MKTPL_ADI	CRM_MKTPL_ADI	CHAR	1	0	Abnormal Demand Indicator
20	REF_TYPE	☐	CRM_MKTPL_REF_TYPE	CRM_MKTPL_REF_TYPE_DOM	CHAR	4	0	Usage Type
21	REF_TYPE_TEXT	☐	CRM_MKTPL_REF_TYPE_TEXT	TEXT40	CHAR	40	0	Usage Type Description
22	ENROLLMENT_REQ	☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	XFELD	CHAR	1	0	Indicator, that enrollment is required
23	TEMPLATE	☐	CRM_MKTPL_TEMPLATE	CRM_BOOLEAN	CHAR	1	0	Template Indicator
24	DELAY	☐	CRMT_MKTCA_DELAY	CRM_MKTCA_DELAY	INT1	3	0	Delay (Relative Scheduling)
25	COMB_TYPE	☐	CRM_MKTPL_COMB_TYPE	CRM_MKTPL_COMB_TYPE	CHAR	4	0	Combinability Type
26	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
27	.INCLUDE	☐				0	0	Generic include for OrgData
28	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
29	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
30	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
31	.INCLUDE	☐				0	0	Generic include for OrgData (external)
32	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
33	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
34	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
35	HIERARCHY_SORT	☐	CRM_MKTPL_HIERARCHY_SORT_SEQ		NUMC	3	0	Hierarchy Sort Sequence
36	.INCLUDE	☐				0	0	Extension Include - Reward Rule Group Header
37	MKTPL_HEADER_RRG	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

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

History

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