C_ChangeDocuments

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 C_ChangeDocuments.
-- 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: CBCCHANGEDOC

CREATE VIEW C_ChangeDocuments AS
SELECT
  _header.ChangeDocObjectClass AS ChangeDocObjectClass,
  _header.ChangeDocObjectClass AS ChangeDocObjectClassDisplay,
  _header.ChangeDocObjectClass AS ChangeDocObjectClassTr,
  _header.ChangeDocObject AS ChangeDocObject,
  cast( _header.ChangeDocObject as cdobjectidtxt preserving type ) AS ChangeDocObjectDisplay,
  _header.ChangeDocObject AS ChangeDocObjectTr,
  _header.ChangeDocument AS ChangeDocument,
  _ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  _ChangeDocumentItem.DatabaseTable AS DatabaseTableTr,
  case when _ChangeDocumentItem._ChangeDocLongTableKey.ChangeDocLongTableKey is not initial then _ChangeDocumentItem.ChangeDocTableKey when _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocTabkeyLength < 71 then coalesce( _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocTableKey, _ChangeDocumentItem.ChangeDocTableKey ) else _ChangeDocumentItem.ChangeDocTableKey end as ChangeDocTableKey AS ChangeDocTableKeyendasChangeDocTableKey,
  case when _ChangeDocumentItem._ChangeDocLongTableKey.ChangeDocLongTableKey is not initial then _ChangeDocumentItem.ChangeDocTableKey when _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocTabkeyLength < 71 then coalesce( _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocTableKey, _ChangeDocumentItem.ChangeDocTableKey ) else _ChangeDocumentItem.ChangeDocTableKey end as ChangeDocTableKeyT AS ChangeDocTableKeyendasChangeDocTableKeyT,
  _ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  _ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableFieldTr,
  cast( _ChangeDocumentItem.ChangeDocItemChangeType as cdchngind ) AS ChangeDocChangeType,
  _ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableFieldT,
  _ChangeDocumentItem.DatabaseTable AS DatabaseTableT,
  _header.CreatedByUser AS CreatedByUser,
  case when _user.NAME_TEXTC is not initial then _user.NAME_TEXTC else _header.CreatedByUser end as NAME_TEXTC AS CreatedByUserendasNAME_TEXTC,
  _header.CreationDate AS CreationDate,
  _header.CreationTime AS CreationTime,
  cast(dats_tims_to_tstmp ( _header.CreationDate, _header.CreationTime, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as cdcreated ) as CreatedOn AS clientNULLascdcreatedasCreatedOn,
  _header._ChangeDocLanguage.Language AS ChangeDocLanguageKey,
  _langu.LanguageName AS ChangeDocLanguage,
  _header.ChangeTransactionCode AS ChangeTransactionCode,
  cast('' as cdobjecttxt) AS ChangeDocObjectDescription,
  _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocStringNew AS ChangeDocumentStringNew,
  _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocStringOld AS ChangeDocumentStringOld,
  _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocShortStringNew AS ChangeDocNewShortString,
  _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocShortStringOld AS ChangeDocOldShortString,
  _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocRawStringNew AS ChangeDocNewRawString,
  _ChangeDocumentItem._ChangeDocumentItemExtension.ChangeDocRawStringOld AS ChangeDocOldRawString,
  _header._ChangeDocLanguage.Language AS Language
FROM I_ChangeDocument AS _header
LEFT OUTER JOIN I_LanguageText AS _langu ON _langu.Language = $session.system_language AND _langu.LanguageCode = ChangeDocLanguage  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocUser AS _user ON CreatedByUser = _user.UserName  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocChangeIndT AS _changetype_text ON ChangeDocChangeType = _changetype_text.Value AND _changetype_text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocFieldNamesT AS _fieldname_text ON _fieldname_text.DatabaseTable = DatabaseTable AND _fieldname_text.Value = ChangeDocDatabaseTableField AND _fieldname_text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocTableNames AS _tablename_text ON DatabaseTable = _tablename_text.Value AND _tablename_text.Language = $session.system_language  -- association [0..1]
;