DDCDS_BOE_OBJINFO_PROCESSING_1

@AbapCatalog.sqlViewName: 'DDCDSBOEOBJINFO1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Object Information Processing Level 1'
define view DDCDS_BOE_OBJINFO_PROCESSING_1
  as select distinct from DDCDS_BOE_FUNCTION_INPUT
    left outer join       DDCDS_BOE_VALIDITY_TF      as dep_f        on dep_f.view_name = function_input_c
    left outer join       DDCDS_BOE_VALIDITY_TF      as baseobj_f       on baseobj_f.view_name = function_input_p
    left outer join       DDCDS_BOE_SYNONYM_INFO_TF  as p_syncheck     on baseobj_name = p_syncheck.synonym_name
    left outer join       DDCDS_BOE_CHECK_OBJTYPE_TF as checkobjtype_c on dep_name = checkobjtype_c.object_name
    left outer join       DDCDS_BOE_CHECK_OBJTYPE_TF as checkobjtype_p on baseobj_name = checkobjtype_p.object_name
    left outer join       DDL_OBJECT_NAMES       as dep_ddlname  on dep_ddlname.CDS_ENTITY = dep_name
    left outer join       DDL_OBJECT_NAMES       as baseobj_ddlname on baseobj_ddlname.CDS_ENTITY = baseobj_name
  association [*] to DDCDS_BOE_OBJINFO_PROCESSING_1 as _Parent on $projection.dep_name = _Parent.baseobj_name
{


  key dep_name,
  key dep_ddlname.CDS_DDL  as dep_ddl,
  key case
    when dep_objtype is null then checkobjtype_c.object_type
    else dep_objtype end   as dep_objtype,
      //dep_f

  key dep_f.is_valid       as dep_is_valid,
  key baseobj_name,
  key baseobj_ddlname.CDS_DDL as baseobj_ddl,
  key case
    when baseobj_objtype is null then checkobjtype_p.object_type
    else baseobj_objtype end  as baseobj_objtype,
      //baseobj_f

  key baseobj_f.is_valid      as baseobj_is_valid,
      p_syncheck.synonym_name,
      p_syncheck.syn_is_valid,
      p_syncheck.object_name,
      p_syncheck.obj_is_valid,

      _Parent

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDCDS_BOE_FUNCTION_INPUT",
"DDL_OBJECT_NAMES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/