I_Taxclass

DDL: I_TAXCLASS Type: view BASIC Package: VDM_MD_PRODUCT_DDIC

Tax Classification

I_Taxclass (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Database & Data Management

I_Taxclass is a Basic CDS View that provides data about "Tax Classification" in SAP S/4HANA. It reads from 1 data source (tskm) and exposes 4 fields with key fields TaxClassificationCategory, TaxClassification. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT_DDIC.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-MM-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Provider for Value Help,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Not Released
Release State (Developer)Released
PackageDatabase and Data Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides a value help for tax classifications used in pricing and tax determination.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the available tax classifications in the system?</p></li> <li><p>Which tax classification category does a specific tax classification belong to?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
tskm tskm from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_Taxclasstext _Text $projection.TaxClassification = _Text.TaxClassification and $projection.TaxClassificationCategory = _Text.TaxClassificationCategory
[0..1] I_PricingConditionType _TaxClassificationCategory $projection.TaxClassificationCategory = _TaxClassificationCategory.ConditionType and _TaxClassificationCategory.ConditionApplication = 'V'

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName ITAXCLASSVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Tax Classification view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey TaxClassification view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TaxClassificationCategory tskm tatyp Condition type for sales tax, VAT, or other tax types
KEY TaxClassification tskm taxkm Tax Classification for Material
_Text _Text
_TaxClassificationCategory _TaxClassificationCategory

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_Taxclass.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_Taxclass AS
SELECT
  tskm.tatyp AS TaxClassificationCategory,
  tskm.taxkm AS TaxClassification
FROM tskm
LEFT OUTER JOIN I_Taxclasstext AS _Text ON TaxClassification = _Text.TaxClassification AND TaxClassificationCategory = _Text.TaxClassificationCategory  -- association [0..*]
LEFT OUTER JOIN I_PricingConditionType AS _TaxClassificationCategory ON TaxClassificationCategory = _TaxClassificationCategory.ConditionType AND _TaxClassificationCategory.ConditionApplication = 'V'  -- association [0..1]
;