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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/