I_TaxItem

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_TaxItem.
-- 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: IFITAXITEM

CREATE VIEW I_TaxItem AS
SELECT
  Taxitem.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  hextobin('00000000000000000000000000000000') AS TaxItemUUID,
  TaxCode,
  GLAccount,
  TaxItemGroup,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TransactionTypeDetermination,
  ConditionRecord,
  Taxitem.VATRegistration AS VATRegistration,
  DestinationCountry,
  SupplyingCountry,
  TaxJurisdiction,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  ConditionType,
  TaxReturnDate,
  cast( TaxReturnExecutionTime as glo_fi_bset_stmti) AS TaxReturnExecutionTime,
  TaxReportingDate,
  TaxReturnCountry,
  TaxAmountInCountryCrcy,
  TaxBaseAmountInCountryCrcy,
  TaxDeterminationDate,
  BusinessPlace,
  LowestLevelTaxJurisdiction,
  TaxJurisdictionLevel,
  TaxItemAcctgDocItemRef,
  TaxResultManualModification,
  DebitCreditCode,
  TaxRateValidityStartDate,
  TaxCountry,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  _CompanyCode.Country AS CompanyCodeCountry,
  _JournalEntry.TransactionCurrency AS DocumentCurrency,
  _JournalEntry.AdditionalCurrency1 AS AdditionalCurrency1,
  _JournalEntry.AdditionalCurrency2 AS AdditionalCurrency2,
  case when TaxCountry <> '' then _TaxCountry.CountryCurrency when TaxReturnCountry <> '' then _TaxReturnCountry.CountryCurrency end as CountryCurrency AS CountryCurrencyendasCountryCurrency,
  '1' AS TaxDataSource,
  _CompanyCode._Currency AS _Currency
FROM P_Bset AS Taxitem
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON AccountingDocument = _JournalEntry.AccountingDocument AND CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND AccountingDocument = _AccountingDocument.AccountingDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CompanyCodeCountry ON CompanyCodeCountry = _CompanyCodeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxReturnCountry ON TaxReturnCountry = _TaxReturnCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxCountry ON TaxCountry = _TaxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentAdditionalCurrency1 ON AdditionalCurrency1 = _DocumentAdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentAdditionalCurrency2 ON AdditionalCurrency2 = _DocumentAdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _DebtorCreditorRblsPyblsItem ON CompanyCode = _DebtorCreditorRblsPyblsItem.CompanyCode AND FiscalYear = _DebtorCreditorRblsPyblsItem.FiscalYear AND AccountingDocument = _DebtorCreditorRblsPyblsItem.AccountingDocument AND ( TaxCode = _DebtorCreditorRblsPyblsItem.TaxCode OR _DebtorCreditorRblsPyblsItem.TaxCode = '**' OR _DebtorCreditorRblsPyblsItem.TaxCode = '' ) AND TaxCountry = _DebtorCreditorRblsPyblsItem.TaxCountry AND TaxJurisdiction = _DebtorCreditorRblsPyblsItem.TaxJurisdiction AND( _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'D' OR _DebtorCreditorRblsPyblsItem.FinancialAccountType = 'K' )  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _TaxReceivablesPayablesItem ON CompanyCode = _TaxReceivablesPayablesItem.CompanyCode AND FiscalYear = _TaxReceivablesPayablesItem.FiscalYear AND AccountingDocument = _TaxReceivablesPayablesItem.AccountingDocument AND TaxItemGroup = _TaxReceivablesPayablesItem.TaxItemGroup AND TaxCode = _TaxReceivablesPayablesItem.TaxCode AND TaxCountry = _TaxReceivablesPayablesItem.TaxCountry AND TaxJurisdiction = _TaxReceivablesPayablesItem.TaxJurisdiction AND ( _TaxReceivablesPayablesItem.TaxType = 'A' OR _TaxReceivablesPayablesItem.TaxType = 'V' )  -- association [0..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _ReceivablesPayablesItem ON CompanyCode = _ReceivablesPayablesItem.CompanyCode AND FiscalYear = _ReceivablesPayablesItem.FiscalYear AND AccountingDocument = _ReceivablesPayablesItem.AccountingDocument  -- association [0..*]
;