HPA_DOCUMENT_READ

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 HPA_DOCUMENT_READ.
-- 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: HPA_DOCREAD

CREATE VIEW HPA_DOCUMENT_READ AS
SELECT
  Data.db_key AS db_key,
  Root.object_type AS object_type,
  Root.object_id AS object_id,
  Data.mime_code AS mime_code,
  Data.file_name AS file_name,
  Data.file_size AS file_size,
  Data.content AS content,
  Data.link_uri AS link_uri,
  Data.crea_uname AS crea_uname,
  Data.lchg_uname AS lchg_uname,
  Root.db_key AS root_key
FROM hpa_d_doc_data AS Data
INNER JOIN hpa_d_doc_store AS Root ON /* join condition not captured in parsed metadata */
;