P_GRIRPurchaseOrderHistory1

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 P_GRIRPurchaseOrderHistory1.
-- 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: PFIGRIRPOHIS1

CREATE VIEW P_GRIRPurchaseOrderHistory1 AS
SELECT
  I_PurchasingDocumentHistory.PurchasingDocument AS PurchasingDocument,
  I_PurchasingDocumentHistory.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_PurchasingDocumentHistory.AccountAssignmentNumber AS AccountAssignmentNumber,
  cast( '000' as stunr preserving type) AS ConditionStep,
  cast( '000' as dzaehk preserving type) AS ConditionCount,
  I_PurchasingDocumentHistory.PurchasingHistoryDocumentType AS PurchasingHistoryDocumentType,
  cast( I_PurchasingDocumentHistory.PurchasingHistoryDocumentYear as fis_grir_mjahr preserving type ) AS PurchasingHistoryDocumentYear,
  I_PurchasingDocumentHistory.PurchasingHistoryDocument AS PurchasingHistoryDocument,
  I_PurchasingDocumentHistory.PurchasingHistoryDocumentItem AS PurchasingHistoryDocumentItem,
  I_PurchasingDocumentHistory.PurchasingHistoryCategory AS PurchasingHistoryCategory,
  I_PurchasingDocumentHistory.GoodsMovementType AS GoodsMovementType,
  I_PurchasingDocumentHistory.PostingDate AS PostingDate,
  I_PurchasingDocumentHistory.Currency AS Currency,
  I_PurchasingDocumentHistory.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( '' as kschl) AS ConditionType,
  I_PurchasingDocumentHistory.DebitCreditCode AS DebitCreditCode,
  I_PurchasingDocumentHistory.IsCompletelyDelivered AS IsCompletelyDelivered,
  I_PurchasingDocumentHistory.ReferenceDocument AS ReferenceDocument,
  cast( I_PurchasingDocumentHistory.ReferenceDocumentFiscalYear as fis_grir_lfbja preserving type ) AS ReferenceDocumentFiscalYear,
  I_PurchasingDocumentHistory.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_PurchasingDocumentHistory.Material AS Material,
  I_PurchasingDocumentHistory.DocumentDate AS DocumentDate,
  I_PurchasingDocumentHistory.InventoryValuationType AS InventoryValuationType,
  I_PurchasingDocumentHistory.DocumentReferenceID AS DocumentReferenceID,
  I_PurchasingDocumentHistory.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  I_PurchasingDocumentHistory.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  I_PurchasingDocumentHistory.PurgHistDocumentCreationTime AS PurgHistDocumentCreationTime,
  I_PurchasingDocumentHistory.Quantity AS Quantity,
  I_PurchasingDocumentHistory.PurOrdAmountInCompanyCodeCrcy AS PurOrdAmountInCompanyCodeCrcy,
  cast(I_PurchasingDocumentHistory.PurchaseOrderAmount as wrbtr) AS PurchaseOrderAmount,
  I_PurchasingDocumentHistory.QtyInPurchaseOrderPriceUnit AS QtyInPurchaseOrderPriceUnit,
  I_PurchasingDocumentHistory.GRIRAcctClrgAmtInCoCodeCrcy AS GRIRAcctClrgAmtInCoCodeCrcy,
  I_PurchasingDocumentHistory.GdsRcptBlkdStkQtyInOrdPrcUnit AS GdsRcptBlkdStkQtyInOrdPrcUnit,
  I_PurchasingDocumentHistory.GdsRcptBlkdStkQtyInOrdQtyUnit AS GdsRcptBlkdStkQtyInOrdQtyUnit,
  I_PurchasingDocumentHistory.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  I_PurchasingDocumentHistory.QuantityInDeliveryQtyUnit AS QuantityInDeliveryQtyUnit,
  I_PurchasingDocumentHistory.GRIRAcctClrgAmtInOrdTrnsacCrcy AS GRIRAcctClrgAmtInOrdTrnsacCrcy,
  I_PurchasingDocumentHistory.QuantityInBaseUnit AS QuantityInBaseUnit,
  I_PurchasingDocumentHistory.GRIRAcctClrgAmtInTransacCrcy AS GRIRAcctClrgAmtInTransacCrcy,
  I_PurchasingDocumentHistory.InvoiceAmtInPurOrdTransacCrcy AS InvoiceAmtInPurOrdTransacCrcy,
  cast( 0 as reewr) AS InvoiceAmtInCoCodeCrcy,
  I_PurchasingDocumentHistory.VltdGdsRcptBlkdQtyInOrdPrcUnit AS VltdGdsRcptBlkdQtyInOrdPrcUnit,
  I_PurchasingDocumentHistory.VltdGdsRcptBlkdStkQtyInOrdUnit AS VltdGdsRcptBlkdStkQtyInOrdUnit,
  cast( 0 as kudif) AS ExchangeRateDifferenceAmount
FROM I_PurchasingDocumentHistory
-- UNION ALL with additional select branch(es): P_GRIRPurchaseOrderHistory2
;