What is I_SitnInstance in SAP S/4HANA?

I_SitnInstance is a basic CDS view in SAP S/4HANA. Situation Instance It contains 14 fields.

Which tables does I_SitnInstance read from?

I_SitnInstance reads data from: sit_inst.

What VDM layer is I_SitnInstance?

I_SitnInstance is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SitnInstance

DDL: I_SITNINSTANCE SQL: ISITNINST Type: view BASIC

14 Fields 1 Data Sources 1 Associations

Situation Instance

I_SitnInstance is a Basic CDS View that provides data about "Situation Instance" in SAP S/4HANA. It reads from 1 data source (sit_inst) and exposes 14 fields with key field SitnInstanceID. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
sit_inst	sit_inst	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_SitnDefinition	_Definition	`$projection.SitnDefinitionID = _Definition.SitnDefinitionID`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	ISITNINST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Situation Instance	view
VDM.viewType	#BASIC	view
VDM.lifecycle.status	#DEPRECATED	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (14)

Key	Field	Source Field	Description
KEY	SitnInstanceID	sitninstanceid	Instance ID
	SitnDefinitionID	sitndefinitionid	Situation Type ID
	SitnInstceAnchorObjectKey	sitninstceanchorobjectkey	Anchor Obj. Key
	SitnAnchorObjectReadableID	sitnanchorobjectreadableid	Anchor Object Key
	SitnInstceTriggerObjectKey	sitninstcetriggerobjectkey	Trigger Obj. Key
	SitnTriggerObjectReadableID	sitntriggerobjectreadableid	Trigger Object Key
	SitnNotifSendDateTime	sitnnotifsenddatetime	Notification Sent On
	SitnNotificationTimeStamp
	sitninstcestatusasSitnInstceStatus
	CreationDateTime	crea_date_time	Occurred
	CreatedByUser	crea_uname	User Name
	LastChangeDateTime	lchg_date_time	Time Stamp
	LastChangedByUser	lchg_uname	Changed By
	_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_SitnInstance.
-- 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: ISITNINST

CREATE VIEW I_SitnInstance AS
SELECT
  SitnInstanceID,
  SitnDefinitionID,
  SitnInstceAnchorObjectKey,
  SitnAnchorObjectReadableID,
  SitnInstceTriggerObjectKey,
  SitnTriggerObjectReadableID,
  SitnNotifSendDateTime,
  crea_date_time AS CreationDateTime,
  crea_uname AS CreatedByUser,
  lchg_date_time AS LastChangeDateTime,
  lchg_uname AS LastChangedByUser
FROM sit_inst
LEFT OUTER JOIN I_SitnDefinition AS _Definition ON SitnDefinitionID = _Definition.SitnDefinitionID  -- association [0..1]
;

Depth:

I_SitnInstance view

sit_inst