C_CustomCDSViewParameterValue

DDL: C_CUSTOMCDSVIEWPARAMETERVALUE SQL: APS_CCV_C_PVAL_V Type: view

Consumption Custom CDS View Para Value

C_CustomCDSViewParameterValue is a CDS View that provides data about "Consumption Custom CDS View Para Value" in SAP S/4HANA. It reads from 1 data source (I_CustomCDSViewParameterValue) and exposes 19 fields with key fields EntityName, DataSourceUUID, ParameterValueUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustomCDSViewParameterValue I_CustomCDSViewParameterValue from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_CustomCDSViewRoot _Root _Root.EntityName = $projection.EntityName
[1..1] C_CustomCDSViewDataSource _DataSource _DataSource.EntityName = $projection.EntityName and _DataSource.DataSourceUUID = $projection.DataSourceUUID
[0..1] C_CustomCDSViewParameter _ValueParameter _ValueParameter.EntityName = $projection.EntityName and _ValueParameter.ParameterUUID = $projection.ValueParameterUUID
[0..*] C_CustomCDSViewParameter _Parameters _Parameters.EntityName = $projection.EntityName

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName APS_CCV_C_PVAL_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumption Custom CDS View Para Value view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
Metadata.allowExtensions true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY EntityName entity_name Table Name
KEY DataSourceUUID data_source_uuid UUID
KEY ParameterValueUUID param_value_uuid UUID
Counter counter Version
ParameterName param_name Parameter Name
DataSourceName _DataSource DataSourceName
ParameterLabel
ParameterType
ValueType value_type Value Type
Value value Value from table
ValueSessionVariable value_session_var Session Variable
ValueParameterUUID value_param_uuid UUID
ValueParameterName _ValueParameter ParameterName Rule Parameter
_Root _Root
_DataSource _DataSource
_ValueType _ValueType
_Parameters _Parameters
_ValueParameter _ValueParameter
_ValueSessionVariable _ValueSessionVariable

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_CustomCDSViewParameterValue.
-- 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.
-- SQL view name: APS_CCV_C_PVAL_V

CREATE VIEW C_CustomCDSViewParameterValue AS
SELECT
  entity_name AS EntityName,
  data_source_uuid AS DataSourceUUID,
  param_value_uuid AS ParameterValueUUID,
  Counter,
  param_name AS ParameterName,
  _DataSource.DataSourceName AS DataSourceName,
  cast( ' ' as abap.sstring( 255 ) ) AS ParameterLabel,
  cast( ' ' as abap.sstring( 255 ) ) AS ParameterType,
  value_type AS ValueType,
  Value,
  value_session_var AS ValueSessionVariable,
  value_param_uuid AS ValueParameterUUID,
  _ValueParameter.ParameterName AS ValueParameterName
FROM I_CustomCDSViewParameterValue
LEFT OUTER JOIN C_CustomCDSViewRoot AS _Root ON _Root.EntityName = EntityName  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewDataSource AS _DataSource ON _DataSource.EntityName = EntityName AND _DataSource.DataSourceUUID = DataSourceUUID  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewParameter AS _ValueParameter ON _ValueParameter.EntityName = EntityName AND _ValueParameter.ParameterUUID = ValueParameterUUID  -- association [0..1]
LEFT OUTER JOIN C_CustomCDSViewParameter AS _Parameters ON _Parameters.EntityName = EntityName  -- association [0..*]
;