C_Supplier_Fs

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_Supplier_Fs.
-- 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: CSUPPLIERSFS

CREATE VIEW C_Supplier_Fs AS
SELECT
  Supplier.Supplier AS Supplier,
  Supplier.SupplierName AS SupplierName,
  Supplier.Material AS Material,
  Supplier.SupplierCityName AS SupplierCityName,
  Supplier.AddressID AS AddressID,
  Supplier.InternationalLocationNumber3 AS InternationalLocationNumber3,
  Supplier.PostingIsBlocked AS PostingIsBlocked,
  Supplier.PurchasingIsBlockedForSupplier AS PurchasingIsBlockedForSupplier,
  Supplier.FaxNumber AS FaxNumber,
  Supplier.SupplierIndustry AS SupplierIndustry,
  Supplier.SupplierIndustryName AS SupplierIndustryName,
  Supplier.InternationalLocationNumber1 AS InternationalLocationNumber1,
  Supplier.InternationalLocationNumber2 AS InternationalLocationNumber2,
  Supplier.Language AS Language,
  Supplier.CountryName AS CountryName,
  Supplier.AdditionalName AS AdditionalName,
  Supplier.InternationalPhoneNumber AS InternationalPhoneNumber,
  Supplier.RoleOwnerEmailAddress AS RoleOwnerEmailAddress,
  Supplier.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  Supplier.InternationalFaxNumber AS InternationalFaxNumber,
  Supplier.PhoneNumber2 AS PhoneNumber2,
  Supplier.Plant AS Plant,
  Supplier.POBox AS POBox,
  Supplier.RegionName AS RegionName,
  Supplier.StreetAddressName AS StreetAddressName,
  Supplier.SupplierTaxID1 AS SupplierTaxID1,
  Supplier.UniformResourceLocator AS UniformResourceLocator,
  Supplier.SupplierVATRegistration AS SupplierVATRegistration,
  Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  Supplier.PlantName AS PlantName,
  Supplier.LocationTimeZone AS LocationTimeZone,
  Supplier.BusinessPartner AS BusinessPartner,
  Supplier.AccountGroupName AS AccountGroupName,
  Supplier.DocumentKeyForUnitCnvrsn AS DocumentKeyForUnitCnvrsn,
  Supplier.PostalCode AS PostalCode
FROM P_Supplier_Fs AS Supplier
LEFT OUTER JOIN C_Product_Fs AS _Product ON Material = _Product.Material  -- association [1..1]
;