SAP ABAP View CRMV_ERMS_CAT_A2 (Multilevel Categorization: Schema with Descriptions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-EMS-CAT (Application Component) Categories
     ⤷ CRM_ERMS_CATEGORIZATION (Package) CRM_ERMS_CATEGORIZATION

Basic Data

View Type	D	Database View
Database View	CRMV_ERMS_CAT_A2
Short Description	Multilevel Categorization: Schema with Descriptions
Root table	CRMC_ERMS_CAT_AS	Coherent Cat - Aspects for Categorization

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMC_ERMS_CAT_AS	CRMC_ERMS_CAT_AS
2	CRMC_ERMS_CAT_AT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMC_ERMS_CAT_AS	CLIENT	JL	EQ				0	0
2	CRMC_ERMS_CAT_AT	CLIENT	JR	EQ			AND	0	0
3	CRMC_ERMS_CAT_AS	ASP_GUID	JL	EQ				0	0
4	CRMC_ERMS_CAT_AT	ASP_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMC_ERMS_CAT_AS	CLIENT		☐	MANDT	☐	Client
2	ASP_GUID	CRMC_ERMS_CAT_AS	ASP_GUID		☐	CRM_ERMS_CAT_GUID	☐	Multilevel Cat. - GUID Data Element
3	ASP_ID	CRMC_ERMS_CAT_AS	ASP_ID		☐	CRM_ERMS_CAT_AS_ID	☐	Coherent Cat. - Aspect ID
4	VAL_FROM	CRMC_ERMS_CAT_AS	VAL_FROM		☐	CRM_ERMS_CAT_TIMESTAMP	☐	Coherent Cat - UTC Timestamp
5	VAL_TO	CRMC_ERMS_CAT_AS	VAL_TO		☐	CRM_ERMS_CAT_TIMESTAMP	☐	Coherent Cat - UTC Timestamp
6	ASP_MS	CRMC_ERMS_CAT_AS	ASP_MS		☐	CRM_ERMS_CAT_AS_MS	☐	Coherent Cat. - Main Structure of Aspect
7	ASP_MODE_AU	CRMC_ERMS_CAT_AS	ASP_MODE_AU		☐	CRM_ERMS_CAT_AS_AU_MODE	☐	Coherent Cat. - Mode of Authorization Checks
8	ASP_TYPE	CRMC_ERMS_CAT_AS	ASP_TYPE		☐	CRM_ERMS_CAT_AS_TYPE	☐	Coherent Categorization - Type of an Aspect
9	ASP_STATE	CRMC_ERMS_CAT_AS	ASP_STATE		☐	CRM_ERMS_CAT_AS_STATE	☐	Schemastatus
10	ASP_DELETED	CRMC_ERMS_CAT_AS	ASP_DELETED		☐	CRM_ERMS_CAT_BOOLEAN	☐	Coherent Cat - Boolean Values
11	ASP_CA_MODIFY	CRMC_ERMS_CAT_AS	ASP_CA_MODIFY		☐	CRM_ERMS_CAT_TIMESTAMP	☐	Coherent Cat - UTC Timestamp
12	TSTAMP_CREATE	CRMC_ERMS_CAT_AS	TSTAMP_CREATE		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	TSTAMP_MODIFY	CRMC_ERMS_CAT_AS	TSTAMP_MODIFY		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	RESP_USER	CRMC_ERMS_CAT_AS	RESP_USER		☐	UPNAME	☐	Last change by
15	LANG	CRMC_ERMS_CAT_AT	LANG		☐	LANGU	☐	Language Key
16	ASP_DESC	CRMC_ERMS_CAT_AT	ASP_DESC		☐	CRM_ERMS_CAT_AS_DESC	☐	Multilevel Categorization - Schema Description
17	ASP_DESC_UC	CRMC_ERMS_CAT_AT	ASP_DESC_UC		☐	CRM_ERMS_CAT_AS_DESC	☐	Multilevel Categorization - Schema Description

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in	703