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

I_SitnDefNotifTemplate

DDL: I_SITNDEFNOTIFTEMPLATE SQL: ISITNNOTIFTEMPL Type: view BASIC
11 Fields 1 Data Sources 1 Associations

Notification Details from Template

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

Data Sources (1)

SourceAliasJoin Type
sit_t_notif NotificationTemplate from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITNNOTIFTEMPL 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 from Template view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SitnDefinitionID sit_t_notif sitndefinitionid Situation Type ID
KEY SitnDefNotificationID sit_t_notif sitndefnotificationid Situation Notif ID
SitnNotifSemanticObject sit_t_notif sitnnotifsemanticobject Semantic Object
SitnNotifSemanticObjAction sit_t_notif sitnnotifsemanticobjaction Semantic Obj. Action
SitnNotifSemanticObjParam sit_t_notif sitnnotifsemanticobjparam Sem. Obj. Parameter
SitnNotifTextVersion sit_t_notif sitnnotiftextversion Notification Version
SitnDefPageVariantID sit_t_notif sitndefpagevariantid Page Variant ID
SitnDefVariantName sit_t_notif sitndefpagevarinatname Variant Name
SitnDefApplicationID sit_t_notif sitndefapplicationid SitDefAppID
SitnRespyMgmtContextID sit_t_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_SitnDefNotifTemplate.
-- 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: ISITNNOTIFTEMPL

CREATE VIEW I_SitnDefNotifTemplate AS
SELECT
  NotificationTemplate.sitndefinitionid AS SitnDefinitionID,
  NotificationTemplate.sitndefnotificationid AS SitnDefNotificationID,
  NotificationTemplate.sitnnotifsemanticobject AS SitnNotifSemanticObject,
  NotificationTemplate.sitnnotifsemanticobjaction AS SitnNotifSemanticObjAction,
  NotificationTemplate.sitnnotifsemanticobjparam AS SitnNotifSemanticObjParam,
  NotificationTemplate.sitnnotiftextversion AS SitnNotifTextVersion,
  NotificationTemplate.sitndefpagevariantid AS SitnDefPageVariantID,
  NotificationTemplate.sitndefpagevarinatname AS SitnDefVariantName,
  NotificationTemplate.sitndefapplicationid AS SitnDefApplicationID,
  NotificationTemplate.sitnrespymgmtcontextid AS SitnRespyMgmtContextID
FROM sit_t_notif AS NotificationTemplate
LEFT OUTER JOIN I_SitnDefTemplate AS _Definition ON SitnDefinitionID = _Definition.SitnDefinitionID  -- association [1..1]
;

Learn More