I_VehSchedgFinalSolution

DDL: I_VEHSCHEDGFINALSOLUTION Type: view_entity BASIC

VSS Explanation Solution

I_VehSchedgFinalSolution is a Basic CDS View that provides data about "VSS Explanation Solution" in SAP S/4HANA. It reads from 1 data source (/scmtms/d_vssxso) and exposes 5 fields with key field VehSchedgSolutionUUID.

Data Sources (1)

SourceAliasJoin Type
/scmtms/d_vssxso /scmtms/d_vssxso from

Annotations (7)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY VehSchedgSolutionUUID db_key UUID
VehSchedgExplanationLogUUID parent_key UUID
VehSchedgTranspActivity act_id S&R GUID
TranspActyPlanStartDateTime Time Stamp
TranspActyPlanEndDateTime Time Stamp

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_VehSchedgFinalSolution.
-- 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_VehSchedgFinalSolution AS
SELECT
  db_key AS VehSchedgSolutionUUID,
  parent_key AS VehSchedgExplanationLogUUID,
  act_id AS VehSchedgTranspActivity,
  cast(start_time as timestamp) AS TranspActyPlanStartDateTime,
  cast(end_time as timestamp) AS TranspActyPlanEndDateTime
FROM /scmtms/d_vssxso
;