I_ENTPROJELEMCHGDOCITEM

CDS View

Chg Doc Items for Project Elements

I_ENTPROJELEMCHGDOCITEM is a CDS View in S/4HANA. Chg Doc Items for Project Elements. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EntProjElemChgDocuments view inner COMPOSITE Chg Doc for Project Elements of Ent Proj

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 1
KEY ChangeDocItemChangeType ChangeDocItemChangeType 1
KEY ChangeDocTableKey ChangeDocTableKey 1
KEY ChangeDocument ChangeDocument 1
KEY DatabaseTable DatabaseTable 1
IsProjectMilestone IsProjectMilestone 1
ProjectElementUUID ProjectElementUUID 1 
@EndUserText.label: 'Chg Doc Items for Project Elements'
@VDM: {
   viewType: #COMPOSITE,
   lifecycle.contract.type: #SAP_INTERNAL_API
}

@AbapCatalog: {
   sqlViewName: 'IENTPRJELMCDI',
   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_EntProjElemChgDocItem
  // select all items

  as select from I_ChangeDocumentItem as cdpos_j

    inner join   I_PPM_Task           as Task on cdpos_j.ChangeDocTableKey = concat(
      Task.mandt, BinToHex(
        Task.TaskUUID
      )
    )
{
  key cdpos_j.ChangeDocObject,
  key cdpos_j.ChangeDocObjectClass,
  key cdpos_j.ChangeDocument,
  key cdpos_j.DatabaseTable,
  key cdpos_j.ChangeDocTableKey,
  key cdpos_j.ChangeDocDatabaseTableField,
  key cdpos_j.ChangeDocItemChangeType,
      cdpos_j.ChangeDocPreviousFieldValue,
      cdpos_j.ChangeDocNewFieldValue,
      Task.IsProjectMilestone,
      Task.TaskUUID                       as ProjectElementUUID,
      Task.ExternalId                     as ProjectElement,
      Task.TaskName                       as ProjectElementName

}

where
       cdpos_j.ChangeDocObjectClass    = '/S4PPM/PROJECT'
  and  cdpos_j.DatabaseTable           = '/S4PPM/PRJELM_CD'

  and(
       cdpos_j.ChangeDocItemChangeType = 'J'
    or cdpos_j.ChangeDocItemChangeType = 'U'
  )

// select blocked functions for project elements only

union all select from I_ChangeDocumentItem    as cdpos_j

  inner join          I_EntProjElmntBlockFunc as BlockFunc on cdpos_j.ChangeDocTableKey = concat(
    BlockFunc.mandt, BinToHex(
      BlockFunc.EntProjElementFunctionUUID
    )
  )

  inner join          I_PPM_Task              as Task      on BlockFunc.ParentObjectUUID = Task.TaskUUID


{
  key cdpos_j.ChangeDocObject,
  key cdpos_j.ChangeDocObjectClass,
  key cdpos_j.ChangeDocument,
  key cdpos_j.DatabaseTable,
  key cdpos_j.ChangeDocTableKey,
  key cdpos_j.ChangeDocDatabaseTableField,
  key cdpos_j.ChangeDocItemChangeType,
      cdpos_j.ChangeDocPreviousFieldValue,
      cdpos_j.ChangeDocNewFieldValue,
      Task.IsProjectMilestone,
      Task.TaskUUID                       as ProjectElementUUID,
      Task.ExternalId                     as ProjectElement,
      Task.TaskName                       as ProjectElementName

}

where
       cdpos_j.ChangeDocObjectClass    = '/S4PPM/PROJECT'
  and  cdpos_j.DatabaseTable           = '/S4PPM/BLKFCT_CD'
  and(
       cdpos_j.ChangeDocItemChangeType = 'J'
    or cdpos_j.ChangeDocItemChangeType = 'U'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENTITEM",
"I_ENTPROJELMNTBLOCKFUNC",
"I_PPM_TASK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More