I_PL_SAFTJournalItem

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_SAFTJournalItem.
-- 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: IPLSAFTJOURNALI

CREATE VIEW I_PL_SAFTJournalItem AS
SELECT
  saftn_pl_KR_i.extraction_id AS SAFTExtractionUUID,
  saftn_pl_KR_i.gjahr AS FiscalYear,
  saftn_pl_KR_i.belnr AS AccountingDocument,
  saftn_pl_KR_i.hkont AS Account,
  saftn_pl_KR_i.docln AS GLAccountLineItem,
  saftn_pl_KR_i.bukrs AS CompanyCode,
  saftn_pl_KR_i.sgtxt AS DocumentItemText,
  saftn_pl_KR_i.amount_d AS DebitAmountInDisplayCrcy,
  saftn_pl_KR_i.amount_c AS CreditAmountInDisplayCrcy,
  saftn_pl_KR_i.doc_amount_d AS DebitAmountInBalanceTransCrcy,
  saftn_pl_KR_i.doc_amount_c AS CreditAmountInBalanceTransCrcy,
  saftn_pl_KR_i.doc_curr AS Currency,
  CompanyCode.Currency AS CompanyCodeCurrency
FROM snd_pl_kr_i AS saftn_pl_KR_i
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON _GLAccount.GLAccount = saftn_pl_KR_i.hkont AND _GLAccount.CompanyCode = saftn_pl_KR_i.bukrs  -- association [0..1]
;