SAP ABAP Table CRMT_BW_PROD_OBJ_LIST (BW: Extract Structure for Product and Object List)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_PROD_OBJ_LIST	Table Relationship Diagram
Short Description	BW: Extract Structure for Product and Object List

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
3	PRPPROD_I_GUID	☐	CRMT_PRP_GUID_C	SYSUUID_C	CHAR	32	0	Unique Key for PPR Objects
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	HEADER_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
6	HEADER_OBJ_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
7	HEADER_PRC_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
8	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
9	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	CRMC_SUBOB_CAT_I
10	ITEM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
11	PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
12	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
13	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
14	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
15	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
16	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
17	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
18	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
19	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
20	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER_32	BU_PARTNER	CHAR	10	0	Activity Partner: GUID	*
21	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
22	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
23	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
24	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
25	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
26	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
27	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
28	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
29	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
30	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
31	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
32	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
33	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
34	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
35	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
36	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
37	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
38	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
39	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
40	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
41	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
42	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
43	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
44	ITEM_CHANGED_TS	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
45	PRP_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
46	PRP_I_GUID	☐	CRMT_PRP_GUID_C	SYSUUID_C	CHAR	32	0	Unique Key for PPR Objects
47	PRP_I_EXCLUSION	☐	CRMT_PRPADM_I_EXCLUSION	CRM_PRP_EXCLUSION	CHAR	1	0	Indicator for the Exclusion of a single PPR item
48	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
49	PRPPROD_I_TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
50	FLAG_PL_OL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
51	PRP_H_GUID	☐	CRMT_PRP_GUID_C	SYSUUID_C	CHAR	32	0	Unique Key for PPR Objects
52	.INCLUDE	☐				0	0	Product Detail Data PPR for BW Datasources
53	PL_PRODUCT_ID	☐	CRMT_PRODUCT_ID_PL	COM_PRODUCT_ID	CHAR	40	0	Product ID from Product List
54	PL_PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_PL	SYSUUID_C	CHAR	32	0	Product GUID from Product List
55	PL_CATEGORY_ID	☐	CRMT_CATEGORY_ID_PL	COM_CATEGORY_ID	CHAR	20	0	Category ID from Product List
56	PL_CATEGORY_GUID	☐	CRMT_CATEGORY_GUID_PL	SYSUUID_C	CHAR	32	0	Category GUID from Product List
57	PL_SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
58	PL_CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
59	PL_CTLOG_ITEM_ID	☐	BBP_CATALOGITEM_PL	CRM_CATALOGITEM	CHAR	40	0	Catalog Item from Product List
60	PL_PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER_PL	PRSHTEXT40	CHAR	40	0	Product Number for PPR
61	PL_MASTER_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
62	PL_MAST_PRP_GUID	☐	CRMT_PRP_GUID_PL	SYSUUID_C	CHAR	32	0	Internal, Unique Identifier for PPR Objects
63	OL_PRODUCT_ID	☐	CRMT_PRODUCT_ID_PL	COM_PRODUCT_ID	CHAR	40	0	Product ID from Product List
64	OL_PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_OL	SYSUUID_C	CHAR	32	0	Product GUID from Object List
65	OL_SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
66	OL_MASTER_PRP_ID	☐	CRMT_PRP_ID_OL	CRM_PRP_ID	CHAR	40	0	External Identifier for a Partner/Product Range (PPR) OBJL
67	OL_MAST_PRP_GUID	☐	CRMT_PRP_GUID_OL	SYSUUID_C	CHAR	32	0	Internal, Unique Identifier for PPR Objects OBJL
68	OL_IB_HEADER	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
69	OL_IB_HEAD_GUID	☐	IB_RECNO_32	SYSUUID_C	CHAR	32	0	IB: 32-Character Record Number
70	OL_IB_COMP	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
71	OL_IB_COMP_GUID	☐	IB_RECNO_32	SYSUUID_C	CHAR	32	0	IB: 32-Character Record Number
72	OL_IOBJECT_ID	☐	COMT_PRODUCT_OBJECT_ID	COM_PRODUCT_ID	CHAR	40	0	Object ID
73	OL_IOBJECT_GUID	☐	CRMT_PRODUCT_GUID_OL	SYSUUID_C	CHAR	32	0	Product GUID from Object List
74	OL_CONFPROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
75	OL_CONFPROD_GUID	☐	CRMT_PRODUCT_GUID_OL	SYSUUID_C	CHAR	32	0	Product GUID from Object List
76	OL_PROD_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
77	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
78	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_PROD_OBJ_LIST	ITEM_OBJECT_TYPE	CRMC_SUBOB_CAT_I	SUBOBJ_CATEGORY	KEY

History

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