I_PL_SAFTTaxItem

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 I_PL_SAFTTaxItem.
-- 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: IPLSAFTTAXITEM

CREATE VIEW I_PL_SAFTTaxItem AS
SELECT
  saftn_pl_vat.extraction_id AS SAFTExtractionUUID,
  saftn_pl_vat.bukrs AS CompanyCode,
  saftn_pl_vat.gjahr AS FiscalYear,
  saftn_pl_vat.belnr AS AccountingDocument,
  saftn_pl_vat.source AS MasterDataSourceNode,
  cast(saftn_settings.file_email as abap.sstring(241)) AS EmailAddress,
  saftn_pl_vat.buzei AS AccountingDocumentItem,
  saftn_pl_vat.kunnr AS Customer,
  saftn_pl_vat.lifnr AS Supplier,
  saftn_pl_vat.vatdate AS TaxReportingDate,
  saftn_pl_vat.blart AS AccountingDocumentType,
  saftn_pl_vat.bldat AS DocumentDate,
  saftn_pl_vat.budat AS PostingDate,
  saftn_pl_vat.awtyp AS ReferenceDocumentType,
  saftn_pl_vat.awkey AS OriginalReferenceDocument,
  cast(saftn_pl_vat.xblnr_alt as abap.char(26)) AS AlternativeReferenceDocument,
  saftn_pl_vat.xblnr AS DocumentReferenceID,
  saftn_pl_vat.waers AS Currency,
  saftn_pl_vat.xcpdd AS IsOneTimeAccount,
  saftn_pl_vat.sgtxt AS JournalEntryItemText,
  case when saftn_pl_vat.stceg is initial then 'Nie dotyczy' else saftn_pl_vat.stceg end as VATRegistration AS stcegendasVATRegistration,
  saftn_pl_vat.delivery_date AS DeliveryDate,
  saftn_pl_vat.reindat AS InvoiceReceiptDate,
  saftn_pl_vat.k_10 AS PL_SAFTNetAmount10,
  saftn_pl_vat.k_11 AS PL_SAFTNetAmount11,
  saftn_pl_vat.k_12 AS PL_SAFTNetAmount12,
  saftn_pl_vat.k_13 AS PL_SAFTNetAmount13,
  saftn_pl_vat.k_14 AS PL_SAFTNetAmount14,
  saftn_pl_vat.k_15 AS PL_SAFTNetAmount15,
  saftn_pl_vat.k_16 AS PL_SAFTTaxAmount16,
  saftn_pl_vat.k_17 AS PL_SAFTNetAmount17,
  saftn_pl_vat.k_18 AS PL_SAFTTaxAmount18,
  saftn_pl_vat.k_19 AS PL_SAFTNetAmount19,
  saftn_pl_vat.k_20 AS PL_SAFTTaxAmount20,
  saftn_pl_vat.k_21 AS PL_SAFTNetAmount21,
  saftn_pl_vat.k_22 AS PL_SAFTNetAmount22,
  saftn_pl_vat.k_23 AS PL_SAFTNetAmount23,
  saftn_pl_vat.k_24 AS PL_SAFTTaxAmount24,
  saftn_pl_vat.k_25 AS PL_SAFTNetAmount25,
  saftn_pl_vat.k_26 AS PL_SAFTTaxAmount26,
  saftn_pl_vat.k_27 AS PL_SAFTNetAmount27,
  saftn_pl_vat.k_28 AS PL_SAFTTaxAmount28,
  saftn_pl_vat.k_29 AS PL_SAFTNetAmount29,
  saftn_pl_vat.k_30 AS PL_SAFTTaxAmount30,
  saftn_pl_vat.k_31 AS PL_SAFTNetAmount31,
  saftn_pl_vat.k_32 AS PL_SAFTNetAmount32,
  saftn_pl_vat.k_33 AS PL_SAFTTaxAmount33,
  saftn_pl_vat.k_34 AS PL_SAFTNetAmount34,
  saftn_pl_vat.k_35 AS PL_SAFTTaxAmount35,
  saftn_pl_vat.k_36 AS PL_SAFTTaxAmount36,
  saftn_pl_vat.k_38 AS PL_SAFTTaxAmount38,
  saftn_pl_vat.k_39 AS PL_SAFTTaxAmount39,
  saftn_pl_vat.k_43 AS PL_SAFTNetAmount43,
  saftn_pl_vat.k_44 AS PL_SAFTTaxAmount44,
  saftn_pl_vat.k_45 AS PL_SAFTNetAmount45,
  saftn_pl_vat.k_46 AS PL_SAFTTaxAmount46
FROM snd_pl_vat AS saftn_pl_vat
LEFT OUTER JOIN snc_pl_bc AS saftn_settings ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntryItemOneTimeData AS _OneTimeAccount ON _OneTimeAccount.CompanyCode = saftn_pl_vat.bukrs AND _OneTimeAccount.AccountingDocument = saftn_pl_vat.belnr AND _OneTimeAccount.FiscalYear = saftn_pl_vat.gjahr AND _OneTimeAccount.AccountingDocumentItem = saftn_pl_vat.buzei  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = saftn_pl_vat.kunnr  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = saftn_pl_vat.lifnr  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = saftn_pl_vat.bukrs  -- association [0..1]
;