I_CostCenterChangeLog

DDL: I_COSTCENTERCHANGELOG SQL: ICCCHNGLOG Type: view COMPOSITE
33 Fields 2 Data Sources

Cost Center Change Log

I_CostCenterChangeLog is a Composite CDS View that provides data about "Cost Center Change Log" in SAP S/4HANA. It reads from 2 data sources (P_CostCenterChangeLog, I_CostCenter) and exposes 33 fields with key fields ChangeDocumentControllingArea, ChangeDocumentCostCenter, ChangeDocumentValidityEndDate, ChangeDocValidityStartDate, ChangeDocObject.

SAP Help Documentation

CategoryCDS Views for Overhead Accounting
Purpose
This CDS view helps to retrieve changes made to the cost center master data. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: KOSTL (Cost Center) BUKRS (Company Code) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description ChangeDocumentControllingArea Controlling Area of the Cost Center ChangeDocumentCostCenter Cost Center ID ChangeDocumentValidityEndDate Cost Center Validity End Date ChangeDocValidityStartDate Cost Center Validity Start Date ChangeDocObject Object Value ChangeDocument Change Document Number ChangeDocDatabaseTableField Name of the Changed Field ChangeDocItemChangeType Type of Change

View on SAP Help Portal →

Data Sources (2)

SourceAliasJoin Type
P_CostCenterChangeLog ChangeDocumentItem from
I_CostCenter CostCenter left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICCCHNGLOG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cost Center Change Log view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentControllingArea P_CostCenterChangeLog ChangeDocumentControllingArea Controlling Area
KEY ChangeDocumentCostCenter P_CostCenterChangeLog ChangeDocumentCostCenter Cost Center
KEY ChangeDocumentValidityEndDate P_CostCenterChangeLog ChangeDocumentValidityEndDate
KEY ChangeDocValidityStartDate P_CostCenterChangeLog ChangeDocValidityStartDate
KEY ChangeDocObject P_CostCenterChangeLog ChangeDocObject Object Value
KEY ChangeDocument P_CostCenterChangeLog ChangeDocument Document Number
KEY ChangeDocDatabaseTableField P_CostCenterChangeLog ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType P_CostCenterChangeLog ChangeDocItemChangeType
ChangeDocObjectClass P_CostCenterChangeLog ChangeDocObjectClass Change Doc. Object
DatabaseTable P_CostCenterChangeLog DatabaseTable Table Name
ChangeDocTableKey P_CostCenterChangeLog ChangeDocTableKey
ChangeDocPreviousUnit P_CostCenterChangeLog ChangeDocPreviousUnit
ChangeDocNewUnit P_CostCenterChangeLog ChangeDocNewUnit
ChangeDocPreviousCurrency P_CostCenterChangeLog ChangeDocPreviousCurrency
ChangeDocNewCurrency P_CostCenterChangeLog ChangeDocNewCurrency
ChangeDocNewFieldValue P_CostCenterChangeLog ChangeDocNewFieldValue
ChangeDocPreviousFieldValue P_CostCenterChangeLog ChangeDocPreviousFieldValue
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
ChangeDocLanguage ChangeDocLanguage
BusinessArea I_CostCenter BusinessArea Business Area
CompanyCode I_CostCenter CompanyCode Receiver Company Code
ControllingArea I_CostCenter ControllingArea Controlling Area
CostCenter I_CostCenter CostCenter Cost Center
ValidityEndDate I_CostCenter ValidityEndDate ValidTo
ValidityStartDate I_CostCenter ValidityStartDate Validity Start Date
_ChangeDocLongTableKey P_CostCenterChangeLog _ChangeDocLongTableKey
_ChangeDocument P_CostCenterChangeLog _ChangeDocument
_ChangeDocumentItemExtension P_CostCenterChangeLog _ChangeDocumentItemExtension
_BusinessArea I_CostCenter _BusinessArea
_CompanyCode I_CostCenter _CompanyCode
_ControllingArea I_CostCenter _ControllingArea

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_CostCenterChangeLog.
-- 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: ICCCHNGLOG

CREATE VIEW I_CostCenterChangeLog AS
SELECT
  ChangeDocumentItem.ChangeDocumentControllingArea AS ChangeDocumentControllingArea,
  ChangeDocumentItem.ChangeDocumentCostCenter AS ChangeDocumentCostCenter,
  ChangeDocumentItem.ChangeDocumentValidityEndDate AS ChangeDocumentValidityEndDate,
  ChangeDocumentItem.ChangeDocValidityStartDate AS ChangeDocValidityStartDate,
  ChangeDocumentItem.ChangeDocObject AS ChangeDocObject,
  ChangeDocumentItem.ChangeDocument AS ChangeDocument,
  ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  ChangeDocumentItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  ChangeDocumentItem.ChangeDocTableKey AS ChangeDocTableKey,
  ChangeDocumentItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  ChangeDocumentItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  ChangeDocumentItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  ChangeDocumentItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  ChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  ChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  CreatedByUser,
  CreationDate,
  CreationTime,
  ChangeDocLanguage,
  CostCenter.BusinessArea AS BusinessArea,
  CostCenter.CompanyCode AS CompanyCode,
  CostCenter.ControllingArea AS ControllingArea,
  CostCenter.CostCenter AS CostCenter,
  CostCenter.ValidityEndDate AS ValidityEndDate,
  CostCenter.ValidityStartDate AS ValidityStartDate,
  ChangeDocumentItem._ChangeDocLongTableKey AS _ChangeDocLongTableKey,
  ChangeDocumentItem._ChangeDocument AS _ChangeDocument,
  ChangeDocumentItem._ChangeDocumentItemExtension AS _ChangeDocumentItemExtension,
  CostCenter._BusinessArea AS _BusinessArea,
  CostCenter._CompanyCode AS _CompanyCode,
  CostCenter._ControllingArea AS _ControllingArea
FROM P_CostCenterChangeLog AS ChangeDocumentItem
LEFT OUTER JOIN I_CostCenter AS CostCenter ON /* join condition not captured in parsed metadata */
;

Learn More