SACMDT_ASPECT_VIEW

DDL: SACMDT_ASPECT_VIEW SQL: ACMASPECT_VIEW Type: view
6 Fields 4 Data Sources

Showing persisted and build-in aspects

SACMDT_ASPECT_VIEW is a CDS View that provides data about "Showing persisted and build-in aspects" in SAP S/4HANA. It reads from 4 data sources (acmaggregate, acmaggregate, acmaggregate, acmaspect) and exposes 6 fields with key fields id, aspect_type, aspect_type, aspect_type, aspect_type.

Data Sources (4)

SourceAliasJoin Type
acmaggregate acmaggregate union
acmaggregate acmaggregate union
acmaggregate acmaggregate union
acmaspect acmaspect from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACMASPECT_VIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Showing persisted and build-in aspects view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY aspect_type aspect_type AspectType
KEY aspect_type AspectType
KEY aspect_type AspectType
KEY aspect_type AspectType
name

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 SACMDT_ASPECT_VIEW.
-- 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: ACMASPECT_VIEW

CREATE VIEW SACMDT_ASPECT_VIEW AS
SELECT
  id,
  aspect_type,
  'USER_BUSINESS_PARTNER_NUMBER' AS name
FROM acmaspect
-- UNION with additional select branch(es): acmaggregate
;

Learn More