C_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 C_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.
-- Parameters: useForValidation : true, P_VehSchedgTimeZoneIANACode : tzniana

CREATE VIEW C_VehSchedgExplanationLog AS
SELECT *  -- field list not available in parsed metadata
FROM I_VehSchedgExplanationLog
LEFT OUTER JOIN C_VehSchedgProblemList AS _ProblemList ON VehSchedgExplanationLogUUID = _ProblemList.VehSchedgExplanationLogUUID  -- association [1..*]
LEFT OUTER JOIN C_VehSchedgSolutionList AS _SolutionList ON VehSchedgExplanationLogUUID = _SolutionList.VehSchedgExplanationLogUUID  -- association [1..*]
LEFT OUTER JOIN C_VehSchedgBrkCal AS _Calendar ON VehSchedgExplanationLogUUID = _Calendar.VehSchedgExplanationLogUUID  -- association [1..*]
LEFT OUTER JOIN C_VehSchedgActivityTree AS _ActivityTree ON VehSchedgExplanationLogUUID = _ActivityTree.VehSchedgExplanationLogUUID  -- association [1..*]
LEFT OUTER JOIN C_VehSchedgVehicleResource AS _VehicleResource ON VehSchedgExplanationLogUUID = _VehicleResource.VehSchedgExplanationLogUUID  -- association [1..*]
LEFT OUTER JOIN C_VehSchedgHandlingResource AS _HandlingResource ON VehSchedgExplanationLogUUID = _HandlingResource.VehSchedgExplanationLogUUID  -- association [1..*]
LEFT OUTER JOIN I_VehSchedgDirectionText AS _VehSchedgDirText ON VehSchedgDirection = _VehSchedgDirText.VehSchedgDirection AND _VehSchedgDirText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_TranspPlnIgnoreContextText AS _PlnIgnoreContextText ON TranspPlngIgnoreContext = _PlnIgnoreContextText.TranspPlngIgnoreContext AND _PlnIgnoreContextText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_TranspOrderPlngStsText AS _OrderPlngStsText ON TransportationOrderPlngSts = _OrderPlngStsText.TransportationOrderPlngSts AND _OrderPlngStsText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_VehSchedgEngineText AS _VehSchedgEngineText ON VehSchedgEngine = _VehSchedgEngineText.VehSchedgEngine AND _VehSchedgEngineText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_VehSchedgCallingActionText AS _VehSchedgCallingActionText ON VehSchedgCallingAction = _VehSchedgCallingActionText.VehSchedgCallingAction AND _VehSchedgCallingActionText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_TranspGanttDfltObjColor AS _GanttCustomizingColor ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN C_VehSchedgUserContactCard AS _UserCreatedBy ON ExplanationLogCreatedByUser = _UserCreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_TranspPlanningProfile AS _PlanningProfile ON TranspPlanningProfile = _PlanningProfile.TranspPlanningProfile  -- association [1..1]
LEFT OUTER JOIN C_VehSchedgSettings AS _SchedulingSettings ON VehSchedgProfile = _SchedulingSettings.VehSchedgSettings  -- association [1..1]
LEFT OUTER JOIN C_VehSchedgGanttChartLocale AS _GanttChartLocale ON VehSchedgTimeZoneIANACode = _GanttChartLocale.TimeZoneIANACode  -- association [1..1]
LEFT OUTER JOIN C_TranspGanttDaylightSvngPerd AS _DaylightSavingPerd ON VehSchedgTimeZoneIANACode = _DaylightSavingPerd.TimeZoneIANACode  -- association [1..*]
;