I_WORKPACKAGEWORKITEM

CDS View

Work Item of Work Package

I_WORKPACKAGEWORKITEM is a CDS View in S/4HANA. Work Item of Work Package. It contains 9 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 9 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_WorkpackageWorkItem view from CONSUMPTION Workpackage workitem
C_WorkPackageWorkItemVH view from CONSUMPTION Work Package Work Item Value Help
I_EngmntProjWrkPckgWrkItm view from COMPOSITE Work Item of Work Package
I_WorkPackageWorkItemStdVH view from COMPOSITE Work Item of Work Package
P_WorkPackageWorkItemCount view from COMPOSITE Number of Work Items in each Work Package

Fields (9)

KeyField CDS FieldsUsed in Views
KEY WorkItem WorkItem 3
KEY WorkPackage WorkPackage 3
EngagementProject EngagementProject 1
EngagementProjFinPlanUUID EngagementProjFinPlanUUID 2
WBSElementObject WBSElementObject 1
WorkItemIsInactive WorkItemIsInactive 2
WorkItemName WorkItemName 2
WorkItemUUID WorkItemUUID 2
WorkPackageUUID WorkPackageUUID 2 
@AbapCatalog: {
  sqlViewName: 'IWRKPKGWRKITEM',
//  compiler.compareFilter: true,

  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction.enabled: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Work Item of Work Package'
@Metadata:{
  allowExtensions: true,
  ignorePropagatedAnnotations: true
}
@ObjectModel: {
  usageType: {
    serviceQuality: #B,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
  },
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE,
                           #EXTRACTION_DATA_SOURCE, #SQL_DATA_SOURCE ],
  representativeKey: 'WorkItem',
  sapObjectNodeType.name: 'CommercialProjectWorkPackage' 
}
@VDM: {
//  private: false,

//  lifecycle.contract.type: #PUBLIC_LOCAL_API,

  viewType: #BASIC
}

define view I_WorkPackageWorkItem
  as select from P_WorkPackageWorkItem as WorkPackageWorkItem
  association [0..1] to I_WorkPackage                 as _WorkPackage                 on  $projection.WorkPackage = _WorkPackage.WorkPackage
  association [0..1] to I_EngagementProjFinancialPlan as _EngagementProjFinancialPlan on  $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID
  association [0..*] to I_EngagementProjectPlanData   as _EngagementProjectPlanData   on  $projection.WorkPackage               = _EngagementProjectPlanData.WorkPackage
                                                                                      and $projection.EngagementProjFinPlanUUID = _EngagementProjectPlanData.EngagementProjFinPlanUUID
                                                                                      and $projection.WorkItem                  = _EngagementProjectPlanData.WorkItem
{


      @ObjectModel.text.element: 'WorkItemName'
  key WorkPackageWorkItem.WorkItem                                                                as WorkItem,
      //--[ GENERATED:012:GlBfhyJl7jY4odLnax6PDW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_WorkPackageStdVH',
                     element: 'WorkPackage' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association:'_WorkPackage'
  key WorkPackageWorkItem.WorkPackage                                                             as WorkPackage,
      WorkPackageWorkItem.EngagementProject                                                       as EngagementProject,
      WorkPackageWorkItem.WBSElementObject                                                        as WBSElementObject,
      cast(WorkPackageWorkItem.WorkPackageUUID as /cpd/wp_db_key preserving type )                as WorkPackageUUID,
      cast(WorkPackageWorkItem.WorkItemUUID    as /cpd/wi_db_key preserving type )                as WorkItemUUID,
      cast(WorkPackageWorkItem.EngagementProjFinPlanUUID as /cpd/eng_pfp_db_key preserving type ) as EngagementProjFinPlanUUID,
      @Semantics.text: true
      WorkPackageWorkItem.WorkItemName                                                            as WorkItemName,
      @Semantics.booleanIndicator:true
      WorkPackageWorkItem.WorkItemIsInactive                                                      as WorkItemIsInactive,
//      @Consumption.hidden: true

//      WorkPackageWorkItem.is_deleted                                                              as IsDeleted,

      _WorkPackage,
      _EngagementProjFinancialPlan,
      _EngagementProjectPlanData

}

where
  WorkPackageWorkItem.is_deleted = ''

Learn More