I_RoutingOpSqncAllocSrchMod

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_RoutingOpSqncAllocSrchMod.
-- 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.

CREATE VIEW I_RoutingOpSqncAllocSrchMod AS
SELECT
  plas.plnty AS BillOfOperationsType,
  plas.plnnr AS BillOfOperationsGroup,
  plas.plnal AS BillOfOperationsVariant,
  plas.plnfl AS BillOfOperationsSequence,
  plas.plnkn AS BOOOperationInternalID,
  plas.zaehl AS BOOSqncOpAssgmtIntVersionCntr,
  cast(plas.datuv as vdm_v_validity_start_date preserving type) AS ValidityStartDate,
  cast(plas.valid_to as vdm_v_validity_end_date preserving type) AS ValidityEndDate,
  plas.loekz AS IsDeleted,
  plas.loekz_inherited AS IsImplicitlyDeleted,
  cast (plas.aennr as changenumber preserving type) AS ChangeNumber,
  cast (plas.andat as creationdate preserving type) AS CreationDate,
  cast (plas.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  cast (plas.aedat as lastchangedate preserving type) AS LastChangeDate,
  cast (plas.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  plas.versn AS BillOfOperationsVersion
FROM plas
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [1..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_RoutingOperationSearchModel AS _RtgOpSrchModel ON BillOfOperationsType = _RtgOpSrchModel.BillOfOperationsType AND BillOfOperationsGroup = _RtgOpSrchModel.BillOfOperationsGroup AND BOOOperationInternalID = _RtgOpSrchModel.BOOOperationInternalID  -- association [0..*]
;