P_SubstnCtrlAssgmtByAccUUID

DDL: P_SUBSTNCTRLASSGMTBYACCUUID Type: view_entity COMPOSITE Package: ATP_OVD_APPL_VDM

Master Data Substitution Related Accesses

P_SubstnCtrlAssgmtByAccUUID is a Composite CDS View that provides data about "Master Data Substitution Related Accesses" in SAP S/4HANA. It reads from 2 data sources (I_MDSubstnCtrl, R_SubstnCtrlAssgmtByAccUUID) and exposes 3 fields with key fields MDSubstnControl, MDSubstnObjectType. Part of development package ATP_OVD_APPL_VDM.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_MDSubstnCtrl I_MDSubstnCtrl inner
R_SubstnCtrlAssgmtByAccUUID R_SubstnCtrlAssgmtByAccUUID from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnControl R_SubstnCtrlAssgmtByAccUUID MDSubstnControl
KEY MDSubstnObjectType R_SubstnCtrlAssgmtByAccUUID MDSubstnObjectType
MDSubstnNmbrOfAssignedAccess 
@AccessControl:{
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
    usageType:{
      dataClass: #MASTER,
      sizeCategory: #S,
      serviceQuality: #A
  }
}
@VDM:{
  private: true,
  viewType: #COMPOSITE
}

define view entity P_SubstnCtrlAssgmtByAccUUID
  as select from R_SubstnCtrlAssgmtByAccUUID
    inner join   I_MDSubstnCtrl on  R_SubstnCtrlAssgmtByAccUUID.MDSubstnObjectType = I_MDSubstnCtrl.MDSubstnObjectType
                                and R_SubstnCtrlAssgmtByAccUUID.MDSubstnControl    = I_MDSubstnCtrl.MDSubstnControl
{
  key R_SubstnCtrlAssgmtByAccUUID.MDSubstnControl,
  key R_SubstnCtrlAssgmtByAccUUID.MDSubstnObjectType,
      cast(count(distinct R_SubstnCtrlAssgmtByAccUUID.ObjValDetnAccessUUID) as md_substn_assgned_access_count preserving type) as MDSubstnNmbrOfAssignedAccess
}
group by
  R_SubstnCtrlAssgmtByAccUUID.MDSubstnControl,
  R_SubstnCtrlAssgmtByAccUUID.MDSubstnObjectType

Learn More