SAP ABAP View CRMV_CATEGO_SCHD (Database View for Extraction of Schema Texts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-SRV-BW (Application Component) BW Data Exchange
     ⤷ CRM_CATEGORIZATION_BW (Package) Coherent Categorization - SAP BW Extraction

Basic Data

View Type	D	Database View
Database View	CRMV_CATEGO_SCHD
Short Description	Database View for Extraction of Schema Texts
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_AD

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_AD	CLIENT	JR	EQ			AND	0	0
3	CRMC_ERMS_CAT_AS	ASP_GUID	JL	EQ				0	0
4	CRMC_ERMS_CAT_AD	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	LANG	CRMC_ERMS_CAT_AD	LANG		☐	LANGU	☐	Language Key
3	ASP_GUID	CRMC_ERMS_CAT_AS	ASP_GUID		☐	CRM_ERMS_CAT_GUID	☐	Multilevel Cat. - GUID Data Element
4	ASP_ID	CRMC_ERMS_CAT_AS	ASP_ID		☐	CRM_ERMS_CAT_AS_ID	☐	Coherent Cat. - Aspect ID
5	VAL_FROM	CRMC_ERMS_CAT_AS	VAL_FROM		☐	CRM_ERMS_CAT_TIMESTAMP	☐	Coherent Cat - UTC Timestamp
6	VAL_TO	CRMC_ERMS_CAT_AS	VAL_TO		☐	CRM_ERMS_CAT_TIMESTAMP	☐	Coherent Cat - UTC Timestamp
7	ASP_STATE	CRMC_ERMS_CAT_AS	ASP_STATE		☐	CRM_ERMS_CAT_AS_STATE	☐	Schemastatus
8	ASP_DELETED	CRMC_ERMS_CAT_AS	ASP_DELETED		☐	CRM_ERMS_CAT_BOOLEAN	☐	Coherent Cat - Boolean Values
9	ASP_LABEL	CRMC_ERMS_CAT_AD	ASP_LABEL		☐	CRM_ERMS_CAT_CA_DESC	☐	Coherent Cat - Category 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	20070401
SAP Release Created in	500