I_InvgCsMChangeLog

DDL: I_INVGCSMCHANGELOG SQL: IINVGCSMCHNGELOG Type: view BASIC
13 Fields 2 Data Sources

ICM Change Log

I_InvgCsMChangeLog is a Basic CDS View that provides data about "ICM Change Log" in SAP S/4HANA. It reads from 2 data sources (cdhdr, cdpos) and exposes 13 fields with key fields InvgCsMChangeLogObjectClass, InvgCsMChangeLogObjectID, InvgCsMChangeLogChangeNumber, InvgCsMChangeLogTableName, InvgCsMChangeLogTableKey.

Data Sources (2)

SourceAliasJoin Type
cdhdr _header inner
cdpos _item from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINVGCSMCHNGELOG view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ICM Change Log view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMChangeLogObjectClass cdhdr objectclas Change Doc. Object
KEY InvgCsMChangeLogObjectID cdhdr objectid Object Value
KEY InvgCsMChangeLogChangeNumber cdhdr changenr Document Number
KEY InvgCsMChangeLogTableName tabname Table/Constant Value
KEY InvgCsMChangeLogTableKey tabkey Table Keys
KEY InvgCsMChangeLogFieldName fname User
KEY InvgCsMChangeLogChangeType chngind Change Indicator
InvgCsMChangeLogNewValue value_new New Value
InvgCsMChangeLogOldValue value_old Old Value
InvgCsMChangeLogCreatedByID username User who owns item
InvgCsMChangeLogCreatedDate udate Update Date
InvgCsMChangeLogCreatedTime utime Time
InvgCsMChangeLogTransCode tcode Undefined range (can be used for patch levels)

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_InvgCsMChangeLog.
-- 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: IINVGCSMCHNGELOG

CREATE VIEW I_InvgCsMChangeLog AS
SELECT
  _header.objectclas AS InvgCsMChangeLogObjectClass,
  _header.objectid AS InvgCsMChangeLogObjectID,
  _header.changenr AS InvgCsMChangeLogChangeNumber,
  tabname AS InvgCsMChangeLogTableName,
  tabkey AS InvgCsMChangeLogTableKey,
  fname AS InvgCsMChangeLogFieldName,
  chngind AS InvgCsMChangeLogChangeType,
  value_new AS InvgCsMChangeLogNewValue,
  value_old AS InvgCsMChangeLogOldValue,
  username AS InvgCsMChangeLogCreatedByID,
  udate AS InvgCsMChangeLogCreatedDate,
  utime AS InvgCsMChangeLogCreatedTime,
  tcode AS InvgCsMChangeLogTransCode
FROM cdpos AS _item
INNER JOIN cdhdr AS _header ON /* join condition not captured in parsed metadata */
;

Learn More