C_KZ_VATRetForeignItemCube

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_VATRetForeignItemCube.
-- 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: CKZVATFOREIGNC
-- Parameters: P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW C_KZ_VATRetForeignItemCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  cast( TaxBaseAmountInCoCodeCrcy as fikz_taxbaseamountcccrcy) AS TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  cast( TaxAmountInCoCodeCrcy as fikz_taxamountcccrcy) AS TaxAmountInCoCodeCrcy,
  TaxAmount,
  PostingDate,
  TaxReportingDate,
  DocumentDate,
  AccountingDocumentType,
  IsReversal,
  IsReversed,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  DocumentReferenceID,
  BusinessTransactionType,
  SenderLogicalSystem,
  AccountingDocumentHeaderText,
  AccountingDocCreatedByUser,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  DocumentItemText,
  CompanyCodeCurrency,
  DocumentCurrency,
  Currency,
  cast ( VATToBePaid as fikz_vat_to_be_paid) AS PaymentRequestAmountInPaytCrcy,
  cast ( PaidVAT as fikz_pvat_c) AS PaidAmountInPaytCurrency,
  SupplierName,
  cast (Country as fikz_country_code) AS Country,
  CountryThreeDigitISOCode,
  TaxNumber1,
  TaxNumber3,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  AccountingDocumentItem,
  KZ_VATReturnVersion,
  KZ_VATReturnSectionType,
  KZ_LineItem AS KZ_VATLineItem,
  cast ( Description as fikz_vat_description) AS VATReturnItemDescription,
  ControllingArea,
  CostCenter,
  Segment,
  BusinessArea,
  Supplier,
  _Supplier.Country AS SupplierCountry,
  Customer,
  _Customer.BPCustomerName AS BPCustomerName,
  _Customer.Country AS CustomerCountry,
  case when _Customer.Country is not initial then _Customer.Country when _Supplier.Country is not initial then _Supplier.Country else '' end as BusinessPartnerCountry AS CountryelseendasBusinessPartnerCountry,
  FiscalPeriod,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  AssignmentReference,
  Plant,
  InventoryValuationType,
  ValuationArea,
  Product,
  FunctionalArea,
  Material,
  AccountingDocumentCategory,
  TaxCode,
  KZ_TaxTurnoverCode,
  _Contract.ExternalContractNumber AS ExternalContractNumber,
  _Contract.ExternalContractDate AS ExternalContractDate
FROM P_KZ_VATRetForeignDoc
;