FAC_UH_MIGRTN_P_HIER_ID_lOG

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_UH_MIGRTN_P_HIER_ID_lOG.
-- 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: FACUHMIGPIDCD

CREATE VIEW FAC_UH_MIGRTN_P_HIER_ID_lOG AS
SELECT
  uhm_id_chlog.field AS Field,
  uhm_id_chlog.hier_type AS HierarchyType,
  uhm_id_chlog.hier_id AS HierarchyOldID,
  uhm_id_chlog.sub_class AS SubClass,
  uhm_id_chlog.updated_by AS ChangedBy,
  tstmp_to_dats( uhm_id_chlog.updated_at, $session.user_timezone, $session.client, 'NULL' ) as ChangedOn AS clientNULLasChangedOn,
  tstmp_to_tims( uhm_id_chlog.updated_at, $session.user_timezone, $session.client, 'NULL' ) as ChangedAt AS clientNULLasChangedAt,
  cast( '' as uhmwapp ) AS Application,
  cast( '' as uhmwobject ) AS Object,
  cast( '' as uhmwsubobject ) AS SubObject,
  cast( '' as uhmobjval ) AS ObjectValue,
  cast( '' as uhmsubobjval ) AS SubObjectValue,
  uhm_id_chlog.action AS Action,
  cast( dd04t.ddtext as htypet ) AS FieldText,
  updated_at as ChangedAtDateTime AS fieldasField,
  uhm_wu_chlog.old_value AS oldvalue,
  uhm_wu_chlog.new_value AS newvalue,
  updated_at AS ChangedAtDateTime
FROM uhm_id_chlog
LEFT OUTER JOIN dd04t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAC_UH_MIGRTN_I_MIGRATESTATUST AS _old_status ON uhm_id_chlog.field = 'UHMIGS' AND uhm_id_chlog.old_value = _old_status.HierarchyMigrationStatus AND _old_status.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN FAC_UH_MIGRTN_I_MIGRATESTATUST AS _new_status ON uhm_id_chlog.field = 'UHMIGS' AND uhm_id_chlog.new_value = _new_status.HierarchyMigrationStatus AND _new_status.Language = $session.system_language  -- association [0..1]
-- UNION with additional select branch(es): uhm_wu_chlog
;