I_ExciseTaxCountry

DDL: I_EXCISETAXCOUNTRY SQL: IETXCOUNTRY Type: view BASIC

Excise Tax Country/Region Code

I_ExciseTaxCountry is a Basic CDS View that provides data about "Excise Tax Country/Region Code" in SAP S/4HANA. It reads from 1 data source (t005) and exposes 7 fields with key field Country. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
t005 t005 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ExciseTaxCountryText _Text $projection.Country = _Text.Country
[0..*] I_ExciseTaxRegion _Region $projection.Country = _Region.Country

Annotations (18)

NameValueLevelField
EndUserText.label Excise Tax Country/Region Code view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IETXCOUNTRY view
ObjectModel.representativeKey Country view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.compositionRoot true view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 1 view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Country land1
CountryThreeLetterISOCode intca3
CountryThreeDigitISOCode intcn3
CountryISOCode
IsEuropeanUnionMember xegld
_Text _Text
_Region _Region 
@EndUserText.label: 'Excise Tax Country/Region Code'
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED   // #CHECK

@AbapCatalog.sqlViewName: 'IETXCOUNTRY'
@ObjectModel.representativeKey: 'Country'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.compositionRoot:true
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.numberOfKeyFields: 1
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.compiler.compareFilter:true 
@AbapCatalog.preserveKey:true
//@Analytics.internalName:#LOCAL


define view I_ExciseTaxCountry
  as select from t005
  association [0..*] to I_ExciseTaxCountryText as _Text on $projection.Country = _Text.Country
  association [0..*] to I_ExciseTaxRegion as _Region on $projection.Country = _Region.Country
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.association: '_Text'
  key land1  as Country,
      intca3 as CountryThreeLetterISOCode,
      intcn3 as CountryThreeDigitISOCode,
      cast ( intca  as abap.char(3) ) as CountryISOCode,
      xegld  as IsEuropeanUnionMember,
      _Text,
      _Region
            


}

Learn More