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