C_VehSchedgBrkCal

DDL: C_VEHSCHEDGBRKCAL Type: view_entity CONSUMPTION Package: CVIEW_TM_PLN_EXPL_VSS
5 Fields 1 Data Sources 1 Associations 1 OData Services

Resource Break Calendar

C_VehSchedgBrkCal is a Consumption CDS View that provides data about "Resource Break Calendar" in SAP S/4HANA. It reads from 1 data source (I_TranspGanttDfltObjColor) and exposes 5 fields with key fields VehSchedgExplanationLogUUID, ResourceBreakCalendar. It has 1 association to related views. It is exposed through 1 OData service (SAPTMVSSEXPLANATION). Part of development package CVIEW_TM_PLN_EXPL_VSS.

Data Sources (1)

SourceAliasJoin Type
I_TranspGanttDfltObjColor GanttCustomizingColor inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_VehSchedgBrkCalInterval _Interval $projection.ResourceBreakCalendar = _Interval.ResourceBreakCalendar and $projection.VehSchedgExplanationLogUUID = _Interval.VehSchedgExplanationLogUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Resource Break Calendar 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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY VehSchedgExplanationLogUUID I_VehSchedgBrkCalInterval VehSchedgExplanationLogUUID
KEY ResourceBreakCalendar I_VehSchedgBrkCalInterval ResourceBreakCalendar
ResourceBreakCalendarName
VehSchedgObjectColorCode I_TranspGanttDfltObjColor VehSchedgObjectColorCode
_Interval _Interval

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_VehSchedgBrkCal.
-- 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_VehSchedgBrkCal AS
SELECT
  I_VehSchedgBrkCalInterval.VehSchedgExplanationLogUUID AS VehSchedgExplanationLogUUID,
  I_VehSchedgBrkCalInterval.ResourceBreakCalendar AS ResourceBreakCalendar,
  cast(I_VehSchedgBrkCalInterval.ResourceBreakCalendar as abap.char(11)) AS ResourceBreakCalendarName,
  GanttCustomizingColor.VehSchedgObjectColorCode AS VehSchedgObjectColorCode
INNER JOIN I_TranspGanttDfltObjColor AS GanttCustomizingColor ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VehSchedgBrkCalInterval AS _Interval ON ResourceBreakCalendar = _Interval.ResourceBreakCalendar AND VehSchedgExplanationLogUUID = _Interval.VehSchedgExplanationLogUUID  -- association [1..*]
;

Learn More