R_WorkAssignmentDetailTP_3

DDL: R_WORKASSIGNMENTDETAILTP_3 Type: view_entity TRANSACTIONAL Package: WFD_INT_RAP_ODATA

Work Assignment Details

R_WorkAssignmentDetailTP_3 is a Transactional CDS View that provides data about "Work Assignment Details" in SAP S/4HANA. It reads from 1 data source (R_WorkAssignmentDetail_1) and exposes 21 fields with key fields WorkforcePersonExternalID, WorkAssignmentExternalID, Country2DigitISOCode, WorkAssignmentStartDate. It has 1 association to related views. Part of development package WFD_INT_RAP_ODATA.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkAssignmentDetail_1 R_WorkAssignmentDetail_1 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_WorkforcePersonTP_3 _WorkforcePerson _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID

Annotations (7)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID WorkforcePersonExternalID
KEY WorkAssignmentExternalID WorkAssignmentExternalID
KEY Country2DigitISOCode Country2DigitISOCode
KEY WorkAssignmentStartDate WorkAssignmentStartDate
WorkAssignment WorkAssignment
WorkAssignmentEndDate WorkAssignmentEndDate
BusinessPartner BusinessPartner
WorkAssignmentStatus WorkAssignmentStatus
EmploymentPercent EmploymentPercent
CompanyCode CompanyCode
CostCenter CostCenter
ControllingArea ControllingArea
WeeklyWorkingHours WeeklyWorkingHours
WeeklyWorkingDays WeeklyWorkingDays
WorkAssignmentJobTitle WorkAssignmentJobTitle
WorkAssignmentJobCode WorkAssignmentJobCode
SupervisorWorkAssignmentExtID SupervisorWorkAssignmentExtID
WorkforceAssignmentIsPrimary WorkforceAssignmentIsPrimary
IsBlocked IsBlocked
_WorkAssignment _WorkAssignment
_WorkforcePerson _WorkforcePerson 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Assignment Details'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity R_WorkAssignmentDetailTP_3
  as select from R_WorkAssignmentDetail_1
  association        to parent R_WorkAssignmentTP_3 as _WorkAssignment  on  $projection.WorkAssignmentExternalID  = _WorkAssignment.WorkAssignmentExternalID
                                                                        and $projection.Country2DigitISOCode      = _WorkAssignment.Country2DigitISOCode
                                                                        and $projection.WorkforcePersonExternalID = _WorkAssignment.WorkforcePersonExternalID
  association [1..1] to R_WorkforcePersonTP_3         as _WorkforcePerson on  _WorkforcePerson.WorkforcePersonExternalID = $projection.WorkforcePersonExternalID
{
  key       WorkforcePersonExternalID,
  key       WorkAssignmentExternalID,
  key       Country2DigitISOCode,
  key       WorkAssignmentStartDate,
            WorkAssignment,
            WorkAssignmentEndDate,
            BusinessPartner,
            WorkAssignmentStatus,
            EmploymentPercent,
            CompanyCode,
            CostCenter,
            ControllingArea,
            WeeklyWorkingHours,
            WeeklyWorkingDays,
            WorkAssignmentJobTitle,
            WorkAssignmentJobCode,
//            SupervisorWorkAssignmentID,

            SupervisorWorkAssignmentExtID,
            WorkforceAssignmentIsPrimary,
            IsBlocked,

            /* Associations */
            _WorkAssignment,
            _WorkforcePerson

}

Learn More