I_ChangeRecdLog

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_ChangeRecdLog.
-- 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: ICHGRECDLOG

CREATE VIEW I_ChangeRecdLog AS
SELECT
  _ChangeStatusLog.ChangeLogObjectID AS ChangeLogObjectID,
  _ChangeStatusLog.ChangeDocument AS ChangeDocument,
  _ChangeStatusLog.ChangeRecdLogStatus AS ChangeRecdLogStatus,
  _ChangeStatusLog.ChangeRecdLogFieldName AS ChangeRecdLogFieldName,
  _ChangeStatusLog.ChangeDocumentChangeType AS ChangeDocumentChangeType,
  _DigSignLog.ChgRecdInitiatedStatusAction AS ChgRecdInitiatedStatusAction,
  _DigSignLog.ChangeRecordStatusActionText AS ChangeRecordStatusActionText,
  _ChangeStatusLog.ChangeRecordStatusDescription AS ChangeRecordStatusDescription,
  _DigSignLog.ChangeRecordStatus AS ChangeRecordStatus,
  _DigSignLog.ChgRecdDigSignStatusTxt AS ChgRecdDigSignStatusTxt,
  cast('' as /iam/internal_id ) AS ChgRecdObjRefKeyID,
  cast ('' as val_text ) AS ProcessingStatusDesc,
  cast ('' as /iam/type_text ) AS ChangeRecordObjectTypeText,
  _ChangeStatusLog.LastChangedByUser AS LastChangedByUser,
  _UserContactCard.FullName AS LastChangedByUserFullName,
  _ChangeStatusLog.LastChangedDate AS LastChangedDate,
  _ChangeStatusLog.ChangeRecdLastChangedTime AS ChangeRecdLastChangedTime,
  _ChangeStatusLog._UsrStsTxt AS _UsrStsTxt
INNER JOIN I_ChangeRecdStatusLogBsc AS _ChangeStatusLog ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChgRecdItmExtnLogBsc AS ItemExtension ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON LastChangedByUser = _UserContactCard.ContactCardID  -- association [0..1]
;