R_WorkAssignmentTP_1

DDL: R_WORKASSIGNMENTTP_1 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP

Work Assignments

R_WorkAssignmentTP_1 is a Transactional CDS View that provides data about "Work Assignments" in SAP S/4HANA. It reads from 1 data source (R_WorkAssignment_1) and exposes 15 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode. It has 5 associations to related views. Part of development package WFD_INT_RAP.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignment_1 Workassignment from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_WorkAssignmentDetailTP_1 _JobDetails
[0..*] R_WrkAssgmtPaymentTP_1 _PaymentDetails
[0..*] R_WrkAssgmtSrvcCostLvlTP_1 _ServiceCostLevel
[0..*] R_WrkAssgmtWrkOrdDetTP _WorkOrderDetails
[0..*] R_WorkAssignmentAddressTP _AddressDetails

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Assignments view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID R_WorkAssignment_1 WorkforcePersonExternalID
KEY WorkAssignmentExternalID R_WorkAssignment_1 WorkAssignmentExternalID
KEY Country2DigitISOCode R_WorkAssignment_1 Country2DigitISOCode
WorkAssignment R_WorkAssignment_1 WorkAssignment
WorkAssignmentStartDate R_WorkAssignment_1 WorkAssignmentStartDate
WorkAssignmentEndDate R_WorkAssignment_1 WorkAssignmentEndDate
BusinessPartner R_WorkAssignment_1 BusinessPartner
IsContingentWorker R_WorkAssignment_1 IsContingentWorker
IsBlocked R_WorkAssignment_1 IsBlocked
_WorkforcePerson _WorkforcePerson
_JobDetails _JobDetails
_ServiceCostLevel _ServiceCostLevel
_WorkOrderDetails _WorkOrderDetails
_PaymentDetails _PaymentDetails
_AddressDetails _AddressDetails 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Assignments'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity R_WorkAssignmentTP_1
  as select from R_WorkAssignment_1 as Workassignment

  composition [1..*] of R_WorkAssignmentDetailTP_1 as _JobDetails

  composition [0..*] of R_WrkAssgmtPaymentTP_1     as _PaymentDetails

  composition [0..*] of R_WrkAssgmtSrvcCostLvlTP_1 as _ServiceCostLevel

  //  composition [0..*] of R_WorkAssignmentAltCostTP     as _AltCostAssgmt " Not in Scope for 2308


  composition [0..*] of R_WrkAssgmtWrkOrdDetTP     as _WorkOrderDetails

  composition [0..*] of R_WorkAssignmentAddressTP  as _AddressDetails

  association to parent I_WorkforcePersonTP        as _WorkforcePerson on _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID


{
  key  Workassignment.WorkforcePersonExternalID,
  key  Workassignment.WorkAssignmentExternalID,
  key  Workassignment.Country2DigitISOCode,
       Workassignment.WorkAssignment,
       Workassignment.WorkAssignmentStartDate,
       Workassignment.WorkAssignmentEndDate,
       Workassignment.BusinessPartner,
       Workassignment.IsContingentWorker,
       Workassignment.IsBlocked,

       /* Associations */
       _WorkforcePerson,
       _JobDetails,
       _ServiceCostLevel,
       _WorkOrderDetails,
       _PaymentDetails,
       _AddressDetails

}

Learn More