I_TaxClassification

DDL: I_TAXCLASSIFICATION SQL: IPVTAXCLASS Type: view BASIC Package: OIU_VDM_CDS

Tax Classification

I_TaxClassification (Basic)

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

Production Revenue Accounting Tax Classification · Cross Applications

I_TaxClassification is a Basic CDS View (Dimension) that provides data about "Tax Classification" in SAP S/4HANA. It reads from 1 data source (oiu_cm_taxcls) and exposes 6 fields with key fields Country, PrimaryGeogrlLocation, TaxClassification. It has 3 associations to related views. Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Analytical Dimension,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
oiu_cm_taxcls oiu_cm_taxcls from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..1] I_PrimaryGeogrlLocation _PrimaryGeogrlLocation $projection.Country = _PrimaryGeogrlLocation.Country and $projection.PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation
[0..*] I_TaxClassificationText _Text $projection.Country = _Text.Country and $projection.PrimaryGeogrlLocation = _Text.PrimaryGeogrlLocation and $projection.TaxClassification = _Text.TaxClassification

Annotations (15)

NameValueLevelField
EndUserText.label Tax Classification view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPVTAXCLASS view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey TaxClassification view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PRATaxClassification view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Country Country/Region Key
KEY PrimaryGeogrlLocation pri_geo_loc Primary Geographical Location
KEY TaxClassification tax_cls Tax Class
_Country _Country
_PrimaryGeogrlLocation _PrimaryGeogrlLocation
_Text _Text

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_TaxClassification.
-- 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: IPVTAXCLASS

CREATE VIEW I_TaxClassification AS
SELECT
  cast( country as land1_gp preserving type ) AS Country,
  pri_geo_loc AS PrimaryGeogrlLocation,
  tax_cls AS TaxClassification
FROM oiu_cm_taxcls
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON Country = _PrimaryGeogrlLocation.Country AND PrimaryGeogrlLocation = _PrimaryGeogrlLocation.PrimaryGeogrlLocation  -- association [0..1]
LEFT OUTER JOIN I_TaxClassificationText AS _Text ON Country = _Text.Country AND PrimaryGeogrlLocation = _Text.PrimaryGeogrlLocation AND TaxClassification = _Text.TaxClassification  -- association [0..*]
;