Ehenv_Scen_Usr_Active

@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'EHENVV_SCEN_USRA'
//Commented by VDM CDS Suite Plugin:@ClientDependent: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Active Scenarios for a User'

//CDS View Performance annotation

@ObjectModel.usageType:{ serviceQuality: #B,        // < 2 msec

                         sizeCategory:  #S,         // < 1.000

                         dataClass: #MASTER }

define view Ehenv_Scen_Usr_Active
  with parameters p_date:abap.dats,
                  p_role:abap.char(30),
                  p_uname:abap.char(13)
as select from ehfndd_loc_rev as revision
  inner join ehfndd_loc_resp as Ehfndd_loc_resp_uname
  on Ehfndd_loc_resp_uname.person_id = $parameters.p_uname and
     Ehfndd_loc_resp_uname.role = $parameters.p_role and
     Ehfndd_loc_resp_uname.parent_key = revision.db_key 
  left outer join ehenvd_scen_root as Scen_root
  on Scen_root.loc_root_key_ref = revision.parent_key and
     Scen_root.valid_from <= $parameters.p_date and
     Scen_root.status = '01'
{
  Scen_root.db_key as scen_key,
  Scen_root.valid_from as valid_from,
  Scen_root.valid_to as valid_to,
  revision.db_key as rev_key,
  revision.parent_key as loc_key,
  revision.type as type,
  revision.status as status,
  revision.auth_group as auth_group,
  revision.plant_id as plant_id,
  revision.cost_center as const_center,
  revision.company_code as company_code,
  revision.buss_area as buss_area
}

where revision.split_date <= $parameters.p_date    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHENVD_SCEN_ROOT",
"EHFNDD_LOC_RESP",
"EHFNDD_LOC_REV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/