C_IT_TaxReturnCube

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_IT_TaxReturnCube.
-- 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_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW C_IT_TaxReturnCube AS
SELECT
  I_StRpTaxReturnCube.CompanyCode AS CompanyCode,
  I_StRpTaxReturnCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxReturnCube.FiscalYear AS FiscalYear,
  I_StRpTaxReturnCube.TaxItem AS TaxItem,
  I_StRpTaxReturnCube.TaxCode AS TaxCode,
  I_StRpTaxReturnCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxReturnCube.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxReturnCube.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxReturnCube.StatryRptRunID AS StatryRptRunID,
  I_StRpTaxReturnCube.TaxRate AS TaxRate,
  cast(right(cast( I_StRpTaxReturnCube.TaxRate as char20 ), 10 ) as figen_taxrateinpercentastext ) AS TaxRateInPercentAsText,
  cast( I_StRpTaxReturnCube._TaxCodeText[1:Language = $session.system_language].TaxCodeName as fis_mwskz_name ) AS TaxCodeName,
  I_StRpTaxReturnCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_StRpTaxReturnCube.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxReturnCube.TaxType AS TaxType,
  I_StRpTaxReturnCube.TaxTypeName AS TaxTypeName,
  I_StRpTaxReturnCube.ActiveTaxType AS ActiveTaxType,
  I_StRpTaxReturnCube.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_StRpTaxReturnCube.ConditionType AS ConditionType,
  I_StRpTaxReturnCube.TaxIsDeferredRelevant AS TaxIsDeferredRelevant,
  I_StRpTaxReturnCube.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxReturnCube.TaxIsMossRelevant AS TaxIsMossRelevant,
  I_StRpTaxReturnCube.TaxCountry AS TaxCountry,
  I_StRpTaxReturnCube.GLAccount AS GLAccount,
  I_StRpTaxReturnCube.IsNegativePosting AS IsNegativePosting,
  I_StRpTaxReturnCube.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxReturnCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxReturnCube.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxReturnCube.DocumentReferenceID AS DocumentReferenceID,
  I_StRpTaxReturnCube.PostingDate AS PostingDate,
  I_StRpTaxReturnCube.DocumentDate AS DocumentDate,
  I_StRpTaxReturnCube.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxReturnCube.ReportingDate AS ReportingDate,
  I_StRpTaxReturnCube.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxReturnCube.IsReversal AS IsReversal,
  I_StRpTaxReturnCube.IsReversed AS IsReversed,
  I_StRpTaxReturnCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  cast( ltrim(I_StRpTaxReturnCube.AlternativeReferenceDocument, '0') as fis_xblnr_alt_alpha ) AS AlternativeReferenceDocument,
  I_StRpTaxReturnCube.CAReconciliationKey AS CAReconciliationKey,
  I_StRpTaxReturnCube.StatryRptRun AS StatryRptRun,
  I_StRpTaxReturnCube._JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
  I_StRpTaxReturnCube._CustomerSupplierLineItem.Customer AS Customer,
  I_StRpTaxReturnCube._CustomerSupplierLineItem.Supplier AS Supplier,
  I_StRpTaxReturnCube.BusinessPartnerName AS BusinessPartnerName,
  I_StRpTaxReturnCube.BusinessPartnerCountry AS BusinessPartnerCountry,
  cast( I_StRpTaxReturnCube.ReportingVATRegistration as stceg) AS ReportingVATRegistration,
  I_StRpTaxReturnCube.TaxNumber1 AS TaxNumber1,
  I_StRpTaxReturnCube.TaxNumber2 AS TaxNumber2,
  I_StRpTaxReturnCube.TaxNumber3 AS TaxNumber3,
  I_StRpTaxReturnCube.Country AS Country,
  I_StRpTaxReturnCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxReturnCube.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxReturnCube.ReportingCountry AS ReportingCountry,
  I_StRpTaxReturnCube.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxReturnCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxReturnCube.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxReturnCube.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxReturnCube.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxReturnCube.TotalGrossAmount AS TotalGrossAmount,
  I_StRpTaxReturnCube.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  I_StRpTaxReturnCube.DcblVATIncrdCostInRptgCrcy AS DcblVATIncrdCostInRptgCrcy,
  I_StRpTaxReturnCube.BalanceAmountInTransacCurrency AS BalanceAmountInTransacCurrency,
  I_StRpTaxReturnCube.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxReturnCube.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_StRpTaxReturnCube.TotalGrossAmountInCoCodeCrcy AS TotalGrossAmountInCoCodeCrcy,
  I_StRpTaxReturnCube.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxReturnCube.TaxAmount AS TaxAmount,
  I_StRpTaxReturnCube.TotalGrossAmountInTransCrcy AS TotalGrossAmountInTransCrcy,
  cast(I_PaymentReceiptLog2.OfficialReceiptNumber as fiit_selfinvoice_no) AS IT_SelfInvoiceNumber,
  I_StRpTaxReturnCube._CustomerSupplierLineItem AS _CustomerSupplierLineItem
FROM I_StRpTaxReturnCube
INNER JOIN P_IT_TaxPartialNonDeduct ON /* join condition not captured in parsed metadata */
;