R_WorkAssignmentTP_3

DDL: R_WORKASSIGNMENTTP_3 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP_ODATA

Work Assignments

R_WorkAssignmentTP_3 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_ODATA.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignment_1 Workassignment from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_WorkAssignmentDetailTP_3 _WorkAssignmentDetail
[0..*] R_WrkAssgmtPaymentTP_3 _WorkAssignmentPayment
[0..*] R_WrkAssgmtSrvcCostLvlTP_3 _WrkAssgmtSrvcCostLvl
[0..*] R_WrkAssgmtWrkOrdDetTP_3 _WrkAssgmtWrkOrdDet
[0..*] R_WorkAssignmentAddressTP_3 _WorkAssignmentAddress

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
_WorkAssignmentDetail _WorkAssignmentDetail
_WrkAssgmtSrvcCostLvl _WrkAssgmtSrvcCostLvl
_WrkAssgmtWrkOrdDet _WrkAssgmtWrkOrdDet
_WorkAssignmentPayment _WorkAssignmentPayment
_WorkAssignmentAddress _WorkAssignmentAddress 
@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_3
  as select from R_WorkAssignment_1 as Workassignment

  composition [1..*] of R_WorkAssignmentDetailTP_3  as _WorkAssignmentDetail

  composition [0..*] of R_WrkAssgmtPaymentTP_3      as _WorkAssignmentPayment

  composition [0..*] of R_WrkAssgmtSrvcCostLvlTP_3  as _WrkAssgmtSrvcCostLvl

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


  composition [0..*] of R_WrkAssgmtWrkOrdDetTP_3    as _WrkAssgmtWrkOrdDet

  composition [0..*] of R_WorkAssignmentAddressTP_3 as _WorkAssignmentAddress

  association to parent R_WorkforcePersonTP_3       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,
       _WorkAssignmentDetail,
       _WrkAssgmtSrvcCostLvl,
       _WrkAssgmtWrkOrdDet,
       _WorkAssignmentPayment,
       _WorkAssignmentAddress

}

Learn More