I_WorkPackageWorkItemAll

DDL: I_WORKPACKAGEWORKITEMALL SQL: IWRKPKGWRKITMALL Type: view BASIC Package: CPD_CDS

All Work Package Work Item

I_WorkPackageWorkItemAll is a Basic CDS View (Dimension) that provides data about "All Work Package Work Item" in SAP S/4HANA. It reads from 1 data source (P_WorkPackageWorkItem) and exposes 12 fields with key fields WorkItem, WorkPackage. It has 3 associations to related views. Part of development package CPD_CDS.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
P_WorkPackageWorkItem WorkPackageWorkItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_WorkPackageAll _WorkPackage $projection.WorkPackage = _WorkPackage.WorkPackage
[0..1] I_EngagementProjFinancialPlan _EngagementProjFinancialPlan $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID
[0..*] I_EngmntProjectPlnDataVersion _EngagementProjectPlanData $projection.WorkPackage = _EngagementProjectPlanData.WorkPackage and $projection.EngagementProject = _EngagementProjectPlanData.EngagementProject and $projection.WorkItem = _EngagementProjectPlanData.WorkItem

Annotations (14)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label All Work Package Work Item view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.representativeKey WorkItem view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.sqlViewName IWRKPKGWRKITMALL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkItem P_WorkPackageWorkItem WorkItem
KEY WorkPackage P_WorkPackageWorkItem WorkPackage
EngagementProject P_WorkPackageWorkItem EngagementProject
WBSElementObject P_WorkPackageWorkItem WBSElementObject
WorkPackageUUID
WorkItemUUID
EngagementProjFinPlanUUID
WorkItemName P_WorkPackageWorkItem WorkItemName
WorkItemIsInactive P_WorkPackageWorkItem WorkItemIsInactive
_WorkPackage _WorkPackage
_EngagementProjFinancialPlan _EngagementProjFinancialPlan
_EngagementProjectPlanData _EngagementProjectPlanData 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'All Work Package Work Item'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'WorkItem'
@AccessControl.authorizationCheck:#CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'IWRKPKGWRKITMALL'
define view I_WorkPackageWorkItemAll
  as select from P_WorkPackageWorkItem as WorkPackageWorkItem
  association [0..1] to I_WorkPackageAll              as _WorkPackage                 on  $projection.WorkPackage = _WorkPackage.WorkPackage
  association [0..1] to I_EngagementProjFinancialPlan as _EngagementProjFinancialPlan on  $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID
  association [0..*] to I_EngmntProjectPlnDataVersion as _EngagementProjectPlanData   on  $projection.WorkPackage               = _EngagementProjectPlanData.WorkPackage
                                                                                      and $projection.EngagementProject         = _EngagementProjectPlanData.EngagementProject
                                                                                      and $projection.WorkItem                  = _EngagementProjectPlanData.WorkItem
{


      @ObjectModel.text.element: 'WorkItemName'
  key WorkPackageWorkItem.WorkItem                                                                as WorkItem,
      @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,
      WorkPackageWorkItem.WorkItemIsInactive                                                      as WorkItemIsInactive,
      _WorkPackage,
      _EngagementProjFinancialPlan,
      _EngagementProjectPlanData
}

Learn More