C_LglCntntMChangeLog

DDL: C_LGLCNTNTMCHANGELOG SQL: CLCMCHNGLOG Type: view CONSUMPTION
27 Fields 1 Data Sources 5 Associations

Legal Content Management Change Log

C_LglCntntMChangeLog is a Consumption CDS View that provides data about "Legal Content Management Change Log" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMChangeDocItem) and exposes 27 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMChangeDocItem ChangeDocumentItem from

Associations (5)

CardinalityTargetAliasCondition
[0..1] C_LglCntntMChangeDocument _LglCntntMChangeDocument $projection.ChangeDocObjectClass = _LglCntntMChangeDocument.ChangeDocObjectClass and $projection.ChangeDocObject = _LglCntntMChangeDocument.ChangeDocObject and $projection.ChangeDocument = _LglCntntMChangeDocument.ChangeDocument
[0..1] I_LglCntntMLongTextVersion _LongText ChangeDocDatabaseTableField = 'LGLCNTNTMLONGTEXTUUID' and ChangeDocNewFieldValue = _LongText.LglCntntMNewLongTextID and ChangeDocPreviousFieldValue = _LongText.LglCntntMOldLongTextID
[0..*] I_ChangeDocTableNames _ChangeDocTableNames $projection.DatabaseTable = _ChangeDocTableNames.Value
[0..*] I_ChangeDocFieldNamesT _ChangeDocFieldNamesT $projection.DatabaseTable = _ChangeDocFieldNamesT.DatabaseTable and $projection.ChangeDocDatabaseTableField = _ChangeDocFieldNamesT.Value
[0..*] I_ChangeDocChangeIndT _ChangeDocChangeIndT $projection.ChangeDocItemChangeType = _ChangeDocChangeIndT.Value

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CLCMCHNGLOG view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
EndUserText.label Legal Content Management Change Log view
ObjectModel.semanticKey ChangeDocObject view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Search.searchable true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject Object Value
KEY ChangeDocObjectClass ChangeDocObjectClass Object Class
KEY ChangeDocument ChangeDocument Document Number
KEY DatabaseTable DatabaseTable Entity
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField Item
KEY ChangeDocItemChangeType ChangeDocItemChangeType Activity
CreatedByUser _LglCntntMChangeDocument CreatedByUser User
FullName _LglCntntMChangeDocument FullName Name
FirstName _LglCntntMChangeDocument FirstName First Name
LastName _LglCntntMChangeDocument LastName Last Name
CreationDate _LglCntntMChangeDocument CreationDate Time Stamp
CreationTime _LglCntntMChangeDocument CreationTime Time of Change
CreationDateTime
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
LglCntntMSrchChgDocNewFldVal ChangeDocNewFieldValue
LglCntntMLongTxtChgType _LongText LglCntntMLongTxtChgType
LglCntntMLongTxtChgTypeTxt _LongText LglCntntMLongTxtChgTypeTxt
LglCntntMSrchChgDocOldFldVal ChangeDocPreviousFieldValue
_LglCntntMChangeDocument _LglCntntMChangeDocument
_LongText _LongText
_ChangeDocTableNames _ChangeDocTableNames
_ChangeDocFieldNamesT _ChangeDocFieldNamesT
_ChangeDocChangeIndT _ChangeDocChangeIndT

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 C_LglCntntMChangeLog.
-- 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: CLCMCHNGLOG

CREATE VIEW C_LglCntntMChangeLog AS
SELECT
  ChangeDocObject,
  ChangeDocObjectClass,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  _LglCntntMChangeDocument.CreatedByUser AS CreatedByUser,
  _LglCntntMChangeDocument.FullName AS FullName,
  _LglCntntMChangeDocument.FirstName AS FirstName,
  _LglCntntMChangeDocument.LastName AS LastName,
  _LglCntntMChangeDocument.CreationDate AS CreationDate,
  _LglCntntMChangeDocument.CreationTime AS CreationTime,
  cast (dats_tims_to_tstmp( _LglCntntMChangeDocument.CreationDate, _LglCntntMChangeDocument.CreationTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as lcm_created_on) AS CreationDateTime,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  ChangeDocNewFieldValue AS LglCntntMSrchChgDocNewFldVal,
  _LongText.LglCntntMLongTxtChgType AS LglCntntMLongTxtChgType,
  _LongText.LglCntntMLongTxtChgTypeTxt AS LglCntntMLongTxtChgTypeTxt,
  ChangeDocPreviousFieldValue AS LglCntntMSrchChgDocOldFldVal
FROM I_LglCntntMChangeDocItem AS ChangeDocumentItem
LEFT OUTER JOIN C_LglCntntMChangeDocument AS _LglCntntMChangeDocument ON ChangeDocObjectClass = _LglCntntMChangeDocument.ChangeDocObjectClass AND ChangeDocObject = _LglCntntMChangeDocument.ChangeDocObject AND ChangeDocument = _LglCntntMChangeDocument.ChangeDocument  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMLongTextVersion AS _LongText ON ChangeDocDatabaseTableField = 'LGLCNTNTMLONGTEXTUUID' AND ChangeDocNewFieldValue = _LongText.LglCntntMNewLongTextID AND ChangeDocPreviousFieldValue = _LongText.LglCntntMOldLongTextID  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocTableNames AS _ChangeDocTableNames ON DatabaseTable = _ChangeDocTableNames.Value  -- association [0..*]
LEFT OUTER JOIN I_ChangeDocFieldNamesT AS _ChangeDocFieldNamesT ON DatabaseTable = _ChangeDocFieldNamesT.DatabaseTable AND ChangeDocDatabaseTableField = _ChangeDocFieldNamesT.Value  -- association [0..*]
LEFT OUTER JOIN I_ChangeDocChangeIndT AS _ChangeDocChangeIndT ON ChangeDocItemChangeType = _ChangeDocChangeIndT.Value  -- association [0..*]
;

Learn More