I_TaskListSequence

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_TaskListSequence.
-- 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 I_TaskListSequence AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOSqncInternalVersionCounter,
  SequenceCategory,
  _CategoryText.SequenceCategoryName AS SequenceCategoryName,
  BillOfOperationsRefSequence,
  BOOSqncBranchOpInternalID,
  cast(_BranchOperation.Operation as pph_vornr preserving type) AS BOOSequenceBranchOperation,
  BOOSqncReturnOpInternalID,
  cast(_ReturnOperation.Operation as pph_vornr preserving type) AS BOOSequenceReturnOperation,
  SequenceText,
  ValidityStartDate,
  ValidityEndDate
FROM I_MfgBOOSequenceChangeState
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _BranchOperation ON BillOfOperationsType = _BranchOperation.BillOfOperationsType AND BillOfOperationsGroup = _BranchOperation.BillOfOperationsGroup AND BillOfOperationsVariant = _BranchOperation.BillOfOperationsVariant AND BillOfOperationsRefSequence = _BranchOperation.BillOfOperationsSequence AND BOOSqncBranchOpInternalID = _BranchOperation.BOOOperationInternalID AND ValidityEndDate >= _BranchOperation.ValidityStartDate AND ValidityStartDate <= _BranchOperation.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _ReturnOperation ON BillOfOperationsType = _ReturnOperation.BillOfOperationsType AND BillOfOperationsGroup = _ReturnOperation.BillOfOperationsGroup AND BillOfOperationsVariant = _ReturnOperation.BillOfOperationsVariant AND BillOfOperationsRefSequence = _ReturnOperation.BillOfOperationsSequence AND BOOSqncReturnOpInternalID = _ReturnOperation.BOOOperationInternalID AND ValidityEndDate >= _ReturnOperation.ValidityStartDate AND ValidityStartDate <= _ReturnOperation.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_SequenceCategoryText AS _CategoryText ON _CategoryText.SequenceCategory = SequenceCategory AND _CategoryText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_RoutingHeader AS _RoutingHeader ON BillOfOperationsType = _RoutingHeader.BillOfOperationsType AND BillOfOperationsGroup = _RoutingHeader.BillOfOperationsGroup AND BillOfOperationsVariant = _RoutingHeader.BillOfOperationsVariant  -- association [1..*]
;