P_KZ_VATRetForeignDocTotalsRen

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_KZ_VATRetForeignDocTotalsRen.
-- 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: PKZVATRETFORTR
-- Parameters: P_VATReturnVersion : j_3rvatdversion, P_TaxItemGroupingVersion : verstax, P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW P_KZ_VATRetForeignDocTotalsRen AS
SELECT
  CompanyCode,
  sum(TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  sum(TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  sum(VATToBePaid) AS VATToBePaid,
  sum(PaidVAT) AS PaidVAT,
  SupplierName,
  Country,
  TaxNumber1,
  Supplier,
  AssignmentReference,
  CompanyCodeCurrency AS Currency,
  KZ_TaxTurnoverCode
FROM P_KZ_VATRetForeignDocRoundRen
;