FAC_CDS_UH_STSTCLKEYFIG

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_CDS_UH_STSTCLKEYFIG.
-- 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: FACV_UH_STKFHIER

CREATE VIEW FAC_CDS_UH_STSTCLKEYFIG AS
SELECT
  version.ver_id AS VersionId,
  version.ver_vldfm AS ValidityStartDate,
  version.ver_vldto AS ValidityEndDate,
  version.ver_msg AS VersionMessage,
  case when ( ver_status = 'R' or ver_status = 'A' ) and locked_by = $session.user then cast ('I' as vrsst ) else version.ver_status end as VersionStatus AS ver_statusendasVersionStatus,
  cast( '' as vrstxt) AS VersionStatusText,
  version.hier_catg AS HierarchyCategory,
  cast( version.hier_hid as vhrid) AS HierarchyId,
  hier.hier_desc AS HierarchyText,
  cast( version.hier_hid as vhdec) AS HierarchyVersionText,
  case clfdvalue.val_sign when 'S' then cast( clfdvalue.val_low as cctrl) when 'R' then cast( concat(clfdvalue.val_low,concat('~',clfdvalue.val_high)) as cctrl) else cast( clfdvalue.val_low as cctrl) end as ControllingArea AS val_lowascctrlendasControllingArea,
  case when hier.hier_desc is null then '' else cast( upper(hier.hier_desc) as vhdec ) end as HierarchyTextUpper AS hier_descasvhdecendasHierarchyTextUpper,
  to_category
FROM uhdt_vrsn AS version
LEFT OUTER JOIN uhdt_hier AS hier ON /* join condition not captured in parsed metadata */
INNER JOIN uhdt_clfd_val AS clfdvalue ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fac_cds_uh_category AS to_category ON HierarchyCategory = to_category.CategoryKey  -- association [1..1]
;