C_TaskListActivity

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_TaskListActivity.
-- 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_TaskListActivity AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOOperationInternalID,
  BOOSqncOpAssgmtIntVersionCntr,
  BOOOpInternalVersionCounter,
  OperationExternalID,
  cast( Operation as abap.char( 4 ) ) AS Operation,
  OperationText,
  ValidityStartDate,
  ValidityEndDate,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  _Sequence.SequenceCategory AS SequenceCategory,
  _Sequence.SequenceCategoryName AS SequenceCategoryName,
  _Sequence.BillOfOperationsRefSequence AS BillOfOperationsRefSequence,
  _Sequence.BOOSqncBranchOpInternalID AS BOOSqncBranchOpInternalID,
  _Sequence.BOOSqncReturnOpInternalID AS BOOSqncReturnOpInternalID,
  cast( _Sequence.BOOSequenceBranchOperation as abap.char( 4 ) ) AS BOOSequenceBranchOperation,
  cast( _Sequence.BOOSequenceReturnOperation as abap.char( 4 ) ) AS BOOSequenceReturnOperation,
  case when _Sequence.SequenceText is initial or _Sequence.SequenceText = '' then BillOfOperationsSequence else _Sequence.SequenceText end as SequenceText AS SequenceTextendasSequenceText
FROM I_MfgBOOOperationChangeState
LEFT OUTER JOIN I_RoutingHeader AS _RoutingHeader ON _RoutingHeader.BillOfOperationsType = BillOfOperationsType AND _RoutingHeader.BillOfOperationsGroup = BillOfOperationsGroup AND _RoutingHeader.BillOfOperationsVariant = BillOfOperationsVariant AND _RoutingHeader.ValidityStartDate <= $session.system_date AND _RoutingHeader.ValidityEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN C_TaskListSequence AS _Sequence ON _Sequence.BillOfOperationsType = BillOfOperationsType AND _Sequence.BillOfOperationsGroup = BillOfOperationsGroup AND _Sequence.BillOfOperationsVariant = BillOfOperationsVariant AND _Sequence.BillOfOperationsSequence = BillOfOperationsSequence AND _Sequence.ValidityStartDate <= $session.system_date AND _Sequence.ValidityEndDate >= $session.system_date  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = WorkCenterTypeCode  -- association [0..1]
;