CNV_PE_MC_LIST_ACOP

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 CNV_PE_MC_LIST_ACOP.
-- 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: CNV_PE_MC_ACOP

CREATE VIEW CNV_PE_MC_LIST_ACOP AS
SELECT
  proj.mandt AS client,
  proj.uuid AS ProjUuid,
  obj_t.descr AS Descr,
  proj.cre_time AS CreatedOn,
  case ltrim(user.UserDescription, ' ') when '' then proj.cre_user else ltrim(user.UserDescription, ' ') end as CreatedBy AS UserDescriptionendasCreatedBy,
  proj.finished AS Finished,
  proj.to_be_deleted AS ToBeDeleted,
  proj.approach AS MigrationApproach,
  proj.scenario AS Scenario,
  proj.imported AS Imported,
  conn.ca_uuid AS DestinationUUID,
  conn.connection_name AS Destination,
  acop.templ_area_id AS TemplAreaId,
  log.event_type AS EventType,
  obj.srcsys_id AS SrcsysId
INNER JOIN cnv_pe_object AS obj ON /* join condition not captured in parsed metadata */
INNER JOIN CNV_PE_MC_UNION_AREA AS area ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_eventlog AS log ON /* join condition not captured in parsed metadata */
;