P_RSHOperationExplicitRelation

DDL: P_RSHOPERATIONEXPLICITRELATION SQL: PRSHOPEREXPLREL Type: view CONSUMPTION

Operations with explicit Relations

P_RSHOperationExplicitRelation is a Consumption CDS View that provides data about "Operations with explicit Relations" in SAP S/4HANA. It reads from 3 data sources (I_ProjectNetworkRelationship, I_MaintenanceOrderOperation, I_MaintenanceOrderOperation) and exposes 12 fields with key fields PredecessorOrder, PredecessorOperation, SuccessorOrder, SuccessorOperation, RelationType.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
I_ProjectNetworkRelationship I_ProjectNetworkRelationship from
I_MaintenanceOrderOperation pred inner
I_MaintenanceOrderOperation succ inner

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PRSHOPEREXPLREL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Operations with explicit Relations view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #META view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PredecessorOrder I_MaintenanceOrderOperation MaintenanceOrder
KEY PredecessorOperation I_MaintenanceOrderOperation MaintenanceOrderOperation
KEY SuccessorOrder I_MaintenanceOrderOperation MaintenanceOrder
KEY SuccessorOperation I_MaintenanceOrderOperation MaintenanceOrderOperation
KEY RelationType NetworkActivityRelationType
OffsetDuration NetworkActivityIntmsnDuration
OffsetDurationUnit NetworkActivityIntmsnDurnUnit
isExplicitRelationship
PredMaintOrderRoutingNumber PredecessorProjNtwkIntID
PredMaintOrderOperationCounter PredecessorNtwkActyIntID
SuccMaintOrderRoutingNumber SuccessorProjNtwkIntID
SuccMaintOrderOperationCounter SuccessorNtwkActyIntID 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PRSHOPEREXPLREL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Operations with explicit Relations'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #META

/*
CONTRACT**********************************************************************************************************************

Name:                       Operations with Explicit Relationships
Specification:              This view provides Operations which have explicit relationships
Requires:                   NA
Ensures:                    Operations with explicit Relationships are returned for operations
                            Deleted Relationships are not considered.
Owners:                     TP
Contributors:               TP
Unit Test required Y/N:     Y
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/

define view P_RSHOperationExplicitRelation

  as select from I_ProjectNetworkRelationship

    inner join   I_MaintenanceOrderOperation as pred on  PredecessorProjNtwkIntID = pred.MaintOrderRoutingNumber
                                                     and PredecessorNtwkActyIntID = pred.MaintOrderOperationCounter

    inner join   I_MaintenanceOrderOperation as succ on  SuccessorProjNtwkIntID = succ.MaintOrderRoutingNumber
                                                     and SuccessorNtwkActyIntID = succ.MaintOrderOperationCounter

//    inner join   I_MaintOrderOperAndSubOper as pred on  PredecessorProjNtwkIntID = pred.MaintOrderRoutingNumber

//                                                    and PredecessorNtwkActyIntID = pred.MaintOrderOperationCounter

//

//    inner join   I_MaintOrderOperAndSubOper as succ on  SuccessorProjNtwkIntID = succ.MaintOrderRoutingNumber

//                                                    and SuccessorNtwkActyIntID = succ.MaintOrderOperationCounter


{

  key pred.MaintenanceOrder          as PredecessorOrder,
  key pred.MaintenanceOrderOperation as PredecessorOperation,

  key succ.MaintenanceOrder          as SuccessorOrder,
  key succ.MaintenanceOrderOperation as SuccessorOperation,

  key NetworkActivityRelationType    as RelationType,

      NetworkActivityIntmsnDuration  as OffsetDuration,
      NetworkActivityIntmsnDurnUnit  as OffsetDurationUnit,

      case when PredecessorProjNtwkIntID <> SuccessorProjNtwkIntID
           then 'X'
           else '' end               as isCrossOrderRelationship,

      'X'                            as isExplicitRelationship,

      PredecessorProjNtwkIntID       as PredMaintOrderRoutingNumber,
      PredecessorNtwkActyIntID       as PredMaintOrderOperationCounter,
      SuccessorProjNtwkIntID         as SuccMaintOrderRoutingNumber,
      SuccessorNtwkActyIntID         as SuccMaintOrderOperationCounter

}
where
  I_ProjectNetworkRelationship.ObjectIsDeleted = ' '

Learn More