I_TAXCODE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
}