DDIC_VFS_ACTIVE_TYPE

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 DDIC_VFS_ACTIVE_TYPE.
-- 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.

CREATE VIEW DDIC_VFS_ACTIVE_TYPE AS
SELECT
  ddls_table.ddlname AS Ddlname,
  ddls_table.source_type AS SourceType,
  vfs.version AS version,
  vfs.object_type AS object_type,
  vfs.object_name AS object_name,
  vfs.author AS author,
  vfs.devclass AS devclass,
  vfs.created_on AS created_on,
  vfs.creation_day AS creation_day,
  vfs.masterlang AS masterlang,
  vfs.alias_type AS alias_type,
  vfs.alias_name AS alias_name,
  vfs.wb_type AS wb_type,
  vfs.full_type AS full_type,
  vfs.fav_list AS fav_list,
  vfs.docu AS docu,
  vfs.package_low AS package_low,
  vfs.package_high AS package_high,
  vfs.ap_component AS ap_component,
  vfs.sw_component AS sw_component,
  vfs.tr_layer AS tr_layer,
  vfs.use_alias AS use_alias
FROM DDIC_VFS_ALL AS vfs
LEFT OUTER JOIN DDIC_ACTIVE_TYPE AS ddls_table ON /* join condition not captured in parsed metadata */
;