What is I_SitnInstceWthoutPndgTrans in SAP S/4HANA?

I_SitnInstceWthoutPndgTrans is a composite CDS view in SAP S/4HANA. Filtered Situation Instances It contains 14 fields.

Which tables does I_SitnInstceWthoutPndgTrans read from?

I_SitnInstceWthoutPndgTrans reads data from: I_SitnInstance.

What VDM layer is I_SitnInstceWthoutPndgTrans?

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

I_SitnInstceWthoutPndgTrans

DDL: I_SITNINSTCEWTHOUTPNDGTRANS Type: view COMPOSITE

14 Fields 1 Data Sources

Filtered Situation Instances

I_SitnInstceWthoutPndgTrans is a Composite CDS View that provides data about "Filtered Situation Instances" in SAP S/4HANA. It reads from 1 data source (I_SitnInstance) and exposes 14 fields with key field SitnInstanceID.

Data Sources (1)

Source	Alias	Join Type
I_SitnInstance	I_SitnInstance	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	ISITNINSTPNDTRN	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.status	#DEPRECATED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
EndUserText.label	Filtered Situation Instances	view

Fields (14)

Key	Field	Source Table	Source Field	Description
KEY	SitnInstanceID	I_SitnInstance	SitnInstanceID	Instance ID
	SitnDefinitionID	I_SitnInstance	SitnDefinitionID	Situation Type ID
	SitnDefTemplateID	_Definition	SitnDefTemplateID	Sitn Template 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
	SitnInstceStatus	I_SitnInstance	SitnInstceStatus	Instance Status
	CreationDateTime		CreationDateTime	Timestamp
	CreatedByUser		CreatedByUser	User Name
	LastChangeDateTime		LastChangeDateTime	Timestamp
	LastChangedByUser		LastChangedByUser	User Name
	_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_SitnInstceWthoutPndgTrans.
-- 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.

CREATE VIEW I_SitnInstceWthoutPndgTrans AS
SELECT
  I_SitnInstance.SitnInstanceID AS SitnInstanceID,
  I_SitnInstance.SitnDefinitionID AS SitnDefinitionID,
  _Definition.SitnDefTemplateID AS SitnDefTemplateID,
  SitnInstceAnchorObjectKey,
  SitnAnchorObjectReadableID,
  SitnInstceTriggerObjectKey,
  SitnTriggerObjectReadableID,
  SitnNotifSendDateTime,
  I_SitnInstance.SitnInstceStatus AS SitnInstceStatus,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_SitnInstance
;

Depth:

I_SitnInstceWthoutPndgTrans view

I_SitnInstance view