I_JITOutbRtgAssemblySeqBasic

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_JITOutbRtgAssemblySeqBasic.
-- 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: IJITREMASMSEQ

CREATE VIEW I_JITOutbRtgAssemblySeqBasic AS
SELECT
  jitremsequence AS JustInTimeRoutingSequence,
  groupnumber AS BillOfOperationsGroup,
  plnty AS BillOfOperationsType,
  plnal AS BillOfOperationsVariant,
  plnkn AS BOOOperationInternalID,
  zaehl AS BOOOpInternalVersionCounter,
  Plant,
  planned_order AS PlannedOrder,
  Material,
  jittakt AS JustInTimeTakt,
  cast( jittaktoperationnumber as vdm_vornr preserving type) AS JustInTimeTaktOperationNumber,
  jitbufferindicator AS JITIsBufferIndicatorCode,
  jitassemblylinetype AS JustInTimeAssemblyLineType,
  jitassemblylinecategory AS JustInTimeAssemblyLineCategory,
  cast( jitpreviousreportingpoint as vdm_vornr preserving type) AS JITPreviousReportingPoint,
  cast( jitnextreportingpoint as vdm_vornr preserving type) AS JustInTimeNextReportingPoint,
  JITAssemblyStatus,
  jitproductionid AS JustInTimeRoutingProductionID,
  confirmedquantity AS ConfirmationEntryQuantity,
  unitofmeasure AS BaseUnit,
  JITAssemblyConfDateTime,
  JITSequenceCreationDateTime,
  JITSequenceLastChangeDateTime,
  vplty AS BillOfOperationsRefType,
  cast (vplnr as billofoperationsrefgroup preserving type) AS BillOfOperationsRefGroup,
  cast (vplal as billofoperationsrefvariant preserving type) AS BillOfOperationsRefVariant,
  vplnkn AS BOORefOperationInternalID,
  vzaehl AS BOORefOpInternalVersion
FROM njit_rem_asm_seq
LEFT OUTER JOIN I_JITOutbAssemblyStatus AS _JITOutbAssemblyStatus ON JITAssemblyStatus = _JITOutbAssemblyStatus.JITAssemblyStatus  -- 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 I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS _OperationDescription ON JustInTimeTaktOperationNumber = _OperationDescription.Operation_2 AND BillOfOperationsType = _OperationDescription.BillOfOperationsType AND BillOfOperationsGroup = _OperationDescription.BillOfOperationsGroup AND BOOOperationInternalID = _OperationDescription.BOOOperationInternalID AND BOOOpInternalVersionCounter = _OperationDescription.BOOOpInternalVersionCounter  -- 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]
;