/FTI/SI_TOP_SEQ

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 /FTI/SI_TOP_SEQ.
-- 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: /FTI/V_SI_SEQ
-- Parameters: p_mandt : mandt

CREATE VIEW /FTI/SI_TOP_SEQ AS
SELECT
  min(ScopeItems.mandt) AS Client,
  min(ScopeItems.scope) AS Scope,
  min(ScopeItems.prjid) AS ScopeItem,
  min(ScopeItems.seqnum) AS SI_Sequence,
  min(BB.bbid) AS BB,
  min(Activities.objty) AS Type,
  Activities.objid AS Act_ID
FROM /smb/bb_prj_et01 AS ScopeItems
INNER JOIN /smb/bbpr_i AS BB ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/bb_lib_i AS Activities ON /* join condition not captured in parsed metadata */
;