How many fields does P_RSHOrdOpForImplicitRel have?

P_RSHOrdOpForImplicitRel has 6 fields. Key fields: OrderInternalID, OrderOperationInternalID.

P_RSHOrdOpForImplicitRel

Q: Which tables does P_RSHOrdOpForImplicitRel use?

P_RSHOrdOpForImplicitRel reads from 3 data source(s): I_OrderOperationBasic, I_LogisticsOrderBasic, I_SchedulingType.

DDL: P_RSHORDOPFORIMPLICITREL SQL: PRSHORDOPIMPREL Type: view CONSUMPTION

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.

Data Sources (3)

Source	Alias	Join Type
I_OrderOperationBasic	op	inner
I_LogisticsOrderBasic	ord	from
I_SchedulingType	st	inner

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_MaintOrderOperPlanningValues	_OperationPlanningValues	`op.OrderInternalID = _OperationPlanningValues.MaintOrderRoutingNumber and op.OrderOperationInternalID = _OperationPlanningValues.MaintOrderOperationCounter`

Annotations (11)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
KEY	OrderInternalID	I_OrderOperationBasic	OrderInternalID
KEY	OrderOperationInternalID	I_OrderOperationBasic	OrderOperationInternalID
	OrderID	I_LogisticsOrderBasic	OrderID
	Operation	I_OrderOperationBasic	Operation
	CalcOfCapacityRqmtsIsPerformed	I_SchedulingType	CalcOfCapacityRqmtsIsPerformed
	SchedulingIsPerformedBackward	I_SchedulingType	SchedulingIsPerformedBackward

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

define view P_RSHOrdOpForImplicitRel
  as select from           I_LogisticsOrderBasic      as ord

    inner join             I_SchedulingType           as st           on ord.BasicSchedulingType = st.SchedulingType // and

  //                                              st.CalcOfCapacityRqmtsIsPerformed = ''  -> check is done in DPC EXT, to show expl. relationships for this scheduling type


  // do not consider sub-operations

    inner join             I_OrderOperationBasic      as op           on  ord.OrderInternalID            = op.OrderInternalID
                                                                      and op.SuperiorOperationInternalID = '00000000'


    left outer to one join I_RSHOperationStatusObject as _OpIsDeleted on  _OpIsDeleted.StatusObject = op.ObjectInternalID
                                                                      and _OpIsDeleted.StatusCode   = 'I0013'


  // add dates/times for relationship violation determination

  association [1..1] to I_MaintOrderOperPlanningValues as _OperationPlanningValues on  op.OrderInternalID          = _OperationPlanningValues.MaintOrderRoutingNumber
                                                                                   and op.OrderOperationInternalID = _OperationPlanningValues.MaintOrderOperationCounter
  //

{

  key op.OrderInternalID,
  key op.OrderOperationInternalID,

      ord.OrderID,
      op.Operation,

      st.CalcOfCapacityRqmtsIsPerformed,
      st.SchedulingIsPerformedBackward,

      case when  st.SchedulingIsPerformedBackward = 'X'
           then _OperationPlanningValues.OpLtstSchedldExecStrtDte
           else _OperationPlanningValues.OpErlstSchedldExecStrtDte  end as PlannedStartDate,

      case when  st.SchedulingIsPerformedBackward = 'X'
           then _OperationPlanningValues.OpLtstSchedldExecStrtTme
           else _OperationPlanningValues.OpErlstSchedldExecStrtTme  end as PlannedStartTime,

      case when  st.SchedulingIsPerformedBackward = 'X'
           then _OperationPlanningValues.OpLtstSchedldExecEndDte
           else _OperationPlanningValues.OpErlstSchedldExecEndDte   end as PlannedEndDate,

      case when  st.SchedulingIsPerformedBackward = 'X'
           then _OperationPlanningValues.OpLtstSchedldExecEndTme
           else _OperationPlanningValues.OpErlstSchedldExecEndTme   end as PlannedEndTime


}
where
  _OpIsDeleted.StatusObject is null

Depth:

P_RSHOrdOpForImplicitRel view