APS_COM_CS_D2_EVENT

DDL: APS_COM_CS_D2_EVENT SQL: APS_COM_CS_E Type: view Package: SR_APS_COM_CS

CS Draft 2.0 OIDC Event View

APS_COM_CS_D2_EVENT is a CDS View that provides data about "CS Draft 2.0 OIDC Event View" in SAP S/4HANA. It reads from 1 data source (aps_cs_d_event) and exposes 12 fields with key field db_key. It has 2 associations to related views. Part of development package SR_APS_COM_CS.

Data Sources (1)

SourceAliasJoin Type
aps_cs_d_event Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] Aps_Com_Cs_D2_Root _Root Document.parent_key = _Root.db_key
[0..*] APS_COM_CS_D2_EVENT_SA _EventSA Document.db_key = _EventSA.parent_key

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_CS_E view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CS Draft 2.0 OIDC Event View view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY db_key db_key UUID
parent_key parent_key UUID
Eventcommarrangementuuid eventcommarrangementuuid
Eventcommarrangement eventcommarrangement
CommunicationScenarioId communicationscenarioid
CommScenarioDescription commscenariodescription
Creationdatetime creationdatetime Timestamp
Createdbyuser createdbyuser User Name
Lastchangedatetime lastchangedatetime Timestamp
Lastchangedbyuser lastchangedbyuser User Name
_Root _Root
_EventSA _EventSA

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 APS_COM_CS_D2_EVENT.
-- 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: APS_COM_CS_E

CREATE VIEW APS_COM_CS_D2_EVENT AS
SELECT
  db_key,
  parent_key,
  Eventcommarrangementuuid,
  Eventcommarrangement,
  CommunicationScenarioId,
  CommScenarioDescription,
  Creationdatetime,
  Createdbyuser,
  Lastchangedatetime,
  Lastchangedbyuser
FROM aps_cs_d_event AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root AS _Root ON Document.parent_key = _Root.db_key  -- association [1..1]
LEFT OUTER JOIN APS_COM_CS_D2_EVENT_SA AS _EventSA ON Document.db_key = _EventSA.parent_key  -- association [0..*]
;