SAP ABAP Table CRMT_BW_SOA_H (CRM BW Extract Structure Social Application (SOA) Header)

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

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	ORDERADM_H Data for BW DataSources
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
27	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
28	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
29	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
30	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
31	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
32	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
33	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
34	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
35	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
36	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
37	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
38	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
39	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
40	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
41	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
42	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
43	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
44	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
45	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
46	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
47	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
48	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
49	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
50	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
51	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
52	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
53	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
54	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
55	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
56	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
57	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
58	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
59	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
60	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
61	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
62	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
63	.INCLUDE	☐				0	0	Social Service Status Groups Data for BW DataSources
64	BWSTSOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
65	BWSTSOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
66	BWSTSOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
67	BWSTSOCSYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
68	BWSTSOCSYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
69	BWSTSOCSYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
70	.INCLUDE	☐				0	0	General date structure Social Service BW Data Source
71	VALID_FROM_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
72	VALID_TO_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_SOA_H	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

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