I_ENTPROJTEAMCHGDOCITEM
Chg Doc items for Team tab of Ent Proj
I_ENTPROJTEAMCHGDOCITEM is a CDS View in S/4HANA. Chg Doc items for Team tab of Ent Proj. It contains 4 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_EntProjTeamChgDocuments | view | inner | COMPOSITE | Chg Doc for Team tab of Ent Proj |
Fields (4)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChangeDocItemChangeType | ChangeDocItemChangeType | 1 |
| KEY | ChangeDocTableKey | ChangeDocTableKey | 1 |
| KEY | DatabaseTable | DatabaseTable | 1 |
| BusinessPartnerRoleName | BusinessPartnerRoleName | 1 |
@EndUserText.label: 'Chg Doc items for Team tab of Ent Proj'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@AbapCatalog: {
sqlViewName: 'IPROJTEAMCDITM',
compiler.compareFilter: true,
preserveKey: true
}
// Authorization handling
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
usageType: {
serviceQuality: #D,
dataClass: #TRANSACTIONAL,
sizeCategory: #XL
}
}
define view I_EntProjTeamChgDocItem
as select from I_ChangeDocumentItem as cd_en_j
// Get business partner data
inner join I_ChangeDocumentItem as cd_bp_j on cd_bp_j.ChangeDocObjectClass = cd_en_j.ChangeDocObjectClass
and cd_bp_j.ChangeDocObject = cd_en_j.ChangeDocObject
and cd_bp_j.DatabaseTable = '/S4PPM/TEAMMBR'
and cd_bp_j.ChangeDocDatabaseTableField = 'BUPA_GUID'
and cd_bp_j.ChangeDocTableKey = concat(
cd_en_j.mandt, cd_en_j.ChangeDocNewFieldValue
)
and cd_bp_j.ChangeDocItemChangeType = 'J'
// Get role data
inner join I_ChangeDocumentItem as cd_ent_role_j on cd_ent_role_j.ChangeDocObjectClass = cd_en_j.ChangeDocObjectClass
and cd_ent_role_j.ChangeDocObject = cd_en_j.ChangeDocObject
and cd_ent_role_j.DatabaseTable = '/S4PPM/ENTITLMNT'
and cd_ent_role_j.ChangeDocDatabaseTableField = 'ROLE_GUID'
and cd_ent_role_j.ChangeDocTableKey = cd_en_j.ChangeDocTableKey
and cd_ent_role_j.ChangeDocItemChangeType = 'J'
inner join I_ChangeDocumentItem as cd_role_j on cd_role_j.ChangeDocObjectClass = cd_ent_role_j.ChangeDocObjectClass
and cd_role_j.ChangeDocObject = cd_ent_role_j.ChangeDocObject
and cd_role_j.DatabaseTable = '/S4PPM/ROLE'
and cd_role_j.ChangeDocDatabaseTableField = 'ROLE_NAME'
and cd_role_j.ChangeDocTableKey = concat(
cd_ent_role_j.mandt, cd_ent_role_j.ChangeDocNewFieldValue
)
and cd_role_j.ChangeDocItemChangeType = 'J'
{
key cd_en_j.ChangeDocObject,
key cd_en_j.ChangeDocObjectClass,
key cd_en_j.ChangeDocument,
key cd_en_j.DatabaseTable,
key cd_en_j.ChangeDocTableKey,
key cd_en_j.ChangeDocDatabaseTableField,
key cd_en_j.ChangeDocItemChangeType,
cd_en_j.ChangeDocNewFieldValue,
cd_en_j.ChangeDocPreviousFieldValue,
cast (cd_bp_j.ChangeDocNewFieldValue as sysuuid_c) as BusinessPartnerUUID,
cast (cd_role_j.ChangeDocNewFieldValue as /s4ppm/tv_role_name) as BusinessPartnerRoleName
}
where
cd_en_j.ChangeDocObjectClass = '/S4PPM/PROJECT'
and cd_en_j.DatabaseTable = '/S4PPM/ENTITLMNT'
and cd_en_j.ChangeDocDatabaseTableField = 'TEAM_MEMBER_GUID'
and cd_en_j.ChangeDocItemChangeType = 'J'
// Union with selected deleted items
union all select from I_ChangeDocumentItem as cd_en_d
// Get business partner data
inner join I_ChangeDocumentItem as cd_en_j on cd_en_j.ChangeDocObjectClass = cd_en_d.ChangeDocObjectClass
and cd_en_j.ChangeDocObject = cd_en_d.ChangeDocObject
and cd_en_j.DatabaseTable = cd_en_d.DatabaseTable
and cd_en_j.ChangeDocTableKey = cd_en_d.ChangeDocTableKey
and cd_en_j.ChangeDocItemChangeType = 'J'
inner join I_ChangeDocumentItem as cd_bp_j on cd_bp_j.ChangeDocObjectClass = cd_en_j.ChangeDocObjectClass
and cd_bp_j.ChangeDocObject = cd_en_j.ChangeDocObject
and cd_bp_j.DatabaseTable = '/S4PPM/TEAMMBR'
and cd_bp_j.ChangeDocDatabaseTableField = 'BUPA_GUID'
and cd_bp_j.ChangeDocTableKey = concat(
cd_en_j.mandt, cd_en_j.ChangeDocNewFieldValue
)
and cd_bp_j.ChangeDocItemChangeType = 'J'
// Get role data
inner join I_ChangeDocumentItem as cd_ent_role_j on cd_ent_role_j.ChangeDocObjectClass = cd_en_j.ChangeDocObjectClass
and cd_ent_role_j.ChangeDocObject = cd_en_j.ChangeDocObject
and cd_ent_role_j.ChangeDocTableKey = cd_en_j.ChangeDocTableKey
and cd_ent_role_j.DatabaseTable = '/S4PPM/ENTITLMNT'
and cd_ent_role_j.ChangeDocDatabaseTableField = 'ROLE_GUID'
and cd_ent_role_j.ChangeDocItemChangeType = 'J'
inner join I_ChangeDocumentItem as cd_role_j on cd_role_j.ChangeDocObjectClass = cd_ent_role_j.ChangeDocObjectClass
and cd_role_j.ChangeDocObject = cd_ent_role_j.ChangeDocObject
and cd_role_j.DatabaseTable = '/S4PPM/ROLE'
and cd_role_j.ChangeDocDatabaseTableField = 'ROLE_NAME'
and cd_role_j.ChangeDocTableKey = concat(
cd_ent_role_j.mandt, cd_ent_role_j.ChangeDocNewFieldValue
)
and cd_role_j.ChangeDocItemChangeType = 'J'
{
key cd_en_j.ChangeDocObject,
key cd_en_j.ChangeDocObjectClass,
key cd_en_d.ChangeDocument,
key cd_en_j.DatabaseTable,
key cd_en_j.ChangeDocTableKey,
key cd_en_j.ChangeDocDatabaseTableField,
key cd_en_d.ChangeDocItemChangeType,
cd_en_j.ChangeDocPreviousFieldValue as ChangeDocNewFieldValue,
cd_en_j.ChangeDocNewFieldValue as ChangeDocPreviousFieldValue,
cast (cd_bp_j.ChangeDocNewFieldValue as sysuuid_c) as BusinessPartnerUUID,
cast (cd_role_j.ChangeDocNewFieldValue as /s4ppm/tv_role_name) as BusinessPartnerRoleName
}
where
cd_en_d.ChangeDocObjectClass = '/S4PPM/PROJECT'
and cd_en_d.DatabaseTable = '/S4PPM/ENTITLMNT'
and cd_en_d.ChangeDocDatabaseTableField = 'KEY'
and cd_en_d.ChangeDocItemChangeType = 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/