SAP ABAP Table CRMT_SERVICE_CMG_BW (Extract Structure for CRM Case Management - BW Extraction)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-SRV-BW (Application Component) BW Data Exchange
     ⤷ CRM_SERVICE_CMG_BW (Package) Package for Objects for Case Replication in BW

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_SERVICE_CMG_BW	Table Relationship Diagram
Short Description	Extract Structure for CRM Case Management - BW Extraction

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)	SCMG_T_CASE
3	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
4	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
5	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
6	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
7	PROFILE_ID	☐	SCMGSTATUSPROFID	SCMGPROFID	CHAR	8	0	Case: Status Profile
8	STAT_ORDERNO	☐	SCMGSTATUSONR	SCMGSTATUSONR	NUMC	2	0	Case: Status	SCMGSTATPROFS
9	PARENT_CASE	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
10	PROCESSOR_BP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
11	PROCESSOR_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
12	RESPONSIBLE_BP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
13	RESPONSIBLE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
14	CASE_DURATION	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
15	CASE_DURUNIT	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
16	CC_CATEGORY_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
17	CRM_BUS_REF_DATE	☐	CRMT_CMG_REF_DATE	DATUM	DATS	8	0	CRM Case Management - Business Reference Date
18	.INCLUDE	☐				0	0	Include for CRM-Specific Case Attributes(SAP, IBU and Cust.)
19	CRM_CASE_TITLE	☐	CRMT_CMG_CASE_TITLE_UPPER	CHAR80	CHAR	80	0	Text Without Upper/Lower Case
20	CRM_SCH_REF_TIME	☐	CRMT_CMG_SCH_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Schema Reference Timestamp - Categories
21	CRM_BUS_REF_TIME	☐	CRMT_CMG_REF_TSTMP	CMG_TIMESTAMP	DEC	15	0	Business Reference Timestamp - Categories
22	CRM_SCHEMA_ID	☐	CRMT_CMG_SCH_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	CRM Case Management - Schema ID
23	CRM_CATEGORY_ID	☐	CRMT_CMG_CAT_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	CRM Case Management - Reference Category ID
24	.INCLUDE	☐				0	0
25	.INCLUDE	☐				0	0
26	.INCLUDE	☐				0	0
27	.INCLUDE	☐				0	0
28	.INCLUDE	☐				0	0
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0	FS-Specific Case Attributes
31	PROD_CAT_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
32	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
33	.INCLUDE	☐				0	0	Include for Customer Includes used by Standard Case
34	CMG_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
35	.INCLUDE	☐				0	0
36	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_SERVICE_CMG_BW	CASE_GUID	SCMG_T_CASE	CASE_GUID	KEY	1	1
2	CRMT_SERVICE_CMG_BW	CASE_TYPE	SCMGCASETYPE	CASE_TYPE	KEY
3	CRMT_SERVICE_CMG_BW	STAT_ORDERNO	SCMGSTATPROFS	STAT_ORDERNO	KEY	1	N

History

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