What is I_SitnDefUnion in SAP S/4HANA?

I_SitnDefUnion is a composite CDS view in SAP S/4HANA. Operational sit types and templates It contains 44 fields.

What VDM layer is I_SitnDefUnion?

I_SitnDefUnion is classified as a Composite view that combines data from multiple basic views.

I_SitnDefUnion

Q: Which tables does I_SitnDefUnion read from?

I_SitnDefUnion reads data from: I_SitnDefinition, I_SitnDefTemplate, I_SitnDefNotifTemplate, I_SitnDefNotifTemplate.

DDL: I_SITNDEFUNION SQL: ISITNDEFUNION Type: view COMPOSITE

44 Fields 4 Data Sources

Operational sit types and templates

I_SitnDefUnion is a Composite CDS View that provides data about "Operational sit types and templates" in SAP S/4HANA. It reads from 4 data sources (I_SitnDefinition, I_SitnDefTemplate, I_SitnDefNotifTemplate, I_SitnDefNotifTemplate) and exposes 44 fields with key fields SitnDefinitionID, SitnDefinitionID.

Data Sources (4)

Source	Alias	Join Type
I_SitnDefinition	Definition	from
I_SitnDefTemplate	DefTemplate	union_all
I_SitnDefNotifTemplate	TemplateNotification	inner
I_SitnDefNotifTemplate	TemplateNotification	inner

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	ISITNDEFUNION	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	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	Operational sit types and templates	view

Fields (44)

Key	Field	Source Table	Source Field	Description
KEY	SitnDefinitionID	I_SitnDefinition	SitnDefinitionID	Situation Type ID
	SitnDefTemplateID	I_SitnDefinition	SitnDefTemplateID	Situation Type ID
	SitnDefIsEnabled	I_SitnDefinition	SitnDefIsEnabled	Sit. Type Enabled
	SitnDefTrackingIsEnabled	I_SitnDefinition	SitnDefTrackingIsEnabled	Monitoring Enabled
	SitnDefAnchorObject	I_SitnDefinition	SitnDefAnchorObject	Anchor Object
	SitnDefAnchorObjectView	I_SitnDefinition	SitnDefAnchorObjectView	Anchor Object View
	SitnDefRank	I_SitnDefinition	SitnDefRank	Display Sequence
	SitnDefNotifIsAggregated	I_SitnDefinition	SitnDefNotifIsAggregated	Notif. Aggr. Enabled
	SitnDefNotifIsRepeated	I_SitnDefinition	SitnDefNotifIsRepeated	Renotif. Enabled
	CreationDateTime	I_SitnDefinition	CreationDateTime	Timestamp
	CreatedByUser	I_SitnDefinition	CreatedByUser	User Name
	LastChangeDateTime	I_SitnDefinition	LastChangeDateTime	Timestamp
	LastChangedByUser	I_SitnDefinition	LastChangedByUser	User Name
	SitnDefIsTemplate	I_SitnDefinition	SitnDefIsTemplate
	SitnIsAttribNavgnParameter	I_SitnDefinition	SitnIsAttribNavgnParameter	Nav. Parameter
	SitnDefPageVariantIsEnabled	I_SitnDefinition	SitnDefPageVariantIsEnabled	Page Var. Enabled
	SitnDefDataContextIsEnabled	I_SitnDefinition	SitnDefDataContextIsEnabled	Data Context Enabled
	SitnDefAutomationIsEnabled	I_SitnDefinition	SitnDefAutomationIsEnabled	Automation Enabled
	RespyMgmtApplContextType	I_SitnDefinition	RespyMgmtApplContextType	Context Type
	SitnDefLongTextVersion	I_SitnDefinition	SitnDefLongTextVersion	Version Msg. Details
	SitnRespyMgmtContextTemplateID	I_SitnDefNotifTemplate	SitnRespyMgmtContextID	Context ID
	clientasMANDT
KEY	SitnDefinitionID	I_SitnDefTemplate	SitnDefinitionID	Situation Type ID
	SitnDefTemplateID	I_SitnDefTemplate	SitnDefinitionID	Situation Type ID
	SitnDefIsEnabled	I_SitnDefTemplate	SitnDefIsEnabled	Sit. Type Enabled
	SitnDefTrackingIsEnabled	I_SitnDefTemplate	SitnDefTrackingIsEnabled	Monitoring Enabled
	SitnDefAnchorObject	I_SitnDefTemplate	SitnDefAnchorObject	Anchor Object
	SitnDefAnchorObjectView	I_SitnDefTemplate	SitnDefAnchorObjectView	Anchor Object View
	SitnDefRank	I_SitnDefTemplate	SitnDefRank	Display Sequence
	SitnDefNotifIsAggregated	I_SitnDefTemplate	SitnDefNotifIsAggregated	Notif. Aggr. Enabled
	SitnDefNotifIsRepeated	I_SitnDefTemplate	SitnDefNotifIsRepeated	Renotif. Enabled
	CreationDateTime	I_SitnDefTemplate	CreationDateTime	Timestamp
	CreatedByUser	I_SitnDefTemplate	CreatedByUser	User Name
	LastChangeDateTime	I_SitnDefTemplate	LastChangeDateTime	Timestamp
	LastChangedByUser	I_SitnDefTemplate	LastChangedByUser	User Name
	SitnDefIsTemplate	I_SitnDefTemplate	SitnDefIsTemplate
	SitnIsAttribNavgnParameter	I_SitnDefTemplate	SitnIsAttribNavgnParameter	Nav. Parameter
	SitnDefPageVariantIsEnabled	I_SitnDefTemplate	SitnDefPageVariantIsEnabled	Page Var. Enabled
	SitnDefDataContextIsEnabled	I_SitnDefTemplate	SitnDefDataContextIsEnabled	Data Context Enabled
	SitnDefAutomationIsEnabled	I_SitnDefTemplate	SitnDefAutomationIsEnabled	Automation Enabled
	RespyMgmtApplContextType	I_SitnDefTemplate	RespyMgmtApplContextType	Context Type
	SitnDefLongTextVersion	I_SitnDefTemplate	SitnDefLongTextVersion	Version Msg. Details
	SitnRespyMgmtContextTemplateID	I_SitnDefNotifTemplate	SitnRespyMgmtContextID	Context ID
	SitnRespyMgmtContextID	I_SitnDefNotifTemplate	SitnRespyMgmtContextID	Context ID

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_SitnDefUnion.
-- 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: ISITNDEFUNION

CREATE VIEW I_SitnDefUnion AS
SELECT
  Definition.SitnDefinitionID AS SitnDefinitionID,
  Definition.SitnDefTemplateID AS SitnDefTemplateID,
  Definition.SitnDefIsEnabled AS SitnDefIsEnabled,
  Definition.SitnDefTrackingIsEnabled AS SitnDefTrackingIsEnabled,
  Definition.SitnDefAnchorObject AS SitnDefAnchorObject,
  Definition.SitnDefAnchorObjectView AS SitnDefAnchorObjectView,
  Definition.SitnDefRank AS SitnDefRank,
  Definition.SitnDefNotifIsAggregated AS SitnDefNotifIsAggregated,
  Definition.SitnDefNotifIsRepeated AS SitnDefNotifIsRepeated,
  Definition.CreationDateTime AS CreationDateTime,
  Definition.CreatedByUser AS CreatedByUser,
  Definition.LastChangeDateTime AS LastChangeDateTime,
  Definition.LastChangedByUser AS LastChangedByUser,
  Definition.SitnDefIsTemplate AS SitnDefIsTemplate,
  Definition.SitnIsAttribNavgnParameter AS SitnIsAttribNavgnParameter,
  Definition.SitnDefPageVariantIsEnabled AS SitnDefPageVariantIsEnabled,
  Definition.SitnDefDataContextIsEnabled AS SitnDefDataContextIsEnabled,
  Definition.SitnDefAutomationIsEnabled AS SitnDefAutomationIsEnabled,
  Definition.RespyMgmtApplContextType AS RespyMgmtApplContextType,
  Definition.SitnDefLongTextVersion AS SitnDefLongTextVersion,
  TemplateNotification.SitnRespyMgmtContextID AS SitnRespyMgmtContextTemplateID,
  Definition.SitnDefinitionID as SitnRespyMgmtContextID AS clientasMANDT,
  TemplateNotification.SitnRespyMgmtContextID AS SitnRespyMgmtContextID
FROM I_SitnDefinition AS Definition
INNER JOIN I_SitnDefNotifTemplate AS TemplateNotification ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_SitnDefTemplate
;

Depth:

I_SitnDefUnion view

I_SitnDefinitionTP view