P_WORKPACKAGEWORKITEM

CDS View

P_WORKPACKAGEWORKITEM is a CDS View in S/4HANA. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkPackageWorkItem view from BASIC Work Item of Work Package
I_WorkPackageWorkItemAll view from BASIC All Work Package Work Item

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkItem WorkItem 2
KEY WorkPackage WorkPackage 2
EngagementProject EngagementProject 2
WBSElementObject WBSElementObject 2
WorkItemIsInactive WorkItemIsInactive 2
WorkItemName WorkItemName 2 
@AbapCatalog.sqlViewName: 'PWRKPCKGWITM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_WorkPackageWorkItem
  as select from /cpd/d_work_item as WorkItem

    inner join   /cpd/d_pfp_ps    as WorkPackage on WorkItem.wp_id = WorkPackage.plan_item_id

  association [0..*] to I_WorkItemText as _WorkItemText on $projection.WorkItem = _WorkItemText.WorkItem



{
  WorkItem.db_key                                                                as  WorkItemUUID,
  WorkItem.mp_id                                                                 as  EngagementProject,
  WorkItem.wp_id                                                                 as  WorkPackage,
  WorkPackage.mapped_item_id                                                     as  WBSElementObject,
  WorkItem.root_key                                                              as  EngagementProjFinPlanUUID,
  WorkItem.parent_key                                                            as  WorkPackageUUID,
  WorkItem.work_item_id                                                          as  WorkItem,

  case
  when WorkItem.work_item_is_standard = 'X'
  then
    _WorkItemText[1:Language=$session.system_language].WorkItemName
  else
  WorkItem.work_item_name end                                                    as  WorkItemName,

  WorkItem.work_item_is_inactive                                                 as  WorkItemIsInactive,
  WorkItem.work_item_is_standard                                                 as  WorkItemIsStandard,
  WorkItem.created_by,
  cast(WorkItem.created_on as /cpd/cpm_createdon)                                as  created_on,
  WorkItem.changed_by,
  cast(WorkItem.changed_on as /cpd/cpm_changedon)                                as  changed_on,
  WorkPackage.is_deleted,
  _WorkItemText
}

Learn More