I_CostCenterChangeLog

DDL: I_COSTCENTERCHANGELOG SQL: ICCCHNGLOG Type: view COMPOSITE Package: FINS_COST_CENTER_VDM
33 Fields 1 Data Sources 1 Associations

Cost Center Change Log

I_CostCenterChangeLog (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_CostCenterChangeLog is a Composite CDS View that provides data about "Cost Center Change Log" in SAP S/4HANA. It reads from 1 data source (P_CostCenterChangeLog) and exposes 33 fields with key fields ChangeDocumentControllingArea, ChangeDocumentCostCenter, ChangeDocumentValidityEndDate, ChangeDocValidityStartDate, ChangeDocObject. It has 1 association to related views. Part of development package FINS_COST_CENTER_VDM.

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 →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-OM-2CL
CapabilitiesData Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view helps to retrieve changes made to the cost center master data.</p> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_CostCenterChangeLog ChangeDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CostCenter CostCenter ChangeDocumentItem.ChangeDocumentControllingArea = CostCenter.ControllingArea and ChangeDocumentItem.ChangeDocumentCostCenter = CostCenter.CostCenter and ChangeDocumentItem.ChangeDocumentValidityEndDate = CostCenter.ValidityEndDate and ChangeDocumentItem.ChangeDocValidityStartDate = CostCenter.ValidityStartDate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICCCHNGLOG view
AbapCatalog.compiler.compareFilter 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.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentControllingArea P_CostCenterChangeLog ChangeDocumentControllingArea Controlling Area
KEY ChangeDocumentCostCenter Cost Center
KEY ChangeDocumentValidityEndDate Cost Center Validity End Date
KEY ChangeDocValidityStartDate Cost Center Validity Start Date
KEY ChangeDocObject P_CostCenterChangeLog ChangeDocObject Object Value
KEY ChangeDocument P_CostCenterChangeLog ChangeDocument Change Number of Document
KEY ChangeDocDatabaseTableField P_CostCenterChangeLog ChangeDocDatabaseTableField Field Name
KEY ChangeDocItemChangeType P_CostCenterChangeLog ChangeDocItemChangeType Type of Change
ChangeDocObjectClass P_CostCenterChangeLog ChangeDocObjectClass Change Doc. Object
DatabaseTable P_CostCenterChangeLog DatabaseTable Table Name
ChangeDocTableKey P_CostCenterChangeLog ChangeDocTableKey Key of Modified Table Row
ChangeDocPreviousUnit P_CostCenterChangeLog ChangeDocPreviousUnit Referenced Unit for Old Field Content
ChangeDocNewUnit P_CostCenterChangeLog ChangeDocNewUnit Referenced Unit for New Field Content
ChangeDocPreviousCurrency P_CostCenterChangeLog ChangeDocPreviousCurrency Referenced Currency for Old Field Content
ChangeDocNewCurrency P_CostCenterChangeLog ChangeDocNewCurrency Referenced Currency for New Field Content
ChangeDocNewFieldValue P_CostCenterChangeLog ChangeDocNewFieldValue New Content of Changed Field
ChangeDocPreviousFieldValue P_CostCenterChangeLog ChangeDocPreviousFieldValue Old Content of Changed Field
CreatedByUser CreatedByUser User Name of Person Making Change in Change Document
CreationDate CreationDate Creation Date of Change Document
CreationTime CreationTime Time of Change
ChangeDocLanguage ChangeDocLanguage Language Key
BusinessArea CostCenter BusinessArea Business Area
CompanyCode CostCenter CompanyCode Receiver Company Code
ControllingArea CostCenter ControllingArea Controlling Area
CostCenter CostCenter CostCenter Cost Center
ValidityEndDate CostCenter ValidityEndDate Valid To Date
ValidityStartDate CostCenter ValidityStartDate Validity Start Date
_ChangeDocLongTableKey P_CostCenterChangeLog _ChangeDocLongTableKey
_ChangeDocument P_CostCenterChangeLog _ChangeDocument
_ChangeDocumentItemExtension P_CostCenterChangeLog _ChangeDocumentItemExtension
_BusinessArea CostCenter _BusinessArea
_CompanyCode CostCenter _CompanyCode
_ControllingArea 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,
  cast( ChangeDocumentItem.ChangeDocumentCostCenter as kostl ) AS ChangeDocumentCostCenter,
  cast( ChangeDocumentItem.ChangeDocumentValidityEndDate as costcentervalidityenddate ) AS ChangeDocumentValidityEndDate,
  cast( ChangeDocumentItem.ChangeDocValidityStartDate as costcentervaliditystartdate ) 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 ChangeDocumentItem.ChangeDocumentControllingArea = CostCenter.ControllingArea AND ChangeDocumentItem.ChangeDocumentCostCenter = CostCenter.CostCenter AND ChangeDocumentItem.ChangeDocumentValidityEndDate = CostCenter.ValidityEndDate AND ChangeDocumentItem.ChangeDocValidityStartDate = CostCenter.ValidityStartDate  -- association [0..1]
;

Learn More