FAC_VE_SRC_Par

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 FAC_VE_SRC_Par.
-- 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: FACVESRPA

CREATE VIEW FAC_VE_SRC_Par AS
SELECT
  src.data_source AS DataSource,
  para.param_name AS ParameterName,
  _SrcText.descr AS DataSourceText,
  src.cds_ddl_name AS CDSDDLName,
  src.usel_cls_id AS SelectionClassID,
  _ParText.param_text AS ParameterNameText,
  para.cds_view_field AS CDSViewFieldName,
  para.result_hdr_fld AS ResultTableHeaderColumnName,
  para.is_view_parameter AS IsCDSViewParameter,
  para.cds_parameter AS CDSParameter,
  para.default_val_fld AS DefaultContextValue,
  para.is_mandatory_parameter AS IsMandatoryParameter,
  para.value_sign AS ParameterValueInputType,
  para.shlp_name AS SearchHelpName,
  para.shlp_exp AS SearchHelpField,
  para.shlp_txtexp AS SearchHelpTextField
FROM fac_ve_datasrc AS src
INNER JOIN fac_ve_con_para AS para ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fac_ve_datasrct AS _SrcText ON _SrcText.data_source = DataSource AND _SrcText.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN fac_ve_con_parat AS _ParText ON _ParText.data_source = para.data_source AND _ParText.param_name = para.param_name AND _ParText.lang = $session.system_language  -- association [0..1]
;