C_VehSchedgRsceRestSoln

DDL: C_VEHSCHEDGRSCERESTSOLN Type: view_entity CONSUMPTION
13 Fields 2 Data Sources 1 OData Services 1 Fiori Apps

Rest Solution based on resource

C_VehSchedgRsceRestSoln is a Consumption CDS View that provides data about "Rest Solution based on resource" in SAP S/4HANA. It reads from 2 data sources (I_VehSchedgActivitySolution, I_VehSchedgRestSolution) and exposes 13 fields with key fields VehSchedgExplanationLogUUID, VehSchedgProblem, VehSchedgSolutionStep, VehSchedgTranspActivity, VehSchedgRestSolutionUUID. It is exposed through 1 OData service (SAPTMVSSEXPLANATION). It is used in 1 Fiori application: Explain Scheduling Results.

Data Sources (2)

SourceAliasJoin Type
I_VehSchedgActivitySolution Activity from
I_VehSchedgRestSolution Rest inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Rest Solution based on resource view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED 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 (13)

KeyFieldSource TableSource FieldDescription
KEY VehSchedgExplanationLogUUID I_VehSchedgActivitySolution VehSchedgExplanationLogUUID
KEY VehSchedgProblem I_VehSchedgActivitySolution VehSchedgProblem
KEY VehSchedgSolutionStep I_VehSchedgActivitySolution VehSchedgSolutionStep
KEY VehSchedgTranspActivity I_VehSchedgActivitySolution VehSchedgTranspActivity
KEY VehSchedgRestSolutionUUID I_VehSchedgRestSolution VehSchedgRestSolutionUUID
ResourceAdditionalUUID I_VehSchedgActivitySolution ResourceAdditionalUUID
VehSchedgSolutionStepType
RestCategory I_VehSchedgRestSolution RestCategory
RestType I_VehSchedgRestSolution RestType
RestStartDateTime I_VehSchedgRestSolution RestStartDateTime
RestEndDateTime I_VehSchedgRestSolution RestEndDateTime
AllowedActivitiesAreUsedByRest I_VehSchedgRestSolution AllowedActivitiesAreUsedByRest
SplitRestCategory I_VehSchedgRestSolution SplitRestCategory

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_VehSchedgRsceRestSoln.
-- 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_VehSchedgRsceRestSoln AS
SELECT
  Activity.VehSchedgExplanationLogUUID AS VehSchedgExplanationLogUUID,
  Activity.VehSchedgProblem AS VehSchedgProblem,
  Activity.VehSchedgSolutionStep AS VehSchedgSolutionStep,
  Activity.VehSchedgTranspActivity AS VehSchedgTranspActivity,
  Rest.VehSchedgRestSolutionUUID AS VehSchedgRestSolutionUUID,
  Activity.ResourceAdditionalUUID AS ResourceAdditionalUUID,
  cast(Activity.VehSchedgSolutionStepType as /scmtms/vss_step_type) AS VehSchedgSolutionStepType,
  Rest.RestCategory AS RestCategory,
  Rest.RestType AS RestType,
  Rest.RestStartDateTime AS RestStartDateTime,
  Rest.RestEndDateTime AS RestEndDateTime,
  Rest.AllowedActivitiesAreUsedByRest AS AllowedActivitiesAreUsedByRest,
  Rest.SplitRestCategory AS SplitRestCategory
FROM I_VehSchedgActivitySolution AS Activity
INNER JOIN I_VehSchedgRestSolution AS Rest ON /* join condition not captured in parsed metadata */
;

Learn More