HPA_DOCUMENT_PART_READ

DDL: HPA_DOCUMENT_PART_READ SQL: HPA_DOCPARTREAD Type: view Package: CUAN_CDS_COMMON_NO_TRANSL
13 Fields 2 Data Sources

Read Document Part from Marketing Document Storage

HPA_DOCUMENT_PART_READ is a CDS View that provides data about "Read Document Part from Marketing Document Storage" in SAP S/4HANA. It reads from 2 data sources (HPA_DOCUMENT_READ, hpa_d_doc_part) and exposes 13 fields with key field db_key. Part of development package CUAN_CDS_COMMON_NO_TRANSL.

Data Sources (2)

SourceAliasJoin Type
HPA_DOCUMENT_READ Doc inner
hpa_d_doc_part Part from

Annotations (9)

NameValueLevelField
EndUserText.label Read Document Part from Marketing Document Storage view
AbapCatalog.sqlViewName HPA_DOCPARTREAD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY db_key hpa_d_doc_part db_key UUID
doc_key hpa_d_doc_part parent_key UUID
pack_no hpa_d_doc_part pack_no
object_type HPA_DOCUMENT_READ object_type Type
object_id HPA_DOCUMENT_READ object_id Transaction ID
mime_code HPA_DOCUMENT_READ mime_code MIME type
file_name HPA_DOCUMENT_READ file_name Uploaded File Name
file_size HPA_DOCUMENT_READ file_size Size/dim.
content hpa_d_doc_part content Trusted Site Content
link_uri HPA_DOCUMENT_READ link_uri
crea_uname HPA_DOCUMENT_READ crea_uname User Name
lchg_uname HPA_DOCUMENT_READ lchg_uname User Name
root_key hpa_d_doc_part root_key UUID

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_PART_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_DOCPARTREAD

CREATE VIEW HPA_DOCUMENT_PART_READ AS
SELECT
  Part.db_key AS db_key,
  Part.parent_key AS doc_key,
  Part.pack_no AS pack_no,
  Doc.object_type AS object_type,
  Doc.object_id AS object_id,
  Doc.mime_code AS mime_code,
  Doc.file_name AS file_name,
  Doc.file_size AS file_size,
  Part.content AS content,
  Doc.link_uri AS link_uri,
  Doc.crea_uname AS crea_uname,
  Doc.lchg_uname AS lchg_uname,
  Part.root_key AS root_key
FROM hpa_d_doc_part AS Part
INNER JOIN HPA_DOCUMENT_READ AS Doc ON /* join condition not captured in parsed metadata */
;

Learn More