I_VATTaxCodeVH

DDL: I_VATTAXCODEVH Type: view_entity BASIC Package: ODATA_TAX_RECONCILIATION

VAT Tax Code

I_VATTaxCodeVH is a Basic CDS View that provides data about "VAT Tax Code" in SAP S/4HANA. It reads from 1 data source (I_TaxCode) and exposes 17 fields with key fields TaxCalculationProcedure, TaxCode. It has 3 associations to related views. Part of development package ODATA_TAX_RECONCILIATION.

Data Sources (1)

SourceAliasJoin Type
I_TaxCode I_TaxCode from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_TaxCodeText _Text $projection.TaxCalculationProcedure = _Text.TaxCalculationProcedure and $projection.TaxCode = _Text.TaxCode
[0..1] I_TaxType _TaxType $projection.TaxType = _TaxType.TaxType
[0..1] I_TaxCalculationProcedure _TaxCalculationProcedure $projection.TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure

Annotations (12)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VAT Tax Code view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey TaxCode view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TaxCalculationProcedure I_TaxCode TaxCalculationProcedure
KEY TaxCode I_TaxCode TaxCode
TaxType I_TaxCode TaxType
TargetTaxCode I_TaxCode TargetTaxCode
EUTaxClassification I_TaxCode EUTaxClassification
IsSalesTaxes I_TaxCode IsSalesTaxes
UnitedStatesTaxCategory I_TaxCode UnitedStatesTaxCategory
TaxReturnCountry I_TaxCode TaxReturnCountry
TaxTolerancePercent I_TaxCode TaxTolerancePercent
EUAcqnInputTaxCode I_TaxCode EUAcqnInputTaxCode
EUAcqnOutputTaxCode I_TaxCode EUAcqnOutputTaxCode
TaxCodeIsInactive I_TaxCode TaxCodeIsInactive
OneStopShopTaxReportingCountry I_TaxCode OneStopShopTaxReportingCountry
OneStopShopScheme I_TaxCode OneStopShopScheme
_TaxCalculationProcedure _TaxCalculationProcedure
_TaxType _TaxType
_Text _Text
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'VAT Tax Code'
@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'TaxCode',
                usageType: { sizeCategory: #S,
                             dataClass: #CUSTOMIZING,
                             serviceQuality: #A },
                supportedCapabilities: [#VALUE_HELP_PROVIDER],
                modelingPattern: #VALUE_HELP_PROVIDER }

@Metadata.ignorePropagatedAnnotations: true 
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: true

define view entity I_VATTaxCodeVH 
  as select from I_TaxCode 
  
  association [0..*] to I_TaxCodeText             as _Text                    on  $projection.TaxCalculationProcedure = _Text.TaxCalculationProcedure
                                                                              and $projection.TaxCode                 = _Text.TaxCode

  association [0..1] to I_TaxType                 as _TaxType                 on  $projection.TaxType = _TaxType.TaxType

  association [0..1] to I_TaxCalculationProcedure as _TaxCalculationProcedure on  $projection.TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure
 
  
{  
      @ObjectModel.foreignKey.association: '_TaxCalculationProcedure'
  key I_TaxCode.TaxCalculationProcedure,                                              
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement:true
      @Search.fuzzinessThreshold:0.8
      @Search.ranking:#HIGH
  key I_TaxCode.TaxCode,
      @ObjectModel.foreignKey.association: '_TaxType'
      I_TaxCode.TaxType,
      I_TaxCode.TargetTaxCode,
      I_TaxCode.EUTaxClassification,
      I_TaxCode.IsSalesTaxes,
      I_TaxCode.UnitedStatesTaxCategory,
      I_TaxCode.TaxReturnCountry,
      I_TaxCode.TaxTolerancePercent,
      I_TaxCode.EUAcqnInputTaxCode,
      I_TaxCode.EUAcqnOutputTaxCode,
      I_TaxCode.TaxCodeIsInactive,
      I_TaxCode.OneStopShopTaxReportingCountry,
      I_TaxCode.OneStopShopScheme,

      _TaxCalculationProcedure,
      _TaxType,
      _Text
}