I_SchedulingRunRequestOrder
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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| bps_review_order | bps_review_order | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BPS_REVIEW_ORDER"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_MATERIAL",
"I_PLANT",
"I_ROUTE",
"I_SCHEDULINGRUN",
"I_SCHEDULINGRUNREQUEST",
"I_SHIPPINGPOINT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA