/CFG/V_FILE_SOL_MIN_SEQ_VIEW

DDL: /CFG/V_FILE_SOL_MIN_SEQ_VIEW SQL: /CFG/V_MINSEQ Type: view
3 Fields 2 Data Sources

Determine the first scope item where BB occurs

/CFG/V_FILE_SOL_MIN_SEQ_VIEW is a CDS View that provides data about "Determine the first scope item where BB occurs" in SAP S/4HANA. It reads from 2 data sources (/smb/bbpr_i, /smb/bb_prj_et01) and exposes 3 fields.

Data Sources (2)

SourceAliasJoin Type
/smb/bbpr_i BuildingBlocks inner
/smb/bb_prj_et01 ScopeItems from

Parameters (1)

NameTypeDefault
P_mandt mandt

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName /CFG/V_MINSEQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MIXED view
EndUserText.label Determine the first scope item where BB occurs view

Fields (3)

KeyFieldSource TableSource FieldDescription
solution_id /smb/bb_prj_et01 scope Visibility
bbid /smb/bbpr_i bbid Building Block
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 /CFG/V_FILE_SOL_MIN_SEQ_VIEW.
-- 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: /CFG/V_MINSEQ
-- Parameters: P_mandt : mandt

CREATE VIEW /CFG/V_FILE_SOL_MIN_SEQ_VIEW AS
SELECT
  ScopeItems.scope AS solution_id,
  BuildingBlocks.bbid AS bbid,
  min(ScopeItems.seqnum) AS seq
FROM /smb/bb_prj_et01 AS ScopeItems
INNER JOIN /smb/bbpr_i AS BuildingBlocks ON /* join condition not captured in parsed metadata */
;

Learn More