SAP ABAP Table CRMT_CAT_IL_SCHEMA (Categorization Schema GenIL)

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_SCHEMA	Table Relationship Diagram
Short Description	Categorization Schema GenIL

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_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
2	ASP_ID	☐	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
3	VAL_FROM	☐	CRM_CAT_IL_TSTAMP_FROM	TZNTSTMPS	DEC	15	0	MC Valid From Timestamp
4	VAL_TO	☐	CRM_CAT_IL_TSTAMP_TO	TZNTSTMPS	DEC	15	0	MC Valid To Timestamp
5	ASP_MS	☐	CRM_ERMS_CAT_AS_MS	CRM_ERMS_CAT_AS_MS_DO	CHAR	1	0	Coherent Cat. - Main Structure of Aspect
6	ASP_MODE_AU	☐	CRM_ERMS_CAT_AS_AU_MODE	CRM_ERMS_CAT_AS_AU_MODE_DO	CHAR	1	0	Coherent Cat. - Mode of Authorization Checks
7	ASP_TYPE	☐	CRM_ERMS_CAT_AS_TYPE	CRM_ERMS_CAT_AS_TYPE_DO	CHAR	16	0	Coherent Categorization - Type of an Aspect
8	ASP_STATE	☐	CRM_ERMS_CAT_AS_STATE	CRM_ERMS_CAT_AS_STATE_DO	CHAR	1	0	Schemastatus
9	ASP_DELETED	☐	CRM_ERMS_CAT_BOOLEAN	CRM_ERMS_CAT_BOOL_DO	CHAR	1	0	Coherent Cat - Boolean Values
10	ASP_CA_MODIFY	☐	CRM_ERMS_CAT_TIMESTAMP	TZNTSTMPS	DEC	15	0	Coherent Cat - UTC Timestamp
11	TSTAMP_CREATE	☐	CRM_CAT_IL_TSTAMP_CREATE	TZNTSTMPS	DEC	15	0	MC Create Timestamp
12	TSTAMP_MODIFY	☐	CRM_CAT_IL_TSTAMP_MODIFY	TZNTSTMPS	DEC	15	0	MC Modify Timestamp
13	RESP_USER	☐	CRM_CAT_IL_RESP_USER	USERNAME	CHAR	12	0	MC User Responsible
14	ASP_LABL	☐	CRM_CAT_IL_SCHEMA_LABEL	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	MC Schema Name
15	ASP_DESC	☐	CRM_CAT_IL_SCHEMA_DESC	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	MC Schema Description
16	ASP_FLAG	☐	CRM_ERMS_CAT_BUF_FLAG	CRM_ERMS_CAT_BUF_FLAG_DO	CHAR	1	0	Coherent Cat - Buffer Flag
17	VAL_FROM_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_FROM	DATUM	DATS	8	0	PCUI Categories - Date Field
18	VAL_FROM_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_FROM	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Valid-From Time
19	VAL_TO_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_TO	DATUM	DATS	8	0	PCUI Categories - Date Field
20	VAL_TO_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_TO	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Valid-To Time
21	ASP_CHG_DATE	☐	CRMT_BSP_ERMS_CAT_DATE_CHG	DATUM	DATS	8	0	Multilevel Categorization - Changed On
22	ASP_CHG_TIME	☐	CRMT_BSP_ERMS_CAT_TIME_CHG	CRMT_BSP_ERMS_CAT_TIME_DO	TIMS	6	0	Multilevel Categorization - Changed At Time

History

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