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

I_SitnDefNotifText

DDL: I_SITNDEFNOTIFTEXT SQL: ISITNNOTIFTEXT Type: view BASIC

Notification - Text

I_SitnDefNotifText is a Basic CDS View that provides data about "Notification - Text" in SAP S/4HANA. It reads from 2 data sources (sit_notif_t, sit_t_notif_t) and exposes 12 fields with key fields SitnDefinitionID, Language, SitnDefNotificationID, SitnDefinitionID, Language. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
sit_notif_t NotificationText from
sit_t_notif_t NotifTextTemplate union_all

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITNNOTIFTEXT 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 - Text view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SitnDefinitionID sit_notif_t sitndefinitionid Situation Type ID
KEY Language sit_notif_t language Report Text Language
KEY SitnDefNotificationID sit_notif_t sitndefnotificationid Situation Notif ID
SitnNotifSensitiveText sit_notif_t sitnnotifsensitivetext Secure Text
SitnNotifPublicText sit_notif_t sitnnotifpublictext Public Notif. Text
clientasMandt
KEY SitnDefinitionID sit_t_notif_t sitndefinitionid Situation Type ID
KEY Language sit_t_notif_t language Report Text Language
KEY SitnDefNotificationID sit_t_notif_t sitndefnotificationid Situation Notif ID
SitnNotifSensitiveText sit_t_notif_t sitnnotifsensitivetext Secure Text
SitnNotifPublicText sit_t_notif_t sitnnotifpublictext Public Notif. Text
_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_SitnDefNotifText.
-- 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: ISITNNOTIFTEXT

CREATE VIEW I_SitnDefNotifText AS
SELECT
  NotificationText.sitndefinitionid AS SitnDefinitionID,
  NotificationText.language AS Language,
  NotificationText.sitndefnotificationid AS SitnDefNotificationID,
  NotificationText.sitnnotifsensitivetext AS SitnNotifSensitiveText,
  NotificationText.sitnnotifpublictext AS SitnNotifPublicText
FROM sit_notif_t AS NotificationText
LEFT OUTER JOIN I_SitnDefUnion AS _Definition ON SitnDefinitionID = _Definition.SitnDefinitionID  -- association [1..1]
-- UNION ALL with additional select branch(es): sit_t_notif_t
;