SEPM_I_SUPPLIER

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 SEPM_I_SUPPLIER.
-- 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: SEPM_ISUPP

CREATE VIEW SEPM_I_SUPPLIER AS
SELECT
  cast( snwd_bpa.node_key as sepm_bp_uuid preserving type ) AS SupplierUUID,
  snwd_bpa.currency_code AS Currency,
  snwd_bpa.company_name AS CompanyName,
  snwd_bpa.legal_form AS LegalForm,
  snwd_bpa.address_guid AS AddressUUID,
  snwd_bpa.email_address AS EmailAddress,
  snwd_bpa.fax_number AS FaxNumber,
  snwd_bpa.phone_number AS PhoneNumber,
  snwd_bpa.web_address AS URL,
  snwd_bpa.approval_status AS SupplierApprovalStatus,
  created_by AS CreatedByUser,
  created_at AS CreationDateTime,
  changed_by AS LastChangedByUser,
  changed_at AS LastChangedDateTime
FROM snwd_bpa
LEFT OUTER JOIN SEPM_I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Address AS _Address ON AddressUUID = _Address.AddressUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ContactPerson AS _ContactPerson ON SupplierUUID = _ContactPerson.BusinessPartnerUUID  -- association [0..*]
LEFT OUTER JOIN SEPM_I_BUPAAPPROVALSTATUS AS _ApprovalStatus ON SupplierApprovalStatus = _ApprovalStatus.BuPaApprovalStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Employee AS _CreatedByUser ON CreatedByUser = _CreatedByUser.EmployeeUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Employee AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.EmployeeUUID  -- association [0..1]
;