FAC_UH_MIGRTN_I_HIERARCHY_ID

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_I_HIERARCHY_ID.
-- 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.

CREATE VIEW FAC_UH_MIGRTN_I_HIERARCHY_ID AS
SELECT
  hier_type AS HierarchyType,
  hier_old_id AS HierarchyOldID,
  sub_class AS SubClass,
  hier_new_id AS HierarchyNewID,
  hier_mig_status AS HierarchyMigrationStatus,
  _MigrationStatusText.HierarchyMigrationStatusName AS HierarchyMigrationStatusName,
  cast( '' as editindicator ) AS EditableInSrcApp,
  updated_by AS LastUpdatedBy,
  updated_at AS LastUpdatedAt,
  cast( '' as btcjobcnt) AS JobID,
  cast( '' as btcjob) AS JobName,
  cast( '' as abap.char(50)) AS LogID,
  cast( '' as abap.char(20) ) AS JobFailFlag,
  _HierarchyType.HierarchyTypeName AS HierarchyTypeName,
  _HierarchyType.IsCompleted AS HierarchyTypeIsCompleted,
  cast( '' as htypee) AS HierarchyTypeEditable,
  cast( '' as uhmalnid) AS HierarchyTypeAllowNewID,
  cast( '' as uhmalprtlmig) AS HierTypeAllowPartialMigration,
  cast( '' as subcatgt) AS SubClassText,
  tstmp_to_dats( updated_at, $session.user_timezone, $session.client, 'NULL' ) as LastUpdatedOnDate AS clientNULLasLastUpdatedOnDate,
  cast(tstmp_to_tims( updated_at, $session.user_timezone, $session.client, 'NULL' ) as abap.char(10)) as LastUpdatedAtTime AS char10asLastUpdatedAtTime,
  cast( '' as hidtxt) AS HierarchyIDText,
  cast( '' as hidtxt) AS HierarchyNewText,
  hier_old_status AS HierarchyOldStatus,
  cast( '' as abap.char(20)) AS HierarchyOldStatusName,
  cast( '' as htype ) AS HierarchyTypeSearch,
  cast( '' as uholdhid ) AS HierarchyOldIDSearch,
  cast( '' as abap.char(1333)) AS NavigationJson,
  cast( '' as abap.char(1333)) AS Reference,
  cast( '' as uhmignodtype ) AS NodeType,
  cast( '' as abap.char(20) ) AS NodeTypeText,
  cast( '' as uhmigdpndcy ) AS HierarchyDependency
FROM uhm_hier_id_ov
LEFT OUTER JOIN FAC_UH_MIGRTN_I_MIGRATESTATUST AS _MigrationStatusText ON HierarchyMigrationStatus = _MigrationStatusText.HierarchyMigrationStatus  -- association [0..1]
LEFT OUTER JOIN FAC_UH_MIGRTN_I_HIER_ID_LOG AS _changelog ON HierarchyType = _changelog.HierarchyType AND HierarchyOldID = _changelog.HierarchyOldID AND SubClass = _changelog.SubClass  -- association [0..*]
LEFT OUTER JOIN FAC_UH_MIGRTN_I_HIER_WHEREUSED AS _whereused ON HierarchyType = _whereused.HierarchyType AND HierarchyOldID = _whereused.HierarchyOldID AND SubClass = _whereused.SubClass  -- association [0..*]
;