I_SitnDefinitionTP

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_SitnDefinitionTP.
-- 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: ISITNDEFTP

CREATE VIEW I_SitnDefinitionTP AS
SELECT
  Definition.SitnDefinitionID AS SitnDefinitionID,
  Definition.SitnDefinitionID AS SitnDefinitionIDForEdit,
  Definition.SitnDefTemplateID AS SitnDefTemplateID,
  cast( Definition.SitnDefIsEnabled as boolean preserving type ) AS SitnDefIsEnabled,
  Definition.SitnDefNotifIsAggregated AS SitnDefNotifIsAggregated,
  Definition.SitnDefNotifIsRepeated AS SitnDefNotifIsRepeated,
  Definition.SitnDefTrackingIsEnabled AS SitnDefTrackingIsEnabled,
  Definition.SitnDefAnchorObject AS SitnDefAnchorObject,
  Definition.SitnDefAnchorObjectView AS SitnDefAnchorObjectView,
  Definition.SitnDefRank AS SitnDefRank,
  Definition.CreationDateTime AS CreationDateTime,
  Definition.CreatedByUser AS CreatedByUser,
  Definition.LastChangeDateTime AS LastChangeDateTime,
  Definition.LastChangedByUser AS LastChangedByUser,
  Definition.SitnDefIsTemplate AS SitnDefIsTemplate,
  Definition.SitnIsAttribNavgnParameter AS SitnIsAttribNavgnParameter,
  Definition.SitnDefDataContextIsEnabled AS SitnDefDataContextIsEnabled,
  Definition.SitnDefAutomationIsEnabled AS SitnDefAutomationIsEnabled,
  Definition.SitnDefLongTextVersion AS SitnDefLongTextVersion,
  _CreatedBy.UserDescription AS CreatedByUserFullName,
  _LastChangedBy.UserDescription AS LastChangedByUserFullName,
  cast(' ' as boole_d) AS SitnDefTrackingIsDeleted,
  cast('00000000' as sit_de_activ_before_date ) AS SitnDefTrackingDelBeforeDate,
  _Conditions.SitnTriggerObjectView AS SitnTriggerObjectView,
  _Conditions.SitnDefTriggerType AS SitnDefTriggerType,
  Definition.SitnDefPageVariantIsEnabled AS SitnDefPageVariantIsEnabled,
  Definition.RespyMgmtApplContextType AS RespyMgmtApplContextType,
  Definition.SitnRespyMgmtContextTemplateID AS SitnRespyMgmtContextTemplateID,
  Definition.SitnRespyMgmtContextID AS SitnRespyMgmtContextID,
  cast('' as char1024) AS SitnDefHelpDocLink
FROM I_SitnDefUnion AS Definition
LEFT OUTER JOIN I_SitnDefConditionTP AS _Conditions ON SitnDefinitionID = _Conditions.SitnDefinitionID  -- association [1..1]
LEFT OUTER JOIN I_SitnDefCndnRangeTP AS _ConditionRanges ON SitnDefinitionID = _ConditionRanges.SitnDefinitionID  -- association [1..*]
LEFT OUTER JOIN I_SitnDefNotifTP AS _Notification ON SitnDefinitionID = _Notification.SitnDefinitionID  -- association [1..*]
LEFT OUTER JOIN I_SitnDefinitionTextTP AS _DefinitionText ON SitnDefinitionID = _DefinitionText.SitnDefinitionID  -- association [1..*]
LEFT OUTER JOIN I_SitnInstanceOfSitnDefTP AS _Instances ON SitnDefinitionID = _Instances.SitnDefinitionID  -- association [1..*]
LEFT OUTER JOIN I_SitnDefSchedldBatchTP AS _TechJob ON SitnDefinitionID = _TechJob.SitnDefinitionID  -- association [1..1]
LEFT OUTER JOIN I_RespyMgmtApplContextTP AS _RsmApplContext ON ( SitnRespyMgmtContextID = _RsmApplContext.RespyMgmtApplContextID AND RespyMgmtApplContextType = _RsmApplContext.RespyMgmtApplContextType )  -- association [1..1]
LEFT OUTER JOIN I_SitnDefNotifTextTP AS _NotifText ON SitnDefinitionID = _NotifText.SitnDefinitionID AND _NotifText.SitnDefNotificationID = '0001' AND _NotifText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SitnDefinitionTextTP AS _SitnDefinitionText ON SitnDefinitionID = _SitnDefinitionText.SitnDefinitionID AND SitnDefLongTextVersion = _SitnDefinitionText.SitnDefLongTextVersion AND _SitnDefinitionText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.UserID  -- association [1..1]
;