N_PurchaseOrderHistoryBasic

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'NMMPURORDHIST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.auxiliaryEntity.for.entity: 'I_PurchaseOrderHistoryBasic'
@VDM.auxiliaryEntity.usage.type: [#ENTERPRISE_SEARCH] 
@EndUserText.label: 'Auxiliary View for Purchase Order History'
define view N_PurchaseOrderHistoryBasic as select from ekbe 

association [1..1] to R_PurchaseOrder             as _PurchaseOrder        on  $projection.PurchaseOrder  = _PurchaseOrder.PurchaseOrder
association [1..1] to R_PurchaseOrderItem         as _PurchaseOrderItem         on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                                and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

{

 key  ebeln                                   as PurchaseOrder,

  key  ebelp                                  as PurchaseOrderItem,

  key  zekkn                                  as AccountAssignmentNumber,

  key  vgabe                                  as PurchasingHistoryDocumentType,

  key  gjahr                                  as PurchasingHistoryDocumentYear,

  key  belnr                                  as PurchasingHistoryDocument,

  key  buzei                                  as PurchasingHistoryDocumentItem,

       bewtp                                  as PurchasingHistoryCategory,

       bwart                                  as GoodsMovementType,

       budat                                  as PostingDate,

       @Semantics.currencyCode: true
       waers                                  as Currency,

       shkzg                                  as DebitCreditCode,

       elikz                                  as IsCompletelyDelivered,

       lfgja                                  as ReferenceDocumentFiscalYear,

       lfbnr                                  as ReferenceDocument,

       lfpos                                  as ReferenceDocumentItem,

       matnr                                  as Material,

       werks                                  as Plant,
      
       xwsbr                                  as RvslOfGoodsReceiptIsAllowed,      
      
       knumv                                  as PricingDocument,
      
       mwskz                                  as TaxCode,              

       bldat                                  as DocumentDate,

       bwtar                                  as InventoryValuationType,

       xblnr                                  as DocumentReferenceID,

       @Semantics.unitOfMeasure: true
       lsmeh                                  as DeliveryQuantityUnit,
      
       ematn                                  as ManufacturerMaterial,         

       cpudt                                  as AccountingDocumentCreationDate,

       @Semantics.quantity.unitOfMeasure:'PurchaseOrderQuantityUnit'
       menge                                  as Quantity,

       @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
       dmbtr                                  as PurOrdAmountInCompanyCodeCrcy,

       @Semantics.amount.currencyCode: 'Currency'
       wrbtr                                  as PurchaseOrderAmount,

       @Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
       bpmng                                  as QtyInPurchaseOrderPriceUnit,

       @Semantics.amount.currencyCode:'CompanyCodeCurrency'
       arewr                                  as GRIRAcctClrgAmtInCoCodeCrcy,

       @Semantics.quantity.unitOfMeasure:'PurchaseOrderQuantityUnit'  
       wesbs                                  as GdsRcptBlkdStkQtyInOrdQtyUnit,

       @Semantics.quantity.unitOfMeasure:'OrderPriceUnit' 
       bpwes                                  as GdsRcptBlkdStkQtyInOrdPrcUnit,

       @Semantics.amount.currencyCode: 'CompanyCodeCurrency' 
       reewr                                  as InvoiceAmtInCoCodeCrcy,
      
       evere                                  as ShipgInstrnSupplierCompliance,      

       @Semantics.amount.currencyCode: 'Currency'
       refwr                                  as InvoiceAmountInFrgnCurrency,

       @Semantics.quantity.unitOfMeasure:'DeliveryQuantityUnit'
       lsmng                                  as QuantityInDeliveryQtyUnit,

       @Semantics.amount.currencyCode: 'Currency' 
       areww                                  as GRIRAcctClrgAmtInTransacCrcy,

       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       bamng                                  as QuantityInBaseUnit,

       @Semantics.amount.currencyCode: 'DocumentCurrency'
       arewb                                  as GRIRAcctClrgAmtInOrdTrnsacCrcy,

       @Semantics.amount.currencyCode: 'DocumentCurrency'
       rewrb                                  as InvoiceAmtInPurOrdTransacCrcy,

       @Semantics.quantity.unitOfMeasure:'PurchaseOrderQuantityUnit'
       wesbb                                  as VltdGdsRcptBlkdStkQtyInOrdUnit,

       @Semantics.quantity.unitOfMeasure:'OrderPriceUnit'
       bpweb                                  as VltdGdsRcptBlkdQtyInOrdPrcUnit,
      
       weora                                  as IsToBeAcceptedAtOrigin,        

       @Semantics.amount.currencyCode: 'Currency'
       kudif                                  as ExchangeRateDifferenceAmount,
      
       cast(wkurs as fis_exchange_rate)       as ExchangeRate,
      
       vbeln_st                               as DeliveryDocument,
      
       vbelp_st                               as DeliveryDocumentItem,
       
      @Semantics.unitOfMeasure: true      
      _PurchaseOrderItem.OrderPriceUnit,
      @Semantics.unitOfMeasure: true      
      _PurchaseOrderItem.PurchaseOrderQuantityUnit,
      @Semantics.unitOfMeasure: true      
      _PurchaseOrderItem.BaseUnit,
      @Semantics.currencyCode: true      
      _PurchaseOrder.DocumentCurrency,
      @Semantics.currencyCode: true      
      _PurchaseOrder._CompanyCode.Currency as CompanyCodeCurrency,  
       
       _PurchaseOrder,
       _PurchaseOrderItem   
                      
    
}