P_TH_TaxCodeRate

DDL: P_TH_TAXCODERATE SQL: PTHTAXCODERATE Type: view COMPOSITE

P_TH_TaxCodeRate is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (a003, I_TaxCode, konp) and exposes 6 fields with key fields TaxCode, ConditionType, TaxCalculationProcedure.

Data Sources (3)

SourceAliasJoin Type
a003 a003 from
I_TaxCode I_TaxCode left_outer
konp konp left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PTHTAXCODERATE view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY TaxCode a003 mwskz Tax Code
KEY ConditionType a003 kschl Tax Item Type
KEY TaxCalculationProcedure I_TaxCode TaxCalculationProcedure Tax Procedure
ConditionNumber a003 knumh NoCondRec.Batch
TaxType I_TaxCode TaxType Tax Type
TaxRate

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_TH_TaxCodeRate.
-- 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: PTHTAXCODERATE

CREATE VIEW P_TH_TaxCodeRate AS
SELECT
  a003.mwskz AS TaxCode,
  a003.kschl AS ConditionType,
  I_TaxCode.TaxCalculationProcedure AS TaxCalculationProcedure,
  a003.knumh AS ConditionNumber,
  I_TaxCode.TaxType AS TaxType,
  division ( konp.kbetr , 10, 2 ) AS TaxRate
FROM a003
LEFT OUTER JOIN konp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaxCode ON /* join condition not captured in parsed metadata */
;