C_VehSchedgSolutionList

DDL: C_VEHSCHEDGSOLUTIONLIST Type: view_entity CONSUMPTION

Gantt Chart Hierarchy in Explanation Tool

C_VehSchedgSolutionList is a Consumption CDS View that provides data about "Gantt Chart Hierarchy in Explanation Tool" in SAP S/4HANA. It has 1 association to related views. It is exposed through 1 OData service (SAPTMVSSEXPLANATION). It is used in 1 Fiori application: Explain Scheduling Results.

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_VehSchedgSolnStepTypeText _SolnStepTypeText $projection.VehSchedgSolutionStepType = _SolnStepTypeText.VehSchedgSolutionStepType and _SolnStepTypeText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Gantt Chart Hierarchy in Explanation Tool view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
SAPTMVSSEXPLANATION SAPTMVSSEXPLANATION V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4976 Explain Scheduling Results Transactional An app to analyze scheduling results to better understand how the system has scheduled objects.

Explain Scheduling Results

Business Role: Transportation Manager (Transportation Management)

Scheduling and automatic planning have been enhanced.

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY VehSchedgExplanationLogUUID VehSchedgExplanationLogUUID
KEY VehSchedgProblem VehSchedgProblem
KEY VehSchedgSolutionStep VehSchedgSolutionStep
VehSchedgSolutionStepType VehSchedgSolutionStepType
_SolnStepTypeText _SolnStepTypeText

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_VehSchedgSolutionList.
-- 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.

CREATE VIEW C_VehSchedgSolutionList AS
SELECT
  VehSchedgExplanationLogUUID,
  VehSchedgProblem,
  VehSchedgSolutionStep,
  VehSchedgSolutionStepType
LEFT OUTER JOIN I_VehSchedgSolnStepTypeText AS _SolnStepTypeText ON VehSchedgSolutionStepType = _SolnStepTypeText.VehSchedgSolutionStepType AND _SolnStepTypeText.Language = $session.system_language  -- association [1..1]
;