FAC_CDS_VE_RESULT_ITEM

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_RESULT_ITEM.
-- 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_VE_GPSN

CREATE VIEW FAC_CDS_VE_RESULT_ITEM AS
SELECT
  grpsnapshot.drruuid AS drruuid,
  grpsnapshot.node_id AS node_id,
  grpsnapshot.node_lval AS node_lval,
  _to_header.hier_hid AS hier_hid,
  grpsnapshot.parent_id AS parent_id,
  grpsnapshot.node_type AS node_type,
  grpsnapshot.node_lev AS node_lev,
  grpsnapshot.node_pos AS node_pos,
  grpsnapshot.node_entity AS node_entity,
  grpsnapshot.scen_id AS scen_id,
  grpsnapshot.state AS state,
  grpsnapshot.rule_id AS rule_id,
  grpsnapshot.currency_o AS currency_o,
  grpsnapshot.currency_t AS currency_t,
  grpsnapshot.group_by_val AS group_by_val,
  grpsnapshot.logic_result AS logic_result,
  grpsnapshot.rule_result AS rule_result,
  grpsnapshot.rule_excep AS rule_excep,
  grpsnapshot.mul_excep AS mul_excep,
  grpsnapshot.tolerance AS tolerance,
  grpsnapshot.power AS power,
  grpsnapshot.cmt_count AS cmt_count,
  grpsnapshot.cmt_required AS cmt_required,
  grpsnapshot.tol_is_and AS tol_is_and,
  grpsnapshot.lognumber AS lognumber,
  grpsnapshot.operator AS operator
FROM vec_grp_snapshot AS grpsnapshot
LEFT OUTER JOIN vec_node_txt AS ntxt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vec_node_txt AS ntxt_e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fac_cds_ve_results_header AS _to_header ON drruuid = _to_header.Drruuid  -- association [1..1]
LEFT OUTER JOIN FAC_CDS_VE_COMMENT AS _to_comment ON _to_comment.drruuid = drruuid AND _to_comment.node_id = node_id  -- association [0..*]
-- UNION ALL with additional select branch(es): vec_grp_snapshot
;