I_DFS_ObjectValidName

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_ObjectValidName.
-- 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: IDFSOBJVALNAME

CREATE VIEW I_DFS_ObjectValidName AS
SELECT
  DfsObjectID,
  DfsObjectType,
  DfsObjectValdtyStartDate,
  DfsObjectValdtyEndDate,
  DfsObjectPlngStatus,
  LanguageCode,
  DfsObjectValdtyPreviousEndDate,
  DfsObjectValdtyNextStartDate
FROM I_DFS_ObjectValidNameBasic AS _SuplmntyStatus
LEFT OUTER JOIN I_DFS_ObjectName AS _ObjectNameCurrent ON _ObjectNameCurrent.DfsObjectID = DfsObjectID AND _ObjectNameCurrent.DfsObjectType = DfsObjectType AND _ObjectNameCurrent.DfsObjectValdtyStartDate <= $session.system_date AND _ObjectNameCurrent.DfsObjectValdtyEndDate >= $session.system_date AND _ObjectNameCurrent.DfsObjectPlngStatus = DfsObjectPlngStatus AND _ObjectNameCurrent.LanguageCode = LanguageCode  -- association [0..1]
LEFT OUTER JOIN I_DFS_ObjectName AS _ObjectNameLatest ON _ObjectNameLatest.DfsObjectID = DfsObjectID AND _ObjectNameLatest.DfsObjectType = DfsObjectType AND _ObjectNameLatest.DfsObjectValdtyEndDate = DfsObjectValdtyPreviousEndDate AND _ObjectNameLatest.DfsObjectPlngStatus = DfsObjectPlngStatus AND _ObjectNameLatest.LanguageCode = LanguageCode  -- association [0..1]
LEFT OUTER JOIN I_DFS_ObjectName AS _ObjectNameFuture ON _ObjectNameFuture.DfsObjectID = DfsObjectID AND _ObjectNameFuture.DfsObjectType = DfsObjectType AND _ObjectNameFuture.DfsObjectValdtyStartDate = DfsObjectValdtyNextStartDate AND _ObjectNameFuture.DfsObjectPlngStatus = DfsObjectPlngStatus AND _ObjectNameFuture.LanguageCode = LanguageCode  -- association [0..1]
;