C_ProdSubstnCtrlTP

DDL: C_PRODSUBSTNCTRLTP Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 2 Associations

Product Substitution Control

C_ProdSubstnCtrlTP is a Consumption CDS View that provides data about "Product Substitution Control" in SAP S/4HANA. It reads from 1 data source (R_ProdSubstnCtrlTP) and exposes 17 fields with key fields MDSubstnObjectType, MDSubstnControl. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_ProdSubstnCtrlTP R_ProdSubstnCtrlTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_ProdSubstnCtrlUnassgdGrp _UnassgdGrp $projection.MDSubstnObjectType = _UnassgdGrp.MDSubstnObjectType and $projection.MDSubstnControl = _UnassgdGrp.MDSubstnControl
[0..*] C_SubstnCtrlAssgmtByAccUUID _AccessComb $projection.MDSubstnObjectType = _AccessComb.MDSubstnObjectType and $projection.MDSubstnControl = _AccessComb.MDSubstnControl

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
EndUserText.label Product Substitution Control view
ObjectModel.representativeKey MDSubstnControl view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MDSubstnObjectType MDSubstnObjectType
KEY MDSubstnControl MDSubstnControl
MDSubstnHasDefaultGroup MDSubstnHasDefaultGroup
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
MDSubstnNmbrOfAssignedGroups MDSubstnNmbrOfAssignedGroups
MDSubstnNmbrOfAssignedAccess MDSubstnNmbrOfAssignedAccess
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_MDObjectType _MDObjectType
MDSubstnControlDescriptionlocalized
CreatedByUserFullName _CreatedByUser FullName Name
LastChangedByUserFullName _LastChangedByUser FullName Name
_UnassgdGrp _UnassgdGrp
_AccessComb _AccessComb

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_ProdSubstnCtrlTP.
-- 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_ProdSubstnCtrlTP AS
SELECT
  MDSubstnObjectType,
  MDSubstnControl,
  MDSubstnHasDefaultGroup,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  MDSubstnNmbrOfAssignedGroups,
  MDSubstnNmbrOfAssignedAccess,
  _Text.MDSubstnControlDescription : localized AS MDSubstnControlDescriptionlocalized,
  _CreatedByUser.FullName AS CreatedByUserFullName,
  _LastChangedByUser.FullName AS LastChangedByUserFullName
FROM R_ProdSubstnCtrlTP
LEFT OUTER JOIN C_ProdSubstnCtrlUnassgdGrp AS _UnassgdGrp ON MDSubstnObjectType = _UnassgdGrp.MDSubstnObjectType AND MDSubstnControl = _UnassgdGrp.MDSubstnControl  -- association [0..*]
LEFT OUTER JOIN C_SubstnCtrlAssgmtByAccUUID AS _AccessComb ON MDSubstnObjectType = _AccessComb.MDSubstnObjectType AND MDSubstnControl = _AccessComb.MDSubstnControl  -- association [0..*]
;

Learn More