C_LocSubstnCtrlGrpTP

DDL: C_LOCSUBSTNCTRLGRPTP Type: view_entity CONSUMPTION
15 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Location Substitution Control Group

C_LocSubstnCtrlGrpTP is a Consumption CDS View that provides data about "Location Substitution Control Group" in SAP S/4HANA. It reads from 1 data source (R_LocSubstnCtrlGrpTP) and exposes 15 fields with key fields MDSubstnObjectType, MDSubstnControl, MDSubstnGroup, MDSubstnVersionValue. It is exposed through 1 OData service (UI_LOCSUBSTN_CTRL_MANAGE). It is used in 1 Fiori application: Manage Substitution Controls - Locations.

Data Sources (1)

SourceAliasJoin Type
R_LocSubstnCtrlGrpTP R_LocSubstnCtrlGrpTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
EndUserText.label Location Substitution Control Group view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_LOCSUBSTN_CTRL_MANAGE UI_LOCSUBSTN_CTRL_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5312 Manage Substitution Controls - Locations Transactional Manage Substitution Controls for Locations

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 (15)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnObjectType MDSubstnObjectType
KEY MDSubstnControl MDSubstnControl
KEY MDSubstnGroup MDSubstnGroup
KEY MDSubstnVersionValue MDSubstnVersionValue
MDSubstnGroupDescriptionlocalized
CreatedByUser _Group CreatedByUser User Name
CreationDateTime _Group CreationDateTime Timestamp
LastChangedByUser _Group LastChangedByUser User Name
LastChangeDateTime _Group LastChangeDateTime Timestamp
MDSubstnStatus _ControlGroupCalc MDSubstnStatus
MDSubstnStatusCriticality _ControlGroupCalc MDSubstnStatusCriticality
MDSubstnStatusDescriptionlocalized
_Group _Group
_MDObjectType _MDObjectType
_ControlGroupCalc _ControlGroupCalc

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_LocSubstnCtrlGrpTP.
-- 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_LocSubstnCtrlGrpTP AS
SELECT
  MDSubstnObjectType,
  MDSubstnControl,
  MDSubstnGroup,
  MDSubstnVersionValue,
  _Group._GroupText.MDSubstnGroupDescription : localized AS MDSubstnGroupDescriptionlocalized,
  _Group.CreatedByUser AS CreatedByUser,
  _Group.CreationDateTime AS CreationDateTime,
  _Group.LastChangedByUser AS LastChangedByUser,
  _Group.LastChangeDateTime AS LastChangeDateTime,
  _ControlGroupCalc.MDSubstnStatus AS MDSubstnStatus,
  _ControlGroupCalc.MDSubstnStatusCriticality AS MDSubstnStatusCriticality,
  _Group._Status._Text.MDSubstnStatusDescription : localized AS MDSubstnStatusDescriptionlocalized
FROM R_LocSubstnCtrlGrpTP
;

Learn More