P_AUDIT_AT_BSET

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_AUDIT_AT_BSET.
-- 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_AUDIT_AT_BSET AS
SELECT
  I_TaxItem.CompanyCode AS bukrs,
  I_TaxItem.AccountingDocument AS belnr,
  I_TaxItem.FiscalYear AS gjahr,
  I_TaxItem.TaxItem AS buzei,
  P_AUDIT_AT_HELPER_LEDGER.Ledger AS Ledger,
  I_TaxItem.TransactionTypeDetermination AS ktosl,
  I_TaxItem.DestinationCountry AS egbld,
  I_TaxItem.SupplyingCountry AS eglld,
  I_TaxItem.GLAccount AS hkont,
  case I_TaxItem.DebitCreditCode when 'S' then I_TaxItem.TaxBaseAmountInCoCodeCrcy when 'H' then -I_TaxItem.TaxBaseAmountInCoCodeCrcy end as fwbas AS TaxBaseAmountInCoCodeCrcyendasfwbas,
  case I_TaxItem.DebitCreditCode when 'S' then I_TaxItem.TaxAmount when 'H' then -I_TaxItem.TaxAmount end as fwste AS TaxAmountendasfwste,
  case I_TaxItem.DebitCreditCode when 'S' then I_TaxItem.TaxBaseAmountInCoCodeCrcy when 'H' then -I_TaxItem.TaxBaseAmountInCoCodeCrcy end as hwbas AS TaxBaseAmountInCoCodeCrcyendashwbas,
  case I_TaxItem.DebitCreditCode when 'S' then I_TaxItem.TaxAmountInCoCodeCrcy when 'H' then -I_TaxItem.TaxAmountInCoCodeCrcy end as hwste AS TaxAmountInCoCodeCrcyendashwste,
  cast ( rpad( '3', 5, ' ') as konwa ) AS TaxRateCurrency,
  I_TaxItem.TaxRate AS kbetr,
  I_TaxItem.TaxReportingDate AS mlddt,
  I_TaxItem.TaxCode AS mwskz,
  I_TaxItem.DebitCreditCode AS shkzg,
  P_T007B_GLO.stbkz AS stbkz,
  I_TaxItem.VATRegistration AS stceg,
  I_TaxItem.TaxItemAcctgDocItemRef AS taxps,
  I_JournalEntry.TransactionCurrency AS TransactionCurrency,
  I_CompanyCode.Currency AS CompanyCodeCurrency,
  I_TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination
FROM P_AUDIT_AT_HELPER_LEDGER
INNER JOIN I_TaxItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntry ON /* join condition not captured in parsed metadata */
INNER JOIN P_T007B_GLO ON /* join condition not captured in parsed metadata */
;