C_ManageWorkforce_F6097

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 C_ManageWorkforce_F6097.
-- 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 C_ManageWorkforce_F6097 AS
SELECT
  PersonUUID,
  Person,
  PersonExternalID,
  FirstName,
  LastName,
  MiddleName,
  AdditionalLastName,
  PersonFullName,
  AuthorizationGroup,
  FormOfAddress,
  _FormOfAddressText.FormOfAddressName AS FormOfAddressName,
  IsBusinessPurposeCompleted,
  LastChangeDateTime,
  virtual CompanyCode : bukrs AS virtualCompanyCodebukrs,
  virtual CompanyCodeName : butxt AS virtualCompanyCodeNamebutxt,
  virtual CostCenter : kostl AS virtualCostCenterkostl,
  virtual CostCenterName : fis_kostl_name AS virtualCostCenterNamefis_kostl_name,
  virtual ManagerEmployee : wfd_assgmt_ext_id AS virtualManagerEmployeewfd_assgmt_ext_id,
  virtual ManagerFullName : char100 AS virtualManagerFullNamechar100,
  CorrespondenceLanguage,
  _CorrespondenceLanguage.LanguageName AS CorrespondenceLanguageName,
  LastNamePrefix,
  _BusPartPrefixLastName.LastNamePrefixName AS LastNamePrefixName,
  LastNameSecondPrefix,
  _BusPartPrefixLastNameSecond.LastNamePrefixName AS LastNameSecondPrefixName,
  BusinessPartnerBirthName,
  BusinessPartnerNicknameLabel,
  AcademicTitle,
  _AcademicTitle1._Text[1:Language = $session.system_language].AcademicTitleName AS AcademicTitleName,
  AcademicTitle2,
  _AcademicTitle2._Text[1:Language = $session.system_language].AcademicTitleName AS AcademicTitle2Name,
  Initials,
  BusinessPartnerSupplementName,
  _NameSupplementText.NameSupplement AS NameSupplementDescription,
  EmailAddress,
  MobilePhoneNumber,
  MblPhoneDestinationLocCountry,
  _MblPhoneDestinationLocCountry._Text[1:Language = $session.system_language].CountryName AS MblPhoneDestinationCountryName,
  PhoneNumber,
  PhoneNumberExtension,
  DestinationLocationCountry,
  _DestinationLocationCountry._Text[1:Language = $session.system_language].CountryName AS DestinationLocationCountryName,
  UserID,
  BPAddressChangeDocObject,
  BusinessPartnerRole,
  _BPUsrRoleLatest.BusinessPartnerRoleShortName AS BusinessPartnerRoleShortName,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  virtual ProfileIsHidden : abap_boolean AS virtualProfileIsHiddenabap_boolean,
  virtual WorkerTypeIsHidden : abap_boolean AS virtualWorkerTypeIsHiddenabap_boolean,
  virtual ConvertButtonIsHidden : abap_boolean AS virtualConvertButtonIsHiddenabap_boolean
FROM R_WorkforcePersonTP
;