/CFG/DDL_EMPTY_FILE_SCOPE

DDL: /CFG/DDL_EMPTY_FILE_SCOPE SQL: /CFG/EMP_FILE Type: view Package: /CFG/FTI_WEBGUI

Get all activities with empty file

/CFG/DDL_EMPTY_FILE_SCOPE is a CDS View that provides data about "Get all activities with empty file" in SAP S/4HANA. It reads from 3 data sources (/smb/bb_img_sobj, /fti/scope_ident, /cfg/webgui_i) and exposes 6 fields. Part of development package /CFG/FTI_WEBGUI.

Data Sources (3)

SourceAliasJoin Type
/smb/bb_img_sobj IMGObject inner
/fti/scope_ident scope inner
/cfg/webgui_i WebUisI inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName /CFG/EMP_FILE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MIXED view
EndUserText.label Get all activities with empty file view

Fields (6)

KeyFieldSource TableSource FieldDescription
act_id WebUisH activity_id IMG Activity
cust_obj WebUisH cust_obj_name Customizing object
subobjid /cfg/webgui_i subobjname Table/View Name
filename /fti/scope_ident scope_iden_file IMG Filename
task_id /smb/bb_img_sobj task_id TaskID
bb_id /smb/bb_img_sobj bbid Building Block

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/DDL_EMPTY_FILE_SCOPE.
-- 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/EMP_FILE

CREATE VIEW /CFG/DDL_EMPTY_FILE_SCOPE AS
SELECT
  WebUisH.activity_id AS act_id,
  WebUisH.cust_obj_name AS cust_obj,
  WebUisI.subobjname AS subobjid,
  scope.scope_iden_file AS filename,
  IMGObject.task_id AS task_id,
  IMGObject.bbid AS bb_id
INNER JOIN /cfg/webgui_i AS WebUisI ON /* join condition not captured in parsed metadata */
INNER JOIN /fti/scope_ident AS scope ON /* join condition not captured in parsed metadata */
INNER JOIN /smb/bb_img_sobj AS IMGObject ON /* join condition not captured in parsed metadata */
;