R_WorkforcePersonTP

DDL: R_WORKFORCEPERSONTP Type: view_entity TRANSACTIONAL

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 55 fields with key field PersonUUID. It has 3 associations to related views.

1 data source(s) 55 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkforcePerson R_WorkforcePerson from

Associations (3)

CardinalityTargetAliasCondition
[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 (55)

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
_WorkplaceAddress _WorkplaceAddress
EmailAddress EmailAddress
MobilePhoneNumber MobilePhoneNumber
MblPhoneDestinationLocCountry MblPhoneDestinationLocCountry
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
DestinationLocationCountry DestinationLocationCountry
UserID UserID
BPAddressChangeDocObject BPAddressChangeDocObject
BusinessPartnerRole BusinessPartnerRole
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
_FormOfAddressText _FormOfAddressText
_BusPartPrefixLastName _BusPartPrefixLastName
_BusPartPrefixLastNameSecond _BusPartPrefixLastNameSecond
_NameSupplementText _NameSupplementText
_CorrespondenceLanguage _CorrespondenceLanguage
_AcademicTitle1 _AcademicTitle1
_AcademicTitle2 _AcademicTitle2
_BPUsrRoleLatest _BPUsrRoleLatest
_DestinationLocationCountry _DestinationLocationCountry
_MblPhoneDestinationLocCountry _MblPhoneDestinationLocCountry 
@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
}
define root view entity R_WorkforcePersonTP
  as select from R_WorkforcePerson
  composition [0..*] of R_WorkforceTagTP   as _WorkforceTag
  composition [0..*] of R_WorkAssignmentTP as _WorkAssignment
  composition [1..*] of R_BPUsrRoleTP      as _BPUsrRole
{
  key PersonUUID,
      Person,
      PersonExternalID,
      FirstName,
      LastName,
      MiddleName,
      AdditionalLastName,
      PersonFullName,
      AuthorizationGroup,
      FormOfAddress,
      CorrespondenceLanguage,
      LastNamePrefix,
      LastNameSecondPrefix,
      BusinessPartnerBirthName,
      BusinessPartnerNicknameLabel,
      AcademicTitle,
      AcademicTitle2,
      Initials,
      BusinessPartnerSupplementName,
      @Semantics.booleanIndicator
      IsBusinessPurposeCompleted,
      LastChangeDateTime,
      /* Associations */
      _WorkplaceAddress,
      EmailAddress,
      MobilePhoneNumber,
      MblPhoneDestinationLocCountry,
      PhoneNumber,
      PhoneNumberExtension,
      DestinationLocationCountry,
      UserID,
      BPAddressChangeDocObject,
      BusinessPartnerRole,
      DataControllerSet,
      DataController1,
      DataController2,
      DataController3,
      DataController4,
      DataController5,
      DataController6,
      DataController7,
      DataController8,
      DataController9,
      DataController10,
//      @Semantics.booleanIndicator

//      IsBlocked,

      _BPUsrRole,
      _WorkforceTag,
      _WorkAssignment,
      _FormOfAddressText,
      _BusPartPrefixLastName,
      _BusPartPrefixLastNameSecond,
      _NameSupplementText,
      _CorrespondenceLanguage,
      _AcademicTitle1,
      _AcademicTitle2,
      _BPUsrRoleLatest,
      _DestinationLocationCountry,
      _MblPhoneDestinationLocCountry
}

Learn More