I_SupplierEvalRespSuplrParty

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_SupplierEvalRespSuplrParty.
-- 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: ISUPEVALRSSUPPTY

CREATE VIEW I_SupplierEvalRespSuplrParty AS
SELECT
  SuplrEvalRspPartyUUID,
  SuplrEvalRspUUID,
  I_BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  cast ( substring(SLCParty,1,10 ) as bu_partner preserving type) AS BusinessPartner,
  cast(I_Supplier_to_BusinessPartner.Supplier as /srmsmc/supplier_id preserving type) AS Supplier,
  I_Supplier.AuthorizationGroup AS AuthorizationGroup,
  I_Supplier.DataController1 AS DataController1,
  I_Supplier.DataController2 AS DataController2,
  I_Supplier.DataController3 AS DataController3,
  I_Supplier.DataController4 AS DataController4,
  I_Supplier.DataController5 AS DataController5,
  I_Supplier.DataController6 AS DataController6,
  I_Supplier.DataController7 AS DataController7,
  I_Supplier.DataController8 AS DataController8,
  I_Supplier.DataController9 AS DataController9,
  I_Supplier.DataController10 AS DataController10,
  I_Supplier.DataControllerSet AS DataControllerSet,
  EmailAddress
FROM I_SupplierEvalResponseParty AS party
INNER JOIN I_BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier_to_BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SupplierEvalResponse AS _SupplierEvalResponse ON SuplrEvalRspUUID = _SupplierEvalResponse.SuplrEvalRspUUID  -- association [1..1]
LEFT OUTER JOIN I_SupplierEvalRspPartyAddress AS _SupplierEvalRspPartyAddress ON SuplrEvalRspPartyUUID = _SupplierEvalRspPartyAddress.SuplrEvalRspPartyUUID  -- association [0..1]
;