P_EXCISEDUTYDEFNMERGE

CDS View

Tranpose Price details for TaxDefn

P_EXCISEDUTYDEFNMERGE is a CDS View in S/4HANA. Tranpose Price details for TaxDefn. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ExciseDueDocument view left_outer CONSUMPTION Excise Duelist from Billing Document 
@AbapCatalog.sqlViewName: 'PSDEXDTYCMGDFN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@EndUserText.label: 'Tranpose Price details for TaxDefn'
define view P_ExciseDutyDefnMerge
  as select from P_Excisedutycalcdefn
{
  BillingDocument,
  PricingDocument,
  max(AEDAmount)           as AEDAmount,
  max(BEDAmount)           as BEDAmount,
  max(SEDAmount)           as SEDAmount,
  max(NCCDAmount)          as NCCDAmount,
  max(CESSAmount)          as CESSAmount,
  max(ECSAmount)           as ECSAmount,
  max(AdditionalTax1Value) as AdditionalTax1Value,
  max(AdditionalTax2Value) as AdditionalTax2Value,
  max(AdditionalTax3Value) as AdditionalTax3Value

}
group by
  BillingDocument,
  PricingDocument

Learn More