C_SitnRelatedSituation

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 C_SitnRelatedSituation.
-- 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 C_SitnRelatedSituation AS
SELECT
  RelatedSituation.SitnInstanceID AS SitnInstanceID,
  RelatedSituation.SitnDefRelatedObjectID AS SitnDefRelatedObjectID,
  RelatedSituation.SitnDefinitionID AS SitnDefinitionID,
  RelatedSituation.SitnInstceReltdObjKey AS SitnInstceReltdObjKey,
  RelatedSituation.SitnDefReltdObjSOT AS SitnDefReltdObjSOT,
  RelatedSituation.SitnDefReltdObjSONT AS SitnDefReltdObjSONT,
  _Instance.SitnInstceAnchorObjectKey AS SitnInstceAnchorObjectKey,
  _Instance.SitnAnchorObjectReadableID AS SitnAnchorObjectReadableID,
  _Instance.CreationDateTime AS CreationDateTime,
  _AnchorObjectType.SitnDefAnchorObjectDesc AS SitnDefAnchorObjectDesc,
  _InstanceText.SitnDefShortText AS SitnDefShortText,
  _Definition.SitnDefAnchorObjectView AS SitnDefAnchorObjectView
FROM I_SitnRelatedSituation AS RelatedSituation
LEFT OUTER JOIN I_SitnDefinition AS _Definition ON _Definition.SitnDefinitionID = SitnDefinitionID  -- association [1..1]
LEFT OUTER JOIN I_SitnInstceWthoutPndgTrans AS _Instance ON _Instance.SitnInstanceID = SitnInstanceID  -- association [1..1]
LEFT OUTER JOIN I_SitnDefTextForSitnInstance AS _InstanceText ON _InstanceText.SitnInstanceID = SitnInstanceID AND _InstanceText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SitnDefAnchrObjType AS _AnchorObjectType ON _AnchorObjectType.SitnDefinitionID = SitnDefinitionID  -- association [1..1]
;