I_SAFTGeneralLedgerOneTimeBP

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_SAFTGeneralLedgerOneTimeBP.
-- 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: ISAFTGENLEDOTBP

CREATE VIEW I_SAFTGeneralLedgerOneTimeBP AS
SELECT
  GenLedBP.CompanyCode AS CompanyCode,
  GenLedBP.FiscalYear AS FiscalYear,
  GenLedBP.AccountingDocument AS AccountingDocument,
  GenLedBP.LedgerGLLineItem AS LedgerGLLineItem,
  GenLedBP.Ledger AS Ledger,
  Journal.ChartOfAccounts AS ChartOfAccounts,
  Journal.GLAccount AS GLAccount,
  Journal.AccountingDocumentCategory AS AccountingDocumentCategory,
  Journal.PostingDate AS PostingDate,
  BusinessPartnerType,
  GenLedBP.BusinessPartnerNumber AS BusinessPartnerNumber,
  case when Journal.Customer is not initial then Journal.Customer else case when Journal.Supplier is not initial then Journal.Supplier end end as BusinessPartner AS SupplierendendasBusinessPartner,
  Journal.Customer AS Customer,
  Journal.Supplier AS Supplier,
  Journal.AccountingDocumentItem AS AccountingDocumentItem,
  OneTimeBP.AddressID AS AddressID,
  case when OneTimeBP.TaxID1 is not initial then OneTimeBP.TaxID1 else _AccdocItem.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  concat( concat( OneTimeBP.BusinessPartnerName1, ' '), OneTimeBP.BusinessPartnerName2 ) AS CompanyName,
  OneTimeBP.StreetAddressName AS StreetAddressName,
  '' AS StreetPrefixName,
  '' AS AdditionalStreetPrefixName,
  '' AS StreetSuffixName,
  '' AS AdditionalStreetSuffixName,
  cast('' as abap.char(10)) AS HouseNumber,
  OneTimeBP.CityName AS CityName,
  OneTimeBP.PostalCode AS PostalCode,
  OneTimeBP.Country AS Country,
  OneTimeBP.POBox AS POBox,
  OneTimeBP.POBoxPostalCode AS POBoxPostalCode,
  OneTimeBP.Region AS Region,
  coalesce(_DfltAddrRprstn._Region._RegionText[1: Language = 'P'].RegionName, coalesce(_DfltAddrRprstn._Region._RegionText[1: Language = 'E'].RegionName, coalesce(_DfltAddrRprstn._Region._RegionText[1: Language = $session.system_language].RegionName, ''))) as RegionName AS RegionNameasRegionName
FROM P_SAFT_GeneralLedgerOneTimeBP AS GenLedBP
INNER JOIN I_JournalEntryItem AS Journal ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS OneTimeBP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _AccdocItem ON Journal.CompanyCode = _AccdocItem.CompanyCode AND Journal.AccountingDocument = _AccdocItem.AccountingDocument AND Journal.FiscalYear = _AccdocItem.FiscalYear AND Journal.AccountingDocumentItem = _AccdocItem.AccountingDocumentItem AND _AccdocItem.VATRegistration <> ''  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _DfltAddrRprstn ON OneTimeBP.AddressID = _DfltAddrRprstn.AddressID AND _DfltAddrRprstn.AddressPersonID is initial AND _DfltAddrRprstn.AddressRepresentationCode is initial  -- association [0..1]
;