FAC_CDS_VE_VALIDATION_GROUP

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_VE_VALIDATION_GROUP.
-- 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: FACVEGROUP

CREATE VIEW FAC_CDS_VE_VALIDATION_GROUP AS
SELECT
  Version.VersionId AS VersionId,
  Version.HierarchyCategory AS HierarchyCategory,
  node.node_lval AS ValidationGroupID,
  Version.HierarchyText AS ValidationGroupDescription,
  CLASSFIED.LowValue AS ValidationScenarioID,
  Version.VersionStatus AS ValidationGroupStatus,
  _StatusText.ValidationGroupStatusText AS ValidationGroupStatusText,
  to_merged_attrvals.AttributeValues AS ComparisonVersionJson,
  scenario.EnableAssignment AS EnableAssignment,
  Version.CreatedAt AS CreatedAt,
  usnam_user.UserDescription AS CreatedByFullName,
  Version.CreatedBy AS CreatedBy,
  Version.UpdatedAt AS ChangedAt,
  Version.UpdatedBy AS ChangedBy,
  ppnam_user.UserDescription AS ChangedByFullName,
  Version.LockedAt AS LockedAt,
  Version.LockedBy AS LockedBy,
  _ScenarioText.descr AS ScenarioText,
  _RuleCount.RuleCount AS RuleCount,
  Version.HierarchyId AS HierarchyId,
  to_node,
  to_changelog,
  to_category,
  to_CreatedByContactCard,
  to_ChangedByContactCard
FROM fac_cds_uh_version AS Version
INNER JOIN fac_cds_uh_clfd_value AS CLASSFIED ON /* join condition not captured in parsed metadata */
INNER JOIN uhdt_node AS node ON /* join condition not captured in parsed metadata */
INNER JOIN FAC_CDS_VE_VALIDATION_SCENARIO AS scenario ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fac_ve_scenariot AS _ScenarioText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_hier AS text_e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAC_VE_GRP_STATUST AS _StatusText ON _StatusText.ValidationGroupStatus = ValidationGroupStatus  -- association [0..1]
LEFT OUTER JOIN fac_cds_ve_group_node AS to_node ON VersionId = to_node.VersionId  -- association [1..*]
LEFT OUTER JOIN fac_cds_uh_category AS to_category ON HierarchyCategory = to_category.CategoryKey  -- association [1..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_CD AS to_changelog ON VersionId = to_changelog.VersionId AND to_changelog.Langauge = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS to_CreatedByContactCard ON CreatedBy = to_CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS to_ChangedByContactCard ON ChangedBy = to_ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN FAC_VE_GRP_RULE_COUNT AS _RuleCount ON VersionId = _RuleCount.VersionId  -- association [0..1]
LEFT OUTER JOIN fac_cds_uh_futb_hd_multiattr AS to_merged_attrvals ON VersionId = to_merged_attrvals.Ver_Id  -- association [1..1]
-- UNION ALL with additional select branch(es): fac_cds_uh_version
;