fac_cds_uh_version

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_version.
-- 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_VRSN

CREATE VIEW fac_cds_uh_version AS
SELECT
  v.ver_id AS VersionId,
  ver_pid AS VersionParentId,
  ver_vldfm AS ValidityStartDate,
  ver_vldto AS ValidityEndDate,
  ver_msg AS VersionMessage,
  ver_nbr AS VersionNumber,
  ver_idx AS VersionIndex,
  v.hier_hid AS HierarchyId,
  v.hier_catg AS HierarchyCategory,
  v.updated_at AS UpdatedAt,
  v.updated_by AS UpdatedBy,
  v.created_at AS CreatedAt,
  v.created_by AS CreatedBy,
  v.node_timedep AS HierarchyNodeIsTimeDependent,
  h.hier_desc AS HierarchyText,
  tstmp_to_dats( v.created_at, abap_user_timezone( $session.user,$session.client,'NULL' ), $session.client, 'NULL' ) as CreatedOn AS clientNULLasCreatedOn,
  locked_by AS LockedBy,
  locked_at AS LockedAt,
  allow_legacy_tcode_usage AS AllowLegacyTCodeUsage,
  case when locked_by <> '' and locked_by <> $session.user then concat(v.ver_id, 'T') else v.ver_id end as calVersionId AS ver_idendascalVersionId,
  to_category.CategoryText AS CategoryText,
  to_merged_attrvals.AttributeValues AS AttributeValues,
  MAINTENANCE_LANG,
  to_node,
  to_category,
  to_changelog,
  concat(concat(',',to_vrsntag.hier_tags),',') AS HierarchyTags,
  to_vrsntag.hier_tagst AS HierarchyTagsText,
  to_vrsntag,
  hid.isprivate AS IsPrivate,
  '' AS ViaJob,
  actjob.jobname AS ActJobName,
  actjob.jobcount AS ActJobCount,
  actjob.status AS ActJobStatus,
  actjob.action AS ActJobAction,
  downloadjob.jobname AS DownloadJobName,
  downloadjob.jobcount AS DownloadJobCount,
  downloadjob.status AS DownloadJobStatus,
  downloadjob.action AS DownloadJobAction
FROM uhdt_vrsn AS v
LEFT OUTER JOIN uhdt_hier AS h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_hid AS hid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_job_log AS actjob ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_job_log AS downloadjob 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]
LEFT OUTER JOIN fac_cds_uh_node AS to_node ON calVersionId = to_node.VersionId  -- association [1..*]
LEFT OUTER JOIN fac_cds_uh_clfd_value AS to_clfd_value ON VersionId = to_clfd_value.ObjectId  -- association [1..*]
LEFT OUTER JOIN fac_cds_uh_futb_hd_multiattr AS to_merged_attrvals ON VersionId = to_merged_attrvals.Ver_Id  -- association [1..1]
LEFT OUTER JOIN FAC_CDS_UH_CD AS to_changelog ON VersionId = to_changelog.VersionId  -- association [0..*]
LEFT OUTER JOIN FAC_CDS_FUNCTBL_VRSN_MULTITAG AS to_vrsntag ON VersionId = to_vrsntag.ver_id  -- association [1..1]
;