I_JITOutbRtgAssemblySeqCube

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_JITOutbRtgAssemblySeqCube.
-- 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: IJITREMASMSEQCU

CREATE VIEW I_JITOutbRtgAssemblySeqCube AS
SELECT
  JustInTimeRoutingSequence,
  BillOfOperationsGroup,
  BillOfOperationsType,
  BillOfOperationsVariant,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  Plant,
  PlannedOrder,
  Material,
  JustInTimeTakt,
  JITIsBufferIndicatorCode,
  JustInTimeAssemblyLineType,
  JustInTimeAssemblyLineCategory,
  JITPreviousReportingPoint,
  JustInTimeNextReportingPoint,
  JITAssemblyStatus,
  JustInTimeRoutingProductionID,
  ConfirmationEntryQuantity,
  BaseUnit,
  cast ( JITAssemblyConfDateTime as njit_assembly_date_time ) AS JITAssemblyConfDateTime,
  cast ( JITSequenceCreationDateTime as njit_assembly_date_time ) AS JITSequenceCreationDateTime,
  cast ( JITSequenceLastChangeDateTime as njit_assembly_date_time ) AS JITSequenceLastChangeDateTime,
  JITAssemblyLineTypeDesc,
  JITAssemblyLineCategoryDesc,
  JITAssemblyStatusDesc,
  cast( 1 as abap.int4 ) AS NumberOfPlannedOrders,
  BillOfOperationsRefType,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  BOORefOperationInternalID,
  BOORefOpInternalVersion,
  JustInTimeTaktOperationNumber,
  JITTaktOperationNumberDesc
FROM I_JITOutbRtgAssemblySeqData AS _JITOutbRtgAssemblySeqData
LEFT OUTER JOIN C_JITOutbPlantVH AS _JITOutbPlantVH ON Plant = _JITOutbPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbTaskListGroupVH AS _JITOutbTaskListGroupVH ON BillOfOperationsGroup = _JITOutbTaskListGroupVH.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN C_JITOutbRtgRptgPtVH AS _JITOutbPrevReportingPointVH ON JITPreviousReportingPoint = _JITOutbPrevReportingPointVH.Operation_2  -- association [0..1]
LEFT OUTER JOIN C_JITOutbRtgTaktOpNmbrVH AS _JITOutbTaktOperationVH ON JustInTimeTaktOperationNumber = _JITOutbTaktOperationVH.Operation_2  -- association [0..1]
LEFT OUTER JOIN C_JITOutbRtgRptgPtVH AS _JITOutbNextReportingPointVH ON JustInTimeNextReportingPoint = _JITOutbNextReportingPointVH.Operation_2  -- association [0..1]
LEFT OUTER JOIN C_JITPlannedOrderVH AS _JITPlannedOrderVH ON PlannedOrder = _JITPlannedOrderVH.PlannedOrder  -- association [0..1]
LEFT OUTER JOIN C_JITOutbRtgTskListGrpCntrVH AS _JITOutbRtgTskListGrpCntrVH ON BillOfOperationsVariant = _JITOutbRtgTskListGrpCntrVH.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN C_Materialvh AS _MaterialVH ON Material = _MaterialVH.Material  -- association [0..1]
LEFT OUTER JOIN E_JITOutbRtgAssemblySeqBasic AS _Extension ON JustInTimeRoutingSequence = _Extension.JustInTimeRoutingSequence AND BillOfOperationsGroup = _Extension.BillOfOperationsGroup AND BillOfOperationsType = _Extension.BillOfOperationsType AND BillOfOperationsVariant = _Extension.BillOfOperationsVariant  -- association [0..1]
;