I_TAXCODE

CDS View

Tax Code

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

CDS Views using this table (44)

ViewTypeJoinVDMDescription
A_TaxCode view_entity from BASIC Tax Code
C_CATaxCodeValueHelp view from CONSUMPTION Value Help - Tax Code
C_CL_StRpSalesLedgerLog view_entity inner CONSUMPTION Chile Sales Ledger Log
C_MM_TaxCodeValueHelp view from CONSUMPTION Tax Code Value Help
C_NO_SAFTJournalItemTax view inner CONSUMPTION SAF-T Norway Journal Item Tax
C_NO_SAFTTax view inner CONSUMPTION SAF-T Norway Tax
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_PL_SAFTInvoiceTaxEUCode view_entity inner COMPOSITE SAF T PL tax EU code
I_RU_TaxCodeValueHelp view from BASIC RU Tax codes
I_SAFTTaxRate view_entity inner BASIC 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_entity from COMPOSITE Tax Code
I_TaxCodeValueHelp view_entity from COMPOSITE Tax Code
I_VATTaxCodeVH view_entity from BASIC VAT Tax Code
P_AR_TaxItem view inner CONSUMPTION Private View for Argentina Tax Item
P_CL_PurJournalEntryTaxItem view_entity inner CONSUMPTION Chile Purchase Journal Entry Tax Item
P_CL_SalesJournalEntryTaxItem view_entity inner CONSUMPTION Sales Journal Entry Tax Item
P_CL_StRpJrnlEntryItemWithTax view_entity inner CONSUMPTION Journal Entry With Tax Log for Chilean Reports
P_CN_AcctStdInputVatAccDoc2 view_entity inner COMPOSITE Input Vat Document
P_GB_ParkedTaxItems view left_outer CONSUMPTION Parked customer/supplier items
P_HR_StRpTaxItem view_entity inner COMPOSITE Croatia selection for tax reporting
P_MX_DueDeferredTaxItem view inner COMPOSITE Mexico Due Deferred Tax Item
P_NL_SAFTVATCode view from COMPOSITE NL Audit File VAT Codes
P_NO_SAFTTAXRATE view inner COMPOSITE SAF-T Tax Rate
P_PE_PurDmstcSuplrTaxItem view inner CONSUMPTION Peru: Purchase Domestic Supplier Tax Item
P_PE_PurFrgnSuplrTaxItem view_entity inner CONSUMPTION Purchase Ledger Foreign Tax Items
P_PL_SAFTInvoiceTaxEUCode view inner COMPOSITE SAF-T PL get tax EU code
P_PT_CAOpenItemSum view_entity inner COMPOSITE Portugal Contract Accounting Sum of Open Items
P_RO_SAFTInvoiceItemCount view inner CONSUMPTION FI Document Relevant for Sales/Purchase Invoice Section
P_RO_SAFTNTRPurInvItem view_entity inner CONSUMPTION Purchase invoice items
P_RO_SAFTNTRPURINVWIAHEADER view_entity inner CONSUMPTION Purchase invoice WIA header
P_RO_SAFTNTRSlsInvItem view_entity inner CONSUMPTION Sales invoice items
P_RO_SAFTNTRSLSINVWIAHEADER view_entity inner CONSUMPTION Sales invoice WIA header
P_RU_TaxCode view from COMPOSITE Tax Category
P_SK_StRpVATCSDfrrdTaxItem view inner COMPOSITE SK VAT Control Statement Deferred Tax Item
P_SlsPurListBPTaxItem view left_outer CONSUMPTION Sales Purchase List BP Tax Item
P_StRpTaxItmWithEUTaxClass7 view inner COMPOSITE EU Sales tax Item View for Statutory Reporting
P_TH_TaxCodeRate view left_outer COMPOSITE Get all tax code configured in Thailand
R_TaxCodesPerCountry view_entity inner BASIC Tax Codes per Country

Fields (19)

KeyField CDS FieldsUsed in Views
KEY TargetTaxCode TargetTaxCode,TaxCode 9
KEY TaxCalculationProcedure TaxCalculationProcedure 14
KEY TaxCode TaxCode 11
KEY TaxType TaxType 19
_TaxCalculationProcedure _TaxCalculationProcedure 2
_TaxType _TaxType 2
_Text _TaxCodeText,_Text 3
EUAcqnInputTaxCode EUAcqnInputTaxCode 4
EUAcqnOutputTaxCode EUAcqnOutputTaxCode 4
EUTaxClassification EUTaxClassification 6
IsSalesTaxes IsSalesTaxes 3
MiniOneStopShopTxRptgCntry MiniOneStopShopTxRptgCntry 4
OneStopShopScheme OneStopShopScheme 2
OneStopShopTaxReportingCountry OneStopShopTaxReportingCountry 2
TaxCategory TaxCategory 1
TaxCodeIsInactive TaxCodeIsInactive 2
TaxReturnCountry TaxCodeReturnCountry,TaxReturnCountry 6
TaxTolerancePercent TaxTolerancePercent 3
UnitedStatesTaxCategory TaxCategory,UnitedStatesTaxCategory 3
@AccessControl.authorizationCheck: #NOT_REQUIRED

@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@Analytics.technicalName: 'IFITAXCODE'

@EndUserText.label: 'Tax Code'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.representativeKey: 'TaxCode'
@ObjectModel.sapObjectNodeType.name: 'SalesTaxCode'

@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #EXTRACTION_DATA_SOURCE ]

@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING }

@Search.searchable: true

@VDM.viewType: #BASIC

define view entity 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

{
      /* start suppress warning shlporigin_not_inherited */
      @ObjectModel.foreignKey.association: '_TaxCalculationProcedure'
  key kalsm                                                as TaxCalculationProcedure,

      /* end suppress warning shlporigin_not_inherited */
      @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, successor: 'UnitedStatesTaxCategory' }
      @Consumption.filter.hidden: true
      cast(txind as smwsk)                                 as TaxCategory,

      cast(txind as txind_007a preserving type)            as UnitedStatesTaxCategory,
      /* start suppress warning shlporigin_not_inherited */
      lstml                                                as TaxReturnCountry,
      /* end suppress warning shlporigin_not_inherited */
      cast(tolerance as fot_tax_tolerance preserving type) as TaxTolerancePercent,
      /* start suppress warning shlporigin_not_inherited */
      zmwsk_ese                                            as EUAcqnInputTaxCode,
      zmwsk_esa                                            as EUAcqnOutputTaxCode,
      /* end suppress warning shlporigin_not_inherited */
      xinact                                               as TaxCodeIsInactive,

      @API.element: { releaseState: #DEPRECATED, successor: 'OneStopShopTaxReportingCountry' }
      @Consumption.filter.hidden: true
      mossc                                                as MiniOneStopShopTxRptgCntry,

      mossc                                                as OneStopShopTaxReportingCountry,
      oss_classification                                   as OneStopShopScheme,

      _TaxCalculationProcedure,
      _TaxType,
      _Text
}