P_WORKPACKAGEWITHFUNCTIONVALUE

CDS View

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

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkPackageWithFunctionValue view from COMPOSITE Work package with blocking function value

Fields (6)

KeyField CDS FieldsUsed in Views
KEY EngagementProject EngagementProject 1
KEY WorkPackage WorkPackage 1
KEY WorkPackageFunctionId WorkPackageFunctionID 1
WBSElementInternalID WBSElementInternalID 1
WorkPackageFunctionIsBlocked WorkPackageFunctionIsBlocked 1
WorkPackageFunctionName WorkPackageFunctionName 1 
@AbapCatalog.sqlViewName:'PWPWTHFUNCVAL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_WorkPackageWithFunctionValue as select from I_WorkPackageWithFunction as WorkPackageFunction
  left outer join I_EntProjElmntBlockFunc as WorkPackageFunctionValues
  on WorkPackageFunction.WBSElementInternalID = WorkPackageFunctionValues.WBSElementInternalID and
     WorkPackageFunction.WorkPackageFunctionID = WorkPackageFunctionValues.EntProjElementFunctionID
  
{   
    key WorkPackageFunction.EngagementProject as EngagementProject,
    key WorkPackageFunction.WBSElementInternalID as WBSElementInternalID,  
    key WorkPackageFunction.WBSElementExternalID as WorkPackage,
    key WorkPackageFunction.WorkPackageFunctionID as WorkPackageFunctionId,
        WorkPackageFunction.WorkPackageFunctionName as WorkPackageFunctionName,
      case
       when WorkPackageFunctionValues.EntProjElementFunctionIsBlkd is not initial or 
       WorkPackageFunctionValues.EntProjElementFunctionIsBlkd <> ' '
      then
      WorkPackageFunctionValues.EntProjElementFunctionIsBlkd

      else
      cast( ' ' as /cpd/wrk_pckg_function_is_blkd ) end as WorkPackageFunctionIsBlocked
}

Learn More