I_BPFModel

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_BPFModel.
-- 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: IBPFMODEL

CREATE VIEW I_BPFModel AS
SELECT
  _info.node_cat AS BPFNodeCategory,
  _info.layout_id AS BPFLayout,
  _state.status AS BPFNodeStatus,
  _parameters.semantic_object_flag AS BPFIsSemanticObject,
  _info.lane_id AS BPFLane,
  _info.status_field AS BPFStatusFieldName,
  _info.node_cdsview AS BPFNodeCDSViewName,
  _info.node_text1_field AS BPFNodeFirstText,
  _info.node_text2_field AS BPFNodeSecondText,
  _info.semantic_object AS BPFSemanticObject,
  _info.dynamic_node_title_field AS BPFNodeDynamicTitle,
  _info.dynamic_node_title_abr_field AS BPFNodeDynamicShortTitle,
  _info.custom_state AS BPFCstmStatusCategoryFieldName,
  _info.custom_state_text AS BPFCustomStatusTextFieldName,
  _layout.label_switch AS BPFHasLabel,
  _layout.label_popover_switch AS BPFHasLabelPopover,
  _layout.node_popover_swtich AS BPFHasNodePopover,
  _layout.main_navgn_switch AS BPFHasObjectNavigation,
  _layout.navgn_switch AS BPFHasActionNavigation,
  _laneinfo.lane_icon AS BPFLaneIcon,
  _parameters.param_field1 AS BPFSemObj1stParameterName,
  _parameters.param_field2 AS BPFSemObj2ndParameterName,
  _parameters.param_field3 AS BPFSemObj3rdParameterName,
  _parameters.param_field4 AS BPFSemObj4thParameterName,
  _parameters.param_field5 AS BPFSemObj5thParameterName,
  _parameters.param_field6 AS BPFSemObj6thParameterName,
  _state.state AS BPFStatusCategory
FROM bpfi_nodeinfo AS _info
LEFT OUTER JOIN bpfi_layout AS _layout ON _info.layout_id = _layout.layout_id  -- association [1..1]
LEFT OUTER JOIN bpfi_laneinfo AS _laneinfo ON _info.lane_id = _laneinfo.lane_id AND _info.layout_id = _laneinfo.layout_id  -- association [1..1]
LEFT OUTER JOIN bpfi_parameters AS _parameters ON _info.layout_id = _parameters.layout_id AND _info.node_cat = _parameters.node_cat  -- association [1..*]
LEFT OUTER JOIN bpfi_nodestate AS _state ON _state.layout_id = _info.layout_id AND _state.node_cat = _info.node_cat AND _state.status_field = _info.status_field  -- association [1..*]
;