R_WorkforcePersonFactSheet

//@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Worker Data'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]

define root view entity R_WorkforcePersonFactSheet
  as select from           R_WorkforcePerson
    left outer to one join I_WorkerStatus as WorkerStatus on R_WorkforcePerson.PersonUUID = WorkerStatus.BusinessPartnerUUID
  //    left outer to one join I_WorkerStatus as WorkerStatus on R_WorkforcePerson.Person = WorkerStatus.BusinessPartner

  //   left outer to one join I_InactiveWorker as _InactiveWorker on R_WorkforcePerson.Person = _InactiveWorker.BusinessPartner

  //   left outer to one join I_BlockedWorker  as _BlockedWorker  on R_WorkforcePerson.Person = _BlockedWorker.BusinessPartner

  //composition of target_data_source_name as _association_name

  composition [0..*] of R_WorkforcePersonTag         as _WorkforcePersonTag
  composition [0..*] of R_WorkAssignment             as _WorkAssignment
  composition [1..*] of R_WorkforcePersonType        as _BPUsrRole
  composition [0..*] of R_WorkforcePersonPrvtAddress as _WorkforcePersonAddress
  composition [0..1] of R_WorkforcePersonSummary     as _WorkforcePersonSummary
//  composition [0..1] of R_WorkAssignmentSummary      as _WorkAssignmentSummary

  composition [0..*] of R_WorkAssignmentListSummary  as _WorkAssignmentListSummary
  //  association [0..1] to I_WorkerImageURL      as _EmployeeImageURL on  $projection.Person           = _EmployeeImageURL.Person

  association [0..1] to R_WorkerImageURL             as _EmployeeImageURL on  $projection.Person           = _EmployeeImageURL.Person
                                                                          and $projection.PersonExternalID = _EmployeeImageURL.WorkforcePersonExternalID
  association [0..1] to E_BP_D                       as _BPExtension      on  $projection.Person = _BPExtension.BusinessPartner
  //  association [0..1] to I_WorkforcePersonImageURL as _WorkforcePersonImageURL on $projection.Person = _WorkforcePersonImageURL.Person

{
  key R_WorkforcePerson.PersonUUID,
      R_WorkforcePerson.PersonExternalID,
      R_WorkforcePerson.Person,
      R_WorkforcePerson.FirstName,
      R_WorkforcePerson.LastName,
      R_WorkforcePerson.PersonFullName,
      R_WorkforcePerson.AuthorizationGroup,
      R_WorkforcePerson.CorrespondenceLanguage,
      R_WorkforcePerson.FormOfAddress,
      @Semantics.booleanIndicator
      R_WorkforcePerson.IsBusinessPurposeCompleted,
      R_WorkforcePerson.LastChangeDateTime,
      R_WorkforcePerson.EmailAddress,
      R_WorkforcePerson.MobilePhoneNumber,
      R_WorkforcePerson.MblPhoneDestinationLocCountry,
      R_WorkforcePerson.PhoneNumber,
      R_WorkforcePerson.PhoneNumberExtension,
      R_WorkforcePerson.DestinationLocationCountry,
      R_WorkforcePerson._WorkplaceAddress.MblNormalizedPhoneNumber,
      R_WorkforcePerson._WorkplaceAddress.NormalizedPhoneNumber,
      R_WorkforcePerson.UserID,
      R_WorkforcePerson.AcademicTitle,
      R_WorkforcePerson.AcademicTitle2,
      R_WorkforcePerson.LastNamePrefix,
      R_WorkforcePerson.LastNameSecondPrefix,
      R_WorkforcePerson.BusinessPartnerSupplementName,
      R_WorkforcePerson.AdditionalLastName,
      R_WorkforcePerson.BusinessPartnerBirthName,
      R_WorkforcePerson.BusinessPartnerNicknameLabel,
      R_WorkforcePerson.MiddleName,
      R_WorkforcePerson.Initials,
      // R_WorkforcePerson.BusinessPartnerRole,

      _EmployeeImageURL.WorkforcePersonImageURL as WorkforcePersonImageURL,
      @Semantics.booleanIndicator
      //    _BlockedWorker.IsBlocked                  as IsBlocked,

      WorkerStatus.IsBlocked                    as IsBlocked,
      @Semantics.booleanIndicator
      //    _InactiveWorker.WorkerIsInactive          as WorkerIsInactive,

      WorkerStatus.WorkerIsInactive             as WorkerIsInactive,
      R_WorkforcePerson.WorkforcePersonEntrySource,
      R_WorkforcePerson.DataControllerSet       as DataControllerSet,
      R_WorkforcePerson.DataController1         as DataController1,
      R_WorkforcePerson.DataController2         as DataController2,
      R_WorkforcePerson.DataController3         as DataController3,
      R_WorkforcePerson.DataController4         as DataController4,
      R_WorkforcePerson.DataController5         as DataController5,
      R_WorkforcePerson.DataController6         as DataController6,
      R_WorkforcePerson.DataController7         as DataController7,
      R_WorkforcePerson.DataController8         as DataController8,
      R_WorkforcePerson.DataController9         as DataController9,
      R_WorkforcePerson.DataController10        as DataController10,

      // _BPUsrRole._BPUsrRoleText.BusinessPartnerRoleShortName,

      //      _EmployeeImageURL.WorkforcePersonImageURL as WorkforcePersonImageURL,

      _EmployeeImageURL,
      _WorkforcePersonTag,
      _WorkAssignment,
      _BPUsrRole,
      _WorkforcePersonAddress,
      _WorkforcePersonSummary,
//      _WorkAssignmentSummary,

      _WorkAssignmentListSummary,
      R_WorkforcePerson._EntrySourceText
      //  R_WorkforcePerson._CorrespondenceLanguage,

      // R_WorkforcePerson._FormOfAddressText,

      //      R_WorkforcePerson._BusPartPrefixLastName,

      //      R_WorkforcePerson._BusPartPrefixLastNameSecond,

      //      R_WorkforcePerson._NameSupplementText,

      //   R_WorkforcePerson._AcademicTitle1,

      // R_WorkforcePerson._AcademicTitle2,

      //  R_WorkforcePerson._BPUsrRoleLatest,

      //  R_WorkforcePerson._WorkplaceAddress

}