P_CostCenterChangeLogItem

DDL: P_COSTCENTERCHANGELOGITEM Type: view_entity COMPOSITE Package: ODATA_COST_CENTER_CHNGLOG
29 Fields 1 Data Sources

Cost Center Change Log Item

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

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (29)

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
ChangeDocumentValidityEndDate
ChangeDocValidityStartDate
ControllingArea
CostCenter
ValidityEndDate
ValidityStartDate
ChangeDocPreviousUnit ChangeDocPreviousUnit
ChangeDocNewUnit ChangeDocNewUnit
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue ChangeDocNewFieldValue New Value
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue Old Value
ChangeDocTextIsChanged ChangeDocTextIsChanged
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocument _ChangeDocument
_ChangeDocumentItemExtension _ChangeDocumentItemExtension
_FieldTextDDIC _FieldTextDDIC
_FieldTextLabel _FieldTextLabel
_FieldTextReplace _FieldTextReplace
_FieldTextView _FieldTextView
_TableTextDDIC _TableTextDDIC
_TableTextView _TableTextView

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_CostCenterChangeLogItem.
-- 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.

CREATE VIEW P_CostCenterChangeLogItem AS
SELECT
  ChangeDocObject,
  ChangeDocObjectClass,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  substring( ChangeDocTableKey, 18, 8 ) AS ChangeDocumentValidityEndDate,
  substring( ChangeDocTableKey, 26, 8) AS ChangeDocValidityStartDate,
  substring( ChangeDocObject, 1, 4 ) AS ControllingArea,
  substring( ChangeDocObject, 5, 10 ) AS CostCenter,
  substring( ChangeDocTableKey, 18, 8 ) AS ValidityEndDate,
  substring( ChangeDocTableKey, 26, 8) AS ValidityStartDate,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue,
  ChangeDocTextIsChanged
FROM I_ChangeDocumentItem
;

Learn More