I_SponsoredClass

DDL: I_SPONSOREDCLASS SQL: IGMSPCLASSQL Type: view BASIC

Sponsored Class

I_SponsoredClass is a Basic CDS View (Dimension) that provides data about "Sponsored Class" in SAP S/4HANA. It reads from 1 data source (gmspclass) and exposes 12 fields with key field SponsoredClass. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
gmspclass gmspclass from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SponsoredClassType _Type $projection.SponsoredClassType = _Type.SponsoredClassType
[0..*] I_SponsoredClassText _Text $projection.SponsoredClass = _Text.SponsoredClass

Annotations (16)

NameValueLevelField
EndUserText.label Sponsored Class view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey SponsoredClass view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IGMSPCLASSQL view
AbapCatalog.preserveKey true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SponsoredClass sponsored_class
SponsoredClassType class_type
SponsoredClassIsBillable flg_billable
GteeMBdgtTransfObjIsVldtd validate_fmbt
GteeMBdgtAndPostObjIsVldtd validate_fmba
SponsoredClassAuthznGrp auth_group
CreatedByUser created_by
CreationDate created_on
LastChangedByUser modified_by
LastChangeDate modified_on
_Type _Type
_Text _Text 
//Do not use it and use I_SponsoredClassCore

@EndUserText.label: 'Sponsored Class'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'SponsoredClass'
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #L
}
@Metadata.allowExtensions:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IGMSPCLASSQL'
@AbapCatalog.preserveKey:true 
define view I_SponsoredClass
  as select from gmspclass

  association [1..1] to I_SponsoredClassType as _Type on $projection.SponsoredClassType = _Type.SponsoredClassType
  association [0..*] to I_SponsoredClassText as _Text on $projection.SponsoredClass = _Text.SponsoredClass
{

      @ObjectModel.text.association: '_Text'
  key sponsored_class as SponsoredClass,
      @ObjectModel.foreignKey.association: '_Type'
      class_type      as SponsoredClassType,
      flg_billable    as SponsoredClassIsBillable,
      validate_fmbt   as GteeMBdgtTransfObjIsVldtd,
      validate_fmba   as GteeMBdgtAndPostObjIsVldtd,
      auth_group      as SponsoredClassAuthznGrp,
      created_by      as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      created_on      as CreationDate,
      modified_by     as LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      modified_on     as LastChangeDate,

      _Type,
      _Text

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

Learn More