I_WithholdingTaxFormula

DDL: I_WITHHOLDINGTAXFORMULA SQL: IEWHTFORMULA Type: view_entity BASIC Package: ODATA_EWHT_TRACE
9 Fields 1 Data Sources

EWHT Trace Formula

I_WithholdingTaxFormula is a Basic CDS View that provides data about "EWHT Trace Formula" in SAP S/4HANA. It reads from 1 data source (with_trace) and exposes 9 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. Part of development package ODATA_EWHT_TRACE.

Data Sources (1)

SourceAliasJoin Type
with_trace with_trace from

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label EWHT Trace Formula view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY AccountingDocument belnr SD Document
KEY FiscalYear gjahr Settlement Year
KEY AccountingDocumentItem buzei Posting View Item
KEY WithholdingTaxType witht WTax Type
KEY WhldgTaxCalcFormulaCategory
WhldgTaxCalcFormulaLeftValue
WhldgTaxCalcFormulaOperator
WhldgTaxCalcFormulaRightValue

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_WithholdingTaxFormula.
-- 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: IEWHTFORMULA

CREATE VIEW I_WithholdingTaxFormula AS
SELECT
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  buzei AS AccountingDocumentItem,
  witht AS WithholdingTaxType,
  cast( '' as fis_wtcalc_category) AS WhldgTaxCalcFormulaCategory,
  cast( '' as fis_wtcalc_leftsidevalue) AS WhldgTaxCalcFormulaLeftValue,
  cast( '' as fis_wtcalc_operator) AS WhldgTaxCalcFormulaOperator,
  cast( '' as fis_wtcalc_rightsidevalue) AS WhldgTaxCalcFormulaRightValue
FROM with_trace
;

Learn More