C_BillOfOperationsActivity

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_BillOfOperationsActivity.
-- 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_BillOfOperationsActivity AS
SELECT
  _Op.BillOfOperationsType AS BillOfOperationsType,
  _Op.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Op.BOOOperationInternalID AS BOOOperationInternalID,
  _Op.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  _Op.BillOfOperationsVariant AS BillOfOperationsVariant,
  _SupOp.BOOOpInternalVersionCounter AS BillOfOperationsIntID,
  cast( _Op.Operation as pph_vornr preserving type ) AS Operation,
  cast( _SupOp.Operation as pph_vornr preserving type ) AS SuperiorOperation,
  _Op.BOOOperationIsPhase AS BOOOperationIsPhase,
  _Op.BOOPhaseSuperiorOpInternalID AS BOOPhaseSuperiorOpInternalID,
  _Op.OperationText AS OperationText,
  _Op.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  _Op.Plant AS Plant,
  _Op.OperationControlProfile AS OperationControlProfile,
  _Op.OperationStandardTextCode AS OperationStandardTextCode,
  _Op.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Op.WorkCenterInternalID AS WorkCenterInternalID,
  _Op.CreationDate AS CreationDate,
  _Op.ValidityStartDate AS ValidityStartDate,
  _Op.ValidityEndDate AS ValidityEndDate,
  _WorkCenterText.WorkCenterText AS WorkCenterText
INNER JOIN I_MfgBillOfOperationsOperation AS _Acty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _SupOp ON _Op.BillOfOperationsType = _SupOp.BillOfOperationsType AND _Op.BillOfOperationsGroup = _SupOp.BillOfOperationsGroup AND _Op.BOOPhaseSuperiorOpInternalID = _SupOp.BOOOperationInternalID AND _Op.ValidityStartDate <= _SupOp.ValidityEndDate AND _Op.ValidityEndDate >= _SupOp.ValidityStartDate AND _SupOp.BOOOperationIsPhase <> 'X' AND _SupOp.IsDeleted <> 'X' AND _SupOp.IsImplicitlyDeleted <> 'X'  -- association [1..*]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode AND _WorkCenterText.Language = $session.system_language  -- association [1..1]
;