P_ChangeDocumentItems

DDL: P_CHANGEDOCUMENTITEMS Type: view_entity COMPOSITE Package: PPH_DD_VDM_STLM

Change document items

P_ChangeDocumentItems is a Composite CDS View that provides data about "Change document items" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocumentItem, P_ChangeDocumentItemLatest) and exposes 14 fields with key fields ChangeDocObject, ChangeDocObjectClass, DatabaseTable, ChangeDocTableKey, ChangeDocDatabaseTableField. Part of development package PPH_DD_VDM_STLM.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocumentItem _chngdoc inner
P_ChangeDocumentItemLatest _chngdoclatest from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change document items view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject P_ChangeDocumentItemLatest ChangeDocObject
KEY ChangeDocObjectClass P_ChangeDocumentItemLatest ChangeDocObjectClass
KEY DatabaseTable P_ChangeDocumentItemLatest DatabaseTable
KEY ChangeDocTableKey P_ChangeDocumentItemLatest ChangeDocTableKey
KEY ChangeDocDatabaseTableField P_ChangeDocumentItemLatest ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType P_ChangeDocumentItemLatest ChangeDocItemChangeType
ChangeDocument P_ChangeDocumentItemLatest ChangeDocument
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue
CreationDate 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change document items'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity P_ChangeDocumentItems
  as select from P_ChangeDocumentItemLatest as _chngdoclatest
    inner join   I_ChangeDocumentItem       as _chngdoc on  _chngdoclatest.ChangeDocObject             = _chngdoc.ChangeDocObject
                                                        and _chngdoclatest.ChangeDocObjectClass        = _chngdoc.ChangeDocObjectClass
                                                        and _chngdoclatest.ChangeDocument              = _chngdoc.ChangeDocument
                                                        and _chngdoclatest.DatabaseTable               = _chngdoc.DatabaseTable
                                                        and _chngdoclatest.ChangeDocTableKey           = _chngdoc.ChangeDocTableKey
                                                        and _chngdoclatest.ChangeDocDatabaseTableField = _chngdoc.ChangeDocDatabaseTableField
                                                        and _chngdoclatest.ChangeDocItemChangeType     = _chngdoc.ChangeDocItemChangeType
{
  key _chngdoclatest.ChangeDocObject,
  key _chngdoclatest.ChangeDocObjectClass,
  key _chngdoclatest.DatabaseTable,
  key _chngdoclatest.ChangeDocTableKey,
  key _chngdoclatest.ChangeDocDatabaseTableField,
  key _chngdoclatest.ChangeDocItemChangeType,

      _chngdoclatest.ChangeDocument,

      _chngdoc.ChangeDocPreviousUnit,
      _chngdoc.ChangeDocNewUnit,
      _chngdoc.ChangeDocPreviousCurrency,
      _chngdoc.ChangeDocNewCurrency,
      _chngdoc.ChangeDocNewFieldValue,
      _chngdoc.ChangeDocPreviousFieldValue,
      _chngdoc._ChangeDocument.CreationDate

}

Learn More