P_CHANGEDOCUMENTITEMLATEST
Latest change document items
P_CHANGEDOCUMENTITEMLATEST is a CDS View in S/4HANA. Latest change document items. It contains 7 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ChangeDocumentItems | view | from | COMPOSITE | Change document items |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChangeDocDatabaseTableField | ChangeDocDatabaseTableField | 1 |
| KEY | ChangeDocItemChangeType | ChangeDocItemChangeType | 1 |
| KEY | ChangeDocObject | ChangeDocObject | 1 |
| KEY | ChangeDocObjectClass | ChangeDocObjectClass | 1 |
| KEY | ChangeDocTableKey | ChangeDocTableKey | 1 |
| KEY | DatabaseTable | DatabaseTable | 1 |
| ChangeDocument | ChangeDocument | 1 |
@AbapCatalog.sqlViewName: 'PDDCHGDOCITMLT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Latest change document items'
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
define view P_ChangeDocumentItemLatest
as select from I_ChangeDocumentItem as _chngdoclatest
{
key _chngdoclatest.ChangeDocObject,
key _chngdoclatest.ChangeDocObjectClass,
key _chngdoclatest.DatabaseTable,
key _chngdoclatest.ChangeDocTableKey,
key _chngdoclatest.ChangeDocDatabaseTableField,
key _chngdoclatest.ChangeDocItemChangeType,
max(_chngdoclatest.ChangeDocument) as ChangeDocument
}
group by
ChangeDocObject,
ChangeDocObjectClass,
DatabaseTable,
ChangeDocTableKey,
ChangeDocDatabaseTableField,
ChangeDocItemChangeType