C_SitnDefNotifTP

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 C_SitnDefNotifTP.
-- 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: CSITNOTIFTP

CREATE VIEW C_SitnDefNotifTP AS
SELECT
  Notification.SitnDefinitionID AS SitnDefinitionID,
  Notification.SitnDefNotificationID AS SitnDefNotificationID,
  Notification.SitnDefPageVariantID AS SitnDefPageVariantID,
  Notification.SitnNotifSemanticObjAction AS SitnNotifSemanticObjAction,
  Notification.SitnNotifSemanticObject AS SitnNotifSemanticObject,
  Notification.SitnNotifTextVersion AS SitnNotifTextVersion,
  Notification.SitnNotifPublicText AS SitnNotifPublicText,
  Notification.SitnNotifSensitiveText AS SitnNotifSensitiveText,
  Notification.SitnRespyMgmtContextID AS SitnRespyMgmtContextID,
  Notification.SitnDefVariantName AS SitnDefVariantName
FROM I_SitnDefNotifTP AS Notification
LEFT OUTER JOIN C_SitnDefinitionTP AS _Definition ON SitnDefinitionID = _Definition.SitnDefinitionID  -- association [1..1]
LEFT OUTER JOIN C_SitnDefNotifTextTP AS _NotifText ON SitnDefinitionID = _NotifText.SitnDefinitionID AND SitnDefNotificationID = _NotifText.SitnDefNotificationID  -- association [1..*]
;