SAP ABAP View CRMV_ERMS_CAT_CA (Multilevel Categorization: View for Aspects and Categories)
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_CA  
Short Description Multilevel Categorization: View for Aspects and Categories    
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  
3 CRMC_ERMS_CAT_CA  
4 CRMC_ERMS_CAT_CD  
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_CA CLIENT JR EQ AND 0 0
3 CRMC_ERMS_CAT_AS ASP_GUID JL EQ 0 0
4 CRMC_ERMS_CAT_CA ASP_GUID JR EQ AND 0 0
5 CRMC_ERMS_CAT_AS CLIENT JL EQ 0 0
6 CRMC_ERMS_CAT_AD CLIENT JR EQ AND 0 0
7 CRMC_ERMS_CAT_AS ASP_GUID JL EQ 0 0
8 CRMC_ERMS_CAT_AD ASP_GUID JR EQ AND 0 0
9 CRMC_ERMS_CAT_CD CLIENT JL EQ 0 0
10 CRMC_ERMS_CAT_CA CLIENT JR EQ AND 0 0
11 CRMC_ERMS_CAT_CD CAT_GUID JL EQ 0 0
12 CRMC_ERMS_CAT_CA CAT_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 CAT_GUID CRMC_ERMS_CAT_CA CAT_GUID   CRM_ERMS_CAT_GUID Multilevel Cat. - GUID Data Element
4 LANG CRMC_ERMS_CAT_AD LANG   LANGU Language Key
5 ASP_ID CRMC_ERMS_CAT_AS ASP_ID   CRM_ERMS_CAT_AS_ID Coherent Cat. - Aspect ID
6 ASP_STATE CRMC_ERMS_CAT_AS ASP_STATE   CRM_ERMS_CAT_AS_STATE Schemastatus
7 ASP_LABEL CRMC_ERMS_CAT_AD ASP_LABEL   CRM_ERMS_CAT_CA_DESC Coherent Cat - Category Description
8 CAT_ID CRMC_ERMS_CAT_CA CAT_ID   CRM_ERMS_CAT_CA_ID Coherent Cat. - Category ID
9 CAT_LABEL CRMC_ERMS_CAT_CD CAT_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  20130604 
SAP Release Created in 510