I_DSP_DRAFT_ENTITY_TYPE

DDL: I_DSP_DRAFT_ENTITY_TYPE Type: view_entity Package: SBOI_RAP_DSP_APPS_MY_DRAFTS

DSP: Draft Entity Type

I_DSP_DRAFT_ENTITY_TYPE is a CDS View that provides data about "DSP: Draft Entity Type" in SAP S/4HANA. It reads from 6 data sources and exposes 3 fields with key field DraftEntityType. Part of development package SBOI_RAP_DSP_APPS_MY_DRAFTS.

6 data source(s) 3 fields

Data Sources (6)

SourceAliasJoin Type
ddddlsrc ddddlsrc inner
ddddlsrc ddddlsrc inner
I_DraftAdminDataUserAuth I_DraftAdminDataUserAuth inner
I_DraftAdminDataUserAuth_cc I_DraftAdminDataUserAuth_cc inner
ddddlsrct txt left_outer
ddddlsrct txt left_outer

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label DSP: Draft Entity Type view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY DraftEntityType draft_admin draft_entity Draft Entity Type
draft_entityasDraftEntityType Description
Description ddddlsrct ddtext 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'DSP: Draft Entity Type'
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true

define view entity I_DSP_DRAFT_ENTITY_TYPE

  as select distinct from sdraft_admin as draft_admin
    inner join            I_DraftAdminDataUserAuth on  draft_admin.draft_entity = I_DraftAdminDataUserAuth.DraftEntityType
                                                   and draft_admin.draft_key    = I_DraftAdminDataUserAuth.DraftUUID
  // Filter records for deleted entity types

    inner join            ddddlsrc                 on  draft_admin.draft_entity = ddddlsrc.ddlname
                                                   and ddddlsrc.as4local        = 'A'
    left outer join       ddddlsrct    as txt      on  draft_admin.draft_entity = txt.ddlname
                                                   and txt.as4local             = 'A'
                                                   and txt.ddlanguage           = $session.system_language
{
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      @ObjectModel.text.element: [ 'Description' ]
      @EndUserText.label: 'Draft Entity Type'
  key draft_admin.draft_entity as DraftEntityType,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      @EndUserText.label: 'Description'
      txt.ddtext               as Description
}
union select distinct from sdraft_admin_cc as draft_admin_cc
  inner join               I_DraftAdminDataUserAuth_cc on  draft_admin_cc.draft_entity = I_DraftAdminDataUserAuth_cc.DraftEntityType
                                                       and draft_admin_cc.draft_key    = I_DraftAdminDataUserAuth_cc.DraftUUID
// Filter records for deleted entity types

  inner join               ddddlsrc                    on  draft_admin_cc.draft_entity = ddddlsrc.ddlname
                                                       and ddddlsrc.as4local           = 'A'
  left outer join          ddddlsrct       as txt      on  draft_admin_cc.draft_entity = txt.ddlname
                                                       and txt.as4local                = 'A'
                                                       and txt.ddlanguage              = $session.system_language
{
  key draft_admin_cc.draft_entity as DraftEntityType,
      txt.ddtext                  as Description
}

Learn More