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

I_SitnDefinitionTextUnion

DDL: I_SITNDEFINITIONTEXTUNION SQL: ISITNDEFTXTUNION Type: view COMPOSITE
20 Fields 2 Data Sources 1 Associations

All situation type texts

I_SitnDefinitionTextUnion is a Composite CDS View that provides data about "All situation type texts" in SAP S/4HANA. It reads from 2 data sources (I_SitnDefinitionText, I_SitnDefinitionTextTemplate) and exposes 20 fields with key fields SitnDefinitionID, SitnDefLongTextVersion, Language, SitnDefinitionID, SitnDefLongTextVersion. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SitnDefinitionText DefinitionText from
I_SitnDefinitionTextTemplate DefTextTemplate union

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISITNDEFTXTUNION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true 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
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SitnDefinitionID view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label All situation type texts view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SitnDefinitionID I_SitnDefinitionText SitnDefinitionID Situation Type ID
KEY SitnDefLongTextVersion I_SitnDefinitionText SitnDefLongTextVersion
KEY Language I_SitnDefinitionText Language Report Text Language
SitnDefName I_SitnDefinitionText SitnDefName Situation Name
SitnDefShortText I_SitnDefinitionText SitnDefShortText Sitn Short Text
SitnDefLongText I_SitnDefinitionText SitnDefLongText Situation Type Long Text
SitnCndnDescription I_SitnDefinitionText SitnCndnDescription Situation Cndn Desc
SitnDefDetailsLinkText I_SitnDefinitionText SitnDefDetailsLinkText Detail Link
SitnDefDetailsLink I_SitnDefinitionText SitnDefDetailsLink URL to Documentation
clientasMANDT
KEY SitnDefinitionID I_SitnDefinitionTextTemplate SitnDefinitionID Situation Type ID
KEY SitnDefLongTextVersion
KEY Language I_SitnDefinitionTextTemplate Language Report Text Language
SitnDefName I_SitnDefinitionTextTemplate SitnDefName Situation Name
SitnDefShortText I_SitnDefinitionTextTemplate SitnDefShortText Sitn Short Text
SitnDefLongText I_SitnDefinitionTextTemplate SitnDefLongText Situation Type Long Text
SitnCndnDescription I_SitnDefinitionTextTemplate SitnCndnDescription Situation Cndn Desc
SitnDefDetailsLinkText Detail Link
SitnDefDetailsLink URL to Documentation
_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_SitnDefinitionTextUnion.
-- 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: ISITNDEFTXTUNION

CREATE VIEW I_SitnDefinitionTextUnion AS
SELECT
  DefinitionText.SitnDefinitionID AS SitnDefinitionID,
  DefinitionText.SitnDefLongTextVersion AS SitnDefLongTextVersion,
  DefinitionText.Language AS Language,
  DefinitionText.SitnDefName AS SitnDefName,
  DefinitionText.SitnDefShortText AS SitnDefShortText,
  DefinitionText.SitnDefLongText AS SitnDefLongText,
  DefinitionText.SitnCndnDescription AS SitnCndnDescription,
  DefinitionText.SitnDefDetailsLinkText AS SitnDefDetailsLinkText,
  DefinitionText.SitnDefDetailsLink AS SitnDefDetailsLink
FROM I_SitnDefinitionText AS DefinitionText
LEFT OUTER JOIN I_SitnDefUnion AS _Definition ON SitnDefinitionID = _Definition.SitnDefinitionID  -- association [1..1]
-- UNION with additional select branch(es): I_SitnDefinitionTextTemplate
;

Learn More