C_KZ_VATRetForeignItemQuery

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 C_KZ_VATRetForeignItemQuery.
-- 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: CKZVATFOREIGNQ
-- Parameters: P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW C_KZ_VATRetForeignItemQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  KZ_VATLineItem,
  SupplierName,
  cast (TaxNumber1 as fikz_tax_number) AS TaxNumber1,
  cast(TaxNumber3 as fikz_bin_vat) AS TaxNumber3,
  TaxReportingDate,
  ExternalContractNumber,
  ExternalContractDate,
  TaxCode,
  KZ_TaxTurnoverCode,
  cast ( TaxBaseAmountInCoCodeCrcy as fikz_taxbaseamountcccrcy ) AS TaxBaseAmountInCoCodeCrcy,
  cast( TaxBaseAmountInTransCrcy as fwbas_shl) AS TaxBaseAmountInTransCrcy,
  cast ( TaxAmountInCoCodeCrcy as fikz_taxamountcccrcy ) AS TaxAmountInCoCodeCrcy,
  cast( TaxAmount as wmwst_shl) AS TaxAmount,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  IsReversal,
  IsReversed,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  DocumentReferenceID,
  BusinessTransactionType,
  SenderLogicalSystem,
  AccountingDocumentHeaderText,
  AccountingDocCreatedByUser,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  DocumentItemText,
  CompanyCodeCurrency,
  cast( DocumentCurrency as /scmtms/doc_currency) AS DocumentCurrency,
  Currency,
  PaymentRequestAmountInPaytCrcy,
  PaidAmountInPaytCurrency,
  Country,
  CountryThreeDigitISOCode,
  AccountingDocumentItem,
  KZ_VATReturnVersion,
  KZ_VATReturnSectionType,
  VATReturnItemDescription,
  ControllingArea,
  CostCenter,
  Segment,
  BusinessArea,
  Supplier,
  Customer,
  BPCustomerName,
  BusinessPartnerCountry,
  FiscalPeriod,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  AssignmentReference,
  Plant,
  InventoryValuationType,
  ValuationArea,
  Product,
  FunctionalArea,
  Material,
  AccountingDocumentCategory,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM C_KZ_VATRetForeignItemCube
;