P_TaxExplainerTaxComponent

DDL: P_TAXEXPLAINERTAXCOMPONENT Type: view_entity COMPOSITE Package: GLO_TAXEXPLAIN
13 Fields 2 Data Sources 2 Associations

Tax component details for tax explainer

P_TaxExplainerTaxComponent is a Composite CDS View that provides data about "Tax component details for tax explainer" in SAP S/4HANA. It reads from 2 data sources (P_TaxExplainerConditionRecord, I_PricingElement) and exposes 13 fields with key fields PricingDocument, PricingDocumentItem, ConditionType. It has 2 associations to related views. Part of development package GLO_TAXEXPLAIN.

Data Sources (2)

SourceAliasJoin Type
P_TaxExplainerConditionRecord ConditionRecord inner
I_PricingElement PricingElement from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ConditionTypeText _Text PricingElement.ConditionType = _Text.ConditionType and PricingElement.ConditionApplication = _Text.ConditionApplication
[0..*] P_TaxExplainerTaxFactor _TaxFactor $projection.ConditionTable = _TaxFactor.ConditionTable and $projection.accesssequence = _TaxFactor.AccessSequence

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PricingDocument I_PricingElement PricingDocument Document Condition
KEY PricingDocumentItem I_PricingElement PricingDocumentItem Item
KEY ConditionType I_PricingElement ConditionType Condition type
ConditionTypeName
TransactionCurrency I_PricingElement TransactionCurrency Transaction Currency
ConditionBaseAmount I_PricingElement ConditionBaseAmount Condition Basis Amount
ConditionAmount I_PricingElement ConditionAmount Condition Value
ConditionRateValue I_PricingElement ConditionRateValue Condition Rate Value
ConditionRateValueUnit
ConditionRecord P_TaxExplainerConditionRecord ConditionRecord Cond.Record No.
ConditionTable P_TaxExplainerConditionRecord ConditionTable Condition Table
AccessSequence
_TaxFactor _TaxFactor

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 P_TaxExplainerTaxComponent.
-- 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 P_TaxExplainerTaxComponent AS
SELECT
  PricingElement.PricingDocument AS PricingDocument,
  PricingElement.PricingDocumentItem AS PricingDocumentItem,
  PricingElement.ConditionType AS ConditionType,
  coalesce(_Text[1: Language = $session.system_language].ConditionTypeName, _Text[1: Language = 'E'].ConditionTypeName) AS ConditionTypeName,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionBaseAmount AS ConditionBaseAmount,
  PricingElement.ConditionAmount AS ConditionAmount,
  PricingElement.ConditionRateValue AS ConditionRateValue,
  '%' AS ConditionRateValueUnit,
  ConditionRecord.ConditionRecord AS ConditionRecord,
  ConditionRecord.ConditionTable AS ConditionTable,
  PricingElement._PricingConditionType.AccessSequence AS AccessSequence
FROM I_PricingElement AS PricingElement
INNER JOIN P_TaxExplainerConditionRecord AS ConditionRecord ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ConditionTypeText AS _Text ON PricingElement.ConditionType = _Text.ConditionType AND PricingElement.ConditionApplication = _Text.ConditionApplication  -- association [0..*]
LEFT OUTER JOIN P_TaxExplainerTaxFactor AS _TaxFactor ON ConditionTable = _TaxFactor.ConditionTable AND accesssequence = _TaxFactor.AccessSequence  -- association [0..*]
;

Learn More