I_ProcmtHubTaxCodeText

DDL: I_PROCMTHUBTAXCODETEXT SQL: IPROCHUBTAXCDTXT Type: view BASIC
7 Fields 1 Data Sources 1 Associations

Procurement Hub Tax Code Text

I_ProcmtHubTaxCodeText is a Basic CDS View that provides data about "Procurement Hub Tax Code Text" in SAP S/4HANA. It reads from 1 data source (mmpur_ext_t007s) and exposes 7 fields with key fields Client, TaxCode, ExtSourceSystem, Language, TaxCalculationProcedure. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mmpur_ext_t007s mmpur_ext_t007s from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPROCHUBTAXCDTXT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Procurement Hub Tax Code Text view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey TaxCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Client mandt Editing Client
KEY TaxCode taxcode Tax Code
KEY ExtSourceSystem extsourcesystem Connected System ID
KEY Language language Report Text Language
KEY TaxCalculationProcedure taxprocedure Procedure
TaxCodeName taxcodename Tax Code Name
_Language _Language

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_ProcmtHubTaxCodeText.
-- 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: IPROCHUBTAXCDTXT

CREATE VIEW I_ProcmtHubTaxCodeText AS
SELECT
  mandt AS Client,
  TaxCode,
  ExtSourceSystem,
  Language,
  taxprocedure AS TaxCalculationProcedure,
  TaxCodeName
FROM mmpur_ext_t007s
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More