I_SchedulingAgreementHistory

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_SchedulingAgreementHistory.
-- 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: IMMSAGMTHISTORY

CREATE VIEW I_SchedulingAgreementHistory AS
SELECT
  History.PurchasingDocument AS SchedulingAgreement,
  History.PurchasingDocumentItem AS SchedulingAgreementItem,
  History.AccountAssignmentNumber AS AccountAssignmentNumber,
  History.PurchasingHistoryDocumentType AS PurchaseOrderTransactionType,
  History.PurchasingHistoryDocumentYear AS MaterialDocumentYear,
  History.PurchasingHistoryDocument AS MaterialDocument,
  History.PurchasingHistoryDocumentItem AS MaterialDocumentItem,
  History.PurchasingHistoryCategory AS PurchaseOrderHistCategory,
  History.GoodsMovementType AS GoodsMovementType,
  History.PostingDate AS PostingDate,
  History.Currency AS Currency,
  History.DebitCreditCode AS DebitCreditCode,
  History.IsCompletelyDelivered AS IsCompletelyDelivered,
  History.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  History.ReferenceDocument AS ReferenceDocument,
  History.ReferenceDocumentItem AS ReferenceDocumentItem,
  History.Material AS Material,
  History.Plant AS Plant,
  History.RvslOfGoodsReceiptIsAllowed AS RvslOfGoodsReceiptIsAllowed,
  History.PricingDocument AS PricingDocument,
  History.TaxCode AS TaxCode,
  History.DocumentDate AS DocumentDate,
  History.CreatedByUser AS CreatedByUser,
  History.InventoryValuationType AS InventoryValuationType,
  History.DocumentReferenceID AS DocumentReferenceID,
  History.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  History.ManufacturerMaterial AS ManufacturerMaterial,
  History.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  History.PurgHistDocumentCreationTime AS PurgHistDocumentCreationTime,
  History.Quantity AS Quantity,
  History.PurOrdAmountInCompanyCodeCrcy AS PurOrdAmountInCompanyCodeCrcy,
  History.PurchaseOrderAmount AS PurchaseOrderAmount,
  History.QtyInPurchaseOrderPriceUnit AS QtyInPurchaseOrderPriceUnit,
  History.GRIRAcctClrgAmtInCoCodeCrcy AS GRIRAcctClrgAmtInCoCodeCrcy,
  History.GdsRcptBlkdStkQtyInOrdQtyUnit AS GdsRcptBlkdStkQtyInOrdQtyUnit,
  History.GdsRcptBlkdStkQtyInOrdPrcUnit AS GdsRcptBlkdStkQtyInOrdPrcUnit,
  History.InvoiceAmtInCoCodeCrcy AS InvoiceAmtInCoCodeCrcy,
  History.ShipgInstrnSupplierCompliance AS ShipgInstrnSupplierCompliance,
  History.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  History.QuantityInDeliveryQtyUnit AS QuantityInDeliveryQtyUnit,
  History.GRIRAcctClrgAmtInTransacCrcy AS GRIRAcctClrgAmtInTransacCrcy,
  History.QuantityInBaseUnit AS QuantityInBaseUnit,
  History.Batch AS Batch,
  History.GRIRAcctClrgAmtInOrdTrnsacCrcy AS GRIRAcctClrgAmtInOrdTrnsacCrcy,
  History.InvoiceAmtInPurOrdTransacCrcy AS InvoiceAmtInPurOrdTransacCrcy,
  History.VltdGdsRcptBlkdStkQtyInOrdUnit AS VltdGdsRcptBlkdStkQtyInOrdUnit,
  History.VltdGdsRcptBlkdQtyInOrdPrcUnit AS VltdGdsRcptBlkdQtyInOrdPrcUnit,
  History.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  History.ExchangeRateDifferenceAmount AS ExchangeRateDifferenceAmount,
  History.ExchangeRate AS ExchangeRate,
  History.DeliveryDocument AS DeliveryDocument,
  History.DeliveryDocumentItem AS DeliveryDocumentItem,
  History.BaseUnit AS BaseUnit,
  _SchedulingAgreementItem.OrderQuantityUnit AS OrderQuantityUnit,
  _SchedulingAgreementItem.OrderPriceUnit AS OrderPriceUnit
FROM I_PurchasingDocumentHistory AS History
INNER JOIN I_Schedgagrmthdr AS SchedulingAgreement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderHistCategory AS _PurchaseOrderHistCategory ON PurchaseOrderHistCategory = _PurchaseOrderHistCategory.PurchaseOrderHistCategory  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmthdr AS _SchedulingAgreement ON SchedulingAgreement = _SchedulingAgreement.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtItm AS _SchedulingAgreementItem ON SchedulingAgreementItem = _SchedulingAgreementItem.SchedulingAgreementItem AND SchedulingAgreement = _SchedulingAgreementItem.SchedulingAgreement  -- association [1..1]
;