I_SAFTGenLedgerOneTimeSupplier

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_SAFTGenLedgerOneTimeSupplier.
-- 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: ISAFTGLOTSUP

CREATE VIEW I_SAFTGenLedgerOneTimeSupplier AS
SELECT
  a.SourceLedger AS SourceLedger,
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.AccountingDocument AS AccountingDocument,
  a.LedgerGLLineItem AS LedgerGLLineItem,
  a.Ledger AS Ledger,
  a.ChartOfAccounts AS ChartOfAccounts,
  a.GLAccount AS GLAccount,
  a.AccountingDocumentCategory AS AccountingDocumentCategory,
  a.AccountingDocumentItem AS AccountingDocumentItem,
  a.Supplier AS Supplier,
  a.PostingDate AS PostingDate,
  a.CompanyCodeCurrency AS CompanyCodeCurrency,
  b.AddressID AS AddressID,
  concat( concat( b.BusinessPartnerName1, ' '), b.BusinessPartnerName2 ) AS CompanyName,
  _DfltAddrRprstn.StreetName AS StreetAddressName,
  _DfltAddrRprstn.StreetPrefixName1 AS StreetPrefixName,
  _DfltAddrRprstn.StreetPrefixName2 AS AdditionalStreetPrefixName,
  _DfltAddrRprstn.StreetSuffixName1 AS StreetSuffixName,
  _DfltAddrRprstn.StreetSuffixName2 AS AdditionalStreetSuffixName,
  _DfltAddrRprstn.HouseNumber AS HouseNumber,
  b.CityName AS CityName,
  b.PostalCode AS PostalCode,
  b.Country AS Country,
  b.POBox AS POBox,
  b.POBoxPostalCode AS POBoxPostalCode,
  b.Region AS Region,
  cast('' as abap.char(241)) AS EmailAddress,
  cast('' as abap.char(50)) AS SearchURLAddress,
  _RecAccount.ReconciliationAccount AS ReconciliationAccount
FROM I_JournalEntryItem AS a
INNER JOIN I_JournalEntryItemOneTimeData AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _AccdocItem ON a.CompanyCode = _AccdocItem.CompanyCode AND a.AccountingDocument = _AccdocItem.AccountingDocument AND a.FiscalYear = _AccdocItem.FiscalYear AND a.AccountingDocumentItem = _AccdocItem.AccountingDocumentItem AND _AccdocItem.VATRegistration <> ''  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _RecAccount ON a.Supplier = _RecAccount.Supplier AND a.CompanyCode = _RecAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _DfltAddrRprstn ON AddressID = _DfltAddrRprstn.AddressID AND _DfltAddrRprstn.AddressPersonID is initial AND _DfltAddrRprstn.AddressRepresentationCode is initial  -- association [0..1]
;