I_PurProductTaxClassification

DDL: I_PURPRODUCTTAXCLASSIFICATION SQL: IMMPRDPURTAXCLS Type: view BASIC

Purchasing Product Tax Classification

I_PurProductTaxClassification (Basic)

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

Purchase Product Tax Classification · Database & Data Management

I_PurProductTaxClassification is a Basic CDS View (Dimension) that provides data about "Purchasing Product Tax Classification" in SAP S/4HANA. It reads from 1 data source (tmkm1) and exposes 4 fields with key fields ProdPurchaseTaxClassification, DestinationCountry. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentMM
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source for Search, Data Source in SQL Select, Data Provider for Value Help
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tmkm1 tmkm1 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.DestinationCountry = _Country.Country
[0..*] I_PurProductTaxClassificationT _Text $projection.DestinationCountry = _Text.DestinationCountry and $projection.ProdPurchaseTaxClassification = _Text.ProdPurchaseTaxClassification

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IMMPRDPURTAXCLS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchasing Product Tax Classification view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProdPurchaseTaxClassification view
ObjectModel.sapObjectNodeType.name PurProductTaxClassification view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ProdPurchaseTaxClassification taxim Tax indicator for material (Purchasing)
KEY DestinationCountry land1 Country/Region of Destination of Goods
_Text _Text
_Country _Country

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_PurProductTaxClassification.
-- 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: IMMPRDPURTAXCLS

CREATE VIEW I_PurProductTaxClassification AS
SELECT
  taxim AS ProdPurchaseTaxClassification,
  land1 AS DestinationCountry
FROM tmkm1
LEFT OUTER JOIN I_Country AS _Country ON DestinationCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_PurProductTaxClassificationT AS _Text ON DestinationCountry = _Text.DestinationCountry AND ProdPurchaseTaxClassification = _Text.ProdPurchaseTaxClassification  -- association [0..*]
;