I_VehSchedgRestSolution

DDL: I_VEHSCHEDGRESTSOLUTION Type: view_entity COMPOSITE Package: VDM_TM_BO_EXPL_VSS

Vehicle Scheduling Rest Solution

I_VehSchedgRestSolution is a Composite CDS View that provides data about "Vehicle Scheduling Rest Solution" in SAP S/4HANA. It reads from 4 data sources (I_VehSchedgRestFinalSolution, I_VehSchedgRestIntmdSolution, I_VehSchedgRestIntmdSolution, P_VehSchedgRestSolnStrtStp) and exposes 26 fields with key field VehSchedgRestSolutionUUID. It is exposed through 1 OData service (SAPTMVSSEXPLANATION). Part of development package VDM_TM_BO_EXPL_VSS.

Data Sources (4)

SourceAliasJoin Type
I_VehSchedgRestFinalSolution I_VehSchedgRestFinalSolution from
I_VehSchedgRestIntmdSolution I_VehSchedgRestIntmdSolution union
I_VehSchedgRestIntmdSolution I_VehSchedgRestIntmdSolution union
P_VehSchedgRestSolnStrtStp P_VehSchedgRestSolnStrtStp inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Vehicle Scheduling Rest Solution view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
SAPTMVSSEXPLANATION SAPTMVSSEXPLANATION V2 C1 NOT_RELEASED

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY VehSchedgRestSolutionUUID VehSchedgRestSolutionUUID UUID
VehSchedgExplanationLogUUID VehSchedgExplanationLogUUID UUID
VehSchedgProblem
VehSchedgSolutionStep
VehSchedgSolutionStepType VSS Sol. Step Type
VehSchedgTranspActivity VehSchedgTranspActivity Activity ID
RestStartDateTime RestStartDateTime
RestEndDateTime RestEndDateTime
RestType RestType Rest Type
VehSchedgExplanationLogUUID VehSchedgExplanationLogUUID UUID
VehSchedgProblem
VehSchedgSolutionStep
VehSchedgSolutionStepType VehSchedgSolutionStepType VSS Sol. Step Type
VehSchedgTranspActivity VehSchedgTranspActivity Activity ID
RestStartDateTime RestStartDateTime
RestEndDateTime RestEndDateTime
RestType RestType Rest Type
VehSchedgExplanationLogUUID I_VehSchedgRestIntmdSolution VehSchedgExplanationLogUUID UUID
VehSchedgProblem I_VehSchedgRestIntmdSolution VehSchedgProblem
VehSchedgSolutionStep
VehSchedgSolutionStepType I_VehSchedgRestIntmdSolution VehSchedgSolutionStepType VSS Sol. Step Type
VehSchedgTranspActivity I_VehSchedgRestIntmdSolution VehSchedgTranspActivity Activity ID
RestStartDateTime I_VehSchedgRestIntmdSolution RestStartDateTime
RestEndDateTime I_VehSchedgRestIntmdSolution RestEndDateTime
RestType I_VehSchedgRestIntmdSolution RestType Rest Type
RestCategory I_VehSchedgRestIntmdSolution RestCategory Rest Category

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_VehSchedgRestSolution.
-- 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 I_VehSchedgRestSolution AS
SELECT
  VehSchedgRestSolutionUUID,
  VehSchedgExplanationLogUUID,
  cast(0 as abap.char(11)) AS VehSchedgProblem,
  cast(1 as abap.char(11)) AS VehSchedgSolutionStep,
  cast('7' as /scmtms/vss_step_type ) AS VehSchedgSolutionStepType,
  VehSchedgTranspActivity,
  RestStartDateTime,
  RestEndDateTime,
  RestType,
  I_VehSchedgRestIntmdSolution.RestCategory AS RestCategory
FROM I_VehSchedgRestFinalSolution
INNER JOIN P_VehSchedgRestSolnStrtStp ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_VehSchedgRestIntmdSolution
;