C_ManufacturingOrderSequence

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_ManufacturingOrderSequence.
-- 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_ManufacturingOrderSequence AS
SELECT
  cast(OrderSequenceBySemKey.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(OrderSequenceBySemKey.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  OrderSequenceBySemKey.OrderInternalID AS OrderInternalID,
  OrderSequenceBySemKey.SequenceInternalID AS SequenceInternalID,
  cast(OrderSequenceBySemKey.SequenceText as mfgordersequencetext preserving type) AS MfgOrderSequenceText,
  OrderSequenceBySemKey.SequenceHasLongText AS MfgOrderSequenceHasLongText,
  cast(OrderSequenceBySemKey.Language as pph_longtextlang preserving type) AS LongTextLanguage,
  OrderSequenceBySemKey.SequenceCategory AS MfgOrderSequenceCategory,
  OrderSequenceBySemKey._SequenceCategory._Text[1: Language=$session.system_language].SequenceCategoryName AS SequenceCategoryName,
  OrderSequenceBySemKey.SequenceSchedulingAlignment AS SequenceSchedulingAlignment,
  OrderSequenceBySemKey._SequenceSchedulingAlignment._Text[1: Language=$session.system_language].SequenceSchedulingAlgnmtName AS SequenceSchedulingAlgnmtName,
  cast( '' as xfeld) AS SequenceExchangeIsPossible,
  OrderSequenceBySemKey.ReferenceSequence AS ReferenceSequence,
  ReferenceSequence.SequenceText AS BOOReferenceSequenceText,
  OrderSequenceBySemKey.BranchOperationInternalID AS BranchOperationInternalID,
  cast(BranchOperation.Operation_2 as vdm_vornr1 preserving type) AS MfgOrderSequenceBrnchOperation,
  BranchOperation.OperationText AS BOOSqncBranchOperationText,
  OrderSequenceBySemKey.ReturnOperationInternalID AS ReturnOperationInternalID,
  cast(ReturnOperation.Operation_2 as vdm_vornr2 preserving type) AS MfgOrderSequenceRetOperation,
  ReturnOperation.OperationText AS BOOSqncReturnOperationText,
  cast(OrderSequenceBySemKey.OrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(OrderSequenceBySemKey.OrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  OrderSequenceBySemKey.ProductionPlant AS ProductionPlant,
  OrderSequenceBySemKey.BillOfOperationsUnit AS BillOfOperationsUnit,
  OrderSequenceBySemKey.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  OrderSequenceBySemKey.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  OrderSequenceBySemKey._SequenceCategory AS _SequenceCategory,
  OrderSequenceBySemKey._SequenceSchedulingAlignment AS _SequenceSchedulingAlignment,
  OrderSequenceBySemKey._Plant AS _Plant,
  OrderSequenceBySemKey._Language AS _Language
FROM I_OrderSequenceBySemKey AS OrderSequenceBySemKey
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _ReferenceSequence ON ManufacturingOrder = _ReferenceSequence.ManufacturingOrder AND ReferenceSequence = _ReferenceSequence.ManufacturingOrderSequence  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderSequenceLongText AS _MfgOrderSequenceLongText ON OrderInternalID = _MfgOrderSequenceLongText.OrderInternalID AND SequenceInternalID = _MfgOrderSequenceLongText.SequenceInternalID AND LongTextLanguage = _MfgOrderSequenceLongText.LongTextLanguage  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
;