R_WorkforcePersonTP

DDL: R_WORKFORCEPERSONTP Type: view_entity TRANSACTIONAL
55 Fields 1 Data Sources 3 Associations

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.

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 BP GUID
Person Person Person/ Farm/ Field
PersonExternalID PersonExternalID Logical System
FirstName FirstName First Name
LastName LastName Last Name
MiddleName MiddleName Middle Name
AdditionalLastName AdditionalLastName Other Last Name
PersonFullName PersonFullName Full Name
AuthorizationGroup AuthorizationGroup AuthorizGroup
FormOfAddress FormOfAddress Title Key
CorrespondenceLanguage CorrespondenceLanguage Language
LastNamePrefix LastNamePrefix Prefix Key
LastNameSecondPrefix LastNameSecondPrefix 2nd prefix
BusinessPartnerBirthName BusinessPartnerBirthName Name at Birth
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel Nickname
AcademicTitle AcademicTitle Academic Title
AcademicTitle2 AcademicTitle2 2nd Academic
Initials Initials Initials
BusinessPartnerSupplementName BusinessPartnerSupplementName Name Supplement
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
LastChangeDateTime LastChangeDateTime Timestamp
_WorkplaceAddress _WorkplaceAddress
EmailAddress EmailAddress E-Mail Address
MobilePhoneNumber MobilePhoneNumber Telephone
MblPhoneDestinationLocCountry MblPhoneDestinationLocCountry
PhoneNumber PhoneNumber Telephone no.
PhoneNumberExtension PhoneNumberExtension Extension
DestinationLocationCountry DestinationLocationCountry Country/Region
UserID UserID User Name
BPAddressChangeDocObject BPAddressChangeDocObject
BusinessPartnerRole BusinessPartnerRole BP Role
DataControllerSet DataControllerSet Data Ctrlr. Set
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_WorkforcePersonTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_WorkforcePersonTP AS
SELECT
  PersonUUID,
  Person,
  PersonExternalID,
  FirstName,
  LastName,
  MiddleName,
  AdditionalLastName,
  PersonFullName,
  AuthorizationGroup,
  FormOfAddress,
  CorrespondenceLanguage,
  LastNamePrefix,
  LastNameSecondPrefix,
  BusinessPartnerBirthName,
  BusinessPartnerNicknameLabel,
  AcademicTitle,
  AcademicTitle2,
  Initials,
  BusinessPartnerSupplementName,
  IsBusinessPurposeCompleted,
  LastChangeDateTime,
  EmailAddress,
  MobilePhoneNumber,
  MblPhoneDestinationLocCountry,
  PhoneNumber,
  PhoneNumberExtension,
  DestinationLocationCountry,
  UserID,
  BPAddressChangeDocObject,
  BusinessPartnerRole,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM R_WorkforcePerson
LEFT OUTER JOIN R_WorkforceTagTP AS _WorkforceTag ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_WorkAssignmentTP AS _WorkAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_BPUsrRoleTP AS _BPUsrRole ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More