/SAM4U/BTL_L_FILE

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 /SAM4U/BTL_L_FILE.
-- 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: /SAM4U/BTLQFILE

CREATE VIEW /SAM4U/BTL_L_FILE AS
SELECT
  File.file_id AS FileGUID,
  File.file_type_id AS FileTypeId,
  FileType.FileTypeText AS FileTypeText,
  File.file_name AS FileName,
  File.status_id AS StatusId,
  Status.StatusText AS StatusText,
  File.created_at AS CreatedAt,
  File.created_by_id AS CreatedById,
  CreatedUser.UserFullName AS CreatedByName,
  File.changed_at AS ChangedAt,
  File.changed_by_id AS ChangedById,
  ChangedUser.UserFullName AS ChangedByName,
  File.is_archived AS IsArchived,
  File.is_deleted AS IsDeleted,
  File.is_favorite AS IsFavorite,
  File.file_value AS FileValue,
  File.content_type AS ContentType,
  File.datasetguid AS DatasetId
FROM /sam4u/btl_dfile AS File
LEFT OUTER JOIN /SAM4U/BTL_L_FILE_TYPE_TEXT AS FileType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_USE_STATUS_TEXT AS Status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_USER AS CreatedUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SAM4U/BTL_L_USER AS ChangedUser ON /* join condition not captured in parsed metadata */
;