I_SchedulingRunRequestOrder

DDL: I_SCHEDULINGRUNREQUESTORDER Type: view_entity BASIC Package: BPS_VDM

Scheduling Request Order

I_SchedulingRunRequestOrder is a Basic CDS View that provides data about "Scheduling Request Order" in SAP S/4HANA. It reads from 1 data source (bps_review_order) and exposes 21 fields with key field SchedulingRunRequestOrderUUID. It has 7 associations to related views. Part of development package BPS_VDM.

Data Sources (1)

SourceAliasJoin Type
bps_review_order bps_review_order from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_SchedulingRun _SchedulingRun $projection.SchedulingRunUUID = _SchedulingRun.SchedulingRunUUID
[1..1] I_Material _Material $projection.Material = _Material.Material
[1..1] I_Route _Route $projection.Route = _Route.Route
[1..1] I_ShippingPoint _ShippingPoint $projection.ShippingPoint = _ShippingPoint.ShippingPoint
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Plant _ReceivingPlant $projection.ReceivingPlant = _ReceivingPlant.Plant
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Scheduling Request Order view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SchedulingRunRequestOrderUUID order_uuid
SchedulingRunRequestUUID request_uuid
SchedulingRunUUID run_uuid
SchedulingDocumentNumber doc_no
SchedulingDocumentItem item_no
ScheduleLine schedule_line_no
Material material
Plant plant
ShippingPoint shipping_point
Route route
Customer customer
UnloadingPointName unloading_point
ReceivingPlant receiving_plant
_SchedulingRun _SchedulingRun
_SchedulingRequest _SchedulingRequest
_Material _Material
_Route _Route
_ShippingPoint _ShippingPoint
_Plant _Plant
_ReceivingPlant _ReceivingPlant
_Customer _Customer
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Scheduling Request Order'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_SchedulingRunRequestOrder
  as select from bps_review_order
  association        to parent I_SchedulingRunRequest as _SchedulingRequest on $projection.SchedulingRunRequestUUID = _SchedulingRequest.SchedulingRunRequestUUID
  association [0..1] to I_SchedulingRun               as _SchedulingRun     on $projection.SchedulingRunUUID = _SchedulingRun.SchedulingRunUUID
  association [1..1] to I_Material                    as _Material          on $projection.Material = _Material.Material
  association [1..1] to I_Route                       as _Route             on $projection.Route = _Route.Route
  association [1..1] to I_ShippingPoint               as _ShippingPoint     on $projection.ShippingPoint = _ShippingPoint.ShippingPoint
  association [1..1] to I_Plant                       as _Plant             on $projection.Plant = _Plant.Plant
  association [1..1] to I_Plant                       as _ReceivingPlant    on $projection.ReceivingPlant = _ReceivingPlant.Plant
  association [1..1] to I_Customer                    as _Customer          on $projection.Customer = _Customer.Customer

{
  key order_uuid       as SchedulingRunRequestOrderUUID,
      request_uuid     as SchedulingRunRequestUUID,
      run_uuid         as SchedulingRunUUID,
      doc_no           as SchedulingDocumentNumber,
      item_no          as SchedulingDocumentItem,
      schedule_line_no as ScheduleLine,
      material         as Material,
      plant            as Plant,
      shipping_point   as ShippingPoint,
      route            as Route,
      customer         as Customer,
      unloading_point  as UnloadingPointName,
      receiving_plant  as ReceivingPlant,

      _SchedulingRun,
      _SchedulingRequest,
      _Material,
      _Route,
      _ShippingPoint,
      _Plant,
      _ReceivingPlant,
      _Customer
}