C_CCV_EIT_Parameter

DDL: C_CCV_EIT_PARAMETER SQL: APS_CCVEIT_P Type: view Package: SAPS_CCV_EIT

Consumption View Export/Import - Param

C_CCV_EIT_Parameter is a CDS View that provides data about "Consumption View Export/Import - Param" in SAP S/4HANA. It reads from 1 data source (I_CustomCDSViewParameter) and exposes 19 fields with key fields EntityName, ParameterName. It has 2 associations to related views. Part of development package SAPS_CCV_EIT.

Data Sources (1)

SourceAliasJoin Type
I_CustomCDSViewParameter I_CustomCDSViewParameter from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_CCV_EIT_Root _Root _Root.EntityName = $projection.EntityName
[0..1] I_CustomCDSViewDataSource _DataSourceHelper _DataSourceHelper.entity_name = $projection.EntityName and _DataSourceHelper.data_source_uuid = $projection.source_data_source_uuid

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName APS_CCVEIT_P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumption View Export/Import - Param view
Metadata.allowExtensions true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY EntityName entity_name Table Name
KEY ParameterName parameter_name Support Parameter
Counter counter Version
ParameterLabel parameter_label Parameter Label
DataElement data_element Field type
DdicType ddic_type Data Type
Length length Text Length
Decimals decimals Rounding Places
OriginCode origin_code Origin
SourceDataSourceAlias _DataSourceHelper data_source_alias Data Source Alias
SourceParameterName source_parameter_name DD: Name of a Parameter
HiddenIndicator hidden_ind Hidden
DefaultValueType default_val_type Default Type
DefaultManualValue default_val_manual Default Value
DefaultSystemValue default_val_system Default Value
SemanticsAnnotation semantics_annotation DD: Key/Name for Annotation
SemanticsValue semantics_value DD: Value of an Annotation
param_uuid param_uuid UUID
_Root _Root

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_CCV_EIT_Parameter.
-- 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_CCVEIT_P

CREATE VIEW C_CCV_EIT_Parameter AS
SELECT
  entity_name AS EntityName,
  parameter_name AS ParameterName,
  Counter,
  parameter_label AS ParameterLabel,
  data_element AS DataElement,
  ddic_type AS DdicType,
  Length,
  Decimals,
  origin_code AS OriginCode,
  _DataSourceHelper.data_source_alias AS SourceDataSourceAlias,
  source_parameter_name AS SourceParameterName,
  hidden_ind AS HiddenIndicator,
  default_val_type AS DefaultValueType,
  default_val_manual AS DefaultManualValue,
  default_val_system AS DefaultSystemValue,
  semantics_annotation AS SemanticsAnnotation,
  semantics_value AS SemanticsValue,
  param_uuid
FROM I_CustomCDSViewParameter
LEFT OUTER JOIN C_CCV_EIT_Root AS _Root ON _Root.EntityName = EntityName  -- association [1..1]
LEFT OUTER JOIN I_CustomCDSViewDataSource AS _DataSourceHelper ON _DataSourceHelper.entity_name = EntityName AND _DataSourceHelper.data_source_uuid = source_data_source_uuid  -- association [0..1]
;