I_PurchasingInfoRecordApi01

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_PurchasingInfoRecordApi01.
-- 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: IPURGINFORECD

CREATE VIEW I_PurchasingInfoRecordApi01 AS
SELECT
  I_PurchasingInfoRecord.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurchasingInfoRecord.Supplier AS Supplier,
  I_PurchasingInfoRecord.Material AS Material,
  I_PurchasingInfoRecord.MaterialGroup AS MaterialGroup,
  I_PurchasingInfoRecord.CreationDate AS CreationDate,
  I_PurchasingInfoRecord.IsDeleted AS IsDeleted,
  I_PurchasingInfoRecord.PurchasingInfoRecordDesc AS PurchasingInfoRecordDesc,
  I_PurchasingInfoRecord.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  I_PurchasingInfoRecord.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  I_PurchasingInfoRecord.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  I_PurchasingInfoRecord.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_PurchasingInfoRecord.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  I_PurchasingInfoRecord.SupplierPhoneNumber AS SupplierPhoneNumber,
  I_PurchasingInfoRecord.BaseUnit AS BaseUnit,
  I_PurchasingInfoRecord.SupplierMaterialGroup AS SupplierMaterialGroup,
  I_PurchasingInfoRecord.PriorSupplier AS PriorSupplier,
  I_PurchasingInfoRecord.VarblPurOrdUnitIsActive AS VarblPurOrdUnitIsActive,
  I_PurchasingInfoRecord.Manufacturer AS Manufacturer,
  I_PurchasingInfoRecord.IsRegularSupplier AS IsRegularSupplier,
  I_PurchasingInfoRecord.SupplierSubrange AS SupplierSubrange,
  I_PurchasingInfoRecord.NoDaysReminder1 AS NoDaysReminder1,
  I_PurchasingInfoRecord.NoDaysReminder2 AS NoDaysReminder2,
  I_PurchasingInfoRecord.NoDaysReminder3 AS NoDaysReminder3,
  I_PurchasingInfoRecord.ProductPurchasePointsQty AS ProductPurchasePointsQty,
  I_PurchasingInfoRecord.ProductPurchasePointsQtyUnit AS ProductPurchasePointsQtyUnit,
  I_PurchasingInfoRecord.ReturnAgreement AS ReturnAgreement,
  I_PurchasingInfoRecord.SupplierCertOriginCat AS SupplierCertOriginCat,
  I_PurchasingInfoRecord.SupplierCertOriginNumber AS SupplierCertOriginNumber,
  I_PurchasingInfoRecord.SupplierCertValidityEndDate AS SupplierCertValidityEndDate,
  I_PurchasingInfoRecord.SupplierCertOriginCountry AS SupplierCertOriginCountry,
  I_PurchasingInfoRecord.SupplierCertOriginRegion AS SupplierCertOriginRegion,
  I_PurchasingInfoRecord.SuplrCertOriginClassfctnNumber AS SuplrCertOriginClassfctnNumber,
  I_PurchasingInfoRecord.SupplierSubrangeSortNumber AS SupplierSubrangeSortNumber
FROM I_PurchasingInfoRecord
LEFT OUTER JOIN I_PurgInfoRecdOrgPlntDataApi01 AS _PurgInfoRecdOrgPlntDataApi01 ON PurchasingInfoRecord = _PurgInfoRecdOrgPlntDataApi01.PurchasingInfoRecord  -- association [1..*]
;