R_WorkforcePersonTP_2

DDL: R_WORKFORCEPERSONTP_2 Type: view_entity TRANSACTIONAL Package: ODATA_CA_BUM_WF

Workforce Person TP

R_WorkforcePersonTP_2 is a Transactional CDS View that provides data about "Workforce Person TP" in SAP S/4HANA. It reads from 1 data source (R_WorkforcePerson_2) and exposes 53 fields with key field BusinessPartner. It has 4 associations to related views. Part of development package ODATA_CA_BUM_WF.

1 data source(s) 53 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkforcePerson_2 R_WorkforcePerson_2 from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_BP_D _BPExtension $projection.BusinessPartner = _BPExtension.BusinessPartner
[0..*] R_WorkforceTagTP_2 _WorkforceTag
[0..*] R_WorkAssignmentTP_2 _WorkAssignment
[1..*] R_BPUsrRoleTP_2 _BPUsrRole

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name WorkforcePerson view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Workforce Person TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerUUID BusinessPartnerUUID
PersonExternalID PersonExternalID
FirstName FirstName
LastName LastName
MiddleName MiddleName
AdditionalLastName AdditionalLastName
PersonFullName PersonFullName
AuthorizationGroup AuthorizationGroup
FormOfAddress FormOfAddress
CorrespondenceLanguage CorrespondenceLanguage
LastNamePrefix LastNamePrefix
LastNameSecondPrefix LastNameSecondPrefix
BusinessPartnerBirthName BusinessPartnerBirthName
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel
AcademicTitle AcademicTitle
AcademicTitle2 AcademicTitle2
Initials Initials
BusinessPartnerSupplementName BusinessPartnerSupplementName
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
LastChangeDateTime LastChangeDateTime
EmailAddress EmailAddress
MobilePhoneNumber MobilePhoneNumber
MblPhoneDestinationLocCountry MblPhoneDestinationLocCountry
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
DestinationLocationCountry DestinationLocationCountry
UserID UserID
BPAddressChangeDocObject BPAddressChangeDocObject
WorkforcePersonEntrySource WorkforcePersonEntrySource
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
_BPUsrRole _BPUsrRole
_WorkforceTag _WorkforceTag
_WorkAssignment _WorkAssignment
_WorkplaceAddress _WorkplaceAddress
_FormOfAddressText _FormOfAddressText
_CorrespondenceLanguage _CorrespondenceLanguage
_AcademicTitle1 _AcademicTitle1
_AcademicTitle2 _AcademicTitle2
_DestinationLocationCountry _DestinationLocationCountry
_MblPhoneDestinationLocCountry _MblPhoneDestinationLocCountry
_EntrySourceText _EntrySourceText
_BusinessPartnerName _BusinessPartnerName 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.sapObjectNodeType.name : 'WorkforcePerson'
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@EndUserText.label: 'Workforce Person TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
//@Consumption.dbHints: ['USE_HEX_PLAN']

define root view entity R_WorkforcePersonTP_2
  as select from R_WorkforcePerson_2
  composition [0..*] of R_WorkforceTagTP_2   as _WorkforceTag
  composition [0..*] of R_WorkAssignmentTP_2 as _WorkAssignment
  composition [1..*] of R_BPUsrRoleTP_2      as _BPUsrRole
  association [0..1] to E_BP_D               as _BPExtension on $projection.BusinessPartner = _BPExtension.BusinessPartner
{
  key  BusinessPartner,
       BusinessPartnerUUID,
       PersonExternalID,
       FirstName,
       LastName,
       MiddleName,
       AdditionalLastName,
       PersonFullName,
       AuthorizationGroup,
       FormOfAddress,
       CorrespondenceLanguage,
       LastNamePrefix,
       LastNameSecondPrefix,
       BusinessPartnerBirthName,
       BusinessPartnerNicknameLabel,
       AcademicTitle,
       AcademicTitle2,
       Initials,
       BusinessPartnerSupplementName,
       @Semantics.booleanIndicator
       IsBusinessPurposeCompleted,
       LastChangeDateTime,
       EmailAddress,
       MobilePhoneNumber,
       MblPhoneDestinationLocCountry,
       PhoneNumber,
       PhoneNumberExtension,
       DestinationLocationCountry,
       UserID,
       BPAddressChangeDocObject,
       WorkforcePersonEntrySource,
       DataControllerSet,
       DataController1,
       DataController2,
       DataController3,
       DataController4,
       DataController5,
       DataController6,
       DataController7,
       DataController8,
       DataController9,
       DataController10,

       /* Associations */
       _BPUsrRole,
       _WorkforceTag,
       _WorkAssignment,
       _WorkplaceAddress,
       _FormOfAddressText,
       _CorrespondenceLanguage,
       _AcademicTitle1,
       _AcademicTitle2,
       _DestinationLocationCountry,
       _MblPhoneDestinationLocCountry,
       _EntrySourceText,
       _BusinessPartnerName

}

Learn More