I_PurchaseOrderHistoryBasic

@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMPURORDHIST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order History'
@VDM.viewType : #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurchaseOrderHistoryBasic as select from I_PurchasingDocumentHistory as history

       inner join R_PurchaseOrder                        as PurchaseOrder         on  history.PurchasingDocument      = PurchaseOrder.PurchaseOrder
       association [1..1] to R_PurchaseOrder             as _PurchaseOrder        on  history.PurchasingDocument      = _PurchaseOrder.PurchaseOrder
       association [1..1] to R_PurchaseOrderItem         as _PurchaseOrderItem    on  history.PurchasingDocument      = _PurchaseOrderItem.PurchaseOrder
                                                                                  and history.PurchasingDocumentItem  = _PurchaseOrderItem.PurchaseOrderItem

{

  key PurchasingDocument                as PurchaseOrder,

  key PurchasingDocumentItem            as PurchaseOrderItem,

  key AccountAssignmentNumber,

  key PurchasingHistoryDocumentType,

  key PurchasingHistoryDocumentYear,

  key PurchasingHistoryDocument,

  key PurchasingHistoryDocumentItem,

      PurchasingHistoryCategory,

      GoodsMovementType,

      PostingDate,

      Currency,

      DebitCreditCode,

      IsCompletelyDelivered,

      ReferenceDocumentFiscalYear,

      ReferenceDocument,

      ReferenceDocumentItem,

      Material,

      Plant,
      
      RvslOfGoodsReceiptIsAllowed,      
      
      history.PricingDocument,
      
      TaxCode,              

      DocumentDate,
      
      history.CreatedByUser,

      InventoryValuationType,

      DocumentReferenceID,
      @Semantics.unitOfMeasure: true
      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,
      
      DeliveryDocument,
      
      DeliveryDocumentItem,

      OrderPriceUnit,
      OrderQuantityUnit as PurchaseOrderQuantityUnit,
      BaseUnit,
      history.DocumentCurrency,
      history.CompanyCodeCurrency,
      
      _PurchaseOrder,
      
      _PurchaseOrderItem,
      
      // Text associations for CustomUI

      history._GoodsMovementTypeText,
      history._CurrencyText,
      history._DebitCreditCodeText,
      history._DeliveryQuantityUnitText,
      history._OrderPriceUnitText,
      history._OrderQuantityUnitText,
      history._BaseUnitText,
      history._DocumentCurrencyText,
      history._CompanyCodeCurrencyText
          
}

where PurchaseOrder.IsEndOfPurposeBlocked = ''