I_ChgRecordLifeCycleStatusLog

DDL: I_CHGRECORDLIFECYCLESTATUSLOG SQL: ICHGLIFESTALOG Type: view BASIC
24 Fields 1 Data Sources 2 Associations

Change Record Life Cycle Status Log

I_ChgRecordLifeCycleStatusLog is a Basic CDS View that provides data about "Change Record Life Cycle Status Log" in SAP S/4HANA. It reads from 1 data source (P_ChgDocUUIDConvertCharToRaw) and exposes 24 fields with key fields ChangeDocumentUUID, ChangeDocObjectClass, ChangeDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ChgDocUUIDConvertCharToRaw ChangeDocument from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_EngCockpit _ChangeRecord ChangeDocument.ChangeDocumentUUID = _ChangeRecord.ChangeRecordUUID
[0..1] I_CalendarDate _Calendar ChangeDocument.CreationDate = _Calendar.CalendarDate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGLIFESTALOG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Record Life Cycle Status Log view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentUUID ChangeDocumentUUID
KEY ChangeDocObjectClass ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument ChangeDocument Document Number
ChangeRecordLifecycleStatus ChangeDocNewFieldValue
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
ChangeDocLanguage ChangeDocLanguage
_ChangeDocLanguage _ChangeDocLanguage
ChangeRecord _ChangeRecord ChangeRecord Char20
ChangeRecordType _ChangeRecord ChangeRecordType Record Type
ChgRecordDescriptionText _ChangeRecord ChgRecordDescriptionText
Partner _ChangeRecord Partner With Partner
YearMonth _Calendar YearMonth Year Month
CalendarYear _Calendar CalendarYear Year
CalendarMonth _Calendar CalendarMonth Calendar Month
YearQuarter _Calendar YearQuarter Year Quarter
CalendarQuarter _Calendar CalendarQuarter Calendar Quarter
YearWeek _Calendar YearWeek Year and Calendar Week
CalendarWeek _Calendar CalendarWeek Calendar Week
FourWeeksInThePast
FourMonthsInThePast
FourQuartersInThePast

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_ChgRecordLifeCycleStatusLog.
-- 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: ICHGLIFESTALOG

CREATE VIEW I_ChgRecordLifeCycleStatusLog AS
SELECT
  ChangeDocumentUUID,
  ChangeDocObjectClass,
  ChangeDocument,
  ChangeDocNewFieldValue AS ChangeRecordLifecycleStatus,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  ChangeDocLanguage,
  _ChangeRecord.ChangeRecord AS ChangeRecord,
  _ChangeRecord.ChangeRecordType AS ChangeRecordType,
  _ChangeRecord.ChgRecordDescriptionText AS ChgRecordDescriptionText,
  _ChangeRecord.Partner AS Partner,
  _Calendar.YearMonth AS YearMonth,
  _Calendar.CalendarYear AS CalendarYear,
  _Calendar.CalendarMonth AS CalendarMonth,
  _Calendar.YearQuarter AS YearQuarter,
  _Calendar.CalendarQuarter AS CalendarQuarter,
  _Calendar.YearWeek AS YearWeek,
  _Calendar.CalendarWeek AS CalendarWeek,
  dats_add_days( _ChangeRecord.SessionDate, _ChangeRecord.NumberOfDaysInFourWeeks, 'UNCHANGED') AS FourWeeksInThePast,
  dats_add_months( _ChangeRecord.SessionDate, _ChangeRecord.NumberOfMonths, 'UNCHANGED') AS FourMonthsInThePast,
  dats_add_months( _ChangeRecord.SessionDate, _ChangeRecord.NumberOfMonthsInOneYear, 'UNCHANGED') AS FourQuartersInThePast
FROM P_ChgDocUUIDConvertCharToRaw AS ChangeDocument
LEFT OUTER JOIN P_EngCockpit AS _ChangeRecord ON ChangeDocument.ChangeDocumentUUID = _ChangeRecord.ChangeRecordUUID  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON ChangeDocument.CreationDate = _Calendar.CalendarDate  -- association [0..1]
;

Learn More