I_AU_StRpWithholdingTaxItem

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_AU_StRpWithholdingTaxItem.
-- 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_AU_StRpWithholdingTaxItem AS
SELECT
  wht_items.CompanyCode AS CompanyCode,
  wht_items.AccountingDocument AS AccountingDocument,
  wht_items.FiscalYear AS FiscalYear,
  wht_items.AccountingDocumentItem AS AccountingDocumentItem,
  wht_items.WithholdingTaxType AS WithholdingTaxType,
  I_StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  I_StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  wht_items.ReportingCurrency AS ReportingCurrency,
  wht_items.TransactionCurrency AS TransactionCurrency,
  wht_items.AdditionalCurrency1 AS AdditionalCurrency1,
  wht_items.AdditionalCurrency2 AS AdditionalCurrency2,
  case when ( wht_items._Supplier.AU_IndividualIsUnder18 = '' and wht_items._Supplier.AU_PartnerIsSupplyWithoutGain = '' and wht_items._Supplier.AU_PayerIsPayingToCarryOnEnt = '' and wht_items._Supplier.AU_PaymentIsExceeding75 = '' and wht_items._Supplier.AU_PaymentIsIncomeExempted = '' and wht_items._Supplier.AU_PaymentIsWhollyInputTaxed = '' and wht_items._Supplier.AU_SupplierIsEntitledToABN = '' and wht_items._Supplier.AU_SupplyIsMadeAsPrivateHobby = '' and wht_items._Supplier.AU_SupplyMadeIsOfDmstcNature = '' ) and wht_items.VATRegistration = '' then cast (wht_items.WhldgTaxAmtInCoCodeCrcy as abap.curr( 23, 2 )) else cast(0 as abap.curr( 23, 2 )) end as AU_WhldgTaxWithoutABNAmount AS curr232endasAU_WhldgTaxWithoutABNAmount,
  case when ( wht_items._Supplier.AU_IndividualIsUnder18 = '' and wht_items._Supplier.AU_PartnerIsSupplyWithoutGain = '' and wht_items._Supplier.AU_PayerIsPayingToCarryOnEnt = '' and wht_items._Supplier.AU_PaymentIsExceeding75 = '' and wht_items._Supplier.AU_PaymentIsIncomeExempted = '' and wht_items._Supplier.AU_PaymentIsWhollyInputTaxed = '' and wht_items._Supplier.AU_SupplierIsEntitledToABN = '' and wht_items._Supplier.AU_SupplyIsMadeAsPrivateHobby = '' and wht_items._Supplier.AU_SupplyMadeIsOfDmstcNature = '' ) and wht_items.VATRegistration = '' then cast(0 as abap.curr( 23, 2 )) else cast (wht_items.WhldgTaxAmtInCoCodeCrcy as abap.curr( 23, 2 ) ) end as AU_WhldgTaxWithABNAmount AS curr232endasAU_WhldgTaxWithABNAmount,
  wht_items.VATRegistration AS VATRegistration,
  wht_items.Supplier AS Supplier,
  wht_items.PostingDate AS PostingDate,
  wht_items.DocumentDate AS DocumentDate,
  wht_items.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht_items.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht_items.IsReversed AS IsReversed,
  wht_items.IsReversal AS IsReversal,
  wht_items.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  wht_items.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht_items.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  wht_items.WhldgTaxBaseAmtInAddlCrcy2 AS WhldgTaxBaseAmtInAddlCrcy2,
  wht_items.WhldgTaxBaseAmtInAddlCrcy3 AS WhldgTaxBaseAmtInAddlCrcy3,
  wht_items.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht_items.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  wht_items.WhldgTaxAmtInAddlCrcy2 AS WhldgTaxAmtInAddlCrcy2,
  wht_items.WhldgTaxAmtInAddlCrcy3 AS WhldgTaxAmtInAddlCrcy3
;