I_WorkPackageWithFunctionValue

DDL: I_WORKPACKAGEWITHFUNCTIONVALUE Type: view COMPOSITE

Work package with blocking function value

I_WorkPackageWithFunctionValue is a Composite CDS View that provides data about "Work package with blocking function value" in SAP S/4HANA. It reads from 1 data source (P_WorkPackageWithFunctionValue) and exposes 9 fields with key fields EngagementProject, WorkPackage, WorkPackageFunctionID. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_WorkPackageWithFunctionValue WorkPackageFuncValue from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[1..1] I_EngmntProjWithUserInvlmnt _MyProjects $projection.EngagementProjectUUID = _MyProjects.ProjectUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IWPWTHFUNCVAL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Work package with blocking function value view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject P_WorkPackageWithFunctionValue EngagementProject
KEY WorkPackage P_WorkPackageWithFunctionValue WorkPackage
KEY WorkPackageFunctionID P_WorkPackageWithFunctionValue WorkPackageFunctionId
WBSElementInternalID P_WorkPackageWithFunctionValue WBSElementInternalID
WorkPackageFunctionName P_WorkPackageWithFunctionValue WorkPackageFunctionName
WorkPackageFunctionIsBlocked P_WorkPackageWithFunctionValue WorkPackageFunctionIsBlocked
EngagementProjectUUID _EngagementProject EngagementProjectUUID
_EngagementProject _EngagementProject
_MyProjects _MyProjects 
@AbapCatalog: {
  sqlViewName: 'IWPWTHFUNCVAL',
  preserveKey: true,
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Work package with blocking function value'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM: {
//  private: false,

  lifecycle.contract.type: #NONE,
  viewType: #COMPOSITE
}
define view I_WorkPackageWithFunctionValue
  as select from P_WorkPackageWithFunctionValue as WorkPackageFuncValue
  association [1..1] to I_EngagementProject         as _EngagementProject on $projection.EngagementProject = _EngagementProject.EngagementProject
  association [1..1] to I_EngmntProjWithUserInvlmnt as _MyProjects        on $projection.EngagementProjectUUID = _MyProjects.ProjectUUID
{
  key  WorkPackageFuncValue.EngagementProject            as EngagementProject,
  key  WorkPackageFuncValue.WorkPackage                  as WorkPackage,
  key  WorkPackageFuncValue.WorkPackageFunctionId        as WorkPackageFunctionID,
       WorkPackageFuncValue.WBSElementInternalID         as WBSElementInternalID,
       WorkPackageFuncValue.WorkPackageFunctionName      as WorkPackageFunctionName,
       
       @Semantics.booleanIndicator: true
       WorkPackageFuncValue.WorkPackageFunctionIsBlocked as WorkPackageFunctionIsBlocked,
       _EngagementProject.EngagementProjectUUID          as EngagementProjectUUID,
       _EngagementProject,
       _MyProjects
}

Learn More