I_EntSrchCustCDSModel

DDL: I_ENTSRCHCUSTCDSMODEL Type: view_entity TRANSACTIONAL

Custom Search Models

I_EntSrchCustCDSModel is a Transactional CDS View that provides data about "Custom Search Models" in SAP S/4HANA. It reads from 2 data sources (ddldependency, esh_cds_mdl) and exposes 7 fields with key field EntSrchModelName. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
ddldependency _cdsmapping inner
esh_cds_mdl _eshsrchcdsmdl from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CDSEntityHeaderAnnotation _cdsheaderanno $projection.EntSrchModelName = _cdsheaderanno.CDSView and _cdsheaderanno.CDSViewAnnotationName = 'UI.HEADERINFO.TYPENAMEPLURAL'

Annotations (6)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Custom Search Models view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EntSrchModelName esh_cds_mdl cds_entity
EntSrchModelScope esh_cds_mdl scope_dependent
EntSrchModelCreatedByUser esh_cds_mdl created_by
EntSrchModelLastChangedByUser esh_cds_mdl changed_by
EntSrchModAppID
ABAPLanguageVersion esh_cds_mdl abap_language_version
EntSrchModelConnectorID _eshconnector sc_id 
@VDM: {
   viewType: #TRANSACTIONAL
}
@ObjectModel: {
    usageType: {
        dataClass:      #MASTER,
        serviceQuality: #C,
        sizeCategory:   #S
    }
}
@EndUserText.label: 'Custom Search Models'
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity I_EntSrchCustCDSModel
  as select from           esh_cds_mdl                as _eshsrchcdsmdl
    inner join             ddldependency              as _cdsmapping          on _eshsrchcdsmdl.cds_entity  = _cdsmapping.ddlname
    left outer to one join esh_om_aotyp               as _eshmodel            on _cdsmapping.objectname     = _eshmodel.backend_name
    left outer to one join esh_adm_sc_main            as _eshconnector        on _eshmodel.object_type_name = _eshconnector.object_type
    left outer to one join esh_adm_status             as _eshconnectorstatus  on _eshconnectorstatus.sc_id  = _eshconnector.sc_id
    left outer to one join I_EntSrchRuntimeBufferText as _eshruntimebufferTxt on _eshruntimebufferTxt.EntSrchModelConnectorID = _eshconnector.sc_id
  association [0..*] to I_CDSEntityHeaderAnnotation   as _cdsheaderanno on  $projection.EntSrchModelName        = _cdsheaderanno.CDSView
                                                                       and _cdsheaderanno.CDSViewAnnotationName = 'UI.HEADERINFO.TYPENAMEPLURAL'
{
  key _eshsrchcdsmdl.cds_entity            as EntSrchModelName,
      _eshsrchcdsmdl.scope_dependent       as EntSrchModelScope,
      _eshsrchcdsmdl.created_by            as EntSrchModelCreatedByUser,
      _eshsrchcdsmdl.changed_by            as EntSrchModelLastChangedByUser,
      //_eshsrchcdsmdl.app_id                as EntSrchModAppID,

      cast( '' as sch_de_iam_app_id )      as EntSrchModAppID,
      //@Semantics.systemDateTime.lastChangedAt: true

      //_eshsrchcdsmdl.changed_timestamp     as EntSrchModelLastChangedTime,

      _eshsrchcdsmdl.abap_language_version as ABAPLanguageVersion,
      case when _eshruntimebufferTxt.EntSrchModelConnectorDesc is null or _eshruntimebufferTxt.EntSrchModelConnectorDesc = ''
              then replace(_cdsheaderanno.CDSViewAnnotationValue,'''','')
           else _eshruntimebufferTxt.EntSrchModelConnectorDesc
              end                          as EntSrchModelConnectorDesc,
      _eshconnector.sc_id                  as EntSrchModelConnectorID,
      case _eshconnectorstatus.sc_status
        when '08'
            then 'Active'
            else 'Inactive'
      end                                  as EntSrchModelConnectorStatus
}
where
  _eshsrchcdsmdl.abap_language_version = '2'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CDSENTITYHEADERANNOTATION",
"I_ENTSRCHRUNTIMEBUFFERTEXT",
"DDLDEPENDENCY",
"ESH_ADM_SC_MAIN",
"ESH_ADM_STATUS",
"ESH_CDS_MDL",
"ESH_OM_AOTYP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More