P_AUDIT_AT_VAT_ITEM

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_VAT_ITEM.
-- 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: PATAUDITVAT

CREATE VIEW P_AUDIT_AT_VAT_ITEM AS
SELECT
  bkpf.bukrs AS bukrs,
  bkpf.gjahr AS gjahr,
  bkpf.belnr AS belnr,
  bkpf.monat AS monat,
  bkpf.bldat AS bldat,
  bkpf.budat AS budat,
  bkpf.vatdate AS vatdate,
  bkpf.blart AS blart,
  bkpf.xblnr AS xblnr,
  bkpf.xblnr_alt AS xblnr_alt,
  bkpf.waers AS waers,
  bset.mwskz AS mwskz,
  bset.ktosl AS ktosl,
  bset.shkzg AS shkzg,
  t007b.stazf AS stazf,
  bset.tax_country AS tax_country,
  cast( case when bset.shkzg = 'S' and bset.hwbas < 0 then bset.hwbas * -1 when bset.shkzg = 'H' and bset.hwbas > 0 then bset.hwbas * -1 else bset.hwbas end as hwbas_bses ) as Steuerbasisbetrag AS hwbasendashwbas_bsesasSteuerbasisbetrag,
  cast( case when bset.shkzg = 'S' and bset.hwste < 0 then bset.hwste * -1 when bset.shkzg = 'H' and bset.hwste > 0 then bset.hwste * -1 else bset.hwste end as hwste ) as Steuer AS hwsteendashwsteasSteuer,
  t007b.stgrp AS Steuergruppe,
  t007a.mwart AS Steuerart
;