P_KZ_VATRETSECTION1SUBTOTALS1

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_VATRETSECTION1SUBTOTALS1.
-- 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: PKZVATRETSEC1ST1

CREATE VIEW P_KZ_VATRETSECTION1SUBTOTALS1 AS
SELECT
  AccDocData.CompanyCode AS CompanyCode,
  AccDocData.AccountingDocument AS AccountingDocument,
  AccDocData.FiscalYear AS FiscalYear,
  AccDocData.TaxCode AS TaxCode,
  AccDocData.StatryRptgEntity AS StatryRptgEntity,
  AccDocData.StatryRptCategory AS StatryRptCategory,
  AccDocData.StatryRptRunID AS StatryRptRunID,
  AccDocData.KZ_LineItem AS KZ_LineItem,
  AccDocData.OperationCode AS OperationCode,
  AccDocData.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  AccDocData.TaxAmount AS TaxAmount,
  AccDocData.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  AccDocData.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  KZ_TaxNormCode,
  AccDocData.CompanyCodeCurrency AS CompanyCodeCurrency,
  AccDocData.DocumentCurrency AS DocumentCurrency,
  Currency,
  AccDocData.TransactionTypeDetermination AS TransactionTypeDetermination,
  AccDocData.PostingDate AS PostingDate,
  AccDocData.TaxReportingDate AS TaxReportingDate,
  AccDocData.DocumentDate AS DocumentDate,
  AccDocData.AccountingDocumentType AS AccountingDocumentType,
  IsReversal,
  IsReversed,
  AccDocData.OriginalReferenceDocument AS OriginalReferenceDocument,
  AccDocData.ReferenceDocumentType AS ReferenceDocumentType,
  AccDocData.DocumentReferenceID AS DocumentReferenceID,
  AccDocData.BusinessTransactionType AS BusinessTransactionType,
  AccDocData.SenderLogicalSystem AS SenderLogicalSystem,
  AccDocData.AccountingDocumentItem AS AccountingDocumentItem,
  AccDocData.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  AccDocData.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  AccDocData.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  AccDocData.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  AccDocData.DocumentItemText AS DocumentItemText,
  KZ_VATReturnSectionType,
  KZ_VATReturnSectionColumn,
  Description,
  AccDocData.Customer AS Customer,
  AccDocData.Supplier AS Supplier,
  BusinessPartnerCountry,
  AccDocData.TaxNumber3 AS TaxNumber3,
  AccDocData.DebitCreditCode AS DebitCreditCode,
  case CustomerData.Country when 'RU' then CustomerData.Country when 'AM' then CustomerData.Country when 'BY' then CustomerData.Country when 'KG' then CustomerData.Country else '' end as Country AS CountryelseendasCountry,
  AccDocData._CustomerText AS _CustomerText,
  AccDocData._SupplierText AS _SupplierText
FROM P_KZ_VATRETURNMAINSECTION_RND AS AccDocData
INNER JOIN I_RU_CustomerData AS CustomerData ON /* join condition not captured in parsed metadata */
;