P_EXCISEITEMDUTYDEFNMERGE

CDS View

Tranpose Price of ExciseItem for TaxDefn

P_EXCISEITEMDUTYDEFNMERGE is a CDS View in S/4HANA. Tranpose Price of ExciseItem for TaxDefn. It contains 9 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 9 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ExciseDueDocItem view left_outer CONSUMPTION ExciseItem List from Billing Document

Fields (9)

KeyField CDS FieldsUsed in Views
AdditionalTax1Rate AdditionalTax1Rate 1
AdditionalTax2Rate AdditionalTax2Rate 1
AdditionalTax3Rate AdditionalTax3Rate 1
AEDRate AEDRate 1
BEDRate BEDRate 1
CESSRate CESSRate 1
ECSRate ECSRate 1
NCCDRate NCCDRate 1
SEDRate SEDRate 1 
@AbapCatalog.sqlViewName: 'PSDEXIDTYMGDFN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@EndUserText.label: 'Tranpose Price of ExciseItem for TaxDefn'
define view P_ExciseItemDutyDefnMerge
  with parameters
    P_BillingDocument : vbeln
  as select from P_ExciseItemDutyCalcDefn(P_BillingDocument : $parameters.P_BillingDocument)
{
  P_ExciseItemDutyCalcDefn.BillingDocument,
  P_ExciseItemDutyCalcDefn.BillingDocumentItem,
  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,
  max(AEDRate)             as AEDRate,
  max(BEDRate)             as BEDRate,
  max(SEDRate)             as SEDRate,
  max(NCCDRate)            as NCCDRate,
  max(CESSRate)            as CESSRate,
  max(ECSRate)             as ECSRate,
  max(AdditionalTax1Rate)  as AdditionalTax1Rate,
  max(AdditionalTax2Rate)  as AdditionalTax2Rate,
  max(AdditionalTax3Rate)  as AdditionalTax3Rate

}
group by
  P_ExciseItemDutyCalcDefn.BillingDocument,
  P_ExciseItemDutyCalcDefn.BillingDocumentItem                                                   
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EXCISEITEMDUTYCALCDEFN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More