P_ClosingChangeLog

DDL: P_CLOSINGCHANGELOG SQL: PCLSGCHNGLOG Type: view COMPOSITE Package: FCCO_VDM_MD
16 Fields 1 Data Sources

Closing Change Log

P_ClosingChangeLog is a Composite CDS View that provides data about "Closing Change Log" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 16 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. Part of development package FCCO_VDM_MD.

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCLSGCHNGLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject Object Value
KEY ChangeDocObjectClass ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument ChangeDocument Document Number
KEY DatabaseTable DatabaseTable Table Name
KEY ChangeDocTableKey ChangeDocTableKey Table Keys
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType ChangeDocItemChangeType Change Indicator
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue New Value
ChangeDocPreviousFieldValue Old Value
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension

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 P_ClosingChangeLog.
-- 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: PCLSGCHNGLOG

CREATE VIEW P_ClosingChangeLog AS
SELECT
  ChangeDocObject,
  ChangeDocObjectClass,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  cast( ChangeDocNewFieldValue as changedocnewfieldvalue ) AS ChangeDocNewFieldValue,
  cast( ChangeDocPreviousFieldValue as changedocpreviousfieldvalue ) AS ChangeDocPreviousFieldValue
FROM I_ChangeDocumentItem
;

Learn More