I_TaxCode
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)
| Source | Alias | Join Type |
|---|---|---|
| t007a | t007a | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| C_BILLGDOCREDACTED_SD | C_BILLGDOCREDACTED | V2 | C1 | NOT_RELEASED |
Fields (19)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA