C_ObjValDetnProdSubstnAccessTP

DDL: C_OBJVALDETNPRODSUBSTNACCESSTP Type: view_entity CONSUMPTION
26 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Access for Product Substitution

C_ObjValDetnProdSubstnAccessTP is a Consumption CDS View that provides data about "Access for Product Substitution" in SAP S/4HANA. It reads from 1 data source (R_ObjValDetnAccessTP) and exposes 26 fields with key field ObjValDetnAccessUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_OVD_SUBSTN_CVC_MNG). It is used in 1 Fiori application: Manage Access Sequences - Substitutions.

Data Sources (1)

SourceAliasJoin Type
R_ObjValDetnAccessTP R_ObjValDetnAccessTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ObjValDetnCharacteristic _Characteristic $projection.ObjValDetnCharcCombinationUUID = _Characteristic.ObjValDetnCharcCombinationUUID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Access for Product Substitution view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
UI.headerInfo.typeName Access view
UI.headerInfo.typeNamePlural Accesses view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value ObjValDetnCharcCombinationDesc view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value ObjValDetnCharcCombination view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OVD_SUBSTN_CVC_MNG UI_OVD_SUBSTN_CVC_MNG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5302 Manage Access Sequences - Substitutions Transactional Manage Access Sequences - Substitutions

Manage Access Sequences - Substitutions

Business Role: Order Fulfillment Manager

Create a combination of characteristics. To create a characteristic combination, you can use the Manage Characteristic Combinations app. If necessary, reorder the characteristics in the combination. Create an access for the characteristic combination created above. To create an access, you can use the Manage Access Sequences - Substitutions app. If necessary, reorder the accesses in a sequence. You can maintain characteristic value combinations for each access, and if necessary specify a control for each characteristic value combination.

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ObjValDetnAccessUUID ObjValDetnAccessUUID Access UUID
ObjValDetnCharcCombinationUUID ObjValDetnCharcCombinationUUID Combination UUID
ObjValDetnCharcCombination _Combination ObjValDetnCharcCombination Combination
ObjValDetnCharcCombinationDesclocalized
ObjValDetnUsage ObjValDetnUsage Usage
ObjValDetnUsageType ObjValDetnUsageType
ObjValDetnUsageTypeDescriptionlocalized
ObjValDetnAccessSequenceValue ObjValDetnAccessSequenceValue
ObjValDetnActivationStatus ObjValDetnActivationStatus Status
ObjValDetnActivationStatusDesclocalized
ProdAllocCharcCatalogType _Combination ProdAllocCharcCatalogType Catalog Type
ProdAllocCharcCatalogTypeDesclocalized
CreatedByUser CreatedByUser User Name
CreatedByUserFullName _CreatedByUser FullName Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserFullName _LastChangedByUser FullName Name
LastChangeDateTime LastChangeDateTime Timestamp
ObjValDetnAccLastChgDateTime ObjValDetnAccLastChgDateTime
_Combination _Combination
_Usage _Usage
_UsageType _UsageType
_Status _Status
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Characteristic _Characteristic

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_ObjValDetnProdSubstnAccessTP.
-- 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_ObjValDetnProdSubstnAccessTP AS
SELECT
  ObjValDetnAccessUUID,
  ObjValDetnCharcCombinationUUID,
  _Combination.ObjValDetnCharcCombination AS ObjValDetnCharcCombination,
  _Combination._Text.ObjValDetnCharcCombinationDesc : localized AS ObjValDetnCharcCombinationDesclocalized,
  ObjValDetnUsage,
  ObjValDetnUsageType,
  _UsageType._Text.ObjValDetnUsageTypeDescription : localized AS ObjValDetnUsageTypeDescriptionlocalized,
  ObjValDetnAccessSequenceValue,
  ObjValDetnActivationStatus,
  _Status._Text.ObjValDetnActivationStatusDesc : localized AS ObjValDetnActivationStatusDesclocalized,
  _Combination.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  _Combination._ProdAllocCharcCatalogType._Text.ProdAllocCharcCatalogTypeDesc : localized AS ProdAllocCharcCatalogTypeDesclocalized,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserFullName,
  CreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserFullName,
  LastChangeDateTime,
  ObjValDetnAccLastChgDateTime
FROM R_ObjValDetnAccessTP
LEFT OUTER JOIN C_ObjValDetnCharacteristic AS _Characteristic ON ObjValDetnCharcCombinationUUID = _Characteristic.ObjValDetnCharcCombinationUUID  -- association [0..*]
;

Learn More