I_MRPPurchasingInfoRecord

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_MRPPurchasingInfoRecord.
-- 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: IMRPPURGINFOREC

CREATE VIEW I_MRPPurchasingInfoRecord AS
SELECT
  eina.matnr AS ManufacturerMaterial,
  mara.matnr AS Material,
  t024w.werks AS Plant,
  eina.lifab AS ValidityStartDate,
  case eina.lifbi when '00000000' then '99991231' else eina.lifbi end as ValidityEndDate AS lifbiendasValidityEndDate,
  eina.lifnr AS PreferredSupplier,
  case eine.minbm when 0 then eine.minbm else case eina.umren when 0 then eine.minbm else division((eine.minbm * eina.umrez), eina.umren, 3) end end as MaterialMinLotSizeQuantity AS umren3endendasMaterialMinLotSizeQuantity,
  case eine.bstma when 0 then cast('9999999999' as abap.dec(13,3)) else case eina.umren when 0 then eine.bstma else division((eine.bstma * eina.umrez), eina.umren, 3) end end as MaterialMaxLotSizeQuantity AS umren3endendasMaterialMaxLotSizeQuantity,
  eine.aut_source AS IsRelevantForAutomSrcg,
  eine.netpr AS PurgDocNetPriceAmount,
  eine.waers AS PurgDocTransactionCurrency,
  eine.peinh AS PurgDocNetPriceQuantity,
  eina.infnr AS ActivePurchasingInfoRecord,
  eine.ekorg AS PurchasingOrganization,
  eine.esokz AS PurchasingInfoRecordCategory,
  eine.ekgrp AS PurchasingGroup,
  marc.webaz AS GoodsReceiptDuration,
  eine.aplfz AS PlannedDeliveryDuration,
  eine.verid AS ProductionVersion,
  eine.rdprf AS RoundingProfile,
  case eine.werks when '' then '' else 'X' end as PurgDocHasPlant AS werkswhenthenelseXendasPurgDocHasPlant,
  eina.matkl AS ProductVariantGroup,
  '' AS PurgDocHasRefPurchasingOrg,
  mara.mprof as ManufacturerPartProfile AS matnrasManufacturerMaterial,
  mara.mprof AS ManufacturerPartProfile
FROM eina
INNER JOIN eine ON /* join condition not captured in parsed metadata */
;