I_RSHOperationHasCrossOrderRel

DDL: I_RSHOPERATIONHASCROSSORDERREL SQL: IRSHOPHASCROSREL Type: view BASIC

Operations with cross order relationship

I_RSHOperationHasCrossOrderRel is a Basic CDS View that provides data about "Operations with cross order relationship" in SAP S/4HANA. It reads from 1 data source (P_RSHRelationshipSplit) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
P_RSHRelationshipSplit P_RSHRelationshipSplit cross

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRSHOPHASCROSREL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Operations with cross order relationship view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (1)

KeyFieldSource TableSource FieldDescription
HasCrossOrderRelationship 
@AbapCatalog.sqlViewName: 'IRSHOPHASCROSREL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
//@VDM.private: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Operations with cross order relationship'
@AccessControl.personalData.blocking: #NOT_REQUIRED

/*
CONTRACT*************************************************************************************************************************
Name:                       Operation Has Cross Order Relation Determination
Specification:              This view splits the cross order relations to get a distinct list of operation technical keys with 
                            cross order relations. 
Requires:                   NA
Ensures:                    Technical Keys of Operations with Cross Order Relations are returned
Owners:                     CK
Contributors:
Unit Test required Y/N:     Y
Additional comments         Intended only for use in I_RSHOperationAndSubOperation

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

define view I_RSHOperationHasCrossOrderRel 
as select distinct from  I_ProjectNetworkRelationship as _CrossOrderRelationships
     cross join P_RSHRelationshipSplit              // just a table with two records                                                                                                                                                               

{ 

key case P_RSHRelationshipSplit.RelationshipSplit 
    when 1 then _CrossOrderRelationships.PredecessorProjNtwkIntID 
           else _CrossOrderRelationships.SuccessorProjNtwkIntID end          as MaintOrderRoutingNumber,

key case P_RSHRelationshipSplit.RelationshipSplit
    when 1 then _CrossOrderRelationships.PredecessorNtwkActyIntID 
           else _CrossOrderRelationships.SuccessorNtwkActyIntID end          as MaintOrderOperationCounter,

'X' as HasCrossOrderRelationship

}

where _CrossOrderRelationships.ObjectIsDeleted = ' ' 
  and _CrossOrderRelationships.PredecessorProjNtwkIntID <> _CrossOrderRelationships.SuccessorProjNtwkIntID
  
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTNETWORKRELATIONSHIP",
"P_RSHRELATIONSHIPSPLIT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More