P_NO_SAFTJournalCustSupMD

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_SAFTJournalCustSupMD.
-- 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: PNOSAFTJCSMD

CREATE VIEW P_NO_SAFTJournalCustSupMD 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,
  BP.BusinessPartner AS BusinessPartner,
  BP.BusinessPartnerUUID AS BusinessPartnerUUID,
  Customer.VATRegistration AS VATRegistration,
  '' AS IsOneTimeAccount,
  CustomerCompany.ReconciliationAccount AS GLAccount,
  Customer.AddressID AS AddressID,
  Customer.TaxNumber1 AS TaxNumber1,
  Customer.TaxNumber2 AS TaxNumber2,
  Customer.OrganizationBPName1 AS OrganizationBPName1,
  Customer.OrganizationBPName2 AS OrganizationBPName2,
  Address.CityName AS CityName,
  Address.StreetName AS StreetName,
  Address.HouseNumber AS HouseNumber,
  Address.PostalCode AS PostalCode,
  Address.Country AS Country,
  Address.POBox AS POBox,
  Address.POBoxPostalCode AS POBoxPostalCode,
  RegionText.RegionName AS Region,
  JournalLineItem._CompanyCode AS _CompanyCode,
  JournalLineItem._FiscalYear AS _FiscalYear,
  JournalLineItem._Ledger AS _Ledger,
  JournalLineItem._JournalEntry AS CompanyCodeasCompanyCode,
  case when OneTimeBP.TaxID1 is not initial then OneTimeBP.TaxID1 else substring(JournalLineItem.VATRegistration ,3,18) end as VATRegistration AS VATRegistration318endasVATRegistration,
  JournalLineItem._JournalEntry AS _JournalEntry
FROM I_NO_SAFTJournalItem AS JournalLineItem
INNER JOIN I_CustomerToBusinessPartner AS CustToBP ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartner AS BP ON /* join condition not captured in parsed metadata */
INNER JOIN I_BPCurrentDefaultAddress AS BPAddress ON /* join condition not captured in parsed metadata */
INNER JOIN I_Address_2 AS Address ON /* join condition not captured in parsed metadata */
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerCompany AS CustomerCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierToBusinessPartner AS SupToBP 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_SupplierCompany AS SupplierCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_OneTimeAccountBP AS OneTimeBP ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_NO_SAFTJournalItem
;