APS_COM_CHG_DOC_BASE

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 APS_COM_CHG_DOC_BASE.
-- 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.

CREATE VIEW APS_COM_CHG_DOC_BASE AS
SELECT
  changedoc.ChangeDocObjectClass AS CDocClass,
  changedoc.ChangeDocObject AS CDocKey,
  changedoc.ChangeDocument AS CDoc,
  p.DatabaseTable AS DBTable,
  p.ChangeDocTableKey AS DBTableKey,
  p.ChangeDocDatabaseTableField AS FieldName,
  p.ChangeDocItemChangeType AS Action,
  case Action when 'I' then _Text_Created.text when 'J' then _Text_Created.text when 'U' then _Text_Changed.text when 'D' then _Text_Deleted.text when 'E' then _Text_Deleted.text else '' end as ActionTxt AS textelseendasActionTxt,
  StructureText.ddtext AS DBTableText,
  changedoc.CreatedByUser AS CreatedByUser,
  _user.UserDescription AS CreatedByUsrTxt,
  changedoc.CreationDate AS CreationDate,
  changedoc.CreationTime AS CreationTime,
  concat(CreationDate, CreationTime) AS ChangedAt,
  tablFields.DataElement AS Attribute,
  tablFields.DataElementLongText AS AttributeText,
  p.ChangeDocNewFieldValue AS NewValue,
  p.ChangeDocPreviousFieldValue AS OldValue,
  cast( ltrim( DBTableKey, ' ' ) as abap.char(32) ) AS DBTableKeyUUID
FROM I_ChangeDocument AS changedoc
INNER JOIN I_ChangeDocumentItem AS p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_COM_STRUCT_COMP_DTEL_TXT AS tablFields ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02t AS StructureText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Created ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Changed ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Deleted ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_user_ddl AS _user ON changedoc.CreatedByUser = _user.UserID  -- association [0..1]
;