R_SUBSTNCTRLASSGMTBYACCUUID

CDS View

Substitution Control used by Accesses

R_SUBSTNCTRLASSGMTBYACCUUID is a CDS View in S/4HANA. Substitution Control used by Accesses. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SubstnCtrlAssgmtByAccUUID view_entity from CONSUMPTION Substituion Control used by Accesses
P_SubstnCtrlAssgmtByAccUUID view_entity from COMPOSITE Master Data Substitution Related Accesses

Fields (2)

KeyField CDS FieldsUsed in Views
KEY MDSubstnControl MDSubstnControl 1
KEY MDSubstnObjectType MDSubstnObjectType 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Substitution Control used by Accesses'
@ObjectModel: {
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #A,
    sizeCategory: #M
  }
}
@VDM: {
  lifecycle: {
    contract.type: #SAP_INTERNAL_API
  },
  viewType: #COMPOSITE
}
define view entity R_SubstnCtrlAssgmtByAccUUID
  as select from I_SubstitutionCtrlAssignment
{
      @ObjectModel.foreignKey.association: null
  key MDSubstnObjectType,

      @ObjectModel.foreignKey.association: null
  key MDSubstnControl,

      @ObjectModel.foreignKey.association: null
  key ObjValDetnAccessUUID,

      cast(count(*) as atp_abc_n_o_related_altvctrl) as NumberOfRelatedSubstnControls

}
where
      _Access.ObjValDetnUsage                      =  'SUBSTN'
  and _CharcValCombn.BusPrpsOfRefdValueIsCompleted <> 'X'
group by
  ObjValDetnAccessUUID,
  MDSubstnObjectType,
  MDSubstnControl

Learn More