C_SubstnCtrlAssgmtByAccUUID

DDL: C_SUBSTNCTRLASSGMTBYACCUUID Type: view_entity CONSUMPTION

Substituion Control used by Accesses

C_SubstnCtrlAssgmtByAccUUID is a Consumption CDS View that provides data about "Substituion Control used by Accesses" in SAP S/4HANA. It reads from 1 data source (R_SubstnCtrlAssgmtByAccUUID) and exposes 17 fields with key fields MDSubstnObjectType, MDSubstnControl, ObjValDetnAccessUUID. It has 3 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
R_SubstnCtrlAssgmtByAccUUID R_SubstnCtrlAssgmtByAccUUID from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ObjValDetnAccess _Access $projection.ObjValDetnAccessUUID = _Access.ObjValDetnAccessUUID
[1..1] I_SAPObjectType _MDObjectType $projection.MDSubstnObjectType = _MDObjectType.SAPObjectType
[1..1] I_MDSubstnCtrl _SubstnCtrl $projection.MDSubstnObjectType = _SubstnCtrl.MDSubstnObjectType and $projection.MDSubstnControl = _SubstnCtrl.MDSubstnControl

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substituion Control used by Accesses view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnObjectType MDSubstnObjectType
KEY MDSubstnControl MDSubstnControl
KEY ObjValDetnAccessUUID ObjValDetnAccessUUID
ObjValDetnCharcCombination
ObjValDetnCharcCombinationDesc
ObjValDetnAccessSequenceValue _Access ObjValDetnAccessSequenceValue
ObjValDetnUsage _Access ObjValDetnUsage
ObjValDetnUsageType _Access ObjValDetnUsageType
ObjValDetnActivationStatus _Access ObjValDetnActivationStatus
ObjValDetnActivationStatusDesc
NumberOfRelatedSubstnControls NumberOfRelatedSubstnControls
_SubstnCtrl _SubstnCtrl
_MDObjectType _MDObjectType
_Access _Access
_Usage _Access _Usage
_UsageType _Access _UsageType
_Status _Access _Status 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Substituion Control used by Accesses'
@ObjectModel: {
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #M
  }
}
@VDM: {
  viewType: #CONSUMPTION
}

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity C_SubstnCtrlAssgmtByAccUUID
  as select from R_SubstnCtrlAssgmtByAccUUID
  association [1..1] to I_ObjValDetnAccess as _Access       on  $projection.ObjValDetnAccessUUID = _Access.ObjValDetnAccessUUID
  association [1..1] to I_SAPObjectType    as _MDObjectType on  $projection.MDSubstnObjectType = _MDObjectType.SAPObjectType
  association [1..1] to I_MDSubstnCtrl     as _SubstnCtrl   on  $projection.MDSubstnObjectType = _SubstnCtrl.MDSubstnObjectType
                                                            and $projection.MDSubstnControl    = _SubstnCtrl.MDSubstnControl
{
      @ObjectModel.foreignKey.association: '_MDObjectType'
      @Semantics.uuid: true
  key MDSubstnObjectType,

      @ObjectModel.foreignKey.association: '_SubstnCtrl'
      @Semantics.uuid: true
  key MDSubstnControl,

      @ObjectModel.foreignKey.association: '_Access'
      @Semantics.uuid: true
  key ObjValDetnAccessUUID,

      _Access._Combination.ObjValDetnCharcCombination,
      _Access._Combination._Text[1: Language=$session.system_language].ObjValDetnCharcCombinationDesc,
      _Access.ObjValDetnAccessSequenceValue,
      _Access.ObjValDetnUsage,
      _Access.ObjValDetnUsageType,
      _Access.ObjValDetnActivationStatus,
      _Access._Status._Text[1: Language=$session.system_language].ObjValDetnActivationStatusDesc,

      NumberOfRelatedSubstnControls,

      /* Associations */
      _SubstnCtrl,
      _MDObjectType,
      _Access,
      _Access._Usage,
      _Access._UsageType,
      _Access._Status
}
where
  MDSubstnControl is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OBJVALDETNACCESS",
"I_OBJVALDETNACTIVATIONSTATUS",
"I_OBJVALDETNACTIVATIONSTSTEXT",
"I_OBJVALDETNCHARCCOMBN",
"I_OBJVALDETNCHARCCOMBNTEXT",
"R_SUBSTNCTRLASSGMTBYACCUUID"
],
"ASSOCIATED":
[
"I_MDSUBSTNCTRL",
"I_OBJVALDETNACCESS",
"I_OBJVALDETNACTIVATIONSTATUS",
"I_OBJVALDETNUSAGE",
"I_OBJVALDETNUSAGETYPE",
"I_SAPOBJECTTYPE"
],
"BASE":
[
"I_OBJVALDETNACCESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More