SAP ABAP Table CRMT_PRP_TOPN_EXPORT_HIS (Record History Data for PPR and Top n)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_USER_INTERFACE (Package) CRM User Interface for Partner/Product Ranges (PPRs)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_TOPN_EXPORT_HIS	Table Relationship Diagram
Short Description	Record History Data for PPR and Top n

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	PRP_LOCA_WL	☐	CRMT_PRP_LOCA_WL_TAB		TTYP	0	0
2	PRP_LOCA_WL_M	☐	CRMT_PRP_LOCA_WL_TAB		TTYP	0	0
3	PRP_LOCA_ALV_UI	☐	CRMT_PRP_LOCA_ALV_UI		STRU	0	0
4	GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
5	ID_DESCRIPTION	☐	CRMT_PRP_ID_DESCRIPTION	CRM_PRP_SHTEXT	CHAR	40	0	Search by Identifier and Header Description
6	PRP_ID	☐	CRMT_PRP_ID_LOCA	CRM_PRP_ID	CHAR	40	0	External identifier for a PPR
7	DESCRIPTION	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
8	PRP_I_ID	☐	CRMT_PRP_I_ID	CRM_PRP_I_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Item
9	PRP_I_TYPE	☐	CRMT_PRP_I_TYPE	CRM_PRP_I_TYPE	CHAR	1	0	PPR Item: Type of Link
10	I_DESCRIPTION	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
11	RELAT_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
12	NODE_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
13	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)
14	PRODUCT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
15	PRODUCT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
16	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
17	PRP_STATUS	☐	CRMT_PRP_STATUS	CRM_PRP_STATUS	CHAR	1	0	Partner/Product Range (PPR) Status
18	PRP_EXCLUSION	☐	CRMT_PRPADM_H_EXCLUSION	CRM_PRP_EXCLUSION	CHAR	1	0	Indicator for the Exclusion of all Items of a PPR
19	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
20	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
21	VALID_DATE_FROM	☐	CRMT_PRP_DATE_FROM	DATE	DATS	8	0	Valid-from Date
22	VALID_DATE_TO	☐	CRMT_PRP_DATE_TO	DATUM	DATS	8	0	Valid-to Date
23	OBJ_KIND	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
24	PRP_WL_SEL_1	☐	BU_TODO_ID_HISTORY	XFELD	CHAR	1	0	History of Last-Maintained Objects
25	PRP_WL_SEL_2	☐	CRMT_PRP_MY_FAVORITES	XFELD	CHAR	1	0	My Favorites
26	MKT_TYPE_ID	☐	CRMT_MKTTG_TG_TYPE	CRM_MKTTG_OBJECT_TYPE	CHAR	6	0	CRM Marketing: Usage ID
27	MKT_DESCRIPTION	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
28	MKT_CREATED_BY	☐	CRMT_MKT_CREATED_BY	UNAME	CHAR	12	0	Marketing Object: Created By User
29	MKT_CHANGED_BY	☐	CRMT_MKT_CHANGED_BY	UNAME	CHAR	12	0	Marketing Object: Last Changed By
30	MKT_SEG_DESCR	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
31	MKT_SEG_TYPE	☐	CRMT_MKTTG_TYPE	CRM_MKTTG_TYPE	CHAR	1	0	CRM Marketing: Object Type (Set, Profile, Target Group)
32	MKT_SEG_TYPE_DESCR	☐	CRMT_PRP_MKT_SEG_TYPE_DESCR	CRMDESCRS	CHAR	30	0	Marketing Segment type description
33	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
34	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division
35	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel
36	SER_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
37	BUHI_NODE_GUID_F4	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
38	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
39	NODE_SEARCH	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
40	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family
41	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key
42	REF_TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR
43	PRP_RANK_FROM	☐	CRMT_PRP_RANK_UI_FROM	CRM_PRP_RANK_UI	CHAR	10	0	Lower Limit for a Selection of PPR Ranks
44	PRP_RANK_TO	☐	CRMT_PRP_RANK_UI_TO	CRM_PRP_RANK_UI	CHAR	10	0	Higher Limit for a Selection of PPR Ranks
45	BUHI_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
46	BUHI_NODE_TEXT	☐	CRMT_PRP_BPH_NODE_DESCRIPTION	CHAR255	CHAR	255	0	Description of a BP Hierarchy Node and Hierarchy Tree
47	PRP_PER_SET	☐	CRMT_PRP_PER_SET		STRU	0	0
48	PER_DISPLAY	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
49	PER_LASTONE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
50	TOPN_LOCA_WL	☐	CRMT_PRP_LOCA_WL_TAB		TTYP	0	0
51	TOPN_LOCA_WL_M	☐	CRMT_PRP_LOCA_WL_TAB		TTYP	0	0
52	TOPN_LOCA_ALV_UI	☐	CRMT_PRP_LOCA_ALV_UI		STRU	0	0
53	GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
54	ID_DESCRIPTION	☐	CRMT_PRP_ID_DESCRIPTION	CRM_PRP_SHTEXT	CHAR	40	0	Search by Identifier and Header Description
55	PRP_ID	☐	CRMT_PRP_ID_LOCA	CRM_PRP_ID	CHAR	40	0	External identifier for a PPR
56	DESCRIPTION	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
57	PRP_I_ID	☐	CRMT_PRP_I_ID	CRM_PRP_I_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Item
58	PRP_I_TYPE	☐	CRMT_PRP_I_TYPE	CRM_PRP_I_TYPE	CHAR	1	0	PPR Item: Type of Link
59	I_DESCRIPTION	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
60	RELAT_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
61	NODE_KEY	☐	LVC_NKEY		CHAR	12	0	ALV Tree Control: Node Key
62	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)
63	PRODUCT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
64	PRODUCT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
65	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
66	PRP_STATUS	☐	CRMT_PRP_STATUS	CRM_PRP_STATUS	CHAR	1	0	Partner/Product Range (PPR) Status
67	PRP_EXCLUSION	☐	CRMT_PRPADM_H_EXCLUSION	CRM_PRP_EXCLUSION	CHAR	1	0	Indicator for the Exclusion of all Items of a PPR
68	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
69	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
70	VALID_DATE_FROM	☐	CRMT_PRP_DATE_FROM	DATE	DATS	8	0	Valid-from Date
71	VALID_DATE_TO	☐	CRMT_PRP_DATE_TO	DATUM	DATS	8	0	Valid-to Date
72	OBJ_KIND	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
73	PRP_WL_SEL_1	☐	BU_TODO_ID_HISTORY	XFELD	CHAR	1	0	History of Last-Maintained Objects
74	PRP_WL_SEL_2	☐	CRMT_PRP_MY_FAVORITES	XFELD	CHAR	1	0	My Favorites
75	MKT_TYPE_ID	☐	CRMT_MKTTG_TG_TYPE	CRM_MKTTG_OBJECT_TYPE	CHAR	6	0	CRM Marketing: Usage ID
76	MKT_DESCRIPTION	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
77	MKT_CREATED_BY	☐	CRMT_MKT_CREATED_BY	UNAME	CHAR	12	0	Marketing Object: Created By User
78	MKT_CHANGED_BY	☐	CRMT_MKT_CHANGED_BY	UNAME	CHAR	12	0	Marketing Object: Last Changed By
79	MKT_SEG_DESCR	☐	CRMT_MKTPR_OBJDESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of a Marketing Segment (Target Group, Profile)
80	MKT_SEG_TYPE	☐	CRMT_MKTTG_TYPE	CRM_MKTTG_TYPE	CHAR	1	0	CRM Marketing: Object Type (Set, Profile, Target Group)
81	MKT_SEG_TYPE_DESCR	☐	CRMT_PRP_MKT_SEG_TYPE_DESCR	CRMDESCRS	CHAR	30	0	Marketing Segment type description
82	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
83	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division
84	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel
85	SER_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
86	BUHI_NODE_GUID_F4	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
87	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
88	NODE_SEARCH	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
89	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family
90	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key
91	REF_TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR
92	PRP_RANK_FROM	☐	CRMT_PRP_RANK_UI_FROM	CRM_PRP_RANK_UI	CHAR	10	0	Lower Limit for a Selection of PPR Ranks
93	PRP_RANK_TO	☐	CRMT_PRP_RANK_UI_TO	CRM_PRP_RANK_UI	CHAR	10	0	Higher Limit for a Selection of PPR Ranks
94	BUHI_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
95	BUHI_NODE_TEXT	☐	CRMT_PRP_BPH_NODE_DESCRIPTION	CHAR255	CHAR	255	0	Description of a BP Hierarchy Node and Hierarchy Tree
96	TOPN_PER_SET	☐	CRMT_PRP_PER_SET		STRU	0	0
97	PER_DISPLAY	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
98	PER_LASTONE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A