C_EG_StRpWhldgTaxItemCube

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_EG_StRpWhldgTaxItemCube.
-- 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.
-- Parameters: P_FromReportingDate : fis_budat, P_ToReportingDate : fis_budat

CREATE VIEW C_EG_StRpWhldgTaxItemCube AS
SELECT
  WHTItem.CompanyCode AS CompanyCode,
  WHTItem.AccountingDocument AS AccountingDocument,
  WHTItem.FiscalYear AS FiscalYear,
  WHTItem.WithholdingTaxType AS WithholdingTaxType,
  WHTItem.StatryRptgEntity AS StatryRptgEntity,
  WHTItem.StatryRptCategory AS StatryRptCategory,
  WHTItem.StatryRptRunID AS StatryRptRunID,
  cast ('' as farp_buzei) AS AccountingDocumentItem,
  WHTItem.ReportingDate AS ReportingDate,
  WHTItem.ReportingDate AS WithholdingTaxReportingDate,
  concat(concat(concat(concat(substring(WHTItem.ReportingDate,7,2),'.') ,substring(WHTItem.ReportingDate,5,2)),'.') ,substring(WHTItem.ReportingDate,1,4)) as ReportingDateAsText AS ReportingDate14asReportingDateAsText,
  WHTItem.FiscalPeriod AS FiscalPeriod,
  WHTItem.DocumentDate AS DocumentDate,
  WHTItem.ClearingDate AS ClearingDate,
  WHTItem.PostingDate AS PostingDate,
  case when Discount.CashDiscountAmtInCoCodeCrcy = 0.00 or Discount.CashDiscountAmtInCoCodeCrcy is null then '' else concat(concat(concat(concat(substring(WHTItem.ReportingDate,7,2),'.') ,substring(WHTItem.ReportingDate,5,2)),'.') ,substring(WHTItem.ReportingDate,1,4)) end as PostingDateAsText AS ReportingDate14endasPostingDateAsText,
  WHTItem.WithholdingTaxCode AS WithholdingTaxCode,
  WHTItem.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  WHTItem.TransactionCurrency AS TransactionCurrency,
  WHTItem.ReportingCurrency AS ReportingCurrency,
  WHTItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  WHTItem.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  WHTItem.WhldgTaxBaseAmtInTransacCrcy AS WhldgTaxBaseAmtInTransacCrcy,
  WHTItem.WithholdingTaxPercent AS WithholdingTaxPercent,
  WHTItem.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  WHTItem.WhldgTaxAmtInTransacCrcy AS WhldgTaxAmtInTransacCrcy,
  WHTItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  WHTItem.AmountInLocalCurrency AS AmountInLocalCurrency,
  WHTItem.BusinessPartner AS BusinessPartner,
  WHTItem.Name AS BusinessPartnerName,
  WHTItem.BusinessPartnerNumber AS BusinessPartnerNumber,
  WHTItem.Debtor AS Debtor,
  WHTItem.Creditor AS Creditor,
  case when (TaxNum2.BPTaxType = 'EG4') then WHTItem.Name else '' end as Name AS NameelseendasName,
  WHTItem.Country AS Country,
  coalesce( WHTItem.ItemIsReportingRelevant, '' ) AS ItemIsReportingRelevant,
  WHTItem.SupplierRecipientType AS SupplierRecipientType,
  Discount.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  cast(abs(WHTItem.ExchangeRate)as fis_absolute_exchangerate preserving type) AS ExchangeRate,
  case when ( TaxNum1.BPTaxType = 'EG2' ) then TaxNum1.BPTaxNumber else '' end as BPTaxNumber AS BPTaxNumberelseendasBPTaxNumber,
  case when ( TaxNum2.BPTaxType = 'EG4' ) then TaxNum2.BPTaxNumber else '' end as BPTaxLongNumber AS BPTaxNumberelseendasBPTaxLongNumber,
  WHTItem.DocumentReferenceID AS DocumentReferenceID,
  case when WHTItem.TransactionCurrency = 'EGP' then cast ('' as waers_frgn) else WHTItem.TransactionCurrency end as ForeignCurrency AS TransactionCurrencyendasForeignCurrency,
  TaxNum2.BPTaxType AS BPTaxType
FROM C_EG_StRpAggrgdWhldgTaxItem AS WHTItem
;