P_Empfactsheet_Employee

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_Empfactsheet_Employee.
-- 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: PEMPFSEMPLOYEE

CREATE VIEW P_Empfactsheet_Employee AS
SELECT
  EE.Employee AS EmployeeExtID,
  EE.Employee AS Employee,
  tstmp_current_utctimestamp() AS currtimestmp,
  EE.EmployeeInternalID AS EmployeeInternalID,
  EE.ValidityStartDate AS ValidityStartDate,
  EE.ValidityEndDate AS ValidityEndDate,
  EE.FormOfAddress AS FormOfAddress,
  EE.FamilyName AS FamilyName,
  EE.GivenName AS GivenName,
  EE.MiddleName AS MiddleName,
  EE.AdditionalFamilyName AS AdditionalFamilyName,
  EE.FamilyNamePrefix AS FamilyNamePrefix,
  EE.Initials AS Initials,
  EE.CorrespondenceLanguage AS CorrespondenceLanguage,
  EE.GenderCode AS GenderCode,
  EE.UserID AS UserID,
  EE.Person AS Person,
  EE.BusinessPartnerUUID AS BusinessPartnerUUID,
  EE.BusinessPartnerRole AS BusinessPartnerRole,
  EE._IsServicePerformerFor.Supplier AS Supplier,
  lpad('',80,'x') AS SupplierText,
  lpad('',80,'x') AS EmployeeText,
  employment.EmploymentInternalID AS MainEmploymentInternalID,
  'image/jpeg' AS ContentType,
  _MainEmploymentDetails._CostCenter.ControllingArea AS ControllingArea,
  _ServiceCostLevelCurrent.ServiceCostLevel AS ServiceCostLevel,
  cast( 0 as abap.int1) AS CostLevel_fc,
  EE._FormOfAddress AS _FormOfAddress,
  EE._Gender AS _Gender,
  EE._AcademicTitle AS _AcademicTitle,
  EE._FamilyNamePrefix AS _FamilyNamePrefix,
  EE._Language AS _Language,
  EE._Employment AS _Employment,
  EE._HomeAddress AS _HomeAddress,
  EE._WorkplaceAddress AS _WorkplaceAddress,
  EE.PersonnelNumber AS PersonnelNumber,
  substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ) , 1, 8 ) AS currentdate,
  _MainEmploymentDetails._CompanyCode.CompanyCodeName AS CompanyName,
  lpad('',80,' ') AS ManagerFullName,
  _ServiceCostLevelCurrent.EmploymentStatus AS EmploymentStatus,
  lpad('',410,'x') AS HeaderInfo,
  EE.GivenName AS HeaderDescription,
  _EmploymentDetails.CostCenter AS Costcenter,
  _ServiceCostLevelCurrent.ServiceCostLevelName AS ServiceCostLevelName,
  EE.AcademicTitle AS AcademicTitle,
  EE.EmployeeFullName AS EmployeeFullName,
  EE.EmployeeImageURL AS EmployeeImageURL,
  _EmploymentDetails.Job AS Job,
  _EmploymentDetails.OrganizationalUnit AS Department,
  _MainEmploymentDetails._CompanyCode.CompanyCode AS CompanyCode,
  lpad('',60,'x') AS ManagerEmployee,
  lpad('',40,'x') AS CostLevel,
  lpad('',95,'x') AS SupplierTxt,
  WorkplaceAddressInfocurrent.MblNormalizedPhoneNumber AS MblNormalizedPhoneNumber,
  WorkplaceAddressInfocurrent.NormalizedPhoneNumber AS NormalizedPhoneNumber,
  WorkplaceAddressInfocurrent.DefaultEmailAddress AS DefaultEmailAddress,
  lpad('',80,'x') AS PaymentExistsText,
  cast( ' ' as boolean ) AS Payment_fc,
  cast( 0 as abap.int1) AS PaymentApplicable
LEFT OUTER JOIN I_Employment AS employment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Empfactsheet_Projects AS _Projects ON EE.PersonnelNumber = _Projects.PersonnelNumber  -- association [0..*]
LEFT OUTER JOIN P_Empfactsheet_Tags AS _EmployeeSkillTags ON EE.PersonnelNumber = _EmployeeSkillTags.PersonnelNumber AND _EmployeeSkillTags.EmployeeSkillTagType = 'U'  -- association [0..*]
LEFT OUTER JOIN P_Empfactsheet_Contrinfo AS _ServiceCostLevel ON EE.PersonnelNumber = _ServiceCostLevel.PersonnelNumber AND _ServiceCostLevel.IsMainEmployment = 'X'  -- association [0..*]
LEFT OUTER JOIN P_EmpDetailsCurrent AS _ServiceCostLevelCurrent ON EE.PersonnelNumber = _ServiceCostLevelCurrent.PersonnelNumber AND _ServiceCostLevelCurrent.IsMainEmployment = 'X'  -- association [0..1]
LEFT OUTER JOIN P_EmpDetailsCurrent AS _EmploymentCurrent ON EE.PersonnelNumber = _EmploymentCurrent.PersonnelNumber  -- association [0..*]
LEFT OUTER JOIN I_EmployOrgDet AS _MainEmploymentDetails ON EE.PersonnelNumber = _MainEmploymentDetails.PersonnelNumber AND _MainEmploymentDetails.StartDate <= $session.system_date AND _MainEmploymentDetails.EndDate >= $session.system_date AND _MainEmploymentDetails.IsMainEmployment = 'X'  -- association [0..1]
LEFT OUTER JOIN P_Employeeorgdet AS _EmploymentDetails ON EE.PersonnelNumber = _EmploymentDetails.PersonnelNumber AND _EmploymentDetails.StartDate <= $session.system_date AND _EmploymentDetails.EndDate >= $session.system_date AND _EmploymentDetails.IsMainEmployment = 'X'  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_WorkplaceAddress AS _WorkplaceAddressInfo ON EE.BusinessPartnerUUID = _WorkplaceAddressInfo.BusinessPartnerUUID  -- association [0..*]
LEFT OUTER JOIN I_WorkplaceAddress AS WorkplaceAddressInfocurrent ON EE.BusinessPartnerUUID = WorkplaceAddressInfocurrent.BusinessPartnerUUID AND WorkplaceAddressInfocurrent.ValidityStartDate <= $session.system_date AND WorkplaceAddressInfocurrent.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_EmployeePayment AS _PaymentExists ON EE.PersonnelNumber = _PaymentExists.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_EmployeePayment AS _PaymentInformation ON EE.PersonnelNumber = _PaymentInformation.PersonnelNumber  -- association [0..*]
;