I_CL_StRpAddlWhldgTaxItemC

DDL: I_CL_STRPADDLWHLDGTAXITEMC Type: view_entity COMPOSITE Package: GLO_FIN_IS_WHT_CL
47 Fields 1 Data Sources 3 Associations

CL Addl Whldng Tax Reporting - Cube

I_CL_StRpAddlWhldgTaxItemC is a Composite CDS View (Cube) that provides data about "CL Addl Whldng Tax Reporting - Cube" in SAP S/4HANA. It reads from 1 data source (I_StRpWhldgTaxItem) and exposes 47 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, WithholdingTaxType. It has 3 associations to related views. Part of development package GLO_FIN_IS_WHT_CL.

Data Sources (1)

SourceAliasJoin Type
I_StRpWhldgTaxItem wht from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_JournalEntry _ClearingJournalEntry wht.CompanyCode = _ClearingJournalEntry.CompanyCode and wht.ClearingJournalEntry = _ClearingJournalEntry.AccountingDocument and wht.ClearingJournalEntryFiscalYear = _ClearingJournalEntry.FiscalYear
[0..1] I_Businesspartnertaxnumber _BPTxNmbr1 wht.BusinessPartnerNumber = _BPTxNmbr1.BusinessPartner and _BPTxNmbr1.BPTaxType = 'CL1'
[0..1] I_CountryText _CountryText _CountryText.Country = wht.BusinessPartnerCountry and _CountryText.Language = $session.system_language

Annotations (11)

NameValueLevelField
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CL Addl Whldng Tax Reporting - Cube view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpWhldgTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpWhldgTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpWhldgTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_StRpWhldgTaxItem AccountingDocumentItem Posting View Item
KEY WithholdingTaxType I_StRpWhldgTaxItem WithholdingTaxType WTax Type
KEY StatryRptgEntity I_StRpWhldgTaxItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpWhldgTaxItem StatryRptCategory Report ID
KEY StatryRptRunID I_StRpWhldgTaxItem StatryRptRunID Report Run ID
WhldgTaxDocumentType I_StRpWhldgTaxItem WhldgTaxDocumentType 3-Byte field
PostingDate
DocumentDate
ClearingDate I_StRpWhldgTaxItem ClearingDate Clearing Date
ClearingDateendasReportingDate
WithholdingTaxCode I_StRpWhldgTaxItem WithholdingTaxCode WTax Code
OfficialWhldgTaxCode
WhldgTaxCodeName
WithholdingTaxIncomeType I_StRpWhldgTaxItem WithholdingTaxIncomeType
ClearingJournalEntry I_StRpWhldgTaxItem ClearingJournalEntry Clrng doc.
DocumentReferenceID I_StRpWhldgTaxItem DocumentReferenceID Reference
DocumentItemText I_StRpWhldgTaxItem DocumentItemText Text
CalendarMonth
BusinessPartner I_StRpWhldgTaxItem BusinessPartner Issuing Authority
BusinessPartnerNumber I_StRpWhldgTaxItem BusinessPartnerNumber
Name I_StRpWhldgTaxItem Name Zone name
BusinessPartnerCountry I_StRpWhldgTaxItem BusinessPartnerCountry BP Ctry/Reg.
BusinessPartnerCountryName _CountryText CountryName Country
IsOneTimeAccount
TaxNumber1endasstcd1asTaxNumber1
ExchangeRateType _ClearingJournalEntry ExchangeRateType Exch. Rate Type
ExchangeRateDate _ClearingJournalEntry ExchangeRateDate Translatn Date
ReportingCurrency I_StRpWhldgTaxItem ReportingCurrency Currency
WithholdingTaxPercent I_StRpWhldgTaxItem WithholdingTaxPercent
TransactionCurrency I_StRpWhldgTaxItem TransactionCurrency Transaction Currency
AdditionalCurrency1 I_StRpWhldgTaxItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_StRpWhldgTaxItem AdditionalCurrency2 Local curr. 3
WhldgTaxBaseAmtInTransacCrcy I_StRpWhldgTaxItem WhldgTaxBaseAmtInTransacCrcy
WhldgTaxBaseAmtInAddlCrcy2 I_StRpWhldgTaxItem WhldgTaxBaseAmtInAddlCrcy2
WhldgTaxBaseAmtInAddlCrcy3 I_StRpWhldgTaxItem WhldgTaxBaseAmtInAddlCrcy3
WhldgTaxAmtInTransacCrcy I_StRpWhldgTaxItem WhldgTaxAmtInTransacCrcy
WhldgTaxAmtInAddlCrcy2 I_StRpWhldgTaxItem WhldgTaxAmtInAddlCrcy2
WhldgTaxAmtInAddlCrcy3 I_StRpWhldgTaxItem WhldgTaxAmtInAddlCrcy3
AmountInTransactionCurrency
AmountInAdditionalCurrency1
AmountInAdditionalCurrency2
WhldgTxDdctdNetAmtInTransCrcy
IsReversal I_StRpWhldgTaxItem IsReversal Reversal doc.
IsReversed I_StRpWhldgTaxItem IsReversed Reversed?

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_CL_StRpAddlWhldgTaxItemC.
-- 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 I_CL_StRpAddlWhldgTaxItemC AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.StatryRptgEntity AS StatryRptgEntity,
  wht.StatryRptCategory AS StatryRptCategory,
  wht.StatryRptRunID AS StatryRptRunID,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht._JournalEntry.PostingDate AS PostingDate,
  wht._JournalEntry.DocumentDate AS DocumentDate,
  wht.ClearingDate AS ClearingDate,
  case when wht.WhldgTaxRptgDateIsActive = 'X' then wht.WithholdingTaxReportingDate else wht.ClearingDate end as ReportingDate AS ClearingDateendasReportingDate,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht._WithholdingTaxCode.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht._WithholdingTaxCode._CodeText[1:Language = $session.system_language].WhldgTaxCodeName AS WhldgTaxCodeName,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.ClearingJournalEntry AS ClearingJournalEntry,
  wht.DocumentReferenceID AS DocumentReferenceID,
  wht.DocumentItemText AS DocumentItemText,
  cast( substring(wht.ClearingDate, 5, 2) as calendarmonth ) AS CalendarMonth,
  wht.BusinessPartner AS BusinessPartner,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.Name AS Name,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  _CountryText.CountryName AS BusinessPartnerCountryName,
  wht._Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  cast(case wht._Supplier.IsOneTimeAccount when '' then coalesce(_BPTxNmbr1.BPTaxNumber,'') else wht.TaxNumber1 end as stcd1) as TaxNumber1 AS TaxNumber1endasstcd1asTaxNumber1,
  _ClearingJournalEntry.ExchangeRateType AS ExchangeRateType,
  _ClearingJournalEntry.ExchangeRateDate AS ExchangeRateDate,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.WithholdingTaxPercent AS WithholdingTaxPercent,
  wht.TransactionCurrency AS TransactionCurrency,
  wht.AdditionalCurrency1 AS AdditionalCurrency1,
  wht.AdditionalCurrency2 AS AdditionalCurrency2,
  wht.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  wht.WhldgTaxBaseAmtInAddlCrcy2 AS WhldgTaxBaseAmtInAddlCrcy2,
  wht.WhldgTaxBaseAmtInAddlCrcy3 AS WhldgTaxBaseAmtInAddlCrcy3,
  wht.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  wht.WhldgTaxAmtInAddlCrcy2 AS WhldgTaxAmtInAddlCrcy2,
  wht.WhldgTaxAmtInAddlCrcy3 AS WhldgTaxAmtInAddlCrcy3,
  wht.AmountInTransactionCurrency * -1 AS AmountInTransactionCurrency,
  wht.AmountInAdditionalCurrency1 * -1 AS AmountInAdditionalCurrency1,
  wht.AmountInAdditionalCurrency2 * -1 AS AmountInAdditionalCurrency2,
  ( wht.AmountInTransactionCurrency * -1 ) - wht.WhldgTaxAmtInTransacCrcy AS WhldgTxDdctdNetAmtInTransCrcy,
  wht.IsReversal AS IsReversal,
  wht.IsReversed AS IsReversed
FROM I_StRpWhldgTaxItem AS wht
LEFT OUTER JOIN I_JournalEntry AS _ClearingJournalEntry ON wht.CompanyCode = _ClearingJournalEntry.CompanyCode AND wht.ClearingJournalEntry = _ClearingJournalEntry.AccountingDocument AND wht.ClearingJournalEntryFiscalYear = _ClearingJournalEntry.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _BPTxNmbr1 ON wht.BusinessPartnerNumber = _BPTxNmbr1.BusinessPartner AND _BPTxNmbr1.BPTaxType = 'CL1'  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = wht.BusinessPartnerCountry AND _CountryText.Language = $session.system_language  -- association [0..1]
;

Learn More