P_DGR_EOD_Date_Data

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_DGR_EOD_Date_Data.
-- 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: PDGREODDATEDATA

CREATE VIEW P_DGR_EOD_Date_Data AS
SELECT
  EvaluationKeyDate,
  EndOfDaySnapshotTime,
  EndOfDaySnapshotTimezone,
  EndOfDaySnapshotDateTime,
  substring( cast(EndOfDaySnapshotDateTime as abap.char( 17 )), 1, 8 ) AS EndOfDaySnapshotDateUTCDate,
  tstmp_current_utctimestamp() AS currentUTCTimestamp,
  substring( cast(tstmp_current_utctimestamp() as abap.char( 17 )), 1, 8 ) AS currentUTCDate,
  DIV( TSTMP_SECONDS_BETWEEN(tstmp_current_utctimestamp(), EndOfDaySnapshotDateTime, 'NULL') , cast(3600 as abap.dec( 17, 3 )) ) as hoursDifference AS dec173ashoursDifference
FROM I_DailyGrainReportDayEndRun
;