I_StRpWhldgTaxItem

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_StRpWhldgTaxItem.
-- 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_StRpWhldgTaxItem AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  _StRpJournalEntryHeaderLog.StatryRptgEntity AS StatryRptgEntity,
  _StRpJournalEntryHeaderLog.StatryRptCategory AS StatryRptCategory,
  _StRpJournalEntryHeaderLog.StatryRptRunID AS StatryRptRunID,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht._WithholdingTaxCode.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht.Country AS Country,
  wht.BusinessPlace AS BusinessPlace,
  wht.BusinessArea AS BusinessArea,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.Debtor AS Debtor,
  wht.Creditor AS Creditor,
  wht.CustomerName AS CustomerName,
  wht.BPCustomerName AS BPCustomerName,
  wht.BusinessPartner AS BusinessPartner,
  wht.FiscalPeriod AS FiscalPeriod,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  _WHTRptDateActive.WhldgTaxRptgDateIsActive AS WhldgTaxRptgDateIsActive,
  _WHTRptDateActive.DefaultWhldgTxRptgDateIsActive AS DefaultWhldgTxRptgDateIsActive,
  case when _WHTRptDateActive.WhldgTaxRptgDateIsActive = 'X' and _WHTRptDateActive.DefaultWhldgTxRptgDateIsActive = '1' then wht.WithholdingTaxReportingDate else wht.PostingDate end as PostingDate AS PostingDateendasPostingDate,
  case when _WHTRptDateActive.WhldgTaxRptgDateIsActive = 'X' and _WHTRptDateActive.DefaultWhldgTxRptgDateIsActive = '2' then wht.WithholdingTaxReportingDate else wht.DocumentDate end as DocumentDate AS DocumentDateendasDocumentDate,
  case when _WHTRptDateActive.WhldgTaxRptgDateIsActive = 'X' then wht.WithholdingTaxReportingDate else wht.ReportingDate end as ReportingDate AS ReportingDateendasReportingDate,
  wht.ClearingDate AS ClearingDate,
  wht.ClearingAccountingDocument AS ClearingAccountingDocument,
  wht.ClearingJournalEntry AS ClearingJournalEntry,
  wht.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  wht.PostingKey AS PostingKey,
  wht.AccountingDocumentType AS AccountingDocumentType,
  wht.SpecialGLCode AS SpecialGLCode,
  wht.SpecialGLTransactionType AS SpecialGLTransactionType,
  wht.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  wht.InvoiceReference AS InvoiceReference,
  wht.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  wht.InvoiceItemReference AS InvoiceItemReference,
  wht.TaxSection AS TaxSection,
  wht.IsReversed AS IsReversed,
  wht.IsReversal AS IsReversal,
  wht.ReverseDocument AS ReverseDocument,
  wht.DebitCreditCode AS DebitCreditCode,
  wht.ClearingItem AS ClearingItem,
  wht.ExchangeRateType AS ExchangeRateType,
  wht._JournalEntry.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.TransactionCurrency AS TransactionCurrency,
  wht.AdditionalCurrency1 AS AdditionalCurrency1,
  wht.AdditionalCurrency2 AS AdditionalCurrency2,
  wht.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  wht.AmountInLocalCurrency AS AmountInLocalCurrency,
  wht.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  wht.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  wht.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  wht.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  wht.TaxAmount AS TaxAmount,
  wht.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  wht.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  wht.WhldgTaxBaseAmtInAddlCrcy2 AS WhldgTaxBaseAmtInAddlCrcy2,
  wht.WhldgTaxBaseAmtInAddlCrcy3 AS WhldgTaxBaseAmtInAddlCrcy3,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  wht.WhldgTaxAmtInAddlCrcy2 AS WhldgTaxAmtInAddlCrcy2,
  wht.WhldgTaxAmtInAddlCrcy3 AS WhldgTaxAmtInAddlCrcy3,
  wht.WhldgTaxBaseIsEnteredManually AS WhldgTaxBaseIsEnteredManually,
  wht.WhldgTaxIsEnteredManually AS WhldgTaxIsEnteredManually,
  wht.WhldgTaxItemStatus AS WhldgTaxItemStatus,
  wht.AggrgdWhldgTxBaseAmtInCCCrcy AS AggrgdWhldgTxBaseAmtInCCCrcy,
  wht.AggrgdWhldgTaxAmtInCCCrcy AS AggrgdWhldgTaxAmtInCCCrcy,
  wht.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  wht.WhldgTaxExmptAmtInCoCodeCrcy AS WhldgTaxExmptAmtInCoCodeCrcy,
  wht.WhldgTaxExmptAmtInTransacCrcy AS WhldgTaxExmptAmtInTransacCrcy,
  wht.WhldgTaxExmptAmtInAddlCrcy2 AS WhldgTaxExmptAmtInAddlCrcy2,
  wht.WhldgTaxExmptAmtInAddlCrcy3 AS WhldgTaxExmptAmtInAddlCrcy3,
  wht.WhldgTaxDeductedNetAmount AS WhldgTaxDeductedNetAmount,
  wht.WhldgTxDdctdNetAmtInTransCrcy AS WhldgTxDdctdNetAmtInTransCrcy,
  wht.RptgWhldgTxBaseAmtInCoCodeCrcy AS RptgWhldgTxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxExmptCertificate AS WhldgTaxExmptCertificate,
  wht.GLAccount AS GLAccount,
  wht.SupplierRecipientType AS SupplierRecipientType,
  wht.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  wht.WithholdingTaxPercent AS WithholdingTaxPercent,
  wht.IsSelfWhldgTax AS IsSelfWhldgTax,
  wht.IsGrossingUp AS IsGrossingUp,
  wht.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  wht.WhldgTaxCertDate AS WhldgTaxCertDate,
  wht._WithholdingTaxCode.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.IN_ClrgWithholdingTaxDocument AS IN_ClrgWithholdingTaxDocument,
  wht.IN_ClrgWithholdingTaxDate AS IN_ClrgWithholdingTaxDate,
  wht.IN_ReferenceDocumentNumber AS IN_ReferenceDocumentNumber,
  wht.IN_WhldgTaxRecordTypeTrans AS IN_WhldgTaxRecordTypeTrans,
  wht.DownPaymentIsCleared AS DownPaymentIsCleared,
  wht.DocumentIsPartialExempted AS DocumentIsPartialExempted,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht.Name AS Name,
  wht.BusinessPartnerName AS BusinessPartnerName,
  wht.TaxNumber1 AS TaxNumber1,
  wht.TaxNumber2 AS TaxNumber2,
  wht.TaxNumber3 AS TaxNumber3,
  wht.TaxNumber4 AS TaxNumber4,
  wht.TaxNumber5 AS TaxNumber5,
  wht.VATRegistration AS VATRegistration,
  wht.PostalCode AS PostalCode,
  wht.CityName AS CityName,
  wht.StreetName AS StreetName,
  wht.HouseNumber AS HouseNumber,
  wht.HouseNumberSupplementText AS HouseNumberSupplementText,
  wht.OrganizationBPName1 AS OrganizationBPName1,
  wht.SearchTerm1 AS SearchTerm1,
  wht.OrganizationFoundationDate AS OrganizationFoundationDate,
  wht.OrganizationBPName2 AS OrganizationBPName2,
  wht.POBoxPostalCode AS POBoxPostalCode,
  wht.POBox AS POBox,
  wht.Region AS Region,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.TaxNumberType AS TaxNumberType,
  wht.PaymentIsNotified AS PaymentIsNotified,
  wht.Language AS Language,
  wht.TaxItemIsZeroRated AS TaxItemIsZeroRated,
  wht.DocumentReferenceID AS DocumentReferenceID,
  wht.TransactionCode AS TransactionCode,
  wht.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  wht.DocumentItemText AS DocumentItemText,
  wht.IsNaturalPerson AS IsNaturalPerson,
  wht.EmailAddress AS EmailAddress,
  wht.SqntlNmbrOfWhldgTaxType AS SqntlNmbrOfWhldgTaxType,
  wht.DependencyNmbrOfWhldgTaxType AS DependencyNmbrOfWhldgTaxType,
  wht.WhldgTaxBaseIsInherited AS WhldgTaxBaseIsInherited,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.SenderCompanyCode AS SenderCompanyCode,
  wht.SenderAccountingDocument AS SenderAccountingDocument,
  wht.SenderFiscalYear AS SenderFiscalYear,
  wht.SenderLogicalSystem AS SenderLogicalSystem,
  wht._WithholdingTaxCode AS _WithholdingTaxCode,
  wht._CompanyCode AS _CompanyCode,
  wht._Supplier AS _Supplier,
  wht._Customer AS _Customer,
  wht._ReportingCurrency AS _ReportingCurrency,
  wht._Onetime AS _Onetime,
  wht._Branch AS _Branch,
  wht._Supplier.Supplier AS Supplier,
  wht._JournalEntry AS _JournalEntry,
  wht._OperationalAcctgDocItem AS _OperationalAcctgDocItem
FROM P_StRpWhldgTaxItem AS wht
LEFT OUTER JOIN I_StRpJournalEntryHeaderLog AS _StRpJournalEntryHeaderLog ON _StRpJournalEntryHeaderLog.CompanyCode = wht.CompanyCode AND _StRpJournalEntryHeaderLog.AccountingDocument = wht.AccountingDocument AND _StRpJournalEntryHeaderLog.FiscalYear = wht.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_WithholdingTaxReportingDate AS _WHTRptDateActive ON _WHTRptDateActive.CompanyCode = wht.CompanyCode  -- association [0..1]
;