fac_cds_uh_category

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_category.
-- 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_CATG

CREATE VIEW fac_cds_uh_category AS
SELECT
  catg.catg_key AS CategoryKey,
  bety_name AS BusinessEntityName,
  allow_mix AS AllowMix,
  mixed_entities AS MixedEntities,
  node_entities AS NodeMixedEntities,
  allow_node_text AS AllowNodeFreeText,
  allow_ver_overlap AS AllowVerOverlap,
  allow_dup_leaf AS AllowDupLeaf,
  allow_dup_nonleaf AS AllowDupNonleaf,
  time_dependent_type AS TimeDependantType,
  time_overlap_type AS TimeOverlapType,
  catgt.catg_text AS CategoryText,
  catgt.app_title AS ApplicationTitle,
  'X' AS ClassValueInherite,
  use_value_range AS UseValueRange,
  catg.hrrp_hrytype AS HryType,
  catg.hrrp_hrynmspace AS HryNamespace,
  allow_legacy_tcode_usage AS AllowUseByLegacyTCode,
  catg.allow_leaf_semtag AS AllowSemTagLeaf,
  catg.allow_node_semtag AS AllowSemTagNode,
  count( distinct _reuse_src.SourceName ) AS ReuseSourceCount,
  catg.legacy_usage_by_default AS LegacyUsageByDefault,
  catg.allow_legacy_usage_change AS AllowLegacyUsageChange,
  catg.transport AS Transport,
  catg.allow_change_log AS AllowChangeLog,
  catg.allow_multi_lang AS AllowMultipleLanguage,
  case catg.hry_id_max_length when 0 then 20 else catg.hry_id_max_length end as HryIdMaxLength AS hry_id_max_lengthendasHryIdMaxLength,
  catg.allow_private_hierarchy AS AllowPrivateHierarchy,
  catg.simulation_disabled AS SimulationDisabled,
  catg.allow_flex_hier AS AllowFlexibleHierarchy,
  catg.allow_md_download AS AllowDownloadMasterData,
  catg.allow_md_upload AS AllowUploadMasterData
FROM uhdt_catg AS catg
LEFT OUTER JOIN uhdt_catgt AS catgt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FAC_CDS_UH_REUSE_SRC AS _reuse_src ON CategoryKey = _reuse_src.CategoryKey  -- association [0..*]
LEFT OUTER JOIN FAC_CDS_UH_NODE_ATTR_DEF AS to_attributes ON CategoryKey = to_attributes.CategoryKey  -- association [0..*]
LEFT OUTER JOIN FAC_CDS_UH_HD_ATTR_DEF AS to_hd_attributes ON CategoryKey = to_hd_attributes.CategoryKey  -- association [0..*]
;