C_SubstnCtrlAssgmtByAccUUID

DDL: C_SUBSTNCTRLASSGMTBYACCUUID Type: view_entity CONSUMPTION Package: ODATA_ATP_OVD_SUBSTN_VAL_MAINT

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. It is exposed through 2 OData services (UI_LOCSUBSTN_CTRL_MANAGE, UI_PRODSUBSTN_CTRL_MANAGE). It is used in 2 Fiori applications: Manage Substitution Controls - Products, Manage Substitution Controls - Locations. Part of development package ODATA_ATP_OVD_SUBSTN_VAL_MAINT.

1 data source(s) Exposed by 2 service(s) Used in 2 Fiori app(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

OData Services (2)

ServiceBindingVersionContractRelease
UI_LOCSUBSTN_CTRL_MANAGE UI_LOCSUBSTN_CTRL_MANAGE V2 C1 NOT_RELEASED
UI_PRODSUBSTN_CTRL_MANAGE UI_PRODSUBSTN_CTRL_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F4787 Manage Substitution Controls - Products Transactional An application to maintain configuration data for product substitution or exclusion where the user can manage substitution controls
F5312 Manage Substitution Controls - Locations Transactional Manage Substitution Controls for Locations

Manage Substitution Controls - Products

Business Role: Master Data Specialist - Product Data

A control is used to consume one or more predefined groups of substitutions. With this app, you can create and manage controls. By assigning substitution groups to controls, consuming applications can manage substitution groups. You can assign only active and inactive groups to a control. A control can be deleted even if groups are assigned to it. You can use this app if the business role Master Data Specialist – Product Data (R0097-13) is assigned to you.

Key Features: You can use this app to: Create, edit, and delete a control. Create multiple language-specific descriptions for a control. Assign and unassign groups to controls.

Manage Substitution Controls - Locations

Business Role: Order Fulfillment Manager

A control is used to consume one or more predefined groups of substitutions. With this app, you can create and manage controls. By assigning substitution groups to controls, consuming applications can manage substitution groups. You can assign only active and inactive groups to a control. A control can be deleted even if groups are assigned to it. You can use this app if the business role Order Fulfilment Manager (R0226) is assigned to you.

Key Features: You can use this app to: Create, edit, and delete a control. Create multiple language-specific descriptions for a control. Assign and unassign groups to controls. Choose whether you want the system to consider the substitutions and exclusions in the default group.

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

Learn More