I_JITOutbPPEAssemblySeqCube

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_JITOutbPPEAssemblySeqCube.
-- 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: IJITPPEASMSEQCU

CREATE VIEW I_JITOutbPPEAssemblySeqCube AS
SELECT
  JITFactoryLayoutSequence,
  JITAssemblyLineNetworkUUID,
  JustInTimeAssemblyLineUUID,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyLineNetworkName AS JITAssemblyLineNetworkName,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyLineName AS JITAssemblyLineName,
  _JITOutbPPEAssemblySeqDEX.PlannedOrder AS PlannedOrder,
  _JITOutbPPEAssemblySeqDEX.JITFactoryLayoutSubSequence AS JITFactoryLayoutSubSequence,
  _JITOutbPPEAssemblySeqDEX.Plant AS Plant,
  _JITOutbPPEAssemblySeqDEX.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _JITOutbPPEAssemblySeqDEX.JustInTimeAssemblyLineCategory AS JustInTimeAssemblyLineCategory,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyLineCategoryDesc AS JITAssemblyLineCategoryDesc,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyNextLineName AS JITAssemblyNextLineName,
  _JITOutbPPEAssemblySeqDEX.JustInTimeTakt AS JustInTimeTakt,
  _JITOutbPPEAssemblySeqDEX.JITIsBufferIndicatorCode AS JITIsBufferIndicatorCode,
  _JITOutbPPEAssemblySeqDEX.JITPreviousReportingPointName AS JITPreviousReportingPointName,
  _JITOutbPPEAssemblySeqDEX.JITNextReportingPointName AS JITNextReportingPointName,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyStatus AS JITAssemblyStatus,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyStatusDesc AS JITAssemblyStatusDesc,
  cast (_JITOutbPPEAssemblySeqDEX.JITAssemblyConfDateTime as njit_assembly_date_time ) AS JITAssemblyConfDateTime,
  cast (_JITOutbPPEAssemblySeqDEX.JITSequenceCreationDateTime as njit_assembly_date_time ) AS JITSequenceCreationDateTime,
  cast (_JITOutbPPEAssemblySeqDEX.JITSequenceLastChangeDateTime as njit_assembly_date_time ) AS JITSequenceLastChangeDateTime,
  cast ( _JITOutbPPEAssemblySeqDEX.JITFctryLaytSequenceReference as njit_s2p_seq_id ) AS JITFctryLaytSequenceReference,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyStatusCriticality AS JITAssemblyStatusCriticality,
  _JITOutbPPEAssemblySeqDEX.JITSequenceIsForPreAssembly AS JITSequenceIsForPreAssembly,
  _JITOutbPPEAssemblySeqDEX.JITSequenceForPreAssemblyDesc AS JITSequenceForPreAssemblyDesc,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyLineSegmentName AS JITAssemblyLineSegmentName,
  _JITOutbPPEAssemblySeqDEX.JITAssemblyLineBufferName AS JITAssemblyLineBufferName,
  JustInTimeAssemblyNextLineUUID,
  JITPreviousReportingPointUUID,
  JITNextReportingPointUUID,
  JITLineSegmentUUID,
  JITLineBufferUUID,
  1 AS NumberOfPlannedOrders
FROM I_JITOutbPPEAssemblySeqDEX AS _JITOutbPPEAssemblySeqDEX
LEFT OUTER JOIN C_JITOutbPlantVH AS _JITOutbPlantVH ON Plant = _JITOutbPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbLineNetworkVH AS _JITOutbLineNetworkVH ON JITAssemblyLineNetworkName = _JITOutbLineNetworkVH.JITAssemblyLineNetworkName  -- association [0..1]
LEFT OUTER JOIN C_JITOutbLineVH AS _JITOutbLineVH ON JITAssemblyLineName = _JITOutbLineVH.JITAssemblyLineName  -- association [0..1]
LEFT OUTER JOIN C_JITOutbLineVH AS _JITOutbNextLineVH ON JITAssemblyNextLineName = _JITOutbNextLineVH.JITAssemblyLineName  -- association [0..1]
LEFT OUTER JOIN C_JITOutbReportingPointVH AS _JITOutbPrevReportingPointVH ON JITPreviousReportingPointName = _JITOutbPrevReportingPointVH.JITPreviousReportingPointName  -- association [0..1]
LEFT OUTER JOIN C_JITOutbReportingPointVH AS _JITOutbNextReportingPointVH ON JITNextReportingPointName = _JITOutbNextReportingPointVH.JITPreviousReportingPointName  -- association [0..1]
LEFT OUTER JOIN C_JITPlannedOrderVH AS _JITPlannedOrderVH ON PlannedOrder = _JITPlannedOrderVH.PlannedOrder  -- association [0..1]
LEFT OUTER JOIN C_JITOutbLineSegmentVH AS _JITOutbLineSegmentVH ON JITAssemblyLineSegmentName = _JITOutbLineSegmentVH.JITAssemblyLineSegmentName  -- association [0..1]
LEFT OUTER JOIN C_JITOutbLineBufferVH AS _JITOutbLineBufferVH ON JITAssemblyLineBufferName = _JITOutbLineBufferVH.JITAssemblyLineBufferName  -- 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]
LEFT OUTER JOIN E_JITOutbPreAssemblySeqBasic AS _ExtensionPreAsm ON JITFactoryLayoutSequence = _ExtensionPreAsm.JITFactoryLayoutSequence AND JITAssemblyLineNetworkUUID = _ExtensionPreAsm.JITAssemblyLineNetworkUUID AND JustInTimeAssemblyLineUUID = _ExtensionPreAsm.JustInTimeAssemblyLineUUID  -- association [0..1]
;