P_KZ_VATRetForeignDoc

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_VATRetForeignDoc.
-- 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: PKZVATRETFOREIGN
-- Parameters: P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW P_KZ_VATRetForeignDoc AS
SELECT
  ForeignDoc.CompanyCode AS CompanyCode,
  ForeignDoc.AccountingDocument AS AccountingDocument,
  ForeignDoc.FiscalYear AS FiscalYear,
  ForeignDoc.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  ForeignDoc.TaxAmount AS TaxAmount,
  ForeignDoc.PostingDate AS PostingDate,
  ForeignDoc.TaxReportingDate AS TaxReportingDate,
  ForeignDoc.DocumentDate AS DocumentDate,
  ForeignDoc.AccountingDocumentType AS AccountingDocumentType,
  ForeignDoc.IsReversal AS IsReversal,
  ForeignDoc.IsReversed AS IsReversed,
  ForeignDoc.OriginalReferenceDocument AS OriginalReferenceDocument,
  ForeignDoc.ReferenceDocumentType AS ReferenceDocumentType,
  ForeignDoc.DocumentReferenceID AS DocumentReferenceID,
  ForeignDoc.BusinessTransactionType AS BusinessTransactionType,
  ForeignDoc.SenderLogicalSystem AS SenderLogicalSystem,
  ForeignDoc.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  ForeignDoc.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  ForeignDoc.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  ForeignDoc.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  ForeignDoc.DocumentItemText AS DocumentItemText,
  ForeignDoc.CompanyCodeCurrency AS CompanyCodeCurrency,
  ForeignDoc.DocumentCurrency AS DocumentCurrency,
  Currency,
  ForeignDoc.TaxBaseAmountInCoCodeCrcy AS VATToBePaid,
  SupplierData.SupplierName AS SupplierName,
  Country.CountryISOCode AS Country,
  Country.CountryThreeDigitISOCode AS CountryThreeDigitISOCode,
  RootSuplierData.TaxNumber1 AS TaxNumber1,
  RootSuplierData.TaxNumber3 AS TaxNumber3,
  ForeignDoc.TaxCode AS TaxCode,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  ForeignDoc.AccountingDocumentItem AS AccountingDocumentItem,
  KZ_VATReturnSectionType,
  KZ_LineItem,
  Description,
  ForeignDoc.FiscalPeriod AS FiscalPeriod,
  BusinessPartnerItem.ControllingArea AS ControllingArea,
  BusinessPartnerItem.Segment AS Segment,
  BusinessPartnerItem.ProfitCenter AS ProfitCenter,
  BusinessPartnerItem.CostCenter AS CostCenter,
  BusinessPartnerItem.BusinessArea AS BusinessArea,
  BusinessPartnerItem.Supplier AS Supplier,
  BusinessPartnerItem.Customer AS Customer,
  BusinessPartnerItem.MasterFixedAsset AS MasterFixedAsset,
  BusinessPartnerItem.FixedAsset AS FixedAsset,
  BusinessPartnerItem.AssetClass AS AssetClass,
  BusinessPartnerItem.AssignmentReference AS AssignmentReference,
  BusinessPartnerItem.Plant AS Plant,
  BusinessPartnerItem.InventoryValuationType AS InventoryValuationType,
  BusinessPartnerItem.ValuationArea AS ValuationArea,
  ProductItem.Product AS Product,
  BusinessPartnerItem.FunctionalArea AS FunctionalArea,
  BusinessPartnerItem.Material AS Material,
  BusinessPartnerItem._Customer AS _Customer,
  BusinessPartnerItem._Supplier AS _Supplier,
  BusinessPartnerItem._ProfitCenter AS _ProfitCenter,
  BusinessPartnerItem._CostCenter AS _CostCenter,
  BusinessPartnerItem._BusinessArea AS _BusinessArea,
  BusinessPartnerItem._FunctionalArea AS _FunctionalArea,
  BusinessPartnerItem._ControllingArea AS _ControllingArea,
  BusinessPartnerItem._Segment AS _Segment,
  BusinessPartnerItem._InventoryValuationType AS _InventoryValuationType,
  ProductItem._Product AS _Product,
  BusinessPartnerItem._Material AS _Material,
  KZ_VATReturnVersion,
  ForeignDoc.AccountingDocumentCategory AS AccountingDocumentCategory,
  ForeignDoc._ReferenceDocumentType AS _ReferenceDocumentType,
  ForeignDoc._BusinessTransactionType AS _BusinessTransactionType,
  ForeignDoc._CompanyCodeCurrency AS _CompanyCodeCurrency,
  ForeignDoc._AccountingDocumentType AS _AccountingDocumentType,
  ForeignDoc._AccountingDocumentCategory AS _AccountingDocumentCategory,
  ForeignDoc._FiscalYear AS _FiscalYear,
  ForeignDoc._FiscalPeriod AS _FiscalPeriod,
  ForeignDoc._CompanyCode AS _CompanyCode,
  ForeignDoc._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  ForeignDoc._BusinessTransactionTypeText AS _BusinessTransactionTypeText,
  ForeignDoc._TransactionCurrency AS _TransactionCurrency
FROM P_KZ_VATRETURNFOREIGN1 AS ForeignDoc
;