S_SCME_ANNOTATION_C

DDL: S_SCME_ANNOTATION_C Type: view Package: S_CME_MODEL
11 Fields 1 Data Sources 2 Associations

CME: Annotation consumption view

S_SCME_ANNOTATION_C is a CDS View that provides data about "CME: Annotation consumption view" in SAP S/4HANA. It reads from 1 data source (I_SCME_ANNOTATION_TP) and exposes 11 fields with key fields ExtensionID, VersionNumber, Name, Scope, Element. It has 2 associations to related views. Part of development package S_CME_MODEL.

Data Sources (1)

SourceAliasJoin Type
I_SCME_ANNOTATION_TP I_SCME_ANNOTATION_TP from

Associations (2)

CardinalityTargetAliasCondition
[1] S_SCME_EXTENSION_C _Extension _Extension.ExtensionID = $projection.ExtensionID and _Extension.VersionNumber = $projection.VersionNumber
[0..*] S_SCME_VALUE_C _Value _Value.ExtensionID = $projection.ExtensionID and _Value.VersionNumber = $projection.VersionNumber and _Value.Name = $projection.Name and _Value.Scope = $projection.Scope and _Value.Element = $projection.Element

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName S_V_SCME_ANNO_C view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CME: Annotation consumption view view
ClientHandling.type #CLIENT_INDEPENDENT view
Search.searchable true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ExtensionID ExtensionID UI Ext ID
KEY VersionNumber VersionNumber Version Number
KEY Name Name Zone name
KEY Scope Scope Visibility
KEY Element Element Target identifier
NameForEdit NameForEdit Zone name
ScopeForEdit ScopeForEdit Visibility
ElementForEdit ElementForEdit Target identifier
Value Value Value from table
_Extension _Extension
_Value _Value

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 S_SCME_ANNOTATION_C.
-- 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.

CREATE VIEW S_SCME_ANNOTATION_C AS
SELECT
  ExtensionID,
  VersionNumber,
  Name,
  Scope,
  Element,
  NameForEdit,
  ScopeForEdit,
  ElementForEdit,
  Value
FROM I_SCME_ANNOTATION_TP
LEFT OUTER JOIN S_SCME_EXTENSION_C AS _Extension ON _Extension.ExtensionID = ExtensionID AND _Extension.VersionNumber = VersionNumber  -- association [1]
LEFT OUTER JOIN S_SCME_VALUE_C AS _Value ON _Value.ExtensionID = ExtensionID AND _Value.VersionNumber = VersionNumber AND _Value.Name = Name AND _Value.Scope = Scope AND _Value.Element = Element  -- association [0..*]
;

Learn More