I_RoutingMaterialSearchModel

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_RoutingMaterialSearchModel.
-- 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_RoutingMaterialSearchModel AS
SELECT
  mapl.matnr AS Material,
  mapl.werks AS Plant,
  mapl.plnty AS BillOfOperationsType,
  mapl.plnnr AS BillOfOperationsGroup,
  mapl.plnal AS BillOfOperationsVariant,
  mapl.zkriz AS BOOToMaterialInternalID,
  mapl.zaehl AS BOOMatlInternalVersionCounter,
  mapl.datuv AS ValidityStartDate,
  mapl.valid_to AS ValidityEndDate,
  mapl.aennr AS ChangeNumber,
  mapl.andat AS CreationDate,
  cast(mapl.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  mapl.aedat AS LastChangeDate,
  cast(mapl.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  mapl.loekz AS IsDeleted,
  mapl.loekz_inherited AS IsImplicitlyDeleted,
  mapl.lifnr AS Supplier,
  mapl.kunr AS Customer,
  mapl.vbeln AS SalesOrder,
  mapl.posnr AS SalesOrderItem,
  cast(mapl.pspnr as pph_pspel preserving type) AS WBSElementInternalID,
  suchfeld AS BOOSearchText,
  mapl.versn AS BillOfOperationsVersion
FROM mapl
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_BOOMaterialAssignment AS _BOOMaterialAssignment ON Plant = _BOOMaterialAssignment.Plant AND Material = _BOOMaterialAssignment.Material AND BillOfOperationsType = _BOOMaterialAssignment.BillOfOperationsType AND BillOfOperationsGroup = _BOOMaterialAssignment.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOMaterialAssignment.BillOfOperationsVariant AND BOOToMaterialInternalID = _BOOMaterialAssignment.BOOToMaterialInternalID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
;