P_RSHOrdOpForImplicitRel

DDL: P_RSHORDOPFORIMPLICITREL SQL: PRSHORDOPIMPREL Type: view CONSUMPTION Package: RSH_CDS_ORD
6 Fields 3 Data Sources 1 Associations

Schedule Operations w/o explicit rel

P_RSHOrdOpForImplicitRel is a Consumption CDS View that provides data about "Schedule Operations w/o explicit rel" in SAP S/4HANA. It reads from 3 data sources (I_OrderOperationBasic, I_LogisticsOrderBasic, I_SchedulingType) and exposes 6 fields with key fields OrderInternalID, OrderOperationInternalID. It has 1 association to related views. Part of development package RSH_CDS_ORD.

Data Sources (3)

SourceAliasJoin Type
I_OrderOperationBasic op inner
I_LogisticsOrderBasic ord from
I_SchedulingType st inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaintOrderOperPlanningValues _OperationPlanningValues op.OrderInternalID = _OperationPlanningValues.MaintOrderRoutingNumber and op.OrderOperationInternalID = _OperationPlanningValues.MaintOrderOperationCounter

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRSHORDOPIMPREL view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Schedule Operations w/o explicit rel view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #META view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderOperationBasic OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
OrderID I_LogisticsOrderBasic OrderID Order ID
Operation I_OrderOperationBasic Operation Transaction
CalcOfCapacityRqmtsIsPerformed I_SchedulingType CalcOfCapacityRqmtsIsPerformed Only Cap.Rqmts.
SchedulingIsPerformedBackward I_SchedulingType SchedulingIsPerformedBackward Backward Sched.

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 P_RSHOrdOpForImplicitRel.
-- 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.
-- SQL view name: PRSHORDOPIMPREL

CREATE VIEW P_RSHOrdOpForImplicitRel AS
SELECT
  op.OrderInternalID AS OrderInternalID,
  op.OrderOperationInternalID AS OrderOperationInternalID,
  ord.OrderID AS OrderID,
  op.Operation AS Operation,
  st.CalcOfCapacityRqmtsIsPerformed AS CalcOfCapacityRqmtsIsPerformed,
  st.SchedulingIsPerformedBackward AS SchedulingIsPerformedBackward
FROM I_LogisticsOrderBasic AS ord
INNER JOIN I_SchedulingType AS st ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS op ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintOrderOperPlanningValues AS _OperationPlanningValues ON op.OrderInternalID = _OperationPlanningValues.MaintOrderRoutingNumber AND op.OrderOperationInternalID = _OperationPlanningValues.MaintOrderOperationCounter  -- association [1..1]
;

Learn More