R_WorkforcePerson

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_WorkforcePerson.
-- 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_WorkforcePerson AS
SELECT
  _BP.BusinessPartnerUUID AS PersonUUID,
  _BP.BusinessPartner AS Person,
  _PersIdentifier.BPIdentificationNumber AS PersonExternalID,
  _BP.FirstName AS FirstName,
  _BP.LastName AS LastName,
  _BP.MiddleName AS MiddleName,
  _BP.AdditionalLastName AS AdditionalLastName,
  _BP.PersonFullName AS PersonFullName,
  _BP.AuthorizationGroup AS AuthorizationGroup,
  _BP.FormOfAddress AS FormOfAddress,
  _BP.CorrespondenceLanguage AS CorrespondenceLanguage,
  _BP.LastNamePrefix AS LastNamePrefix,
  _BP.LastNameSecondPrefix AS LastNameSecondPrefix,
  _BP.BusinessPartnerBirthName AS BusinessPartnerBirthName,
  _BP.BusinessPartnerNicknameLabel AS BusinessPartnerNicknameLabel,
  _BP.AcademicTitle AS AcademicTitle,
  _BP.AcademicTitle2 AS AcademicTitle2,
  _BP.Initials AS Initials,
  _BP.BusinessPartnerSupplementName AS BusinessPartnerSupplementName,
  _BPUsrRoleLatest[inner].BusinessPartnerRole AS BusinessPartnerRole,
  _BP.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _WorkplaceAddress.DefaultEmailAddress AS EmailAddress,
  _WorkplaceAddress.MobilePhoneNumber AS MobilePhoneNumber,
  _WorkplaceAddress.MblPhoneDestinationLocCountry AS MblPhoneDestinationLocCountry,
  _WorkplaceAddress.PhoneNumber AS PhoneNumber,
  _WorkplaceAddress.PhoneNumberExtension AS PhoneNumberExtension,
  _WorkplaceAddress.DestinationLocationCountry AS DestinationLocationCountry,
  _BusinessUserBasic.UserID AS UserID,
  cast( cast( _ChangeDoc.BPAddressChangeDocObject as char24 preserving type ) as char90 ) AS BPAddressChangeDocObject,
  _BP.DataControllerSet AS DataControllerSet,
  _BP.DataController1 AS DataController1,
  _BP.DataController2 AS DataController2,
  _BP.DataController3 AS DataController3,
  _BP.DataController4 AS DataController4,
  _BP.DataController5 AS DataController5,
  _BP.DataController6 AS DataController6,
  _BP.DataController7 AS DataController7,
  _BP.DataController8 AS DataController8,
  _BP.DataController9 AS DataController9,
  _BP.DataController10 AS DataController10
FROM I_BusinessPartner AS _BP
LEFT OUTER JOIN I_FormOfAddressText AS _FormOfAddressText ON _FormOfAddressText.FormOfAddress = _BP.FormOfAddress AND _FormOfAddressText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusPartPrefixName AS _BusPartPrefixLastName ON _BusPartPrefixLastName.LastNamePrefix = _BP.LastNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_BusPartPrefixName AS _BusPartPrefixLastNameSecond ON _BusPartPrefixLastNameSecond.LastNamePrefix = _BP.LastNameSecondPrefix  -- association [0..1]
LEFT OUTER JOIN I_NameSupplement AS _NameSupplementText ON _NameSupplementText.PersonNameSupplementCode = _BP.BusinessPartnerSupplementName  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _CorrespondenceLanguage ON _CorrespondenceLanguage.LanguageCode = _BP.CorrespondenceLanguage AND _CorrespondenceLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle1 ON _AcademicTitle1.AcademicTitle = _BP.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle2 ON _AcademicTitle2.AcademicTitle = _BP.AcademicTitle2  -- association [0..1]
LEFT OUTER JOIN I_Country AS _DestinationLocationCountry ON DestinationLocationCountry = _DestinationLocationCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _MblPhoneDestinationLocCountry ON MblPhoneDestinationLocCountry = _MblPhoneDestinationLocCountry.Country  -- association [0..1]
LEFT OUTER JOIN R_BPUsrPersonExternalID AS _PersIdentifier ON Person = _PersIdentifier.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_WorkplaceAddress AS _WorkplaceAddress ON PersonUUID = _WorkplaceAddress.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserBasic ON Person = _BusinessUserBasic.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN R_BPUsrRoleLatest AS _BPUsrRoleLatest ON PersonUUID = _BPUsrRoleLatest.BusinessPartnerUUID AND _BPUsrRoleLatest.BPRoleCategoryUsageCode = 'B'  -- association [1..1]
LEFT OUTER JOIN I_BPRelationship AS _BPRelationshipBUR025 ON Person = _BPRelationshipBUR025.BusinessPartnerPerson AND _BPRelationshipBUR025.RelationshipCategory = 'BUR025' AND _BPRelationshipBUR025.ValidityStartDate <= $session.system_date AND _BPRelationshipBUR025.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN C_BPUsrChangeDocument AS _ChangeDoc ON PersonUUID = _ChangeDoc.BusinessPartnerUUID  -- association [1..1]
LEFT OUTER JOIN R_WorkAssignmentTP AS _WorkAssignment ON PersonUUID = _WorkAssignment.PersonUUID  -- association [0..*]
;