I_Scbo_Node_Logic

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 I_Scbo_Node_Logic.
-- 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: I_SCBO_ND_LGC_V

CREATE VIEW I_Scbo_Node_Logic AS
SELECT
  Logic.business_object_id AS BusinessObjectID,
  Logic.node_id AS NodeID,
  Logic.version_number AS VersionNumber,
  Logic.evaluation_type AS EvaluationType,
  Logic.evaluation_time_point AS EvaluationTime,
  Logic.class_name_key_user AS PublishedClass,
  DraftMapping.draft_class_name AS DraftClass,
  DraftMapping.published_class_etag AS PublishedClassEtag,
  DraftMapping.test_enabled AS DraftTestEnabled,
  Eval_Type_Text.description AS EvaluationTypeDescription,
  Eval_Time_Point_Text.description AS EvaluationTimeDescription,
  Business_Object.LastGenerateTimestamp AS BusinessObjectTimestamp
FROM scbo_bl_eval AS Logic
LEFT OUTER JOIN scbo_bl_mapping AS DraftMapping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Scbo AS Business_Object ON Business_Object.BusinessObjectID = Logic.business_object_id AND Business_Object.VersionNumber = Logic.version_number association[0..1] to I_Scbo_Bl_Eval_Type_Text as Eval_Type_Text on Eval_Type_Text.code = Logic.evaluation_type AND Eval_Type_Text.language = $session.system_language association[0..1] to I_Scbo_Bl_Eval_Time_Point_Text as Eval_Time_Point_Text on Eval_Time_Point_Text.code = Logic.evaluation_time_point AND Eval_Time_Point_Text.language = $session.system_language  -- association [1..1]
;