Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_SitnDefNotif

DDL: I_SITNDEFNOTIF SQL: ISITNNOTIF Type: view BASIC
10 Fields 1 Data Sources 1 Associations

Notification Details

I_SitnDefNotif is a Basic CDS View that provides data about "Notification Details" in SAP S/4HANA. It reads from 1 data source (sit_notif) and exposes 10 fields with key fields SitnDefinitionID, SitnDefNotificationID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
sit_notif Notification from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SitnDefinition _Definition $projection.SitnDefinitionID = _Definition.SitnDefinitionID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITNNOTIF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPRECATED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Notification Details view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SitnDefinitionID sit_notif sitndefinitionid Situation Type ID
KEY SitnDefNotificationID sit_notif sitndefnotificationid Situation Notif ID
SitnNotifSemanticObject sit_notif sitnnotifsemanticobject Semantic Object
SitnNotifSemanticObjAction sit_notif sitnnotifsemanticobjaction Semantic Obj. Action
SitnNotifTextVersion sit_notif sitnnotiftextversion Notification Version
SitnDefPageVariantID sit_notif sitndefpagevariantid Page Variant ID
SitnDefVariantName sit_notif sitndefpagevariantname Variant Name
SitnDefApplicationID sit_notif sitndefapplicationid SitDefAppID
SitnRespyMgmtContextID sit_notif sitnrespymgmtcontextid Context ID
_Definition _Definition

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_SitnDefNotif.
-- 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: ISITNNOTIF

CREATE VIEW I_SitnDefNotif AS
SELECT
  Notification.sitndefinitionid AS SitnDefinitionID,
  Notification.sitndefnotificationid AS SitnDefNotificationID,
  Notification.sitnnotifsemanticobject AS SitnNotifSemanticObject,
  Notification.sitnnotifsemanticobjaction AS SitnNotifSemanticObjAction,
  Notification.sitnnotiftextversion AS SitnNotifTextVersion,
  Notification.sitndefpagevariantid AS SitnDefPageVariantID,
  Notification.sitndefpagevariantname AS SitnDefVariantName,
  Notification.sitndefapplicationid AS SitnDefApplicationID,
  Notification.sitnrespymgmtcontextid AS SitnRespyMgmtContextID
FROM sit_notif AS Notification
LEFT OUTER JOIN I_SitnDefinition AS _Definition ON SitnDefinitionID = _Definition.SitnDefinitionID  -- association [1..1]
;

Learn More