I_SuplrEvalTmplPurchResp

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_SuplrEvalTmplPurchResp.
-- 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: ISUPEVALTEMPRSP

CREATE VIEW I_SuplrEvalTmplPurchResp AS
SELECT
  cast (SuplrEvalTemplatePartyUUID as /srmsmc/sep_party_uuid preserving type) AS SuplrEvalTemplatePartyUUID,
  cast (SuplrEvalTemplateUUID as /srmsmc/sep_uuid preserving type) AS SuplrEvalTemplateUUID,
  cast(substring( SLCParty,1,12) as /srmsmc/user preserving type) AS UserID,
  EmailAddress,
  IsBusinessPurposeCompleted,
  AuthorizationGroup,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  DataControllerSet
FROM I_SupplierEvalTemplateParty AS Party
LEFT OUTER JOIN I_BusinessUser AS _BusinessUser ON UserID = _BusinessUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SupplierEvalTemplate AS _SupplierEvalTemplate ON SuplrEvalTemplateUUID = _SupplierEvalTemplate.SuplrEvalTemplateUUID  -- association [1..1]
;