P_ActyTypeChangeLog

DDL: P_ACTYTYPECHANGELOG Type: view_entity COMPOSITE Package: ODATA_ACTIVITY_TYPE_CHNGLOG
22 Fields 1 Data Sources 1 Associations

Activity Type Change Log

P_ActyTypeChangeLog is a Composite CDS View that provides data about "Activity Type Change Log" in SAP S/4HANA. It reads from 1 data source (P_ActyTypeChangeLogHeader) and exposes 22 fields with key fields ChangeDocumentControllingArea, ChangeDocumentActivityType, ChangeDocumentValidityEndDate, ChangeDocValidityStartDate, ChangeDocObject. It has 1 association to related views. Part of development package ODATA_ACTIVITY_TYPE_CHNGLOG.

Data Sources (1)

SourceAliasJoin Type
P_ActyTypeChangeLogHeader _Header from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_ActyTypeChangeLogItem _Item _Item.ChangeDocObject = _Header.ChangeDocObject and _Item.ChangeDocObjectClass = _Header.ChangeDocObjectClass and _Item.ChangeDocument = _Header.ChangeDocument and _Item.ControllingArea = _Header.ControllingArea and _Item.ActivityType = _Header.ActivityType

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 (22)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocumentControllingArea ControllingArea Controlling Area
KEY ChangeDocumentActivityType ActivityType Activity Type
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
ActivityType ActivityType Activity Type
ChangeDocObjectClass _Item ChangeDocObjectClass Change Doc. Object
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_ActyTypeChangeLog.
-- 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_ActyTypeChangeLog AS
SELECT
  ControllingArea AS ChangeDocumentControllingArea,
  ActivityType AS ChangeDocumentActivityType,
  cast( substring( _Item.ChangeDocTableKey, 14, 8 ) as datbi ) AS ChangeDocumentValidityEndDate,
  cast( substring( _Item.ChangeDocTableKey, 22, 8 ) as datab ) AS ChangeDocValidityStartDate,
  _Item.ChangeDocObject AS ChangeDocObject,
  _Item.ChangeDocument AS ChangeDocument,
  _Item.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  _Item.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  ControllingArea,
  ActivityType,
  _Item.ChangeDocObjectClass AS ChangeDocObjectClass,
  _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_ActyTypeChangeLogHeader AS _Header
LEFT OUTER JOIN P_ActyTypeChangeLogItem AS _Item ON _Item.ChangeDocObject = _Header.ChangeDocObject AND _Item.ChangeDocObjectClass = _Header.ChangeDocObjectClass AND _Item.ChangeDocument = _Header.ChangeDocument AND _Item.ControllingArea = _Header.ControllingArea AND _Item.ActivityType = _Header.ActivityType  -- association [1..*]
;

Learn More