I_ExciseTaxCmmdty

DDL: I_EXCISETAXCMMDTY SQL: IEXCTXCMMDTY Type: view COMPOSITE

Commodity Code for Excise Tax

I_ExciseTaxCmmdty is a Composite CDS View that provides data about "Commodity Code for Excise Tax" in SAP S/4HANA. It reads from 3 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_CommodityCode, I_TrdClassfctnNmbrSchmUsge) and exposes 7 fields with key fields Country, ValidityStartDate, CommodityCode. It has 1 association to related views.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _Activation inner
I_CommodityCode _CommodityCode from
I_TrdClassfctnNmbrSchmUsge _Usage inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ExciseTaxCmmdtyText _Text _CommodityCode.CommodityCode = _Text.CommodityCode and _CommodityCode.ValidityStartDate = _Text.ValidityStartDate and _Usage.Country = _Text.Country

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEXCTXCMMDTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Commodity Code for Excise Tax view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Country I_TrdClassfctnNmbrSchmUsge Country
KEY ValidityStartDate I_CommodityCode ValidityStartDate
KEY CommodityCode I_CommodityCode CommodityCode
ValidityEndDate I_CommodityCode ValidityEndDate
CreationDateTime CreationDateTime
LastChangeDateTime LastChangeDateTime
_Text _Text 
@AbapCatalog.sqlViewName: 'IEXCTXCMMDTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
      
@Metadata.ignorePropagatedAnnotations: true

define view  I_ExciseTaxCmmdty as select from I_CommodityCode as _CommodityCode

  inner join I_TrdClassfctnNmbrSchmCntntAct                   as _Activation on  _CommodityCode.TrdClassfctnNmbrSchmCntnt = _Activation.TrdClassfctnNmbrSchmCntnt
  
  inner join I_TrdClassfctnNmbrSchmUsge                       as _Usage      on  _Usage.TrdClassfctnNmbrSchmType          = '01'
                                                                             and _Activation.TrdClassfctnNmbrSchm         = _Usage.TrdClassfctnNmbrSchm    
                                                                              
  association [0..*] to I_ExciseTaxCmmdtyText                 as _Text       on  _CommodityCode.CommodityCode             = _Text.CommodityCode
                                                                             and _CommodityCode.ValidityStartDate         = _Text.ValidityStartDate       
                                                                             and _Usage.Country                           = _Text.Country           
{

  key _Usage.Country                   as Country,
  key _CommodityCode.ValidityStartDate as ValidityStartDate,
  key _CommodityCode.CommodityCode     as CommodityCode,
      _CommodityCode.ValidityEndDate   as ValidityEndDate,
//    administrative data

      CreationDateTime                 as CreationDateTime,
      LastChangeDateTime               as LastChangeDateTime,

  _Text
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYCODE",
"I_TRDCLASSFCTNNMBRSCHMCNTNTACT",
"I_TRDCLASSFCTNNMBRSCHMUSGE"
],
"ASSOCIATED":
[
"I_EXCISETAXCMMDTYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More