I_TaxCode

DDL: I_TAXCODE SQL: IFITAXCODE Type: view BASIC

Tax Code

I_TaxCode is a Basic CDS View (Dimension) that provides data about "Tax Code" in SAP S/4HANA. It reads from 1 data source (t007a) and exposes 19 fields with key fields TaxCalculationProcedure, TaxCode. It has 3 associations to related views. It is exposed through 1 OData service (C_BILLGDOCREDACTED_SD).

Data Sources (1)

SourceAliasJoin Type
t007a t007a 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 (17)

NameValueLevelField
AbapCatalog.sqlViewName IFITAXCODE view
EndUserText.label Tax Code view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey TaxCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name SalesTaxCode view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
C_BILLGDOCREDACTED_SD C_BILLGDOCREDACTED V2 C1 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TaxCalculationProcedure kalsm
KEY TaxCode
TaxType mwart
TargetTaxCode
EUTaxClassification egrkz
IsSalesTaxes xslta
TaxCategory
UnitedStatesTaxCategory
TaxReturnCountry lstml
TaxTolerancePercent
EUAcqnInputTaxCode zmwsk_ese
EUAcqnOutputTaxCode zmwsk_esa
TaxCodeIsInactive xinact
MiniOneStopShopTxRptgCntry mossc
OneStopShopTaxReportingCountry mossc
OneStopShopScheme oss_classification
_TaxCalculationProcedure _TaxCalculationProcedure
_TaxType _TaxType
_Text _Text
@AbapCatalog.sqlViewName: 'IFITAXCODE'
@EndUserText.label: 'Tax Code'

@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'TaxCode'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #EXTRACTION_DATA_SOURCE]
@ObjectModel.sapObjectNodeType.name: 'SalesTaxCode'
@Search.searchable: true

define view I_TaxCode
  as select from t007a

  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 kalsm                                                 as TaxCalculationProcedure,
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement:true
      @Search.fuzzinessThreshold:0.8
      @Search.ranking:#HIGH
  key cast(mwskz as fis_mwskz preserving type)              as TaxCode,
      @ObjectModel.foreignKey.association: '_TaxType'
      mwart                                                 as TaxType,
      cast (zmwsk as farp_dzmwsk preserving type)           as TargetTaxCode,
      egrkz                                                 as EUTaxClassification,
      xslta                                                 as IsSalesTaxes,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'UnitedStatesTaxCategory'
      @Consumption.filter.hidden: true
      cast ( txind as smwsk )                               as TaxCategory,
      cast ( txind as txind_007a preserving type)           as UnitedStatesTaxCategory,
      lstml                                                 as TaxReturnCountry,
      cast( tolerance as fot_tax_tolerance preserving type) as TaxTolerancePercent,
      zmwsk_ese                                             as EUAcqnInputTaxCode,
      zmwsk_esa                                             as EUAcqnOutputTaxCode,
      xinact                                                as TaxCodeIsInactive,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'OneStopShopTaxReportingCountry'
      @Consumption.filter.hidden: true
      mossc                                                 as MiniOneStopShopTxRptgCntry,
      mossc                                                 as OneStopShopTaxReportingCountry,
      oss_classification                                    as OneStopShopScheme,

      _TaxCalculationProcedure,
      _TaxType,
      _Text
}