SAP ABAP Table CRMD_MKTGS_TIER (Tier assignment table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTGS_TIERS (Package) Tiers Growth Rebate Assignment Package

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTGS_TIER	Table Relationship Diagram
Short Description	Tier assignment table

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	.INCLUDE	☑				0	0	MKTGS OL: Generic Assignment Primary Key Include
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
4	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
5	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
7	.INCLUDE	☐				0	0	MKTGS OL: Key include for sub-assignments
8	ASSIGN_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
9	.INCLUDE	☐				0	0	TIer assignment include
10	PRODUCT_DIM_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
11	PRODUCT_DIM_ID	☐	CRM_MKTGS_PROD_GROUP		CHAR	3	0	Product Group
12	PRODUCT_DIM_TYPE	☐	CRM_MKTGS_PDIM_TYPE	CHR4	CHAR	4	0	String describing the product dimension type
13	REBATE_MONVALUE	☐	CRM_MKTGS_SUM	CRM_MKTGS_SUM	CURR	17	4	CRM TIER Currency value DE
14	RATE_MONVALUE	☐	CRM_MKTGS_SUM	CRM_MKTGS_SUM	CURR	17	4	CRM TIER Currency value DE
15	RATE_PERCVALUE	☐	CRM_MKTGS_RATE_PERCENT	CRM_MKTGS_TGR_PLAN_PERCENT	DEC	5	4	Rate Percentage type data element
16	RATE_UNITVALUE	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
17	UNITLBOUND	☐	CRM_MKTGS_BOUND_UNIT	CRM_MKTGS_TGR_PLAN_UNIT	NUMC	10	0	Tier unit type data element
18	UNITUBOUND	☐	CRM_MKTGS_BOUND_UNIT	CRM_MKTGS_TGR_PLAN_UNIT	NUMC	10	0	Tier unit type data element
19	MONETARYLBOUND	☐	CRM_MKTGS_SUM	CRM_MKTGS_SUM	CURR	17	4	CRM TIER Currency value DE
20	MONETARYUBOUND	☐	CRM_MKTGS_SUM	CRM_MKTGS_SUM	CURR	17	4	CRM TIER Currency value DE
21	DATELBOUND	☐	BCOS_TSTMP	BCOS_TSTMP	DEC	15	0	Time Stamp (In UTC)
22	PERCUBOUND	☐	CRM_MKTGS_BOUND_PERCENT	CRM_MKTGS_TGR_PLAN_PERCENT	DEC	5	4	Tier Percentage type data element
23	PERCLBOUND	☐	CRM_MKTGS_BOUND_PERCENT	CRM_MKTGS_TGR_PLAN_PERCENT	DEC	5	4	Tier Percentage type data element
24	DATEUBOUND	☐	BCOS_TSTMP	BCOS_TSTMP	DEC	15	0	Time Stamp (In UTC)
25	CURRENCY	☐	CRM_MKTGS_CURRENCY	CRM_MKTGS_CURRENCY	CUKY	5	0	Currency Data Element
26	IS_GENERIC	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
27	.INCLUDE	☐				0	0	Extension Include - Tiers
28	MKTPL_TIER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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