C_PurchasingInfoRecordDEX

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 C_PurchasingInfoRecordDEX.
-- 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: CMMPURINFORECDEX

CREATE VIEW C_PurchasingInfoRecordDEX AS
SELECT
  PurchasingInfoRecord,
  Supplier,
  Material,
  MaterialGroup,
  CreationDate,
  IsDeleted,
  PurchasingInfoRecordDesc,
  PurgDocOrderQuantityUnit,
  cast ( OrderItemQtyToBaseQtyNmrtr as umbsz_ll preserving type) AS OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  SupplierMaterialNumber,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  BaseUnit,
  SupplierMaterialGroup,
  PriorSupplier,
  VarblPurOrdUnitIsActive,
  Manufacturer,
  IsRegularSupplier,
  SupplierSubrange,
  NoDaysReminder1,
  NoDaysReminder2,
  NoDaysReminder3,
  ProductPurchasePointsQty,
  ProductPurchasePointsQtyUnit,
  ReturnAgreement,
  SupplierCertOriginCat,
  SupplierCertOriginNumber,
  SupplierCertValidityEndDate,
  SupplierCertOriginCountry,
  SupplierCertOriginRegion,
  SuplrCertOriginClassfctnNumber,
  SupplierSubrangeSortNumber
FROM I_PurchasingInfoRecordApi01
LEFT OUTER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS _PurgInfoRecdOrgPlntDataApi01 ON PurchasingInfoRecord = _PurgInfoRecdOrgPlntDataApi01.PurchasingInfoRecord  -- association [1..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON MaterialGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurgDocOrderQuantityUnit ON PurgDocOrderQuantityUnit = _PurgDocOrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PriorSupplier ON PriorSupplier = _PriorSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Manufacturer ON Manufacturer = _Manufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductPurchasePointsQtyUnit ON ProductPurchasePointsQtyUnit = _ProductPurchasePointsQtyUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON SupplierCertOriginCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON SupplierCertOriginCountry = _Region.Country AND SupplierCertOriginRegion = _Region.Region  -- association [0..1]
;