Swx_Sddl_Formabsenc_Base

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 Swx_Sddl_Formabsenc_Base.
-- 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: SWX_V_FORMABSBAS

CREATE VIEW Swx_Sddl_Formabsenc_Base AS
SELECT
  leaveRequest.formnumber AS leaveRequestId,
  dats_tims_to_tstmp(approvdate, approvtime, approv_timezone, $session.client, 'NULL') AS t_approvedTimestamp,
  leaveRequest.approvby AS approvedBy,
  dats_tims_to_tstmp(createdate, createtime, create_timezone, $session.client, 'NULL') AS t_createdTimestamp,
  leaveRequest.createdby AS createdBy,
  leaveRequest.addrnumber AS addressNumber,
  leaveRequest.pernr AS personalNumber,
  leaveRequest.name AS creatorNameText,
  leaveRequest.department AS creatorDepartment,
  leaveRequest.costcenter AS costcenter,
  leaveRequest.firstday1 AS partOneFirstDay,
  leaveRequest.lastday1 AS partOneLastDay,
  case when leaveRequest.day1_timezone = ' ' then 'UTC' else leaveRequest.day1_timezone end as partOneTimezone AS day1_timezoneendaspartOneTimezone,
  leaveRequest.abshours1 AS partOneAbsenceHours,
  leaveRequest.holidaytp1 AS partOneLeaveType,
  leaveRequest.firstday2 AS partTwoFirstDay,
  leaveRequest.lastday2 AS partTwoLastDay,
  case when leaveRequest.day2_timezone = ' ' then 'UTC' else leaveRequest.day2_timezone end as partTwoTimezone AS day2_timezoneendaspartTwoTimezone,
  leaveRequest.abshours2 AS partTwoAbsenceHours,
  leaveRequest.holidaytp2 AS partTwoLeaveType,
  leaveRequest.firstday3 AS partThreeFirstDay,
  leaveRequest.lastday3 AS partThreeLastDay,
  case when leaveRequest.day3_timezone = ' ' then 'UTC' else leaveRequest.day3_timezone end as partThreeTimezone AS day3_timezoneendaspartThreeTimezone,
  leaveRequest.abshours3 AS partThreeAbsenceHours,
  leaveRequest.holidaytp3 AS partThreeLeaveType,
  leaveRequest.reason AS reason,
  leaveRequest.contact AS contact,
  leaveRequest.procstate AS leaveRequestState
FROM swxformabs AS leaveRequest
;