I_Taxclasstext

DDL: I_TAXCLASSTEXT Type: view BASIC Package: VDM_MD_PRODUCT_DDIC

Tax Classification - Text

I_Taxclasstext (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_Taxclasstext is a Basic CDS View that provides data about "Tax Classification - Text" in SAP S/4HANA. It reads from 1 data source (tskmt) and exposes 5 fields with key fields TaxClassificationCategory, Language, TaxClassification. It has 1 association 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,Language-Dependent Text,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

Documentation

Data Sources (1)

SourceAliasJoin Type
tskmt tskmt from

Associations (1)

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

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ITAXCLSTXT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Tax Classification - Text view
Search.searchable true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TaxClassification view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TaxClassificationCategory tskmt tatyp Condition type for sales tax, VAT, or other tax types
KEY Language tskmt spras Off. Language
KEY TaxClassification tskmt taxkm Tax Classification for Material
TaxClassificationName vtext Wgh.Dat.Ty.Txt.
_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_Taxclasstext.
-- 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_Taxclasstext AS
SELECT
  tskmt.tatyp AS TaxClassificationCategory,
  tskmt.spras AS Language,
  tskmt.taxkm AS TaxClassification,
  vtext AS TaxClassificationName
FROM tskmt
LEFT OUTER JOIN I_PricingConditionType AS _TaxClassificationCategory ON TaxClassificationCategory = _TaxClassificationCategory.ConditionType AND _TaxClassificationCategory.ConditionApplication = 'V'  -- association [0..1]
;