I_CustomizingObjectTables

DDL: I_CUSTOMIZINGOBJECTTABLES Type: view_entity Package: S_CUSTOMIZING_IMG_ACTIVITY

Tables related to Customizing Objects

I_CustomizingObjectTables is a CDS View that provides data about "Tables related to Customizing Objects" in SAP S/4HANA. It reads from 1 data source (objs) and exposes 3 fields with key fields ParentObjectName, ParentObjectType, tabnameendasTableName. Part of development package S_CUSTOMIZING_IMG_ACTIVITY.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
objs ChildObjectList left_outer

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Tables related to Customizing Objects view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ParentObjectName ParentObjectList objectname
KEY ParentObjectType ParentObjectList objecttype
KEY tabnameendasTableName 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Tables related to Customizing Objects'
define view entity I_CustomizingObjectTables
 as select distinct from         
                          objs     as ParentObjectList            
    left outer join       objs     as ChildObjectList 
                                       on     ParentObjectList.tabname    = ChildObjectList.objectname and
                                              ParentObjectList.objecttype = 'C' and
                                            ( ChildObjectList.objecttype = 'S' or
                                              ChildObjectList.objecttype = 'V' or
                                              ChildObjectList.objecttype is initial )
  {
   key           ParentObjectList.objectname                          as ParentObjectName,
   key           ParentObjectList.objecttype                          as ParentObjectType,
   key           case 
                      when ParentObjectList.objecttype = 'C' then  ChildObjectList.tabname
                                                             else  ParentObjectList.tabname
                 end                                                  as TableName
}

Learn More