I_WorkPackageWorkItem

@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 = ''