Vfs_All_Search

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 Vfs_All_Search.
-- 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: VFS_ALL_SEARCH1

CREATE VIEW Vfs_All_Search AS
SELECT
  obj.object_type AS object_type,
  obj.object_name AS object_name,
  obj.author AS author,
  obj.devclass AS devclass,
  obj.created_on AS created_on,
  substring(obj.created_on, 7, 2 ) AS creation_day,
  obj.masterlang AS masterlang,
  obj.alias_type AS alias_type,
  obj.alias_name AS alias_name,
  obj.wb_type AS wb_type,
  fav.list_id AS fav_list,
  package_intervals.low AS package_low,
  package_intervals.high AS package_high,
  package_intervals.ap_component AS ap_component,
  package_intervals.sw_component AS sw_component,
  package_intervals.tr_layer AS tr_layer,
  obj.use_alias AS use_alias,
  obj.is_virtual AS is_virtual
FROM Vfs_Object_Search AS obj
LEFT OUTER JOIN VFS_Api_States AS api ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Vfs_Inactive_Objects AS version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pak_intervals AS package_intervals ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vfs_fav_objects AS fav ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vfs_documentation AS docu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFS_Language_Version AS alvers ON /* join condition not captured in parsed metadata */
;