I_EntSrchFileAttachmentCntnt

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 I_EntSrchFileAttachmentCntnt.
-- 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: IESHFATTACHCTNT

CREATE VIEW I_EntSrchFileAttachmentCntnt AS
SELECT
  ph_class AS PhysicalDocumentClass,
  phio_id AS PhysicalDocumentUUID,
  file_num AS PhysDocFileSqncVal,
  job_id AS EntSrchJobID,
  title AS DocumentTitle,
  url_bin_content AS PhysDocBinaryURL,
  plain_text AS PhysDocCntntText,
  filename AS PhysDocFileName,
  file_extension AS PhysDocFileExtensionCode,
  mime_type AS PhysDocMimeType,
  Language,
  url_thumbnail AS PhysDocThumbnailURL,
  url_suv AS PhysDocSUVURL,
  mime_type_suv AS PhysDocSUVMimeType,
  creator AS CreatedByUser,
  author AS PhysDocAuthorName,
  size_file AS PhysDocFileSize,
  size_file_uom AS PhysDocFileSizeUnit,
  ph_class_thumbnail AS PhysicalDocumentThumbnailClass,
  phio_id_thumbnail AS PhysicalDocumentThumbnailUUID,
  file_num_thumbnail AS PhysDocThumbnailFileSqncVal,
  ph_class_suv AS PhysicalDocumentSUVClass,
  phio_id_suv AS PhysicalDocumentSUV,
  file_num_suv AS PhysDocSUVFileSqncVal,
  file_property AS PhysDocFilePropertiesText
FROM esh_fl_ftask
;