I_VehSchedgRestIntmdSolution

DDL: I_VEHSCHEDGRESTINTMDSOLUTION Type: view_entity BASIC

Intermediate Solution for Rest

I_VehSchedgRestIntmdSolution is a Basic CDS View that provides data about "Intermediate Solution for Rest" in SAP S/4HANA. It reads from 1 data source (/scmtms/d_vssxir) and exposes 14 fields with key field VehSchedgIntmdRestSolutionUUID.

Data Sources (1)

SourceAliasJoin Type
/scmtms/d_vssxir /scmtms/d_vssxir from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Intermediate Solution for Rest view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY VehSchedgIntmdRestSolutionUUID db_key UUID
VehSchedgExplanationLogUUID parent_key UUID
VehSchedgProblem VSS Sol. Problem ID
VehSchedgSolutionStepType step_type VSS Sol. Step Type
VehSchedgIntmdSolnStp step Step Number
VehSchedgTranspActivity ref_act_id Activity ID
RestStartDateTime Time Stamp
RestEndDateTime Time Stamp
RestType rest_id Rest Type
RestCategory rest_cat Rest Category
AllowedActivitiesAreUsedByRest rest_uses_allowed_activities Considers Allow.Act.
TranspActivityCategoryGroup used_allowed_activity_group
TranspRestSplitIndicator rest_split
SplitRestCategory rest_split

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_VehSchedgRestIntmdSolution.
-- 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_VehSchedgRestIntmdSolution AS
SELECT
  db_key AS VehSchedgIntmdRestSolutionUUID,
  parent_key AS VehSchedgExplanationLogUUID,
  cast(problem_id as abap.char(11) ) AS VehSchedgProblem,
  step_type AS VehSchedgSolutionStepType,
  step AS VehSchedgIntmdSolnStp,
  ref_act_id AS VehSchedgTranspActivity,
  cast(start_time as /scmtms/vdm_departure_datetime preserving type ) AS RestStartDateTime,
  cast(end_time as /scmtms/vdm_arrival_datetime preserving type ) AS RestEndDateTime,
  rest_id AS RestType,
  rest_cat AS RestCategory,
  rest_uses_allowed_activities AS AllowedActivitiesAreUsedByRest,
  used_allowed_activity_group AS TranspActivityCategoryGroup,
  rest_split AS TranspRestSplitIndicator,
  rest_split AS SplitRestCategory
FROM /scmtms/d_vssxir
;