I_InhRepairTransactionRelation

@EndUserText.label: 'Relationship between Service Transactions'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@ObjectModel: {
  usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
  sqlViewName: 'IIHRTRANSACRLTN',
  compiler.compareFilter: true,
  preserveKey: true
}

define view I_InhRepairTransactionRelation

  as select from I_CustMgmtTransactionRelation

  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_ServiceDocument   as _PredecessorServiceTransaction on  $projection.CustMgmtPrdcssrTransactionUUID = _PredecessorServiceTransaction.ServiceDocumentUUID
                                                                              and $projection.CustMgmtPrdcssrTransacObjType  = _PredecessorServiceTransaction.ServiceObjectType
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_ServiceDocument   as _SuccessorServiceTransaction   on  $projection.CustMgmtSuccssrTransactionUUID = _SuccessorServiceTransaction.ServiceDocumentUUID
                                                                              and $projection.CustMgmtSuccssrTransacObjType  = _SuccessorServiceTransaction.ServiceObjectType
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [0..1] to I_InHouseRepairItem as _InHouseRepairItem             on  $projection.CustMgmtPrdcssrTransactionUUID = _InHouseRepairItem.InHouseRepairItemUUID
                                                                              and $projection.CustMgmtPrdcssrTransacObjType  = _InHouseRepairItem.InhRepairItemObjectType
                                                                              and $projection.CustMgmtPrdcssrTransacObjType  = 'BUS2000257'

  association [0..1] to I_CustomerReturnEnhanced as _PredecessorCustomerReturn on $projection.CustMgmtPrdcssrTransactionKey = _PredecessorCustomerReturn.CustomerReturn
  association [0..1] to I_OutboundDelivery as _OutboundDelivery on $projection.CustMgmtSuccssrTransactionKey = _OutboundDelivery.OutboundDelivery
{
  key CustMgmtTransacRelationUUID,
      CustMgmtPrdcssrTransactionUUID,
      CustMgmtPrdcssrTransacObjType,
      CustMgmtSuccssrTransactionUUID,
      CustMgmtSuccssrTransactionKey,
      CustMgmtSuccssrTransacObjType,
      CustMgmtTransacRelationType,

      //Return Order Changes

      CustMgmtPrdcssrTransactionKey, 
      
      
      // Associations

      _PredecessorServiceTransaction,
      _SuccessorServiceTransaction,
      _InHouseRepairItem,
      
      _PredecessorCustomerReturn,      
      _OutboundDelivery
}