P_N_EmployeeOp

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 P_N_EmployeeOp.
-- 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.
-- SQL view name: PNEMPLOYEEOP

CREATE VIEW P_N_EmployeeOp AS
SELECT
  keymap.central_person AS PersonnelNumber,
  bpexid.idnumber AS Employee,
  bp.partner AS EmployeeInternalID,
  /to assgmt.start_date as ValidityStartDate AS start_dateasValidityStartDate,
  /to assgmt.end_date as ValidityEndDate AS end_dateasValidityEndDate,
  bp.title AS FormOfAddress,
  bp.name_last AS FamilyName,
  bp.name_first AS FirstName,
  bp.mc_name1 AS LastName,
  bp.mc_name2 AS BusinessPartnerName,
  bp.name_first AS GivenName,
  bp.namemiddle AS MiddleName,
  bp.name_lst2 AS AdditionalFamilyName,
  bp.title_aca1 AS AcademicTitle,
  bp.prefix1 AS FamilyNamePrefix,
  bp.initials AS Initials,
  bp.name1_text AS FullName,
  bp.name1_text AS EmployeeFullName,
  bp.langu_corr AS CorrespondenceLanguage,
  case bp.xsexm when 'X' then '1' else case bp.xsexf when 'X' then '2' else '' end end as GenderCode AS xsexfwhenXthen2elseendendasGenderCode,
  '' AS BusinessUser,
  '' AS UserID,
  '' AS EmployeeImageURL,
  case when bp_cf_role.BusinessPartnerRole is not initial then bp_cf_role.BusinessPartnerRole else bp_role.rltyp end as BusinessPartnerRole AS rltypendasBusinessPartnerRole,
  bp.persnumber AS Person,
  bp.partner_guid AS BusinessPartnerUUID,
  bp.crusr AS CreatedByUser,
  bp.crdat AS CreationDate,
  bp.crtim AS CreationTime,
  bp.chusr AS LastChangedByUser,
  bp.chdat AS LastChangeDate,
  bp.chtim AS LastChangeTime,
  bp.augrp AS AuthorizationGroup,
  bp.xpcpt AS IsBusinessPurposeCompleted
INNER JOIN wfd_d_keymap AS keymap ON /* join condition not captured in parsed metadata */
INNER JOIN wfd_d_assgmt AS assgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN but0id AS bpexid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkforcePersonDetermineRole AS bp_cf_role ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkforcePersonPastMinRole AS bp_p_role ON /* join condition not captured in parsed metadata */
INNER JOIN but100 AS bp_role ON /* join condition not captured in parsed metadata */
;