I_NO_SAFTSupplierMasterData

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_NO_SAFTSupplierMasterData.
-- 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.
-- Parameters: P_FromPostingDate : budat, P_ToPostingDate : budat, P_Ledger : fins_ledger, P_FiscalYear : gjahr

CREATE VIEW I_NO_SAFTSupplierMasterData AS
SELECT
  SupplierCompany.CompanyCode AS CompanyCode,
  SupplierCompany.Supplier AS Supplier,
  cast('' as fis_belnr) AS AccountingDocument,
  cast('' as fis_docln) AS LedgerGLLineItem,
  cast(ltrim(Supplier.Supplier,'0') as saftn_no_supplier_id) AS NO_SAFTSupplierID,
  BP.BusinessPartner AS BusinessPartner,
  BP.BusinessPartnerUUID AS BusinessPartnerUUID,
  Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  SupplierCompany.ReconciliationAccount AS GLAccount,
  Supplier.TaxNumber1 AS TaxNumber1,
  Supplier.TaxNumber2 AS TaxNumber2,
  Supplier.OrganizationBPName1 AS OrganizationBPName1,
  Supplier.OrganizationBPName2 AS OrganizationBPName2,
  Supplier.VATRegistration AS VATRegistration,
  cast('' as suppliername) AS SupplierName,
  Address.Country AS Country,
  Address.Region AS Region,
  Address.CityName AS CityName,
  Address.StreetName AS StreetName,
  Address.HouseNumber AS HouseNumber,
  Address.PostalCode AS PostalCode,
  Address.POBox AS POBox,
  Address.POBoxPostalCode AS POBoxPostalCode,
  cast('' as bankn) AS BankAccount,
  cast('' as bankk) AS BankNumber,
  RegionText.RegionName AS RegionName,
  SupplierCompany._CompanyCode AS _CompanyCode,
  SupplierCompany._Supplier AS P_FromPostingDate,
  P_ToPostingDate: $parameters.P_ToPostingDate AS P_ToPostingDate,
  P_Ledger: $parameters.P_Ledger AS P_Ledger,
  case when OneTimeBP.TaxID1 is not initial then concat(concat(ltrim(JournalItem.Supplier,'0'), '/'), OneTimeBP.TaxID1) when OneTimeBP.TaxID2 is not initial then concat(concat(ltrim(JournalItem.Supplier,'0'), '/'), OneTimeBP.TaxID2) else concat(ltrim(JournalItem.Supplier,'0'), '/NA') end as NO_SAFTSupplierID AS Supplier0NAendasNO_SAFTSupplierID,
  SupplierCompany._Supplier AS _Supplier
FROM I_SAFTSupplierBalance
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_SupplierToBusinessPartner AS SupToBP 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_NO_SAFTSuppliersInPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS OneTimeBP ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;