I_SponsoredProgramCore

@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:['_SponsoredProgHierarchyNode','_CreatedByUser','_LastChangedByUser'] 
@ObjectModel.representativeKey: 'SponsoredProgram'
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #L
}
@Metadata.allowExtensions:true
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.compiler.compareFilter: true
@Analytics.internalName:#LOCAL
@AbapCatalog.preserveKey:true
@AbapCatalog.sqlViewName: 'IGMSPPROGCL'
@EndUserText.label: 'Sponsored Program'
define view I_SponsoredProgramCore
  as select from gmspprogram

  association [0..*] to I_SponsoredProgHierarchyNode as _SponsoredProgHierarchyNode on $projection.SponsoredProgram = _SponsoredProgHierarchyNode.SponsoredProgram

  association [0..*] to I_SponsoredProgramTextCore   as _Text                       on $projection.SponsoredProgram = _Text.SponsoredProgram

  association [0..1] to I_User                       as _CreatedByUser              on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                       as _LastChangedByUser          on $projection.LastChangedByUser = _LastChangedByUser.UserID

  association [1..1] to E_SponsoredProgramCore       as _Extension //do not expose this association in the projection list of the view

                                                                                    on $projection.SponsoredProgram = _Extension.SponsoredProgram
{
      @ObjectModel.text.association: '_Text'
      @ObjectModel.hierarchy.association: '_SponsoredProgHierarchyNode'
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key sponsored_prog as SponsoredProgram,

      created_by     as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      created_on     as CreationDate,
      modified_by    as LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      modified_on    as LastChangeDate,

      auth_group     as SponsoredProgramAuthznGrp,
      _Text,
      _SponsoredProgHierarchyNode,
      _CreatedByUser,
      _LastChangedByUser
}