SAP ABAP Table CRMV_ERMS_CAT_A1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMV_ERMS_CAT_A1	Table Relationship Diagram
Short Description	Generated Table for View

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ASP_GUID	☑	CRM_ERMS_CAT_GUID	SYSUUID	RAW	16	0	Multilevel Cat. - GUID Data Element
3	ASP_ID	☑	CRM_ERMS_CAT_AS_ID	CRM_ERMS_CAT_AS_ID_DO	CHAR	40	0	Coherent Cat. - Aspect ID
4	VAL_FROM	☑	CRM_ERMS_CAT_TIMESTAMP	TZNTSTMPS	DEC	15	0	Coherent Cat - UTC Timestamp
5	VAL_TO	☑	CRM_ERMS_CAT_TIMESTAMP	TZNTSTMPS	DEC	15	0	Coherent Cat - UTC Timestamp
6	ASP_MS	☑	CRM_ERMS_CAT_AS_MS	CRM_ERMS_CAT_AS_MS_DO	CHAR	1	0	Coherent Cat. - Main Structure of Aspect
7	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
8	ASP_TYPE	☑	CRM_ERMS_CAT_AS_TYPE	CRM_ERMS_CAT_AS_TYPE_DO	CHAR	16	0	Coherent Categorization - Type of an Aspect
9	ASP_STATE	☑	CRM_ERMS_CAT_AS_STATE	CRM_ERMS_CAT_AS_STATE_DO	CHAR	1	0	Schemastatus
10	ASP_DELETED	☑	CRM_ERMS_CAT_BOOLEAN	CRM_ERMS_CAT_BOOL_DO	CHAR	1	0	Coherent Cat - Boolean Values
11	ASP_CA_MODIFY	☑	CRM_ERMS_CAT_TIMESTAMP	TZNTSTMPS	DEC	15	0	Coherent Cat - UTC Timestamp
12	TSTAMP_CREATE	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	TSTAMP_MODIFY	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	RESP_USER	☑	UPNAME	USERNAME	CHAR	12	0	Last change by
15	LANG	☑	LANGU	SPRAS	LANG	1	0	Language Key	T002
16	ASP_LABEL	☐	CRM_ERMS_CAT_CA_DESC	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	Coherent Cat - Category Description
17	ASP_LABEL_UC	☐	CRM_ERMS_CAT_CA_DESC	CRM_ERMS_CAT_DESC_DO	CHAR	50	0	Coherent Cat - Category Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMV_ERMS_CAT_A1	CLIENT	T000	MANDT
2	CRMV_ERMS_CAT_A1	LANG	T002	SPRAS

History

Last changed by/on	SAP	20130604
SAP Release Created in