I_SADL_GW_CPLDATA

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_SADL_GW_CPLDATA.
-- 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: IV_SADL_CPLDATA

CREATE VIEW I_SADL_GW_CPLDATA AS
SELECT
  DataHandle,
  header_id AS ParentID,
  Object,
  obj_name AS ObjectName,
  created_on AS CreatedOn,
  start_time AS StartTime,
  msgty AS MessageType,
  msgid AS MessageID,
  msgno AS MessageNumber,
  msgv1 AS MessageVar1,
  msgv2 AS MessageVar2,
  msgv3 AS MessageVar3,
  msgv4 AS MessageVar4,
  text AS MessageText,
  long_text AS MessageLongText,
  source_code AS SourceCode,
  source_code_type AS ObjectType
FROM sadl_gw_cpldata AS Data
LEFT OUTER JOIN t100 AS Message ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SADL_GW_CPLHDR AS _Header ON ParentID = _Header.LogHandle  -- association [1..1]
;