C_SitnInstance

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_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.

CREATE VIEW C_SitnInstance AS
SELECT
  Instance.SitnInstanceID AS SitnInstanceID,
  Instance.SitnDefinitionID AS SitnDefinitionID,
  Instance.SitnInstceAnchorObjectKey AS SitnInstceAnchorObjectKey,
  Instance.SitnInstceTriggerObjectKey AS SitnInstceTriggerObjectKey,
  Instance.CreationDateTime AS CreationDateTime,
  _Definition.SitnDefRank AS SitnDefRank,
  _Definition.SitnDefAnchorObject AS SitnDefAnchorObject,
  _Definition.SitnDefPageVariantIsEnabled AS SitnDefPageVariantIsEnabled,
  _Definition.SitnDefTemplateID AS SitnDefTemplateID,
  _Definition.SitnDefAnchorObjectView AS SitnDefAnchorObjectView,
  _InstanceText.SitnDefShortText AS SitnDefShortText,
  _InstanceText.SitnDefLongText AS SitnDefLongText,
  _InstanceText.SitnDefDetailsLink AS SitnDefDetailsLink,
  _InstanceText.SitnDefDetailsLinkText AS SitnDefDetailsLinkText,
  _InstanceText.SitnDefName AS SitnDefName,
  _TemplateCondition.SitnTriggerObjectKeyField AS SitnTriggerObjectKeyField,
  _Notification.SitnDefPageVariantID AS SitnDefPageVariantID
FROM I_SitnInstceWthoutPndgTrans AS Instance
LEFT OUTER JOIN I_SitnTemplateCondition AS _TemplateCondition ON Instance.SitnDefTemplateID = _TemplateCondition.SitnDefTemplateID  -- association [1..1]
LEFT OUTER JOIN I_SitnDefNotif AS _Notification ON Instance.SitnDefinitionID = _Notification.SitnDefinitionID AND _Notification.SitnDefNotificationID = '0001'  -- association [0..1]
LEFT OUTER JOIN I_SitnDefTextForSitnInstance AS _InstanceText ON _InstanceText.SitnInstanceID = SitnInstanceID AND _InstanceText.Language = $session.system_language  -- association [1..1]
;