I_TAXCODE

CDS View

Tax Code

I_TAXCODE is a CDS View in S/4HANA. Tax Code. It contains 15 fields. 29 CDS views read from this table.

CDS Views using this table (29)

ViewTypeJoinVDMDescription
C_CATaxCodeValueHelp view from CONSUMPTION Value Help - Tax Code
C_MM_TaxCodeValueHelp view from CONSUMPTION Tax Code Value Help
C_PE_StRpJournalEntryWithTax view inner CONSUMPTION Peru journal entries with tax
C_StRpDocLineItemWthRefDoc view inner CONSUMPTION Tax Items with Reference Accounting Documents
FAC_AUDIT_Z3_TAX_CODE view from Tax Code
FAC_TAXCODEVH view from Value help for tax code
I_DigitalVehicleTaxCode view_entity from BASIC Digital Vehicle Tax Code
I_RU_TaxCodeValueHelp view from BASIC RU Tax codes
I_SAFTTaxRate view inner COMPOSITE SAF-T Tax Rate
I_SAFTVatCode view from COMPOSITE SAFT Vat Codes
I_StRpTaxItem view inner COMPOSITE Tax Item view for Statutory Reporting
I_TaxCodeStdVH view from COMPOSITE Tax code
I_TaxCodeValueHelp view from COMPOSITE Tax Code
I_TripTaxCodeVH view from BASIC Trip tax code VH
P_AR_TaxItem view inner CONSUMPTION
P_GB_ParkedTaxItems view left_outer CONSUMPTION
P_HR_StRpTaxItem view_entity inner COMPOSITE Croatia selection for tax reporting
P_MX_DueDeferredTaxItem view inner COMPOSITE
P_NL_SAFTVATCode view from COMPOSITE
P_NL_SAFTVATCode view union COMPOSITE
P_NO_SAFTTAXRATE view inner COMPOSITE
P_PE_PurDmstcSuplrTaxItem view inner CONSUMPTION
P_PE_SalesTaxItem view inner CONSUMPTION
P_PL_SAFTInvoiceTaxEUCode view inner CONSUMPTION
P_RU_TaxCode view from COMPOSITE
P_SK_StRpVATCSDfrrdTaxItem view inner COMPOSITE
P_SlsPurListBPTaxItem view left_outer CONSUMPTION Sales Purchase List BP Tax Item
P_StRpTaxItmWithEUTaxClass7 view inner COMPOSITE
P_TH_TaxCodeRate view left_outer COMPOSITE

Fields (15)

KeyField CDS FieldsUsed in Views
KEY TargetTaxCode TargetTaxCode,TaxCode 6
KEY TaxCalculationProcedure TaxCalculationProcedure 13
KEY TaxCode TaxCode 8
KEY TaxType TaxType 13
_TaxCalculationProcedure _TaxCalculationProcedure 1
_TaxType _TaxType 1
_Text _TaxCodeText 1
EUAcqnInputTaxCode EUAcqnInputTaxCode 2
EUAcqnOutputTaxCode EUAcqnOutputTaxCode 2
EUTaxClassification EUTaxClassification 4
IsSalesTaxes IsSalesTaxes 1
MiniOneStopShopTxRptgCntry MiniOneStopShopTxRptgCntry 2
TaxReturnCountry TaxCodeReturnCountry,TaxReturnCountry 3
TaxTolerancePercent TaxTolerancePercent 1
UnitedStatesTaxCategory TaxCategory 1
@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]
@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,
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'UnitedStatesTaxCategory'  
      @Consumption.filter.hidden: true          
      cast ( txind as smwsk )                               as TaxCategory,
      cast ( txind as txind_007a)                           as UnitedStatesTaxCategory,
      lstml                                                 as TaxReturnCountry,
      cast( tolerance as fot_tax_tolerance preserving type) as TaxTolerancePercent,
      zmwsk_esa                                             as EUAcqnInputTaxCode,
      zmwsk_ese                                             as EUAcqnOutputTaxCode,
      mossc                                                 as MiniOneStopShopTxRptgCntry,

      _TaxCalculationProcedure,
      _TaxType,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T007A"
],
"ASSOCIATED":
[
"I_TAXCALCULATIONPROCEDURE",
"I_TAXCODETEXT",
"I_TAXTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/