I_VehSchedgExplanationLog

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 I_VehSchedgExplanationLog.
-- 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: I_TMVSSEXPROOT

CREATE VIEW I_VehSchedgExplanationLog AS
SELECT
  db_key AS VehSchedgExplanationLogUUID,
  cast(start as tzntstmps preserving type ) AS VehSchedgExecutionDateTime,
  profile AS TranspPlanningProfile,
  cast(status as /scmtms/sched_status preserving type ) AS TransportationOrderPlngSts,
  sched_profile_id AS VehSchedgProfile,
  vss_direction AS VehSchedgDirection,
  process_indicator AS VehSchedgCallingAction,
  ignore_context AS TranspPlngIgnoreContext,
  cast(ph_start as timestamp) AS TranspPlngHorizonStartDateTime,
  cast(ph_end as timestamp) AS TranspPlngHorizonEndDateTime,
  vss_engine AS VehSchedgEngine,
  created_by AS ExplanationLogCreatedByUser,
  cast(created_on as tzntstmps) AS ExplanationLogCreatedOnDteTme,
  changed_by AS ExplanationLogChangedByUser,
  cast(changed_on as tzntstmps) AS ExplanationLogChangedOnDteTme
FROM /scmtms/d_vssxro
;