UPOV_WCDWN_DETAILS

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 UPOV_WCDWN_DETAILS.
-- 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: UPOS_WCDWN_DTLS

CREATE VIEW UPOV_WCDWN_DETAILS AS
SELECT
  event.event_id AS EventID,
  event.strt_period AS strt_period,
  event.end_period AS end_period,
  TSTMP_TO_DATS(event.strt_period,'UTC',$session.client,'NULL') AS start_date,
  TSTMP_TO_DATS(event.end_period,'UTC',$session.client,'NULL') AS end_date,
  TSTMP_TO_TIMS(event.strt_period,'UTC',$session.client,'NULL') AS start_time,
  TSTMP_TO_TIMS(event.end_period,'UTC',$session.client,'NULL') AS end_time,
  TSTMP_SECONDS_BETWEEN( event.strt_period, event.end_period, 'INITIAL') AS DiffSec,
  DATS_DAYS_BETWEEN( tstmp_to_dats(event.strt_period,'UTC',$session.client,'NULL'), tstmp_to_dats(event.end_period,'UTC',$session.client,'NULL')) as Converted_To_Days AS clientNULLasConverted_To_Days,
  DIV(TSTMP_SECONDS_BETWEEN( event.strt_period, event.end_period,'INITIAL'),3600) AS Converted_To_Hours,
  DIVISION(DIV(MOD(cast(cast(replace(cast(TSTMP_SECONDS_BETWEEN( event.strt_period, event.end_period,'INITIAL') as abap.char( 19 )),',','.') as abap.numc( 19 )) as abap.int8), 3600),60),100,2) as Remaining_Minutes AS int83600601002asRemaining_Minutes,
  DIV(TSTMP_SECONDS_BETWEEN( event.strt_period, event.end_period,'INITIAL'),3600) AS DiffHrs,
  cast(cast(cast(RIGHT(REPLACE(cast(cast( DIV(TSTMP_SECONDS_BETWEEN( event.strt_period, event.end_period,'INITIAL'),3600) + DIVISION(DIV(MOD(cast(cast(replace(cast(TSTMP_SECONDS_BETWEEN( event.strt_period, event.end_period,'INITIAL') as abap.char( 19 )),',','.') as abap.numc( 19 )) as abap.int8), 3600),60),100,2) as abap.dec( 23, 2 ) ) as abap.char(25 )),',','.'), 6) as abap.numc( 6 )) as abap.dec( 5, 2 )) as oiu_hrs) as eventTime AS dec52asoiu_hrsaseventTime
FROM gho_dm_event AS event
;