I_FR_VATTaxItemCube

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_FR_VATTaxItemCube.
-- 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.
-- SQL view name: IFRVATTXITEM

CREATE VIEW I_FR_VATTaxItemCube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  TaxCode,
  TaxItem,
  TaxBox,
  I_TaxGroup.TaxGroupExternalID AS TaxGroupExternalID,
  TaxDeclnAmountType,
  I_StRpTaxItemBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.ValidFrom AS ValidFrom,
  I_StRpTaxItemBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  AccountingDocumentType,
  TransactionTypeDetermination,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  DocumentDate,
  PostingDate,
  ReportingDate,
  cast(I_StRpTaxItemBoxCube.CompanyCodeCurrency as hwaer) AS CompanyCodeCurrency,
  cast(I_StRpTaxItemBoxCube.DocumentCurrency as /scmtms/doc_currency) AS DocumentCurrency,
  ReportingCurrency,
  ReportingCountry,
  TaxType,
  TransactionType.stgrp AS TransactionTaxType,
  TaxGroupName,
  DocumentReferenceID,
  GLAccount,
  CompanyCodeCountry AS Country,
  substring(DocumentReferenceID,1,10) AS TaxInvoiceNumber,
  TargetTaxCode,
  TaxRate,
  cast(I_StRpTaxItemBoxCube.TaxAmountInCoCodeCrcy as fis_mwsts ) AS TaxAmountInCoCodeCrcy,
  cast(I_StRpTaxItemBoxCube.TaxBaseAmountInCoCodeCrcy as hwbas_shl ) AS TaxBaseAmountInCoCodeCrcy,
  cast(I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy as fwbas ) AS TaxBaseAmountInTransCrcy,
  cast(I_StRpTaxItemBoxCube.TaxAmount as fwste_f05l ) AS TaxAmount,
  AmountInReportingCurrency
FROM P_StRpTaxItemBoxPA AS I_StRpTaxItemBoxCube
LEFT OUTER JOIN I_TaxGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaxGroupText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_T007B_GLO AS TransactionType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
;