SAP ABAP Table CRMC_EVT_SUBSC (Database Table with Subscription Parameters)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPS (Application Component) Public Sector
     ⤷ CRM_EVT (Package) CRM Social Services Event Control

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_EVT_SUBSC	Table Relationship Diagram
Short Description	Database Table with Subscription Parameters

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	IMPORT_STATUS	☑	BRF_IMPORT_STATUS	BRF_IMPORT_STATUS	CHAR	1	0	BRF: Import Status
3	APPLCLASS	☑	BRF_APPLCLASS	BRF_APPLCLASS	CHAR	30	0	BRF: Application Class	TBRF000
4	EVENT	☑	BRF_EVENT	BRF_EVENT	CHAR	20	0	Name of Event	*
5	VERSION	☑	BRF_VERSION	BRF_VERSION	NUMC	4	0	BRF: Version
6	SUBSCR_GUID	☑	CRMT_EVT_SUBSCR_GUID	SYSUUID_C	CHAR	32	0	Subscription GUID
7	.INCLUDE	☐				0	0	BRF: Administration Information
8	CREATED_BY	☐	BRF_CREATED_BY	XUBNAME	CHAR	12	0	BRF: Version Created by	USR02
9	CREATED_AT	☐	BRF_CREATED_AT	TZNTSTMPS	DEC	15	0	Version Created On/At
10	CHANGED_BY	☐	BRF_CHANGED_BY	XUBNAME	CHAR	12	0	BRF: Version Changed By	USR02
11	CHANGED_AT	☐	BRF_CHANGED_AT	TZNTSTMPS	DEC	15	0	Version Changed On/At
12	DELETED	☐	BRF_XDELETED	BRF_BOOLE_D	CHAR	1	0	Obsolete (BRF: Mark Entry for Physical Deletion)
13	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
14	CRM_CATEGORY_ID	☐	CRMT_CMG_CAT_ID	CRM_ERMS_CAT_CA_ID_DO	CHAR	40	0	CRM Case Management - Reference Category ID
15	ACTION	☐	BRF_ACTION	BRF_ACTION	CHAR	20	0	Name of Action	TBRF170
16	EXPRESSION	☐	BRF_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF: Expression	TBRF150
17	EXPR_GATE	☐	BRF_EXPRESSION_GATE	BRF_EXPRESSION	CHAR	20	0	BRF: Gate Expression	TBRF150
18	VALID_FROM	☐	CRMT_EVT_SUBSC_VALID_FROM	CRMT_EVT_TIMESTAMP	DEC	15	0	Subscription Valid From
19	VALID_TO	☐	CRMT_EVT_SUBSC_VALID_TO	CRMT_EVT_TIMESTAMP	DEC	15	0	Subscription Valid To
20	REF_DATE_EXPR	☐	CRMT_EVT_SUBSC_REF_DATE	BRF_EXPRESSION	CHAR	20	0	Reference Date for Subscription Processing	*
21	REF_TIME_EXPR	☐	CRMT_EVT_SUBSC_REF_TIME	BRF_EXPRESSION	CHAR	20	0	Reference Time for Subscription Processing	*
22	EXPR_CASE_EXIST	☐	CRMT_EVT_EXPR_CASE_EXIST	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Case Existence Check	TBRF150
23	OBJ_GROUP	☐	BRF_OBJ_GROUP	BRF_OBJ_GROUP	CHAR	20	0	BRF: Grouping of BRF Objects	TBRF230
24	EVENT_PHASE	☐	CRMT_EVT_EVENT_PHASE	CRMT_EVT_EVENT_PHASE	CHAR	8	0	SSE: Event Processing Phase	CRMC_EVT_PHASE
25	PRIORITY	☐	CRMT_EVT_PRIORITY	CRMT_EVT_PRIORITY	NUMC	4	0	Priority of Process
26	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_EVT_SUBSC	ACTION	TBRF170	ACTION
2	CRMC_EVT_SUBSC	APPLCLASS	TBRF000	APPLCLASS
3	CRMC_EVT_SUBSC	CASE_TYPE	SCMGCASETYPE	CASE_TYPE
4	CRMC_EVT_SUBSC	CHANGED_BY	USR02	BNAME
5	CRMC_EVT_SUBSC	CREATED_BY	USR02	BNAME
6	CRMC_EVT_SUBSC	EVENT_PHASE	CRMC_EVT_PHASE	EVENT_PHASE
7	CRMC_EVT_SUBSC	EXPRESSION	TBRF150	EXPRESSION
8	CRMC_EVT_SUBSC	EXPR_CASE_EXIST	TBRF150	EXPRESSION
9	CRMC_EVT_SUBSC	EXPR_GATE	TBRF150	EXPRESSION
10	CRMC_EVT_SUBSC	OBJ_GROUP	TBRF230	OBJ_GROUP

History

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