I_EXCISETAXCMMDTYTEXT

CDS View

Commodity Code Text for Excise Tax

I_EXCISETAXCMMDTYTEXT is a CDS View in S/4HANA. Commodity Code Text for Excise Tax. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ExciseTaxCmmdtyText view from COMPOSITE Commodity Code Text for Excise Tax 
@AbapCatalog.sqlViewName: 'IEXSTXCMMDTYT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@EndUserText.label: 'Commodity Code Text for Excise Tax'

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

@ObjectModel.dataCategory: #TEXT

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@Metadata.ignorePropagatedAnnotations: true

define view I_ExciseTaxCmmdtyText as select from I_TrdClassfctnNmbrText as _Text     
 
  inner join I_TrdClassfctnNmbrSchmCntntAct as _Activation    on  _Text.TrdClassfctnNmbrSchmCntnt = _Activation.TrdClassfctnNmbrSchmCntnt
  
  inner join I_TrdClassfctnNmbrSchmUsge     as _Usage         on  _Usage.TrdClassfctnNmbrSchmType = '01'
                                                              and _Usage.TrdClassfctnNmbrSchm     = _Activation.TrdClassfctnNmbrSchm  
                                                              
  association [0..1] to I_ExciseTaxCmmdty   as _CommodityCode on  _Usage.Country                  = _CommodityCode.Country
                                                              and _Text.ValidityStartDate         = _CommodityCode.ValidityStartDate
                                                              and _Text.TrdClassfctnNmbr          = _CommodityCode.CommodityCode
                                                                                                                                            
  association [0..1] to I_Language          as _Language      on  _Text.Language                  = _Language.Language
  
{

  key _CommodityCode.Country           as Country,
  key _CommodityCode.ValidityStartDate as ValidityStartDate,
  key _CommodityCode.CommodityCode     as CommodityCode,
   @Semantics.language:true
  key _Text.Language                   as Language,
      _CommodityCode.ValidityEndDate   as ValidityEndDate,
     @Semantics.text: true
       TrdClassfctnNmbrText as CommodityCodeText, 
       
  _Language
  
}
where TrdClassfctnNmbrTextType  = 'A'

Learn More