C_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 C_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 C_NO_SAFTSupplierMasterData AS
SELECT
  Supplier.CompanyCode AS CompanyCode,
  Supplier.Supplier AS Supplier,
  Supplier.AccountingDocument AS AccountingDocument,
  Supplier.LedgerGLLineItem AS LedgerGLLineItem,
  Supplier.BusinessPartner AS BusinessPartner,
  Supplier.BusinessPartnerUUID AS BusinessPartnerUUID,
  Supplier.NO_SAFTSupplierID AS NO_SAFTSupplierID,
  Supplier.TaxNumber1 AS TaxNumber1,
  Supplier.TaxNumber2 AS TaxNumber2,
  Supplier.VATRegistration AS VATRegistration,
  case when Supplier.OrganizationBPName1 is initial and Supplier.OrganizationBPName2 is initial then 'NA' else concat_with_space(Supplier.OrganizationBPName1, Supplier.OrganizationBPName2, 1) end as BPSupplierName AS OrganizationBPName21endasBPSupplierName,
  SupplierName,
  case when Supplier.CityName is initial then 'NA' else substring(Supplier.CityName,1,35) end as CityName AS CityName135endasCityName,
  case when Supplier.StreetName is initial then Supplier.POBox else Supplier.StreetName end as StreetName AS StreetNameendasStreetName,
  case when Supplier.PostalCode is not initial and Supplier.StreetName is not initial then Supplier.PostalCode else case when Supplier.POBoxPostalCode is not initial and Supplier.POBox is not initial then Supplier.POBoxPostalCode else 'NA' end end as PostalCode AS POBoxPostalCodeelseNAendendasPostalCode,
  Supplier.Region AS Region,
  Supplier.RegionName AS RegionName,
  Supplier.HouseNumber AS HouseNumber,
  Supplier.Country AS Country,
  Supplier.POBox AS POBox,
  Supplier.POBoxPostalCode AS POBoxPostalCode,
  Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  Supplier.BankAccount AS BankAccount,
  Supplier.BankNumber AS BankNumber,
  'X' AS ItemIsReportingRelevant,
  Supplier._CompanyCode AS _CompanyCode,
  Supplier._Supplier AS _Supplier
;