I_SupplierActivityTaskSupplier

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_SupplierActivityTaskSupplier.
-- 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: ISUPLACTTSSUPLR

CREATE VIEW I_SupplierActivityTaskSupplier AS
SELECT
  SuplrActyTaskPartyUUID,
  SuplrActyTaskUUID,
  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
FROM I_SupplierActivityTaskParty AS party
LEFT OUTER JOIN I_BusinessPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier_to_BusinessPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierActivityTask AS _SupplierActivityTask ON SuplrActyTaskUUID = _SupplierActivityTask.SuplrActyTaskUUID  -- association [1..1]
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]
;