I_PurchasingInfoRecord

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_PurchasingInfoRecord.
-- 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: IPURINFREC

CREATE VIEW I_PurchasingInfoRecord AS
SELECT
  infnr AS PurchasingInfoRecord,
  lifnr AS Supplier,
  matnr AS Material,
  matkl AS MaterialGroup,
  erdat AS CreationDate,
  loekz AS IsDeleted,
  ernam AS CreatedByUser,
  txz01 AS PurchasingInfoRecordDesc,
  sortl AS PurgInfoRecNonStockItmSortTerm,
  meins AS PurgDocOrderQuantityUnit,
  umrez AS OrderItemQtyToBaseQtyNmrtr,
  umren AS OrderItemQtyToBaseQtyDnmntr,
  idnlf AS SupplierMaterialNumber,
  verkf AS SupplierRespSalesPersonName,
  telf1 AS SupplierPhoneNumber,
  lmein AS BaseUnit,
  wglif AS SupplierMaterialGroup,
  kolif AS PriorSupplier,
  lifab AS AvailabilityStartDate,
  lifbi AS AvailabilityEndDate,
  vabme AS VarblPurOrdUnitIsActive,
  mfrnr AS Manufacturer,
  relif AS IsRegularSupplier,
  ltsnr AS SupplierSubrange,
  mahn1 AS NoDaysReminder1,
  mahn2 AS NoDaysReminder2,
  mahn3 AS NoDaysReminder3,
  anzpu AS ProductPurchasePointsQty,
  punei AS ProductPurchasePointsQtyUnit,
  rueck AS ReturnAgreement,
  urztp AS SupplierCertOriginCat,
  urznr AS SupplierCertOriginNumber,
  urzdt AS SupplierCertValidityEndDate,
  urzla AS SupplierCertOriginCountry,
  regio AS SupplierCertOriginRegion,
  urzzt AS SuplrCertOriginClassfctnNumber,
  ltssf AS SupplierSubrangeSortNumber,
  LastChangeDateTime,
  eina.iseopblocked AS IsEndOfPurposeBlocked
FROM eina
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS _PurgInfoRecdOrgPlantData ON PurchasingInfoRecord = _PurgInfoRecdOrgPlantData.PurchasingInfoRecord  -- association [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 [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurgDocOrderQuantityUnit ON PurgDocOrderQuantityUnit = _PurgDocOrderQuantityUnit.UnitOfMeasure  -- association [0..1]
;