C_SubstnCtrlAssgmtByAccUUID

DDL: C_SUBSTNCTRLASSGMTBYACCUUID Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 3 Associations 2 OData Services 2 Fiori Apps

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.

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 Access UUID
ObjValDetnCharcCombination
ObjValDetnCharcCombinationDesc
ObjValDetnAccessSequenceValue _Access ObjValDetnAccessSequenceValue
ObjValDetnUsage _Access ObjValDetnUsage Usage
ObjValDetnUsageType _Access ObjValDetnUsageType
ObjValDetnActivationStatus _Access ObjValDetnActivationStatus Status
ObjValDetnActivationStatusDesc
NumberOfRelatedSubstnControls NumberOfRelatedSubstnControls
_SubstnCtrl _SubstnCtrl
_MDObjectType _MDObjectType
_Access _Access
_Usage _Access _Usage
_UsageType _Access _UsageType
_Status _Access _Status

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SubstnCtrlAssgmtByAccUUID.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_SubstnCtrlAssgmtByAccUUID AS
SELECT
  MDSubstnObjectType,
  MDSubstnControl,
  ObjValDetnAccessUUID,
  _Access._Combination.ObjValDetnCharcCombination AS ObjValDetnCharcCombination,
  _Access._Combination._Text[1: Language=$session.system_language].ObjValDetnCharcCombinationDesc AS ObjValDetnCharcCombinationDesc,
  _Access.ObjValDetnAccessSequenceValue AS ObjValDetnAccessSequenceValue,
  _Access.ObjValDetnUsage AS ObjValDetnUsage,
  _Access.ObjValDetnUsageType AS ObjValDetnUsageType,
  _Access.ObjValDetnActivationStatus AS ObjValDetnActivationStatus,
  _Access._Status._Text[1: Language=$session.system_language].ObjValDetnActivationStatusDesc AS ObjValDetnActivationStatusDesc,
  NumberOfRelatedSubstnControls,
  _Access._Usage AS _Usage,
  _Access._UsageType AS _UsageType,
  _Access._Status AS _Status
FROM R_SubstnCtrlAssgmtByAccUUID
LEFT OUTER JOIN I_ObjValDetnAccess AS _Access ON ObjValDetnAccessUUID = _Access.ObjValDetnAccessUUID  -- association [1..1]
LEFT OUTER JOIN I_SAPObjectType AS _MDObjectType ON MDSubstnObjectType = _MDObjectType.SAPObjectType  -- association [1..1]
LEFT OUTER JOIN I_MDSubstnCtrl AS _SubstnCtrl ON MDSubstnObjectType = _SubstnCtrl.MDSubstnObjectType AND MDSubstnControl = _SubstnCtrl.MDSubstnControl  -- association [1..1]
;

Learn More