I_JITOutbPPEAssemblySeqBasic

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_JITOutbPPEAssemblySeqBasic.
-- 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: IJITPPEASMSEQ

CREATE VIEW I_JITOutbPPEAssemblySeqBasic AS
SELECT
  _asm_seq.jitppesequence AS JITFactoryLayoutSequence,
  _asm_seq.jitassemblylinenetwork AS JITAssemblyLineNetworkUUID,
  _asm_seq.jitassemblyline AS JustInTimeAssemblyLineUUID,
  _asm_seq.jitppesubsequence AS JITFactoryLayoutSubSequence,
  _asm_seq.plant AS Plant,
  _asm_seq.planned_order AS PlannedOrder,
  _asm_seq.vehicleidentificationnumber AS VehicleIdentificationNumber,
  _asm_seq.jitassemblylinetype AS JustInTimeAssemblyLineType,
  _asm_seq.jitassemblylinecategory AS JustInTimeAssemblyLineCategory,
  _asm_seq.jitassemblynextline AS JustInTimeAssemblyNextLineUUID,
  _asm_seq.jittakt AS JustInTimeTakt,
  _asm_seq.jitbufferindicator AS JITIsBufferIndicatorCode,
  _asm_seq.jitpreviousreportingpoint AS JITPreviousReportingPointUUID,
  _asm_seq.jitnextreportingpoint AS JITNextReportingPointUUID,
  _asm_seq.jitassemblystatus AS JITAssemblyStatus,
  cast ('' as njit_boolean preserving type ) AS JITSequenceIsForPreAssembly,
  _asm_seq.jitassemblyconfdatetime AS JITAssemblyConfDateTime,
  _asm_seq.jitsequencecreationdatetime AS JITSequenceCreationDateTime,
  _asm_seq.jitsequencelastchangedatetime AS JITSequenceLastChangeDateTime,
  _asm_seq.jitassemblylinesegment AS JITLineSegmentUUID,
  _asm_seq.jitassemblylinebuffer AS JITLineBufferUUID
FROM njit_ppe_asm_seq AS _asm_seq
LEFT OUTER JOIN I_JITOutbPPEFactoryLayoutBsc AS _LineNetwork ON JITAssemblyLineNetworkUUID = _LineNetwork.FactoryLayoutNodeUUID AND _LineNetwork.FactoryLayoutNodeType = 'S_FLOLNT'  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPPEFactoryLayoutBsc AS _Line ON JustInTimeAssemblyLineUUID = _Line.FactoryLayoutNodeUUID AND ( _Line.FactoryLayoutNodeType = 'S_FLOLIN' OR _Line.FactoryLayoutNodeType = 'S_FLOBUF' OR _Line.FactoryLayoutNodeType = 'S_FLODCP' )  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPPEFactoryLayoutBsc AS _LineNext ON JustInTimeAssemblyNextLineUUID = _LineNext.FactoryLayoutNodeUUID AND ( _LineNext.FactoryLayoutNodeType = 'S_FLOLIN' OR _LineNext.FactoryLayoutNodeType = 'S_FLOBUF' OR _LineNext.FactoryLayoutNodeType = 'S_FLODCP' )  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPPERptgPtBsc AS _ReportingPointPrev ON JITPreviousReportingPointUUID = _ReportingPointPrev.ReportingPointUUID  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPPERptgPtBsc AS _ReportingPointNext ON JITNextReportingPointUUID = _ReportingPointNext.ReportingPointUUID  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPPEFactoryLayoutBsc AS _LineSegment ON JITLineSegmentUUID = _LineSegment.FactoryLayoutNodeUUID AND _LineSegment.FactoryLayoutNodeType = 'S_FLOLSG'  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPPEFactoryLayoutBsc AS _LineBuffer ON JITLineBufferUUID = _LineBuffer.FactoryLayoutNodeUUID AND _LineBuffer.FactoryLayoutNodeType = 'S_FLODCP'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [0..1]
LEFT OUTER JOIN I_JITOutbAssemblyStatus AS _JITOutbAssemblyStatus ON JITAssemblyStatus = _JITOutbAssemblyStatus.JITAssemblyStatus  -- association [0..1]
LEFT OUTER JOIN I_JITOutbSupToProdnFlag AS _JITOutbSupToProdnFlag ON JITSequenceIsForPreAssembly = _JITOutbSupToProdnFlag.JITIsSupToProdnFlag  -- association [0..1]
LEFT OUTER JOIN I_JITOutbAssemblyLineCat AS _JITOutbAssemblyLineCat ON JustInTimeAssemblyLineCategory = _JITOutbAssemblyLineCat.JustInTimeAssemblyLineCategory  -- association [0..1]
LEFT OUTER JOIN I_JITOutbAssemblyLineType AS _JITOutbAssemblyLineType ON JustInTimeAssemblyLineType = _JITOutbAssemblyLineType.JustInTimeAssemblyLineType  -- association [0..1]
LEFT OUTER JOIN E_JITOutbPPEAssemblySeqBasic AS _ExtensionAsm ON JITFactoryLayoutSequence = _ExtensionAsm.JITFactoryLayoutSequence AND JITAssemblyLineNetworkUUID = _ExtensionAsm.JITAssemblyLineNetworkUUID AND JustInTimeAssemblyLineUUID = _ExtensionAsm.JustInTimeAssemblyLineUUID  -- association [0..1]
;