/smb/v_Ddl_Ins_Files

DDL: /SMB/V_DDL_INS_FILES SQL: /SMB/V_INS_FILES Type: view

Installation files of all Building Bl

/smb/v_Ddl_Ins_Files is a CDS View that provides data about "Installation files of all Building Bl" in SAP S/4HANA. It reads from 1 data source (/smb/bb_img_sobj) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
/smb/bb_img_sobj IMGObject inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName /SMB/V_INS_FILES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Installation files of all Building Bl view

Fields (9)

KeyFieldSource TableSource FieldDescription
objid BlockActivities objid Work Center
objty BlockActivities objty Prj. Obj. Type
cust_obj BlockActivities altn_objid Char 70
subobjid /smb/bb_img_sobj objid Work Center
objidasobjid
objty BlockActivities objty Prj. Obj. Type
cust_obj BlockActivities altn_objid Char 70
subobjid Work Center
filename BlockActivities filename URL or Filenam Path

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 /smb/v_Ddl_Ins_Files.
-- 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: /SMB/V_INS_FILES

CREATE VIEW /smb/v_Ddl_Ins_Files AS
SELECT
  BlockActivities.objid AS objid,
  BlockActivities.objty AS objty,
  BlockActivities.altn_objid AS cust_obj,
  IMGObject.objid AS subobjid,
  IMGObject.filename as filename AS objidasobjid,
  BlockActivities.filename AS filename
INNER JOIN /smb/bb_img_sobj AS IMGObject ON /* join condition not captured in parsed metadata */
;