R_WorkforcePersonTP

DDL: R_WORKFORCEPERSONTP Type: view_entity TRANSACTIONAL Package: ODATA_CA_BUM_WF

Workforce Person TP

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

1 data source(s) 52 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkforcePerson R_WorkforcePerson from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_BP_D _BPExtension $projection.Person = _BPExtension.BusinessPartner
[0..*] R_WorkforceTagTP _WorkforceTag
[0..*] R_WorkAssignmentTP _WorkAssignment
[1..*] R_BPUsrRoleTP _BPUsrRole

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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 (52)

KeyFieldSource TableSource FieldDescription
KEY PersonUUID PersonUUID
Person Person
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 
//@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #CHECK
@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
}
//@AbapCatalog.extensibility: {

//  extensible: true,

//  dataSources: ['_BPExtension'],

//  elementSuffix: 'WFP',

//  quota: {

//    maximumFields: 204,

//    maximumBytes: 100000

//  }

//}

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
define root view entity R_WorkforcePersonTP
  as select from R_WorkforcePerson
  //  ZR_WorkforcePerson_Test_perf

  composition [0..*] of R_WorkforceTagTP   as _WorkforceTag
  composition [0..*] of R_WorkAssignmentTP as _WorkAssignment
  composition [1..*] of R_BPUsrRoleTP      as _BPUsrRole
  association [0..1] to E_BP_D             as _BPExtension on $projection.Person = _BPExtension.BusinessPartner
{
  key PersonUUID,
      Person,
      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,
//      PreferredPhoneType,

      UserID,
      BPAddressChangeDocObject,
      WorkforcePersonEntrySource,
      //      BusinessPartnerRole,

      DataControllerSet,
      DataController1,
      DataController2,
      DataController3,
      DataController4,
      DataController5,
      DataController6,
      DataController7,
      DataController8,
      DataController9,
      DataController10,
      //      @Semantics.booleanIndicator

      //      IsBlocked,


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

}

Learn More