P_ServiceOrderBpfSuccssr

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BPF for Succssr Service Transactions'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@VDM.private: true
@VDM: {
  viewType: #COMPOSITE
}
define view entity P_ServiceOrderBpfSuccssr
  as select from C_SrvcDocDocumentFlow        as _ServiceOrder
    inner join   I_ServiceDocumentPredecessor as _SuccessorPredeccessor on  _ServiceOrder.SrvcMgmtObjectUUID                      = _SuccessorPredeccessor.ServiceDocumentUUID
                                                                        and _ServiceOrder.ServiceDocumentRelationUUID             = _SuccessorPredeccessor.ServiceDocumentRelationUUID
                                                                        and _ServiceOrder.ReltdSrvcDocIsPredecessor               = ' '
                                                                        and _SuccessorPredeccessor.ServiceDocumentPredecessorUUID is not null
{
  key _ServiceOrder.ServiceDocument,
  key _ServiceOrder.ServiceDocumentRelationUUID,
  key _ServiceOrder.CustMgmtPrdcssrTransactionKey,
      _ServiceOrder.ServiceOrder,
      _ServiceOrder.SrvcMgmtObjectUUID,
      _SuccessorPredeccessor._ServiceDoc.ServiceDocument as PrecedingDocument,
      _SuccessorPredeccessor.ServiceDocPrdcssrBusObjType as PrecedingDocumentCategory,
      _ServiceOrder.CustMgmtPrdcssrTransactionKey        as SubsequentDocument,
      _ServiceOrder.PrdcssrSuccssrDocObjectType          as SubsequentDocumentCategory
      //      _SuccessorPredeccessor.ServiceDocumentPredecessorUUID as ServiceDocumentSuccessorUUID, //Not Required

      //      _ServiceOrder.ServiceObjectType //Not Required



}
where
       _ServiceOrder.ReltdSrvcDocIsPredecessor   = ' '
  and(
       _ServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000116'
    or _ServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000117'
    or _ServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000172'
    or _ServiceOrder.PrdcssrSuccssrDocObjectType = 'VBRK'
  )


union select from C_SrvcDocDocumentFlow        as _ServiceOrder
  inner join      I_ServiceDocumentPredecessor as _SuccessorPredeccessor on  _ServiceOrder.SrvcMgmtObjectUUID                      = _SuccessorPredeccessor.ServiceDocumentUUID
                                                                         and _ServiceOrder.ServiceDocumentRelationUUID             = _SuccessorPredeccessor.ServiceDocumentRelationUUID
                                                                         and _ServiceOrder.ReltdSrvcDocIsPredecessor               = ' '
                                                                         and _SuccessorPredeccessor.ServiceDocumentPredecessorUUID is null
{
  key _ServiceOrder.ServiceDocument,
  key _ServiceOrder.ServiceDocumentRelationUUID,
  key _ServiceOrder.CustMgmtPrdcssrTransactionKey,
      _ServiceOrder.ServiceOrder,
      _ServiceOrder.SrvcMgmtObjectUUID,
      // as PrecedingDocument,

      //_ServiceOrder.PrdcssrSuccssrDocObjectType as PrecedingDocumentCategory,

      substring(_SuccessorPredeccessor.CustMgmtPrdcssrTransactionKey, 1, 10) as PrecedingDocument,
      _SuccessorPredeccessor.ServiceDocPrdcssrBusObjType                     as PrecedingDocumentCategory,
      _ServiceOrder.CustMgmtPrdcssrTransactionKey                            as SubsequentDocument,
      _ServiceOrder.PrdcssrSuccssrDocObjectType                              as SubsequentDocumentCategory
      //      _SuccessorPredeccessor.ServiceDocumentPredecessorUUID                  as ServiceDocumentSuccessorUUID, //Not Required

      //      _ServiceOrder.ServiceObjectType //Not Required



}
where
       _ServiceOrder.ReltdSrvcDocIsPredecessor   = ' '
  and(
       _ServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000116'
    or _ServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000117'
    or _ServiceOrder.PrdcssrSuccssrDocObjectType = 'BUS2000172'
    or _ServiceOrder.PrdcssrSuccssrDocObjectType = 'VBRK'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_SRVCDOCDOCUMENTFLOW",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTPREDECESSOR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/