I_DFS_DisconnectedClassfctn

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_DFS_DisconnectedClassfctn.
-- 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: IDISCLFN

CREATE VIEW I_DFS_DisconnectedClassfctn AS
SELECT
  DfsDisconnectedSubscriptionID,
  DefenseDisconnectedObjectType,
  DefenseDisconnectedObjectKey,
  DfsDisconnectedObjectStatus,
  DfsDisconnectedSourceObjectID,
  CreatedByName,
  MobileUserCreationDateTime,
  ChangedByName,
  MobileUserChangeDateTime
FROM I_DFS_DisconnectedStagingBasic
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON _WorkCenterText.WorkCenterText = DfsDisconnectedClfnObjectKey AND _WorkCenterText.Language = 'E' AND _WorkCenterText.WorkCenterTypeCode = 'A'  -- association [1..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = DfsDisconnectedClfnObjectKey AND _MaterialText.Language = 'E'  -- association [1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = DfsDisconnectedClfnObjectKey AND _EquipmentText.Language = 'E'  -- association [1]
LEFT OUTER JOIN I_ClfnClassDescription AS _ClfnClassDescription ON _ClfnClassDescription.ClassInternalID = ClassName AND _ClfnClassDescription.Language = 'E'  -- association [1]
LEFT OUTER JOIN I_ClfnClassDescription AS _ClfnNoDescription ON _ClfnNoDescription.ClassInternalID = ObjectClassification AND _ClfnNoDescription.Language = 'E'  -- association [1]
LEFT OUTER JOIN I_ClfnClassDescription AS _HdrClfnNoDescription ON _HdrClfnNoDescription.ClassInternalID = DfsDisconnectedClfnClassID AND _HdrClfnNoDescription.Language = 'E'  -- association [1]
LEFT OUTER JOIN I_ClfnCharcDesc AS _ClfnCharcDesc ON _ClfnCharcDesc.CharcInternalID = CharcValueTo AND _ClfnCharcDesc.Language = 'E' AND _ClfnCharcDesc.TimeIntervalNumber = '0000'  -- association [1]
LEFT OUTER JOIN I_ClfnCharcDesc AS _HdrClfnCharcDesc ON _HdrClfnCharcDesc.CharcInternalID = DfsScenarioCharacteristicValue AND _HdrClfnCharcDesc.Language = 'E' AND _HdrClfnCharcDesc.TimeIntervalNumber = '0000'  -- association [1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = DfsDisconnectedClfnObjectKey AND _FunctionalLocationText.Language = 'E'  -- association [1]
LEFT OUTER JOIN I_MaintenanceNotification AS _NotificationText ON _NotificationText.MaintenanceNotification = DfsDisconnectedClfnObjectKey AND _NotificationText.MasterLanguage = 'E'  -- association [1]
LEFT OUTER JOIN I_FrcElmntOrgName AS _FrcElmntOrgName ON _FrcElmntOrgName.ForceElementOrgID = DfsDisconnectedClfnObjectKey AND _FrcElmntOrgName.FrcElmntOrgLanguage = 'E' AND _FrcElmntOrgName.FrcElmntOrgPlngStatus = '1'  -- association [1..*]
LEFT OUTER JOIN I_MeasuringPoint AS _MeasuringPointText ON _MeasuringPointText.MeasuringPoint = DfsDisconnectedClfnObjectKey AND _MeasuringPointText.Language = 'E'  -- association [1]
;