SAP ABAP Table CRMT_BW_SOA_I (CRM BW Extract Structure Social Application (SOA) Item)

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_SOA_I	Table Relationship Diagram
Short Description	CRM BW Extract Structure Social Application (SOA) Item

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	Item administration Social Service BW Data Source
2	HEADER_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	HEADER_PROC_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
4	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
5	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
6	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
7	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
8	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
9	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
10	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
11	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
12	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
13	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
14	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
15	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
16	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
17	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
18	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
19	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
20	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
21	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
22	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
23	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
24	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
25	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
26	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
27	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
28	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
29	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
30	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
31	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
32	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
33	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
34	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
35	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
36	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
37	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
38	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
39	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
40	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
41	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
42	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
43	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
44	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
45	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
46	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
47	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
48	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
49	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
50	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
51	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
52	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
53	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
54	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
55	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
56	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
57	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
58	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
59	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
60	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
61	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
62	.INCLUDE	☐				0	0	Social Service Status Groups Data for BW DataSources
63	BWSTSOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
64	BWSTSOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
65	BWSTSOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
66	BWSTSOCSYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
67	BWSTSOCSYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
68	BWSTSOCSYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
69	.INCLUDE	☐				0	0	General Product Data for BW DataSources
70	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
71	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
72	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
73	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
74	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
75	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
76	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
77	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
78	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
79	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
80	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
81	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
82	.INCLUDE	☐				0	0	General date structure Social Service BW Data Source
83	VALID_FROM_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
84	VALID_TO_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date

History

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