SAP ABAP Table CRMT_CAT_IL_QS_ATTR (MC Query Schema by Attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_CATEGOIL (Package) Multilevel Categorization GenIL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_CAT_IL_QS_ATTR	Table Relationship Diagram
Short Description	MC Query Schema by Attributes

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	ASP_GUID	☐	CRM_CAT_IL_SCHEMA_GUID	SYSUUID	RAW	16	0	MC Schema GUID
2	ASP_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
3	ASP_STATE	☐	CRMT_BSP_ERMS_CAT_AS_STATE_S	CRM_BSP_ERMS_CAT_AS_STATE_DO	CHAR	1	0	Category Modeler - State of Aspect
4	ASP_TSTAMP	☐	CRM_CAT_IL_TSTAMP_AT	TZNTSTMPS	DEC	15	0	MC Valid At Timestamp
5	ASP_FROM	☐	CRM_CAT_IL_TSTAMP_FROM	TZNTSTMPS	DEC	15	0	MC Valid From Timestamp
6	ASP_TO	☐	CRM_CAT_IL_TSTAMP_TO	TZNTSTMPS	DEC	15	0	MC Valid To Timestamp
7	OVERLAP	☐	CRM_CAT_IL_SCHEMA_OVERLAP	CRM_ERMS_CAT_BOOL_DO	CHAR	1	0	MC Indicator for Overlap Search
8	ASP_DESC	☐	CRM_CAT_IL_SCHEMA_DESC	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	MC Schema Description
9	ASP_LABL	☐	CRM_CAT_IL_SCHEMA_LABEL	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	MC Schema Name
10	CASE_SENSITIVE	☐	CRM_CAT_IL_SCHEMA_CASESEN	CRM_ERMS_CAT_BOOL_DO	CHAR	1	0	MC Indicator for Case Sensitive Search
11	ASP_LANG	☐	CRMT_BSP_ERMS_CAT_LANG_SOURCE	SPRAS	LANG	1	0	PCUI Categories - Query Language	*
12	TSTAMP_CREATE	☐	CRM_CAT_IL_TSTAMP_CREATE	TZNTSTMPS	DEC	15	0	MC Create Timestamp
13	TSTAMP_MODIFY	☐	CRM_CAT_IL_TSTAMP_MODIFY	TZNTSTMPS	DEC	15	0	MC Modify Timestamp
14	RESP_USER	☐	CRM_CAT_IL_RESP_USER	USERNAME	CHAR	12	0	MC User Responsible
15	SC_GUID	☐	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
16	SC_ID	☐	CRM_ERMS_CAT_SC_ID	CRM_ERMS_CAT_SC_ID_DO	CHAR	40	0	Application ID	*
17	SC_PAR	☐	CRM_CAT_IL_APPAREA_PAR	CRM_ERMS_CAT_SC_PAR_DO	CHAR	40	0	MC Application Area Parameter	*
18	SC_VAL	☐	CRM_CAT_IL_APPAREA_VAL	CRM_ERMS_CAT_SC_VAL_DO	CHAR	40	0	MC Application Area Parameter Value
19	UNASSIGNED	☐	CRM_CAT_IL_SCHEMA_UNASS	CRM_ERMS_CAT_BOOL_DO	CHAR	1	0	MC Indicator for Unassigned Schemas
20	UNASSIGNED_ONLY	☐	CRM_CAT_IL_SCHEMA_UNASS_ONLY	CRM_ERMS_CAT_BOOL_DO	CHAR	1	0	MC Indicator for Unassigned Schemas Only
21	VAL_AT_DATE	☐	CRMT_BSP_ERMS_CAT_DATE	DATUM	DATS	8	0	Multilevel Categorization - Valid On
22	VAL_AT_TIME	☐	CRMT_BSP_ERMS_CAT_TIME	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Valid At Time
23	VAL_FROM_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_FROM	DATUM	DATS	8	0	PCUI Categories - Date Field
24	VAL_FROM_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_FROM	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Valid-From Time
25	VAL_TO_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_TO	DATUM	DATS	8	0	PCUI Categories - Date Field
26	VAL_TO_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_TO	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Valid-To Time
27	ASP_CHG_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_CHG	DATUM	DATS	8	0	Multilevel Categorization - Changed On
28	ASP_CHG_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_CHG	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Changed At Time
29	MAX_HITS	☐	CRM_ERMS_CAT_INTEGER	CRM_ERMS_CAT_HI_LEVEL_DO	INT4	10	0	Coherent Cat - Integer Number
30	RFCDEST	☐	CRMT_ERMS_CAT_RFC	RFCDEST	CHAR	32	0	RFC Destination for Schema Import	*

History

Last changed by/on	SAP	20100420
SAP Release Created in	510