C_GRIRPurchaseOrderHistory

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_GRIRPurchaseOrderHistory.
-- 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: CFIGRIRPURORDHIS

CREATE VIEW C_GRIRPurchaseOrderHistory AS
SELECT
  cast( P_GRIRPurchaseOrderHistory1.PurchasingDocument as fis_ebeln preserving type) AS PurchasingDocument,
  cast( P_GRIRPurchaseOrderHistory1.PurchasingDocumentItem as fis_ebelp preserving type) AS PurchasingDocumentItem,
  P_GRIRPurchaseOrderHistory1.AccountAssignmentNumber AS AccountAssignmentNumber,
  cast(P_GRIRPurchaseOrderHistory1.ConditionStep as fis_stunr preserving type) AS ConditionStep,
  P_GRIRPurchaseOrderHistory1.ConditionCount AS ConditionCount,
  cast(P_GRIRPurchaseOrderHistory1.PurchasingHistoryDocumentType as fis_grir_po_his_doctype preserving type) AS PurchasingHistoryDocumentType,
  cast(P_GRIRPurchaseOrderHistory1.PurchasingHistoryDocumentYear as fis_grir_po_his_docyear preserving type) AS PurchasingHistoryDocumentYear,
  cast(P_GRIRPurchaseOrderHistory1.PurchasingHistoryDocument as fis_grir_po_his_docnr preserving type) AS PurchasingHistoryDocument,
  cast(P_GRIRPurchaseOrderHistory1.PurchasingHistoryDocumentItem as fis_grir_po_his_docln preserving type) AS PurchasingHistoryDocumentItem,
  cast( P_GRIRPurchaseOrderHistory1.PurchasingHistoryDocument as belnr_d ) AS SupplierInvoice,
  cast( cast( concat('00', P_GRIRPurchaseOrderHistory1.PurchasingHistoryDocumentItem) as abap.numc(6) ) as rblgp ) AS SupplierInvoiceItem,
  _PurchasingDocumentItem.CompanyCode AS CompanyCode,
  P_GRIRPurchaseOrderHistory1.PurchasingHistoryCategory AS PurchasingHistoryCategory,
  P_GRIRPurchaseOrderHistory1.GoodsMovementType AS GoodsMovementType,
  P_GRIRPurchaseOrderHistory1.PostingDate AS PostingDate,
  cast( P_GRIRPurchaseOrderHistory1.CompanyCodeCurrency as fis_hwaer preserving type ) AS CompanyCodeCurrency,
  cast( P_GRIRPurchaseOrderHistory1.Currency as fis_rwcur preserving type) AS TransactionCurrency,
  P_GRIRPurchaseOrderHistory1.DebitCreditCode AS DebitCreditCode,
  P_GRIRPurchaseOrderHistory1.IsCompletelyDelivered AS IsCompletelyDelivered,
  P_GRIRPurchaseOrderHistory1.ReferenceDocument AS ReferenceDocument,
  P_GRIRPurchaseOrderHistory1.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  P_GRIRPurchaseOrderHistory1.ReferenceDocumentItem AS ReferenceDocumentItem,
  P_GRIRPurchaseOrderHistory1.Material AS Material,
  _PurchasingDocumentItem.Plant AS Plant,
  P_GRIRPurchaseOrderHistory1.DocumentDate AS DocumentDate,
  P_GRIRPurchaseOrderHistory1.DocumentReferenceID AS DocumentReferenceID,
  cast( _PurchasingDocumentItem.OrderQuantityUnit as fis_bstme preserving type) AS OrderQuantityUnit,
  _PurchasingDocument.Supplier AS Supplier,
  cast(_PurchasingDocument.PurchasingGroup as fis_grir_ekgrp preserving type ) AS PurchasingGroup,
  cast(_PurchasingDocument.PurchasingOrganization as fis_grir_ekorg preserving type ) AS PurchasingOrganization,
  _PurchasingDocumentItem.OrderPriceUnit AS OrderPriceUnit,
  _PurchasingDocumentItem.BaseUnit AS BaseUnit,
  _PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
  cast( _PurchasingDocument.DocumentCurrency as fis_ebeln_waers preserving type) AS PurgDocTransactionCurrency,
  _PurchasingDocumentItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  P_GRIRPurchaseOrderHistory1.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  P_GRIRPurchaseOrderHistory1.PurgHistDocumentCreationTime AS PurgHistDocumentCreationTime,
  _PurchasingDocumentItem._OrderQuantityUnit AS _OrderQuantityUnit,
  _PurchasingDocumentItem._MaterialGroup AS _MaterialGroup,
  _PurchasingDocumentItem._OrderPriceUnit AS _OrderPriceUnit,
  _PurchasingDocumentItem._Plant AS _Plant,
  _PurchasingDocumentItem._PurgDocumentCategory AS _PurgDocumentCategory,
  _PurchasingDocument._DocumentCurrency AS _DocumentCurrency,
  _PurchasingDocument._Supplier AS _Supplier
FROM P_GRIRPurchaseOrderHistory1
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderHistCategory AS _PurchaseOrderHistCategory ON PurchasingHistoryCategory = _PurchaseOrderHistCategory.PurchaseOrderHistCategory  -- association [1..1]
LEFT OUTER JOIN I_PurOrderHistoryCategoryText AS _PurchaseOrderHistCategName ON PurchasingHistoryCategory = _PurchaseOrderHistCategName.PurchaseOrderHistCategory  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN C_GRIRSupplierInvoiceItem AS _GRIRSupplierInvoiceItem ON SupplierInvoice = _GRIRSupplierInvoiceItem.SupplierInvoice AND SupplierInvoiceItem = _GRIRSupplierInvoiceItem.SupplierInvoiceItem AND PurchasingHistoryDocumentYear = _GRIRSupplierInvoiceItem.FiscalYear AND ( PurchasingHistoryCategory = 'G' OR PurchasingHistoryCategory = 'I' OR PurchasingHistoryCategory = 'K' OR PurchasingHistoryCategory = 'M' OR PurchasingHistoryCategory = 'N' OR PurchasingHistoryCategory = 'P' OR PurchasingHistoryCategory = 'Q' OR PurchasingHistoryCategory = 'R' OR PurchasingHistoryCategory = 'S' OR PurchasingHistoryCategory = 'T' OR PurchasingHistoryCategory = 'W' OR PurchasingHistoryCategory = 'X' )  -- association [0..1]
LEFT OUTER JOIN C_GRIRMaterialDocumentItem AS _GRIRMaterialDocumentItem ON PurchasingHistoryDocument = _GRIRMaterialDocumentItem.MaterialDocument AND PurchasingHistoryDocumentItem = _GRIRMaterialDocumentItem.MaterialDocumentItem AND PurchasingHistoryDocumentYear = _GRIRMaterialDocumentItem.MaterialDocumentYear AND ( PurchasingHistoryCategory = 'E' OR PurchasingHistoryCategory = 'F' )  -- association [0..1]
LEFT OUTER JOIN I_GRIRProcess AS _GRIRProcess ON CompanyCode = _GRIRProcess.CompanyCode AND PurchasingDocument = _GRIRProcess.PurchasingDocument AND PurchasingDocumentItem = _GRIRProcess.PurchasingDocumentItem  -- association [0..1]
;