C_WithholdingTaxTrace

DDL: C_WITHHOLDINGTAXTRACE Type: view_entity CONSUMPTION Package: ODATA_EWHT_TRACE
74 Fields 1 Data Sources 2 Associations 2 OData Services

EWHT Trace Withholding Tax Lines

C_WithholdingTaxTrace is a Consumption CDS View that provides data about "EWHT Trace Withholding Tax Lines" in SAP S/4HANA. It reads from 1 data source (I_WithholdingTaxTrace) and exposes 74 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. It has 2 associations to related views. It is exposed through 2 OData services (UI_WITHHOLDINGANALYSISDISPLAY, UI_WITHHOLDINGTAXANALYSIS). Part of development package ODATA_EWHT_TRACE.

Data Sources (1)

SourceAliasJoin Type
I_WithholdingTaxTrace I_WithholdingTaxTrace from

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_WithholdingTaxFormula _Formula $projection.AccountingDocument = _Formula.AccountingDocument and $projection.CompanyCode = _Formula.CompanyCode and $projection.FiscalYear = _Formula.FiscalYear and $projection.AccountingDocumentItem = _Formula.AccountingDocumentItem and $projection.WithholdingTaxType = _Formula.WithholdingTaxType
[1..*] C_WhldgTaxRateByThreshold _Rules $projection.AccountingDocument = _Rules.AccountingDocument and $projection.CompanyCode = _Rules.CompanyCode and $projection.FiscalYear = _Rules.FiscalYear and $projection.AccountingDocumentItem = _Rules.AccountingDocumentItem and $projection.WithholdingTaxType = _Rules.WithholdingTaxType

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label EWHT Trace Withholding Tax Lines view
Search.searchable true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.query.implementedBy ABAP:CL_EWHT_TRACE_LIST_BUILDER view

OData Services (2)

ServiceBindingVersionContractRelease
UI_WITHHOLDINGANALYSISDISPLAY UI_WHTANALYSISDISPLAY V2 C1 NOT_RELEASED
UI_WITHHOLDINGTAXANALYSIS UI_WITHHOLDINGTAXANALYSIS V4 C1 NOT_RELEASED

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType WithholdingTaxType WTax Type
WithholdingTaxCode WithholdingTaxCode WTax Code
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy
WhldgTaxBaseAmtInTransacCrcy WhldgTaxBaseAmtInTransacCrcy
WhldgTaxBaseAmtInAddlCrcy2 WhldgTaxBaseAmtInAddlCrcy2
WhldgTaxBaseAmtInAddlCrcy3 WhldgTaxBaseAmtInAddlCrcy3
WhldgTaxBaseIsEnteredManually WhldgTaxBaseIsEnteredManually
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy
WhldgTaxAmtInTransacCrcy WhldgTaxAmtInTransacCrcy
WhldgTaxAmtInAddlCrcy2 WhldgTaxAmtInAddlCrcy2
WhldgTaxAmtInAddlCrcy3 WhldgTaxAmtInAddlCrcy3
WhldgTaxIsEnteredManually WhldgTaxIsEnteredManually
WhldgTaxItemStatus WhldgTaxItemStatus
WhldgTaxExmptAmtInCoCodeCrcy WhldgTaxExmptAmtInCoCodeCrcy
WhldgTaxExmptAmtInTransacCrcy WhldgTaxExmptAmtInTransacCrcy
WhldgTaxExmptAmtInAddlCrcy2 WhldgTaxExmptAmtInAddlCrcy2
WhldgTaxExmptAmtInAddlCrcy3 WhldgTaxExmptAmtInAddlCrcy3
WhldgTaxExmptCertificate WhldgTaxExmptCertificate Exemption Number
FinancialAccountType FinancialAccountType Fin. Account Type
CustomerSupplierAccount CustomerSupplierAccount
GLAccount GLAccount General Ledger
SupplierRecipientType SupplierRecipientType
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingDate ClearingDate Clearing Date
WithholdingTaxExmptPercent WithholdingTaxExmptPercent Exemption Rate
WithholdingTaxPercent WithholdingTaxPercent
IsSelfWhldgTax IsSelfWhldgTax
IsGrossingUp IsGrossingUp
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
WhldgTaxCertDate WhldgTaxCertDate
IN_ClrgWithholdingTaxDocument IN_ClrgWithholdingTaxDocument
IN_ClrgWithholdingTaxDate IN_ClrgWithholdingTaxDate
IN_ReferenceDocumentNumber IN_ReferenceDocumentNumber
DownPaymentIsCleared DownPaymentIsCleared
DocumentIsPartialExempted DocumentIsPartialExempted
IN_WhldgTaxRecordTypeTrans IN_WhldgTaxRecordTypeTrans
PostingDate PostingDate Posting Date for GR
IsReversed IsReversed Reversed?
DiscountAmtInCoCodeCrcy DiscountAmtInCoCodeCrcy
WhldgTaxPostingTimePoint WhldgTaxPostingTimePoint
Country Country Venue: Ctry/Reg
CompanyCodeCurrency _CompanyCode Currency Valuation Crcy
DocumentCurrency _AccountingDocument Currency Valuation Crcy
AdditionalCurrency1 _AccountingDocument AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 _AccountingDocument AdditionalCurrency2 Local curr. 3
RptgWhldgTxBaseAmtInCoCodeCrcy RptgWhldgTxBaseAmtInCoCodeCrcy
WhgdTaxPostingIsRequired WhgdTaxPostingIsRequired Post WTax Amount
IsUsedInPaymentTransaction IsUsedInPaymentTransaction Is Used In Payment Transaction
RequiredStartDate RequiredStartDate Req. Start Date
RequiredEndDate RequiredEndDate Req. End Date
WithholdingTaxValidFromDate WithholdingTaxValidFromDate Valid From
ValidityEndDate ValidityEndDate ValidTo
ExemptionDateBegin ExemptionDateBegin Exempt From
ExemptionDateEnd ExemptionDateEnd Exempt To
WhldgTaxRelevantPercent WhldgTaxRelevantPercent Percentage Subject to Tax
NoWhldgTaxReasonCode NoWhldgTaxReasonCode
WhgdTxBaseAmtIsReduced WhgdTxBaseAmtIsReduced Base amnt reductn
ReferentialWhldgTaxType ReferentialWhldgTaxType
ReversalJournalEntryFiscalYear ReversalJournalEntryFiscalYear Year
CountryName CountryName Country
WithholdingTaxTypeName WithholdingTaxTypeName
WhldgTaxCodeName WhldgTaxCodeName
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CompanyCodeName _CompanyCode CompanyCodeName Company Name
_CompanyCode _CompanyCode
_AccountingDocument _AccountingDocument
_GLAccount _GLAccount
_Formula _Formula
_Rules _Rules
_Country _Country

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 C_WithholdingTaxTrace.
-- 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 C_WithholdingTaxTrace AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  WithholdingTaxType,
  WithholdingTaxCode,
  WhldgTaxBaseAmtInCoCodeCrcy,
  WhldgTaxBaseAmtInTransacCrcy,
  WhldgTaxBaseAmtInAddlCrcy2,
  WhldgTaxBaseAmtInAddlCrcy3,
  WhldgTaxBaseIsEnteredManually,
  WhldgTaxAmtInCoCodeCrcy,
  WhldgTaxAmtInTransacCrcy,
  WhldgTaxAmtInAddlCrcy2,
  WhldgTaxAmtInAddlCrcy3,
  WhldgTaxIsEnteredManually,
  WhldgTaxItemStatus,
  WhldgTaxExmptAmtInCoCodeCrcy,
  WhldgTaxExmptAmtInTransacCrcy,
  WhldgTaxExmptAmtInAddlCrcy2,
  WhldgTaxExmptAmtInAddlCrcy3,
  WhldgTaxExmptCertificate,
  FinancialAccountType,
  CustomerSupplierAccount,
  GLAccount,
  SupplierRecipientType,
  ClearingAccountingDocument,
  ClearingDate,
  WithholdingTaxExmptPercent,
  WithholdingTaxPercent,
  IsSelfWhldgTax,
  IsGrossingUp,
  WithholdingTaxCertificate,
  WhldgTaxCertDate,
  IN_ClrgWithholdingTaxDocument,
  IN_ClrgWithholdingTaxDate,
  IN_ReferenceDocumentNumber,
  DownPaymentIsCleared,
  DocumentIsPartialExempted,
  IN_WhldgTaxRecordTypeTrans,
  PostingDate,
  IsReversed,
  DiscountAmtInCoCodeCrcy,
  WhldgTaxPostingTimePoint,
  Country,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  _AccountingDocument.Currency AS DocumentCurrency,
  _AccountingDocument.AdditionalCurrency1 AS AdditionalCurrency1,
  _AccountingDocument.AdditionalCurrency2 AS AdditionalCurrency2,
  RptgWhldgTxBaseAmtInCoCodeCrcy,
  WhgdTaxPostingIsRequired,
  IsUsedInPaymentTransaction,
  RequiredStartDate,
  RequiredEndDate,
  WithholdingTaxValidFromDate,
  ValidityEndDate,
  ExemptionDateBegin,
  ExemptionDateEnd,
  WhldgTaxRelevantPercent,
  NoWhldgTaxReasonCode,
  WhgdTxBaseAmtIsReduced,
  ReferentialWhldgTaxType,
  ReversalJournalEntryFiscalYear,
  CountryName,
  WithholdingTaxTypeName,
  WhldgTaxCodeName,
  BusinessPartnerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_WithholdingTaxTrace
LEFT OUTER JOIN C_WithholdingTaxFormula AS _Formula ON AccountingDocument = _Formula.AccountingDocument AND CompanyCode = _Formula.CompanyCode AND FiscalYear = _Formula.FiscalYear AND AccountingDocumentItem = _Formula.AccountingDocumentItem AND WithholdingTaxType = _Formula.WithholdingTaxType  -- association [1..*]
LEFT OUTER JOIN C_WhldgTaxRateByThreshold AS _Rules ON AccountingDocument = _Rules.AccountingDocument AND CompanyCode = _Rules.CompanyCode AND FiscalYear = _Rules.FiscalYear AND AccountingDocumentItem = _Rules.AccountingDocumentItem AND WithholdingTaxType = _Rules.WithholdingTaxType  -- association [1..*]
;

Learn More