P_CostCenterChangeLog

DDL: P_COSTCENTERCHANGELOG Type: view_entity COMPOSITE
28 Fields 1 Data Sources 1 Associations

P_CostCenterChangeLog is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_CostCenterChangeLogHeader) and exposes 28 fields with key fields ChangeDocumentControllingArea, ChangeDocumentCostCenter, ChangeDocumentValidityEndDate, ChangeDocValidityStartDate, ChangeDocObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CostCenterChangeLogHeader _Header from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_CostCenterChangeLogItem _Item _Item.ChangeDocObject = _Header.ChangeDocObject and _Item.ChangeDocObjectClass = _Header.ChangeDocObjectClass and _Item.ChangeDocument = _Header.ChangeDocument and _Item.ControllingArea = _Header.ControllingArea and _Item.CostCenter = _Header.CostCenter

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY 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 (28)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentControllingArea ControllingArea Controlling Area
KEY ChangeDocumentCostCenter CostCenter Cost Center
KEY ChangeDocumentValidityEndDate
KEY ChangeDocValidityStartDate
KEY ChangeDocObject _Item ChangeDocObject Object Value
KEY ChangeDocument _Item ChangeDocument Document Number
KEY ChangeDocDatabaseTableField _Item ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType _Item ChangeDocItemChangeType
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
ValidityEndDate
ValidityStartDate
ChangeDocObjectClass _Item ChangeDocObjectClass Change Doc. Object
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
ChangeDocLanguage ChangeDocLanguage
DatabaseTable _Item DatabaseTable Table Name
ChangeDocTableKey _Item ChangeDocTableKey
ChangeDocPreviousUnit _Item ChangeDocPreviousUnit
ChangeDocNewUnit _Item ChangeDocNewUnit
ChangeDocPreviousCurrency _Item ChangeDocPreviousCurrency
ChangeDocNewCurrency _Item ChangeDocNewCurrency
ChangeDocNewFieldValue
ChangeDocPreviousFieldValue
_ChangeDocLongTableKey _Item _ChangeDocLongTableKey
_ChangeDocument _Item _ChangeDocument
_ChangeDocumentItemExtension _Item _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_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.

CREATE VIEW P_CostCenterChangeLog AS
SELECT
  ControllingArea AS ChangeDocumentControllingArea,
  CostCenter AS ChangeDocumentCostCenter,
  cast( substring( _Item.ChangeDocTableKey, 18, 8 ) as datbi ) AS ChangeDocumentValidityEndDate,
  cast( substring( _Item.ChangeDocTableKey, 26, 8) as datab ) AS ChangeDocValidityStartDate,
  _Item.ChangeDocObject AS ChangeDocObject,
  _Item.ChangeDocument AS ChangeDocument,
  _Item.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  _Item.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  ControllingArea,
  CostCenter,
  cast( substring( _Item.ChangeDocTableKey, 18, 8 ) as datbi ) AS ValidityEndDate,
  cast( substring( _Item.ChangeDocTableKey, 26, 8) as datab ) AS ValidityStartDate,
  _Item.ChangeDocObjectClass AS ChangeDocObjectClass,
  CreatedByUser,
  CreationDate,
  CreationTime,
  ChangeDocLanguage,
  _Item.DatabaseTable AS DatabaseTable,
  _Item.ChangeDocTableKey AS ChangeDocTableKey,
  _Item.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  _Item.ChangeDocNewUnit AS ChangeDocNewUnit,
  _Item.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  _Item.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  cast( _Item.ChangeDocNewFieldValue as changedocnewfieldvalue ) AS ChangeDocNewFieldValue,
  cast( _Item.ChangeDocPreviousFieldValue as changedocpreviousfieldvalue ) AS ChangeDocPreviousFieldValue,
  _Item._ChangeDocLongTableKey AS _ChangeDocLongTableKey,
  _Item._ChangeDocument AS _ChangeDocument,
  _Item._ChangeDocumentItemExtension AS _ChangeDocumentItemExtension
FROM P_CostCenterChangeLogHeader AS _Header
LEFT OUTER JOIN P_CostCenterChangeLogItem AS _Item ON _Item.ChangeDocObject = _Header.ChangeDocObject AND _Item.ChangeDocObjectClass = _Header.ChangeDocObjectClass AND _Item.ChangeDocument = _Header.ChangeDocument AND _Item.ControllingArea = _Header.ControllingArea AND _Item.CostCenter = _Header.CostCenter  -- association [1..*]
;

Learn More