P_KZ_VATRetForeignDocRound

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_VATRetForeignDocRound.
-- 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: PKZVATRETFOREIGR
-- Parameters: P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW P_KZ_VATRetForeignDocRound AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  round( TaxBaseAmountInCoCodeCrcy, 0) AS TaxBaseAmountInCoCodeCrcy,
  round( TaxAmountInCoCodeCrcy,0 ) AS TaxAmountInCoCodeCrcy,
  PostingDate,
  TaxReportingDate,
  DocumentDate,
  AccountingDocumentType,
  IsReversal,
  IsReversed,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  DocumentReferenceID,
  BusinessTransactionType,
  SenderLogicalSystem,
  CompanyCodeCurrency,
  DocumentCurrency,
  Currency,
  round ( VATToBePaid ,0 ) AS VATToBePaid,
  round ( PaidVAT,0) AS PaidVAT,
  SupplierName,
  Country,
  TaxNumber1,
  TaxCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  AccountingDocumentItem,
  KZ_VATReturnSectionType,
  KZ_LineItem,
  Description,
  FiscalPeriod,
  ControllingArea,
  Segment,
  ProfitCenter,
  CostCenter,
  BusinessArea,
  Supplier,
  Customer,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  AssignmentReference,
  Plant,
  InventoryValuationType,
  ValuationArea,
  Product,
  FunctionalArea,
  Material,
  KZ_VATReturnVersion,
  AccountingDocumentCategory,
  KZ_TaxTurnoverCode
FROM P_KZ_VATRetForeignDoc
;