I_RSHOperationStatusObject

@AbapCatalog.sqlViewName: 'IRSHOPSTATOBJ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Status Object and Codes for PM Operations'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

/*
CONTRACT*********************************************************************************************************************************
Name:                       Status Objects and Status Codes for PM Operations
Specification:              This view will retrieve all Status Object equivalent for all PM Operations along with all active Status Codes
Requires:                   NA
Ensures:                    Status Object equivalent for all PM Operations along with all their Status Codes are returned. 
                            Inactive Status Codes are ignored.
Owners:                     PRP
Contributors:
Unit Test required Y/N:     Y
Additional comments         Created based on the original view I_StatusObjectStatusBasic. But only PM Operations (Object type 'OVG')
                            are retrieved in the current view, considering the expected performance gains.
                            
END OF CONTRACT**************************************************************************************************************************
*/

define view I_RSHOperationStatusObject as select from jest 
    inner join jsto on jest.objnr = jsto.objnr

{

  key jest.objnr as StatusObject,
  
  key jest.stat  as StatusCode
  
}

where jest.inact = '' and 

/* START TEMPORARY VERSION for PERF TEST ------------------------------------------------------------------------------------------------------------------------ */
      ( jest.stat = 'I0010' or 
        jest.stat = 'I0117' or 
        jest.stat = 'I0002' or 
        jest.stat = 'I0001' or 
        jest.stat = 'I0045' or 
        jest.stat = 'I0009' or 
        jest.stat = 'I0046' or 
        jest.stat = 'I0013' or 
        jest.stat = 'I0043')
/* END TEMPORARY VERSION for PERF TEST -------------------------------------------------------------------------------------------------------------------------- */ 
      
     and jsto.obtyp = 'OVG'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"JEST",
"JSTO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/