SAP ABAP Table CRMS_MKTGS_IB_TIERS (Tiers IBOM attribute structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTGS_IB_IMPL (Package) Generic IBOM Assignment Implementation

Basic Data

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

History

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