I_CustomCDSViewParameter

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 I_CustomCDSViewParameter.
-- 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_I_PARA_V

CREATE VIEW I_CustomCDSViewParameter AS
SELECT
  aps_ccv_d_param.entity_name AS entity_name,
  aps_ccv_d_param.param_uuid AS param_uuid,
  counter,
  data_element,
  ddic_type,
  length,
  decimals,
  origin_code,
  hidden_ind
FROM aps_ccv_d_param
LEFT OUTER JOIN I_CustomCDSViewRoot AS _Root ON _Root.entity_name = entity_name  -- association [1..1]
LEFT OUTER JOIN I_CustomCDSViewParameterValue AS _ParameterValue ON _ParameterValue.entity_name = entity_name AND _ParameterValue.value_param_uuid = param_uuid  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewDdicType AS _DdicType ON _DdicType.DdicType = ddic_type  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewParDefValType AS _DefaultValueType ON _DefaultValueType.DefaultValueType = default_val_type  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewParDefSystValue AS _DefaultSystemValue ON _DefaultSystemValue.DefaultSystemValue = default_val_system  -- association [0..1]
;