C_JITOutbPPEAssemblySeqQry

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_JITOutbPPEAssemblySeqQry.
-- 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: CJITPPEASMSEQQR

CREATE VIEW C_JITOutbPPEAssemblySeqQry AS
SELECT
  JITFactoryLayoutSequence,
  JITAssemblyLineNetworkUUID,
  JustInTimeAssemblyLineUUID,
  JITAssemblyLineNetworkName,
  JITAssemblyLineName,
  JITFactoryLayoutSubSequence,
  PlannedOrder,
  Plant,
  VehicleIdentificationNumber,
  JITAssemblyNextLineName,
  JustInTimeTakt,
  JITIsBufferIndicatorCode,
  JITPreviousReportingPointName,
  JITNextReportingPointName,
  JITAssemblyStatus,
  JITAssemblyStatusDesc,
  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,
  JITFctryLaytSequenceReference,
  JITSequenceIsForPreAssembly,
  JITAssemblyStatusCriticality,
  JITSequenceForPreAssemblyDesc,
  JustInTimeAssemblyLineCategory,
  JITAssemblyLineCategoryDesc,
  JITAssemblyLineSegmentName,
  JITAssemblyLineBufferName,
  JustInTimeAssemblyLineVersion,
  NumberOfPlannedOrders
FROM I_JITOutbPPEAssemblySeqCube AS _JITOutbPPEAssemblySeqCube
LEFT OUTER JOIN C_JITOutbPlannedOrderOvw AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [0..1]
;