P_NO_SAFTJournalCustSup

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_NO_SAFTJournalCustSup.
-- 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: PNOSAFTJCS

CREATE VIEW P_NO_SAFTJournalCustSup AS
SELECT
  JournalLineItem.CompanyCode AS CompanyCode,
  JournalLineItem.FiscalYear AS FiscalYear,
  JournalLineItem.AccountingDocument AS AccountingDocument,
  JournalLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalLineItem.Ledger AS Ledger,
  JournalLineItem.PostingDate AS PostingDate,
  JournalLineItem.Customer AS Customer,
  JournalLineItem.Supplier AS Supplier,
  JournalLineItem.VATRegistration AS VATRegistration,
  '' AS IsOneTimeAccount,
  JournalLineItem.GLAccount AS GLAccount,
  Customer.TaxNumber1 AS TaxNumber1,
  Customer.TaxNumber2 AS TaxNumber2,
  JournalLineItem._CompanyCode AS _CompanyCode,
  JournalLineItem._FiscalYear AS _FiscalYear,
  JournalLineItem._JournalEntry AS _JournalEntry,
  JournalLineItem._Ledger AS CompanyCodeasCompanyCode,
  case when OTC.TaxID1 is not initial then OTC.TaxID1 else substring(JournalLineItem.VATRegistration ,3,18) end as VATRegistration AS VATRegistration318endasVATRegistration,
  JournalLineItem._Ledger AS _Ledger
FROM I_NO_SAFTJournalItem AS JournalLineItem
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS OTC ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS OTS ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_NO_SAFTJournalItem
;