I_PurchaseOrderHistoryBasic

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_PurchaseOrderHistoryBasic.
-- 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: IMMPURORDHIST

CREATE VIEW I_PurchaseOrderHistoryBasic AS
SELECT
  PurchasingDocument AS PurchaseOrder,
  PurchasingDocumentItem AS PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PurchasingHistoryCategory,
  GoodsMovementType,
  PostingDate,
  Currency,
  DebitCreditCode,
  IsCompletelyDelivered,
  ReferenceDocumentFiscalYear,
  ReferenceDocument,
  ReferenceDocumentItem,
  Material,
  Plant,
  RvslOfGoodsReceiptIsAllowed,
  history.PricingDocument AS PricingDocument,
  TaxCode,
  DocumentDate,
  history.CreatedByUser AS CreatedByUser,
  InventoryValuationType,
  DocumentReferenceID,
  DeliveryQuantityUnit,
  ManufacturerMaterial,
  AccountingDocumentCreationDate,
  PurgHistDocumentCreationTime,
  Quantity,
  PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderAmount,
  QtyInPurchaseOrderPriceUnit,
  GRIRAcctClrgAmtInCoCodeCrcy,
  GdsRcptBlkdStkQtyInOrdQtyUnit,
  GdsRcptBlkdStkQtyInOrdPrcUnit,
  InvoiceAmtInCoCodeCrcy,
  ShipgInstrnSupplierCompliance,
  InvoiceAmountInFrgnCurrency,
  QuantityInDeliveryQtyUnit,
  GRIRAcctClrgAmtInTransacCrcy,
  QuantityInBaseUnit,
  Batch,
  GRIRAcctClrgAmtInOrdTrnsacCrcy,
  InvoiceAmtInPurOrdTransacCrcy,
  VltdGdsRcptBlkdStkQtyInOrdUnit,
  VltdGdsRcptBlkdQtyInOrdPrcUnit,
  IsToBeAcceptedAtOrigin,
  ExchangeRateDifferenceAmount,
  history.ExchangeRate AS ExchangeRate,
  DeliveryDocument,
  DeliveryDocumentItem,
  OrderPriceUnit,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  BaseUnit,
  history.DocumentCurrency AS DocumentCurrency,
  history.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_PurchasingDocumentHistory AS history
INNER JOIN R_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON history.PurchasingDocument = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON history.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND history.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
;