I_OIJ06_RECENT_EVENT

CDS View

Nomination recent events

I_OIJ06_RECENT_EVENT is a CDS View in S/4HANA. Nomination recent events. It contains 3 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 3 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_Oij06_Recent_Events view from CONSUMPTION Recent Events
I_NominationAnalysisPath view left_outer BASIC View for APF Nominations
I_Oij06_My_Nominations view left_outer COMPOSITE My Nominations
I_Oij06_Myeventss1_Object view left_outer BASIC Mass Change Events - events interface view
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization

Fields (3)

KeyField CDS FieldsUsed in Views
NominationEventChangedDate NominationEventChangedDate 2
NominationEventChangedTime NominationEventChangedTime 2
NominationEventType NominationEventType 2 
@AbapCatalog.sqlViewName: 'IOIJ06_REVENTS'
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.type: #INHERITED 
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Nomination recent events'
define view I_Oij06_Recent_Event
  as select from oijne              as e
    inner join  I_Oij06_Max_Events as m on  e.nomtk    = m.NominationDoc
                                         and e.nomit    = m.NominationDocItem 
                                         and (e.cre_date = m.NominationEventChangedDate or 
                                         e.cha_date = m.NominationEventChangedDate)                                         
                                       and (e.cre_time = m.NominationEventChangedTime or 
                                         e.cha_time = m.NominationEventChangedTime)
                                        and e.event_nr = m.NominationEventNumber                                     
                                      
{
//  cha_date       as NominationEventChangedDate,

//  cha_time       as NominationEventChangedTime,

  m.NominationEventChangedDate as NominationEventChangedDate,
  m.NominationEventChangedTime as NominationEventChangedTime,
  nomtk          as NominationDoc,
  nomit          as NominationDocItem,
  max(e.event_nr)       as NominationEventNumber,
 // type           as NominationEventType

  
//} 

  ( case when type = ' ' then 'blank' else type end ) as NominationEventType
} 
where e.updflag != 'L'
group by
NominationEventChangedDate,
NominationEventChangedTime,
nomtk,
nomit, 
type,
NominationEventNumber



  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OIJ06_MAX_EVENTS",
"OIJNE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More