SAP ABAP Table CRMT_CAT_IL_DQ_SCHEMA (MC Dynamic 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_DQ_SCHEMA	Table Relationship Diagram
Short Description	MC Dynamic 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_DESC	☐	CRM_CAT_IL_SCHEMA_DESC	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	MC Schema Description
6	ASP_LABL	☐	CRM_CAT_IL_SCHEMA_LABEL	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	MC Schema Name
7	ASP_LANG	☐	CRMT_BSP_ERMS_CAT_LANG_SOURCE	SPRAS	LANG	1	0	PCUI Categories - Query Language	*
8	ASP_LANG_ISO	☐	CRM_CAT_IL_LANG_SOURCE	LAISO	CHAR	2	0	Source Language
9	SC_ID	☐	CRM_ERMS_CAT_SC_ID	CRM_ERMS_CAT_SC_ID_DO	CHAR	40	0	Application ID	CRMC_ERMS_CAT_AA
10	SC_PAR	☐	CRM_CAT_IL_APPAREA_PAR	CRM_ERMS_CAT_SC_PAR_DO	CHAR	40	0	MC Application Area Parameter	*
11	SC_VAL	☐	CRM_CAT_IL_APPAREA_VAL	CRM_ERMS_CAT_SC_VAL_DO	CHAR	40	0	MC Application Area Parameter Value
12	SRC_MODE	☐	CRM_BSP_ERMS_CAT_SRC_MODE	CRM_BSP_ERMS_CAT_SRC_MODE_DO	CHAR	1	0	Category Modeler - Search Mode
13	ASP_TIME	☐	CRMT_BSP_ERMS_CAT_TIME	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Valid At Time
14	ASP_DATE	☐	CRMT_BSP_ERMS_CAT_DATE	DATUM	DATS	8	0	Multilevel Categorization - Valid On
15	ASP_CHG_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_CHG	DATUM	DATS	8	0	Multilevel Categorization - Changed On
16	ASP_CHG_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_CHG	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Changed At Time
17	TSTAMP_CREATE	☐	CRM_CAT_IL_TSTAMP_CREATE	TZNTSTMPS	DEC	15	0	MC Create Timestamp
18	TSTAMP_MODIFY	☐	CRM_CAT_IL_TSTAMP_MODIFY	TZNTSTMPS	DEC	15	0	MC Modify Timestamp
19	RESP_USER	☐	CRM_CAT_IL_RESP_USER	USERNAME	CHAR	12	0	MC User Responsible
20	RFCDEST	☐	CRMT_ERMS_CAT_RFC	RFCDEST	CHAR	32	0	RFC Destination for Schema Import	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_CAT_IL_DQ_SCHEMA	SC_ID	CRMC_ERMS_CAT_AA	SCHEME_ID

History

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