DHBAS_ExtractionEnabledObj

DDL: DHBAS_EXTRACTIONENABLEDOBJ Type: view_entity

Extraction Enabled Objects

DHBAS_ExtractionEnabledObj is a CDS View that provides data about "Extraction Enabled Objects" in SAP S/4HANA. It reads from 3 data sources (dd02l, dd02t, DHCDC_AUTH_CdsExtrctnEnabled) and exposes 7 fields with key fields ObjectType, ObjectName, ObjectName.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
dd02l dd02l union
dd02t dd02t left_outer
DHCDC_AUTH_CdsExtrctnEnabled DHCDC_AUTH_CdsExtrctnEnabled from

Parameters (1)

NameTypeDefault
p_langu langu

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Extraction Enabled Objects view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ObjectType
KEY ObjectName viewname
ObjectNameRaw viewname_raw
ObjectText ddtext
KEY ObjectName dd02l tabname
ObjectNameRaw dd02l tabname
ObjectText dd02t ddtext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Extraction Enabled Objects'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DHBAS_ExtractionEnabledObj
  with parameters
    p_langu : langu
  as select from DHCDC_AUTH_CdsExtrctnEnabled
{
  key cast ('DDLS' as trobjtype preserving type )                                        as ObjectType,
  key viewname                                                                           as ObjectName,
      viewname_raw                                                                       as ObjectNameRaw,
      ddtext                                                                             as ObjectText,
      case
        when isDeltaSupported = 'true' then cast('X' as abap_boolean preserving type)
                                       else cast('' as abap_boolean preserving type) end as IsDeltaSupported
}

union

select from       dd02l
  left outer join dd02t on  dd02t.tabname    = dd02l.tabname
                        and dd02t.as4local   = dd02l.as4local
                        and dd02t.as4vers    = dd02l.as4vers
                        and dd02t.ddlanguage = $parameters.p_langu
{
  key case
        when dd02l.tabclass = 'TRANSP' then cast('TABL' as trobjtype preserving type )
                                       else cast('VIEW' as trobjtype preserving type )
                                       end                                          as ObjectType,
  key dd02l.tabname                                                                 as ObjectName,
      dd02l.tabname                                                                 as ObjectNameRaw,
      dd02t.ddtext                                                                  as ObjectText,
      case
        when dd02l.viewref <> '' or dd02l.tabclass = 'VIEW'
                                 then cast('' as abap_boolean preserving type)
                                 else cast('X' as abap_boolean preserving type) end as IsDeltaSupported
}
where
       dd02l.is_gtt   = ''
  and  dd02l.as4local = 'A'
  and(
       dd02l.tabclass = 'TRANSP'
    or dd02l.tabclass = 'VIEW'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DHCDC_AUTH_CDSEXTRCTNENABLED",
"DD02L",
"DD02T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More