I_ChangeDocument_2

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_ChangeDocument_2.
-- 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 I_ChangeDocument_2 AS
SELECT
  cdpos.objectclas AS ChangeDocObjectClass,
  cdpos.objectid AS ChangeDocObject,
  cdpos.changenr AS ChangeDocument,
  cdpos.tabname AS ChangeDocDatabaseTable,
  cdpos.tabkey AS ChangeDocShortTableKey,
  cdpos.fname AS ChangeDocDatabaseTableField,
  cdpos.chngind AS ChangeDocItemChangeType,
  case when _ChangeDocumentItemExtension.ChangeDocTableKey is not initial then _ChangeDocumentItemExtension.ChangeDocTableKey when _ChangeDocLongTableKey.ChangeDocLongTableKey is not initial then _ChangeDocLongTableKey.ChangeDocLongTableKey else cdpos.tabkey end as ChangeDocTableKey AS tabkeyendasChangeDocTableKey,
  cdhdr.username AS CreatedByUser,
  case when _user.NAME_TEXTC is not initial then _user.NAME_TEXTC else cdhdr.username end as ChangeDocCreatedByUser AS usernameendasChangeDocCreatedByUser,
  cdhdr.udate AS CreationDate,
  cdhdr.utime AS CreationTime,
  cast(dats_tims_to_tstmp ( cdhdr.udate, cdhdr.utime, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as cdcreated ) as CreationDateTime AS clientNULLascdcreatedasCreationDateTime,
  cdhdr.tcode AS ChangeTransactionCode,
  cdhdr.change_ind AS ChangeDocChangeType,
  cdhdr.langu AS ChangeDocLanguage,
  cast ( cdpos.unit_old as cdunito preserving type ) AS ChangeDocPreviousUnit,
  cast ( cdpos.unit_new as cdunitn preserving type ) AS ChangeDocNewUnit,
  cast ( cdpos.cuky_old as cdcukyo preserving type ) AS ChangeDocPreviousCurrency,
  cast ( cdpos.cuky_new as cdcukyn preserving type ) AS ChangeDocNewCurrency,
  cdpos.value_new AS ChangeDocNewFieldValueDB,
  cdpos.value_old AS ChangeDocPreviousFieldValueDB,
  _ChangeDocumentItemExtension.ChangeDocStringNew AS ChangeDocNewString,
  _ChangeDocumentItemExtension.ChangeDocStringOld AS ChangeDocPreviousString,
  _ChangeDocumentItemExtension.ChangeDocShortStringNew AS ChangeDocNewShortString,
  _ChangeDocumentItemExtension.ChangeDocShortStringOld AS ChangeDocPreviousShortString,
  _ChangeDocumentItemExtension.ChangeDocRawStringNew AS ChangeDocNewRawString,
  _ChangeDocumentItemExtension.ChangeDocRawStringOld AS ChangeDocPreviousRawString
FROM cdpos
LEFT OUTER JOIN cdhdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeDocLongTableKey AS _ChangeDocLongTableKey ON ChangeDocShortTableKey = _ChangeDocLongTableKey.ChangeDocKeyGuid  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocumentItemExtension AS _ChangeDocumentItemExtension ON ChangeDocShortTableKey = _ChangeDocumentItemExtension.ChangeDocKeyGuid  -- association [0..1]
LEFT OUTER JOIN I_Language AS _ChangeDocLanguage ON ChangeDocLanguage = _ChangeDocLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _ChangeDocLanguageText ON _ChangeDocLanguageText.Language = $session.system_language AND _ChangeDocLanguageText.LanguageCode = ChangeDocLanguage  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocUser AS _user ON CreatedByUser = _user.UserName  -- association [0..1]
;