I_BPFModelDetails

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_BPFModelDetails.
-- 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: IBPFMODELD

CREATE VIEW I_BPFModelDetails AS
SELECT
  BPFNodeCategory,
  BPFLayout,
  BPFNodeStatus,
  BPFIsSemanticObject,
  BPFLane,
  BPFStatusFieldName,
  BPFNodeCDSViewName,
  BPFNodeFirstText,
  BPFNodeSecondText,
  _nodeText.text AS BPFNodeAddlFirstText,
  _nodeText1.text AS BPFNodeAddlSecondText,
  BPFSemanticObject,
  BPFNodeDynamicTitle,
  BPFNodeDynamicShortTitle,
  BPFCstmStatusCategoryFieldName,
  BPFCustomStatusTextFieldName,
  BPFHasLabel,
  BPFHasLabelPopover,
  BPFHasNodePopover,
  BPFHasObjectNavigation,
  BPFHasActionNavigation,
  BPFLaneIcon,
  BPFSemObj1stParameterName,
  BPFSemObj2ndParameterName,
  BPFSemObj3rdParameterName,
  BPFSemObj4thParameterName,
  BPFSemObj5thParameterName,
  BPFSemObj6thParameterName,
  BPFStatusCategory,
  _statet.state_text AS BPFStatusText,
  _dyntext.node_title AS BPFNodeTitle,
  _dyntext.node_title_abr AS BPFNodeShortTitle,
  _LaneInfoT.lane_desc AS BPFLaneName
FROM I_BPFModel
LEFT OUTER JOIN bpfi_nodestatet AS _statet ON BPFLayout = _statet.layout_id AND BPFNodeCategory = _statet.node_cat AND BPFStatusFieldName = _statet.status_field AND BPFNodeStatus = _statet.status AND _statet.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN bpfi_laneinfot AS _LaneInfoT ON BPFLayout = _LaneInfoT.layout_id AND BPFLane = _LaneInfoT.lane_id AND _LaneInfoT.spras = $session.system_language  -- association [1..1]
LEFT OUTER JOIN bpfi_node_texts AS _nodeText ON BPFLayout = _nodeText.layout_id AND BPFNodeCategory = _nodeText.node_cat AND _nodeText.spras = $session.system_language AND BPFNodeFirstText = _nodeText.text_field  -- association [1..1]
LEFT OUTER JOIN bpfi_node_texts AS _nodeText1 ON BPFLayout = _nodeText1.layout_id AND BPFNodeCategory = _nodeText1.node_cat AND _nodeText1.spras = $session.system_language AND BPFNodeSecondText = _nodeText1.text_field  -- association [1..1]
LEFT OUTER JOIN bpfi_nodeinfot AS _dyntext ON BPFLayout = _dyntext.layout_id AND BPFNodeCategory = _dyntext.node_cat AND _dyntext.spras = $session.system_language  -- association [1..1]
;