I_SchedulingRunRequest

DDL: I_SCHEDULINGRUNREQUEST Type: view_entity BASIC Package: BPS_VDM
11 Fields 1 Data Sources 4 Associations

Scheduling Run Request

I_SchedulingRunRequest is a Basic CDS View that provides data about "Scheduling Run Request" in SAP S/4HANA. It reads from 1 data source (bps_request) and exposes 11 fields with key field SchedulingRunRequestUUID. It has 4 associations to related views. Part of development package BPS_VDM.

Data Sources (1)

SourceAliasJoin Type
bps_request bps_request from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SchedulingDateType _SchedulingDateType $projection.SchedulingDateType = _SchedulingDateType.SchedulingDateType
[1..1] I_SchedulingSchema _Schema $projection.SchedulingSchema = _Schema.SchedulingSchema
[0..*] I_SchedulingRunRequestResult _SchedulingResult
[1..1] I_SchedulingRunRequestOrder _SchedulingRunRequestOrder

Annotations (7)

NameValueLevelField
EndUserText.label Scheduling Run Request view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey SchedulingRunRequestUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SchedulingRunRequestUUID request_uuid UUID
SchedulingRunUUID run_uuid Scheduling Worklist Run UUID
SchedulingSchema schema_id Status Scheme
SchedulingDateType date_type Date Type
SchedulingEntryDateTime timestamp_entry BSP - Entry timestamp
TimeZoneIANACode iana_tzone IANA time zone
_SchedulingRun _SchedulingRun
_SchedulingResult _SchedulingResult
_SchedulingRunRequestOrder _SchedulingRunRequestOrder
_SchedulingDateType _SchedulingDateType
_Schema _Schema

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_SchedulingRunRequest.
-- 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_SchedulingRunRequest AS
SELECT
  request_uuid AS SchedulingRunRequestUUID,
  run_uuid AS SchedulingRunUUID,
  schema_id AS SchedulingSchema,
  date_type AS SchedulingDateType,
  timestamp_entry AS SchedulingEntryDateTime,
  iana_tzone AS TimeZoneIANACode
FROM bps_request
LEFT OUTER JOIN I_SchedulingDateType AS _SchedulingDateType ON SchedulingDateType = _SchedulingDateType.SchedulingDateType  -- association [0..1]
LEFT OUTER JOIN I_SchedulingSchema AS _Schema ON SchedulingSchema = _Schema.SchedulingSchema  -- association [1..1]
LEFT OUTER JOIN I_SchedulingRunRequestResult AS _SchedulingResult ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SchedulingRunRequestOrder AS _SchedulingRunRequestOrder ON /* condition not available in parsed metadata */  -- association [1..1]
;

Learn More