P_ExciseItemExBaseAmt

DDL: P_EXCISEITEMEXBASEAMT SQL: PSDEXIEXBSAMT Type: view CONSUMPTION

ExciseItem ExBase Amout Calculation

P_ExciseItemExBaseAmt is a Consumption CDS View that provides data about "ExciseItem ExBase Amout Calculation" in SAP S/4HANA. It reads from 2 data sources (I_ExciseDueDocItemBase, I_PricingElement) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_ExciseDueDocItemBase I_ExciseDueDocItemBase from
I_PricingElement I_PricingElement inner

Parameters (1)

NameTypeDefault
P_BillingDocument vbeln

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDEXIEXBSAMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label ExciseItem ExBase Amout Calculation view

Fields (2)

KeyFieldSource TableSource FieldDescription
BillingDocument BillingDocument
BillingDocumentItem BillingDocumentItem 
@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
}

Learn More