I_SAFTGenLedgerOneTimeCustomer

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_SAFTGenLedgerOneTimeCustomer.
-- 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: ISAFTGENLEDOTC

CREATE VIEW I_SAFTGenLedgerOneTimeCustomer 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.PostingDate AS PostingDate,
  a.Customer AS Customer,
  a.CompanyCodeCurrency AS CompanyCodeCurrency,
  _CustCompany.ReconciliationAccount AS ReconciliationAccount,
  concat(b.BusinessPartnerName1, concat (' ', b.BusinessPartnerName2)) AS CompanyName,
  b.StreetAddressName AS StreetName,
  '' AS StreetPrefixName,
  '' AS AdditionalStreetPrefixName,
  '' AS StreetSuffixName,
  '' AS AdditionalStreetSuffixName,
  cast('' as abap.char(10)) AS HouseNumber,
  b.CityName AS CityName,
  b.PostalCode AS PostalCode,
  b.Country AS Country,
  b.Region AS Region,
  b.POBox AS POBox,
  b.POBoxPostalCode AS POBoxPostalCode,
  b.AddressID AS AddressID,
  cast('' as abap.char(30)) AS PhoneNumber,
  '' AS FaxNumber,
  cast('' as abap.char(241)) AS EmailAddress,
  cast('' as abap.char(50)) AS WebsiteURL,
  a._Customer AS _Customer,
  a._ChartOfAccounts AS _ChartOfAccounts,
  a._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  a._SourceLedger AS _SourceLedger,
  a._CompanyCode AS _CompanyCode,
  a._FiscalYear AS _FiscalYear,
  a._JournalEntry AS _JournalEntry,
  a._Ledger AS _Ledger,
  a._AccountingDocumentCategory AS _AccountingDocumentCategory,
  a._GLAccountInCompanyCode AS _GLAccountInCompanyCode
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_CustomerCompany AS _CustCompany ON a.Customer = _CustCompany.Customer AND a.CompanyCode = _CustCompany.CompanyCode  -- association [0..1]
;