I_MKT_MktgObjectAttachment

DDL: I_MKT_MKTGOBJECTATTACHMENT SQL: IMKTGOBJATTCH Type: view BASIC Package: CUAN_CDS_COMMON_NO_TRANSL
10 Fields 2 Data Sources

Marketing: Object Attachment

I_MKT_MktgObjectAttachment is a Basic CDS View that provides data about "Marketing: Object Attachment" in SAP S/4HANA. It reads from 2 data sources (hpa_d_doc_data, hpa_d_doc_store) and exposes 10 fields with key field MarketingObjectUUID. Part of development package CUAN_CDS_COMMON_NO_TRANSL.

Data Sources (2)

SourceAliasJoin Type
hpa_d_doc_data Data from
hpa_d_doc_store Root inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMKTGOBJATTCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Marketing: Object Attachment view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MarketingObjectUUID hpa_d_doc_data db_key UUID
MarketingObjectType hpa_d_doc_store object_type Type
MarketingObject hpa_d_doc_store object_id Transaction ID
mime_code
file_size
content
link_uri
crea_uname
lchg_uname
root_key

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_MKT_MktgObjectAttachment.
-- 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: IMKTGOBJATTCH

CREATE VIEW I_MKT_MktgObjectAttachment AS
SELECT
  Data.db_key AS MarketingObjectUUID,
  Root.object_type AS MarketingObjectType,
  Root.object_id AS MarketingObject
FROM hpa_d_doc_data AS Data
INNER JOIN hpa_d_doc_store AS Root ON /* join condition not captured in parsed metadata */
;

Learn More