P_ExciseDutyCalcDefn

DDL: P_EXCISEDUTYCALCDEFN SQL: PSDEXDTYCALCDFN Type: view CONSUMPTION Package: GLO_LOG_IN

Excise Duty Calculation with TaxDefn

P_ExciseDutyCalcDefn is a Consumption CDS View that provides data about "Excise Duty Calculation with TaxDefn" in SAP S/4HANA. It reads from 3 data sources (I_ExciseDueDocHdr, I_PricingElement, I_TaxDefCondType) and exposes 14 fields. Part of development package GLO_LOG_IN.

3 data source(s) 14 fields

Data Sources (3)

SourceAliasJoin Type
I_ExciseDueDocHdr I_ExciseDueDocHdr from
I_PricingElement I_PricingElement inner
I_TaxDefCondType I_TaxDefCondType inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSDEXDTYCALCDFN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Excise Duty Calculation with TaxDefn view

Fields (14)

KeyFieldSource TableSource FieldDescription
BillingDocument I_ExciseDueDocHdr BillingDocument
SDPricingProcedure I_ExciseDueDocHdr SDPricingProcedure
PricingDocument I_PricingElement PricingDocument
ConditionType I_PricingElement ConditionType
IndianTaxConditionName I_TaxDefCondType IndianTaxConditionName
ConditionAmountendasAEDAmount
ConditionAmountendasBEDAmount
ConditionAmountendasSEDAmount
ConditionAmountendasNCCDAmount
ConditionAmountendasCESSAmount
ConditionAmountendasECSAmount
ConditionAmountendasAdditionalTax1Value
ConditionAmountendasAdditionalTax2Value
ConditionAmountendasAdditionalTax3Value 
@AbapCatalog.sqlViewName: 'PSDEXDTYCALCDFN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@EndUserText.label: 'Excise Duty Calculation with TaxDefn'
define view P_ExciseDutyCalcDefn
  as select from I_ExciseDueDocHdr
    inner join  I_PricingElement on I_PricingElement.PricingDocument = I_ExciseDueDocHdr.PricingDocument
    inner join   I_TaxDefCondType on(
      I_PricingElement.ConditionType               = I_TaxDefCondType.ConditionType
      and I_ExciseDueDocHdr.SDPricingProcedure = I_TaxDefCondType.PricingProcedure
    )
{
  I_ExciseDueDocHdr.BillingDocument,
  I_ExciseDueDocHdr.SDPricingProcedure,
  I_PricingElement.PricingDocument,
  I_PricingElement.ConditionType,
  I_TaxDefCondType.IndianTaxConditionName,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'AEDARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as AEDAmount,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'BEDARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as BEDAmount,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'SEDARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as SEDAmount,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'NCCDARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as NCCDAmount,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'CESARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as CESSAmount,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'ECSARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as ECSAmount,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'AT1ARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as AdditionalTax1Value,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'AT2ARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as AdditionalTax2Value,

  case I_TaxDefCondType.IndianTaxConditionName
  when 'AT3ARTOT' then
  sum(I_PricingElement.ConditionAmount)
  end as AdditionalTax3Value

}
group by
  I_ExciseDueDocHdr.BillingDocument,
  I_ExciseDueDocHdr.SDPricingProcedure,
  I_PricingElement.PricingDocument,
  I_PricingElement.ConditionType,
  I_TaxDefCondType.IndianTaxConditionName

Learn More