I_JITOutbPreAssemblySeqBasic

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_JITOutbPreAssemblySeqBasic.
-- 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: IJITPREASMSEQ

CREATE VIEW I_JITOutbPreAssemblySeqBasic AS
SELECT
  jitpreassemblyseq AS JITFactoryLayoutSequence,
  jitassemblylinenetwork AS JITAssemblyLineNetworkUUID,
  jitassemblyline AS JustInTimeAssemblyLineUUID,
  planned_order AS PlannedOrder,
  jitppesequence AS JITFctryLaytSequenceReference,
  jitassemblynextline AS JustInTimeAssemblyNextLineUUID,
  jittakt AS JustInTimeTakt,
  jitpreviousreportingpoint AS JITPreviousReportingPointUUID,
  jitnextreportingpoint AS JITNextReportingPointUUID,
  JITPreAssemblyStatus,
  cast ('3' as njit_s2p_ppe_asm_line_cat ) AS JustInTimeAssemblyLineCategory,
  cast ('X' as njit_boolean preserving type ) AS JITSequenceIsForPreAssembly,
  jitbufferindicator AS JITIsBufferIndicatorCode,
  JITAssemblyConfDateTime,
  JITSequenceCreationDateTime,
  JITSequenceLastChangeDateTime,
  jitassemblylinesegment AS JITLineSegmentUUID,
  jitassemblylinebuffer AS JITLineBufferUUID
FROM njit_preasm_seq AS _PreAssembly
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_JITOutbAssemblyLineCat AS _JITOutbAssemblyLineCat ON JustInTimeAssemblyLineCategory = _JITOutbAssemblyLineCat.JustInTimeAssemblyLineCategory  -- association [0..1]
LEFT OUTER JOIN E_JITOutbPreAssemblySeqBasic AS _ExtensionPreAsm ON JITFactoryLayoutSequence = _ExtensionPreAsm.JITFactoryLayoutSequence AND JITAssemblyLineNetworkUUID = _ExtensionPreAsm.JITAssemblyLineNetworkUUID AND JustInTimeAssemblyLineUUID = _ExtensionPreAsm.JustInTimeAssemblyLineUUID  -- association [0..1]
;