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

I_SitnDefTextForSitnInstance

DDL: I_SITNDEFTEXTFORSITNINSTANCE SQL: ISITNTXTVERS Type: view COMPOSITE Package: CA_SIT_DDIC
10 Fields 1 Data Sources 1 Associations

Situation instance text by relevant version

I_SitnDefTextForSitnInstance is a Composite CDS View that provides data about "Situation instance text by relevant version" in SAP S/4HANA. It reads from 1 data source (P_SitnInstanceTextVersion) and exposes 10 fields with key fields SitnInstanceID, Language. It has 1 association to related views. Part of development package CA_SIT_DDIC.

Data Sources (1)

SourceAliasJoin Type
P_SitnInstanceTextVersion TextVersionByInstance from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SitnDefinitionText _TextByVersion _TextByVersion.SitnDefinitionID = $projection.SitnDefinitionID and _TextByVersion.SitnDefLongTextVersion = $projection.SitnMsgTextVersion

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITNTXTVERS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Situation instance text by relevant version 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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SitnInstanceID P_SitnInstanceTextVersion SitnInstanceID Instance ID
KEY Language _TextByVersion Language Report Text Language
SitnMsgTextVersion P_SitnInstanceTextVersion SitnMsgTextVersion Version Msg. Details
SitnDefinitionID P_SitnInstanceTextVersion SitnDefinitionID Situation Type ID
SitnDefName _TextByVersion SitnDefName Situation Name
SitnDefShortText _TextByVersion SitnDefShortText Sitn Short Text
SitnDefLongText _TextByVersion SitnDefLongText Situation Type Long Text
SitnCndnDescription _TextByVersion SitnCndnDescription Situation Cndn Desc
SitnDefDetailsLinkText _TextByVersion SitnDefDetailsLinkText Detail Link
SitnDefDetailsLink _TextByVersion SitnDefDetailsLink URL to Documentation

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_SitnDefTextForSitnInstance.
-- 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: ISITNTXTVERS

CREATE VIEW I_SitnDefTextForSitnInstance AS
SELECT
  TextVersionByInstance.SitnInstanceID AS SitnInstanceID,
  _TextByVersion.Language AS Language,
  TextVersionByInstance.SitnMsgTextVersion AS SitnMsgTextVersion,
  TextVersionByInstance.SitnDefinitionID AS SitnDefinitionID,
  _TextByVersion.SitnDefName AS SitnDefName,
  _TextByVersion.SitnDefShortText AS SitnDefShortText,
  _TextByVersion.SitnDefLongText AS SitnDefLongText,
  _TextByVersion.SitnCndnDescription AS SitnCndnDescription,
  _TextByVersion.SitnDefDetailsLinkText AS SitnDefDetailsLinkText,
  _TextByVersion.SitnDefDetailsLink AS SitnDefDetailsLink
FROM P_SitnInstanceTextVersion AS TextVersionByInstance
LEFT OUTER JOIN I_SitnDefinitionText AS _TextByVersion ON _TextByVersion.SitnDefinitionID = SitnDefinitionID AND _TextByVersion.SitnDefLongTextVersion = SitnMsgTextVersion  -- association [1..*]
;

Learn More