What is I_ProductTaxClassification in SAP S/4HANA?

I_ProductTaxClassification is a basic CDS view in SAP S/4HANA. Tax Classification for Product It contains 14 fields.

Which tables does I_ProductTaxClassification read from?

I_ProductTaxClassification reads data from: mlan.

What VDM layer is I_ProductTaxClassification?

I_ProductTaxClassification is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProductTaxClassification

DDL: I_PRODUCTTAXCLASSIFICATION SQL: IPRDTAXCLASSFCTN Type: view BASIC

14 Fields 1 Data Sources 3 Associations

Tax Classification for Product

I_ProductTaxClassification (Basic)

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

Product Tax Classification · Database & Data Management

I_ProductTaxClassification is a Basic CDS View (Dimension) that provides data about "Tax Classification for Product" in SAP S/4HANA. It reads from 1 data source (mlan) and exposes 14 fields with key fields Product, Country. It has 3 associations to related views.

SAP API Hub

State	C1
Line of Business	Database & Data Management
Application Component	LO-MD-MM
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
Package	Database & Data Management for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the consumer with list of sales tax records along with Product, Country and and it's TaxClassification.</p> <p>Customers can use this information to find out the county specific tax details of the products.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
mlan	tax	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_Product	_Product	`$projection.Product = _Product.Product`
[1..1]	I_Country	_Country	`$projection.Country = _Country.Country`
[0..*]	I_CountryText	_CountryName	`$projection.Country = _CountryName.Country`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	IPRDTAXCLASSFCTN	view
VDM.viewType	#BASIC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Tax Classification for Product	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.representativeKey	Product	view
Metadata.allowExtensions	true	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	true	view

Fields (14)

Key	Field	Source Table	Source Field	Description
KEY	Product			Product Number
KEY	Country	mlan	aland	Departure Country/Region (from which the goods are sent)
	TaxClassification1	mlan	taxm1	Tax classification material
	TaxClassification2	mlan	taxm2	Tax classification material
	TaxClassification3	mlan	taxm3	Tax classification material
	TaxClassification4	mlan	taxm4	Tax classification material
	TaxClassification5	mlan	taxm5	Tax classification material
	TaxClassification6	mlan	taxm6	Tax classification material
	TaxClassification7	mlan	taxm7	Tax classification material
	TaxClassification8	mlan	taxm8	Tax classification material
	TaxClassification9	mlan	taxm9	Tax classification material
	_Product		_Product
	_Country		_Country
	_CountryName		_CountryName

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_ProductTaxClassification.
-- 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.
-- SQL view name: IPRDTAXCLASSFCTN

CREATE VIEW I_ProductTaxClassification AS
SELECT
  cast (tax.matnr as productnumber preserving type ) AS Product,
  tax.aland AS Country,
  tax.taxm1 AS TaxClassification1,
  tax.taxm2 AS TaxClassification2,
  tax.taxm3 AS TaxClassification3,
  tax.taxm4 AS TaxClassification4,
  tax.taxm5 AS TaxClassification5,
  tax.taxm6 AS TaxClassification6,
  tax.taxm7 AS TaxClassification7,
  tax.taxm8 AS TaxClassification8,
  tax.taxm9 AS TaxClassification9
FROM mlan AS tax
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _CountryName ON Country = _CountryName.Country  -- association [0..*]
;

Depth:

I_ProductTaxClassification view

mlan