FCLM_BAH_ACCOUNTNODE_VH

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 FCLM_BAH_ACCOUNTNODE_VH.
-- 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: VFCLMBAHND

CREATE VIEW FCLM_BAH_ACCOUNTNODE_VH AS
SELECT
  cast( concat( concat(node.hierid,'/'),node.nodeid) as nodid ) AS nodekey,
  node.hierid AS hierid,
  node.nodeid AS nodeid,
  node.valid_to AS valid_to,
  node.valid_from AS valid_from,
  node.nodetype AS nodetype,
  node.par_hiernode AS par_hiernode,
  text.nodename AS nodename,
  hierarchytext.hiername AS hiername,
  hierarchy.hiertype AS hiertype,
  hierarchy.public_hier AS public_hier
FROM fclm_bam_hierdt AS node
LEFT OUTER JOIN fclm_bam_hierdtt AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fclm_bam_hiert AS hierarchytext ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fclm_bam_hier AS hierarchy ON /* join condition not captured in parsed metadata */
;