P_EXCISEITEMEXBASEAMT

@AbapCatalog.sqlViewName: 'PSDEXIEXBSAMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@EndUserText.label: 'ExciseItem ExBase Amout Calculation'
define view P_ExciseItemExBaseAmt
  with parameters
    P_BillingDocument : vbeln
  as select from I_ExciseDueDocItemBase(P_BillingDocument : $parameters.P_BillingDocument)
    inner join   I_PricingElement on  I_PricingElement.PricingDocument     = I_ExciseDueDocItemBase.PricingDocument
                              and I_PricingElement.PricingDocumentItem = I_ExciseDueDocItemBase.BillingDocumentItem
{
  BillingDocument,
  BillingDocumentItem,
  case I_PricingElement.ConditionType
  when 'UTXJ' then
  I_PricingElement.ConditionBaseValue
  else
      case I_PricingElement.ConditionIsForStatistics
      when ' ' then
          case I_PricingElement.ConditionClass
          when 'B' then
              case I_PricingElement.ConditionCategory
              when 'G' then
              I_PricingElement.ConditionAmount
              else
                  case I_PricingElement.ConditionIsForStatistics
                  when ' ' then
                  case I_PricingElement.ConditionClass
                  when 'B' then
                  case I_PricingElement.ConditionCategory
                  when 'H' then
                  I_PricingElement.ConditionAmount
                  end
                  end
                  end
             end
          else
         case I_PricingElement.ConditionIsForStatistics
         when ' ' then
         case I_PricingElement.ConditionClass
         when 'B' then
         case I_PricingElement.ConditionCategory
         when 'H' then
         I_PricingElement.ConditionAmount
         end
     end
     else
     case I_PricingElement.ConditionIsForStatistics
     when ' ' then
     case I_PricingElement.ConditionClass
     when 'B' then
     case I_PricingElement.ConditionCategory
     when 'H' then
     I_PricingElement.ConditionAmount
     end
     end
     end
     end
  end
  end
  end as ExciseDutyBaseAmount
}