P_BSET1

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 P_BSET1.
-- 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 P_BSET1 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  cast ( hextobin('00000000000000000000000000000000') as txrg_tax_item_uuid preserving type ) AS TaxItemUUID,
  TaxCode,
  TaxRateValidityStartDate,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount AS TaxAmountInTransCrcy,
  TransactionTypeDetermination,
  TaxAmountInCountryCrcy AS TaxAmountInRptgCrcy,
  TaxBaseAmountInCountryCrcy AS TaxBaseAmountInRptgCrcy,
  cast (_JournalEntry.TransactionCurrency as fins_currw) AS TransactionCurrency,
  cast( _CompanyCode.Currency as fins_currh ) AS CompanyCodeCurrency,
  TaxCountry,
  TaxReturnCountry,
  case when TaxCountry <> '' then _TaxCountry.CountryCurrency when TaxReturnCountry <> '' then _TaxReturnCountry.CountryCurrency else _CompanyCode.Currency end as ReportingCurrency AS CurrencyendasReportingCurrency,
  case when TaxCountry <> '' then TaxCountry when TaxReturnCountry <> '' then TaxReturnCountry else _CompanyCode.Country end as ReportingCountry AS CountryendasReportingCountry,
  cast ( '1' as figen_taxdatasource_id preserving type ) AS TaxDataSource,
  DebitCreditCode,
  _CompanyCode.Country AS CompanyCodeCountry
FROM P_Bset
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_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- 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_Country AS _CompanyCodeCountry ON CompanyCodeCountry = _CompanyCodeCountry.Country  -- association [0..1]
;