I_SalesPlanChangeLog

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_SalesPlanChangeLog.
-- 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: ISDSPCL

CREATE VIEW I_SalesPlanChangeLog AS
SELECT
  Header.ChangeDocObject AS ChangeDocObject,
  cast ( Header.ChangeDocObjectClass as sp_chglog_object ) AS ChangeDocObjectClass,
  Header.ChangeDocument AS ChangeDocument,
  Item.DatabaseTable AS DatabaseTable,
  Item.ChangeDocTableKey AS ChangeDocTableKey,
  Item.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  Item.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  left( Header.ChangeDocObject, 32) AS SalesPlanUUID,
  _SalesPlan.SalesPlan AS SalesPlan,
  User.UserID AS UserID,
  cast ( User.PersonFullName as sp_chglog_username ) AS PersonFullName,
  Header.CreationDate AS CreationDate,
  Header.CreationTime AS CreationTime,
  cast ( Item.ChangeDocNewFieldValue as sp_chglog_new_value ) AS ChangeDocNewFieldValue,
  cast ( Item.ChangeDocPreviousFieldValue as sp_chglog_old_value ) AS ChangeDocPreviousFieldValue
FROM I_ChangeDocument AS Header
LEFT OUTER JOIN I_ChangeDocumentItem AS Item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessUser AS User ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeDocChangeIndT AS _ChgDocItmChgTypeText ON ChangeDocItemChangeType = _ChgDocItmChgTypeText.Value  -- association [0..*]
LEFT OUTER JOIN I_ChangeDocFieldNamesT AS _DatabaseTableFieldText ON DatabaseTable = _DatabaseTableFieldText.DatabaseTable AND ChangeDocDatabaseTableField = _DatabaseTableFieldText.Value AND _DatabaseTableFieldText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_SalesPlanForChangeDoc AS _SalesPlan ON ChangeDocObject = _SalesPlan.ChangeDocObject  -- association [0..1]
;