C_WorkpackageMember

DDL: C_WORKPACKAGEMEMBER SQL: CWPMEMBER Type: view CONSUMPTION Package: CPD_CDS

Members of Workpackage

C_WorkpackageMember is a Consumption CDS View that provides data about "Members of Workpackage" in SAP S/4HANA. It has 1 association to related views. Part of development package CPD_CDS.

13 fields

Associations (1)

CardinalityTargetAliasCondition
[1] I_WorkforcePersonDet _WorkforcePerson $projection.person = _WorkforcePerson.Person

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CWPMEMBER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Members of Workpackage view
AccessControl.personalData.blocking #REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
EngagementProject PlanData EngagementProject
EngagementProjectResource PlanData EngagementProjectResource
EmploymentInternalID PlanData EmploymentInternalID
EngmtProjEmployeeIsStaffed _EngmntProjectSupplyData EngmtProjEmployeeIsStaffed
WorkPackage PlanData WorkPackage
EngagementProjectServiceOrg PlanData EngagementProjectServiceOrg
_EngagementProjectResource PlanData _EngagementProjectResource
_WorkPackage PlanData _WorkPackage
_EngagementProject PlanData _EngagementProject
Person
EngagementProjectResourceType PlanData EngagementProjectResourceType
_PersonWorkAgreement_1 PlanData _PersonWorkAgreement_1
_PersonWorkAgreementDet PlanData _PersonWorkAgreementDet 
@AbapCatalog.sqlViewName: 'CWPMEMBER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Members of Workpackage'
@AccessControl.personalData.blocking: #REQUIRED
define view C_WorkpackageMember
  as select distinct from  I_EngmntProjectPlnDataVersion as PlanData
    left outer to one join I_EngmntProjectSupplyData     as _EngmntProjectSupplyData on  PlanData.WorkPackage               = _EngmntProjectSupplyData.WorkPackage
                                                                                     and PlanData.EngagementProjectResource = _EngmntProjectSupplyData.EngagementProjectResource
  association [1] to I_WorkforcePersonDet as _WorkforcePerson on $projection.person = _WorkforcePerson.Person
{
  // PlanData.EngagementProjectUUID,

  PlanData.EngagementProject,
  //PlanData.WorkPackageStartDate,

  //PlanData.WorkPackageEndDate,

  PlanData.EngagementProjectResource,
  //--[ GENERATED:012:GlBfhyJl7jY4oBIOE}WCZW

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

  PlanData.EmploymentInternalID,
  // PlanData.EngmtProjEmployeeIsStaffed,

  _EngmntProjectSupplyData.EngmtProjEmployeeIsStaffed,
  PlanData.WorkPackage,
  PlanData.EngagementProjectServiceOrg,
  PlanData._EngagementProjectResource,
  PlanData._WorkPackage,
  PlanData._EngagementProject,
  @Consumption.hidden: true
  PlanData._PersonWorkAgreement_1.Person,
  @Consumption.hidden: true
  PlanData.EngagementProjectResourceType,


//  @VDM.lifecycle: {

//    successor:'PlanData._PersonWorkAgreement_1',

//    status: #DEPRECATED

//  }

//  PlanData._Employment,

  PlanData._PersonWorkAgreement_1,

  PlanData._PersonWorkAgreementDet

}
where
  PlanData.EngagementProjectResourceType = '0ACT'

Learn More