R_Sitn2ObjStructureCDSVH

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel:{  usageType:{
                            serviceQuality:#C,
                            sizeCategory: #L,
                            dataClass: #MASTER
                           },
                  dataCategory: #VALUE_HELP
             }
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Situation Object Structure'
define view entity R_Sitn2ObjStructureCDSVH

  //CDS views that have a C1 contract (either from SAP or Customers)

  as select from           ARS_APIS_RELEASED_FOR_C1 as apis
    inner join             ddddlsrc  on  apis.tadir_obj_name = ddddlsrc.ddlname
                                     and apis.tadir_object   = 'DDLS'
                                     and apis.object_type    = 'CDS_STOB'
    left outer to one join ddddlsrct on  apis.tadir_obj_name  = ddddlsrct.ddlname
                                     and ddddlsrct.ddlanguage = $session.system_language
{
  key cast ( ddddlsrc.ddlname as ddstrucobjname )                    as SitnObjStrucName,
      cast ( '01' as sit2_de_obj_str_contract_type preserving type ) as SitnObjStrucContractType, // Contract

      ddddlsrct.ddtext                                               as SitnObjStrucDescription
}
where
       ddddlsrc.as4local      = 'A' //Activation state of the object (Entry was activated or generated in this form)

  and(
       ddddlsrc.source_type   = 'V' //View

    or ddddlsrc.source_type   = 'W' //View Entity

    or ddddlsrc.source_type   = 'P' //Projection View

  )
  and  ddddlsrc.parentname    = '' //CDS view is not extension view

  and  ddddlsrc.source_origin = 0 //ABAP Development Tools

  and  apis.state             = 'RELEASED'

union
// CDS views that are part of a release group (Custom CDS builder)

select from              ARS_APIS_RELEASED_C1_OR_GROUPS as apis
  inner join             ddddlsrc  on  apis.tadir_obj_name = ddddlsrc.ddlname
                                   and apis.tadir_object   = 'DDLS'
                                   and apis.object_type    = 'CDS_STOB'
  left outer to one join ddddlsrct on  apis.tadir_obj_name  = ddddlsrct.ddlname
                                   and ddddlsrct.ddlanguage = $session.system_language
{
  key cast ( ddddlsrc.ddlname as ddstrucobjname )                    as SitnObjStrucName,
      cast ( '02' as sit2_de_obj_str_contract_type preserving type ) as SitnObjStrucContractType, // Release group

      ddddlsrct.ddtext                                               as SitnObjStrucDescription
}
where
       ddddlsrc.as4local      = 'A'
  and(
       ddddlsrc.source_type   = 'V'
    or ddddlsrc.source_type   = 'W'
    or ddddlsrc.source_type   = 'P'
  )
  and  ddddlsrc.parentname    = ''
  and  ddddlsrc.source_origin = 1 // Custom View Builder

  and  apis.state             = 'RELEASED' // Views from release group are listed as "released" even though they have no C1 contract


//union

//// CDS views that just have the PUBLIC_LOCAL_API annotation, but no contract

//select from              ddddlsrc

//  inner join             ddheadanno                       on  ddheadanno.strucobjn = ddddlsrc.ddlname

//                                                          and ddheadanno.name      = 'VDM.LIFECYCLE.CONTRACT.TYPE'

//                                                          and ddheadanno.value     = '#PUBLIC_LOCAL_API'

//  left outer to one join ddddlsrct                        on  ddddlsrc.ddlname     = ddddlsrct.ddlname

//                                                          and ddddlsrct.ddlanguage = $session.system_language

//

//  left outer to one join ARS_APIS_RELEASED_FOR_C1 as apis on  apis.tadir_obj_name = ddddlsrc.ddlname

//                                                          and apis.tadir_object   = 'DDLS'

//                                                          and apis.object_type    = 'CDS_STOB'

//                                                          and apis.state          = 'RELEASED'

//

//{

//  key cast ( ddddlsrc.ddlname as ddstrucobjname )                    as SitnObjStrucName,

//      cast ( '03' as sit2_de_obj_str_contract_type preserving type ) as SitnObjStrucContractType, // Annotation (only)

//      ddddlsrct.ddtext                                               as SitnObjStrucDescription

//}

//where

//       ddddlsrc.as4local      = 'A'

//  and(

//       ddddlsrc.source_type   = 'V'

//    or ddddlsrc.source_type   = 'W'

//    or ddddlsrc.source_type   = 'P'

//  )

//  and  ddddlsrc.parentname    = ''

//  and  ddddlsrc.source_origin = 0 // Only ADT, custom view builder does not support header annotations

//  and  apis.state             is null

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARS_APIS_RELEASED_C1_OR_GROUPS",
"ARS_APIS_RELEASED_FOR_C1",
"DDDDLSRC",
"DDDDLSRCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/