I_PurchaseOrderPricingElement

@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMPURORDPRICE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order Pricing Element on Header'
@VDM.viewType : #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_PurchaseOrderPricingElement as select from I_PurgDocPricingElement as pricing 
      inner join I_PurchaseOrder                        as PurchaseOrder         on  pricing.PurchasingDocument     = PurchaseOrder.PurchaseOrder
      association [1..1] to I_PurchaseOrder             as _PurchaseOrder        on  $projection.PurchaseOrder      = _PurchaseOrder.PurchaseOrder
{

  key PurchasingDocument         as PurchaseOrder,
     
  key PricingDocument,
  key PricingDocumentItem,
  key PricingProcedureStep,
  key PricingProcedureCounter,
  
      ConditionApplication,
      ConditionType,
      @Semantics.dateTime: true
      PricingDateTime,
      ConditionCalculationType,
      ConditionBaseValue,
      ConditionRateValue,

      ConditionCurrency,
      PriceDetnExchangeRate,

      ConditionQuantity,
 
      ConditionQuantityUnit,
      ConditionToBaseQtyNmrtr,
      ConditionToBaseQtyDnmntr,
      ConditionCategory,
      ConditionIsForStatistics,
      PricingScaleType,
      IsRelevantForAccrual,
      CndnIsRelevantForInvoiceList,
      ConditionOrigin,
      IsGroupCondition,
      AccessNumberOfAccessSequence,
      ConditionRecord,
      ConditionSequentialNumber,
      AccountKeyForGLAccount,
      GLAccount,
      TaxCode,
      AcctKeyForAccrualsGLAccount,
      AccrualsGLAccount,
      WithholdingTaxCode,
 
      FreightSupplier,

      CndnRoundingOffDiffAmount,

      ConditionAmount,

      TransactionCurrency,
      ConditionControl,
      ConditionInactiveReason,
      ConditionClass,
      PrcgProcedureCounterForHeader,
      FactorForConditionBasisValue,
      StructureCondition,
      PeriodFactorForCndnBasisValue,
      PricingScaleBasis,
      ConditionScaleBasisValue,

      ConditionScaleBasisUnit,

      ConditionScaleBasisCurrency,

      ConditionAlternativeCurrency,

      ConditionAmountInLocalCrcy,
      CndnIsRelevantForIntcoBilling,
      ConditionIsManuallyChanged,
      BillingPriceSource,
      TaxJurisdictionLevel,
      ConditionByteSequence,
      CndnIsRelevantForLimitValue,
      ConditionBasisLimitExceeded,
      ConditionAmountLimitExceeded,
      CumulatedConditionBasisValue,
    
      CustomerRebateRecipient,
      ConditionIsForConfiguration,
      VariantCondition,
      ConditionAcctAssgmtRelevance,
      ConditionMatrixMaintRelevance,
      ConfigblParametersAndFormulas,
      ConditionAdjustedQuantity,
      CndnValueZeroProcgCode,
     
      _PurchaseOrder, 
      pricing._BillingPriceSource,
      pricing._ConditionAcctAssgmtRelevance,
      pricing._ConditionAlternativeCurrency,
      pricing._ConditionAmountLimitExceeded,
      pricing._ConditionApplication,
      pricing._ConditionBasisLimitExceeded,
      pricing._ConditionCalculationType,
      pricing._ConditionCategory,
      pricing._ConditionClass,
      pricing._ConditionControl,
      pricing._ConditionCurrency,
      pricing._ConditionInactiveReason,
      pricing._ConditionOrigin,
      pricing._Currency,
      pricing._Customer,
      pricing._PricingConditionType,
      pricing._PricingScaleBasis,
      pricing._ConditionQuantityUnit,
      pricing._ScaleCurrency,
      pricing._ScaleUnitOfMeasure,
      pricing._StructureCondition,
      pricing._Supplier,
      pricing._VariantCondition   
}

where PurchasingDocumentItem = '00000' and
      PurchaseOrder.IsEndOfPurposeBlocked = ''