I_NotificationCodeGroupText

DDL: I_NOTIFICATIONCODEGROUPTEXT SQL: INOTIFCDGRTXT Type: view BASIC

Notification Code Group Text

I_NotificationCodeGroupText is a Basic CDS View that provides data about "Notification Code Group Text" in SAP S/4HANA. It reads from 1 data source (qpgt) and exposes 7 fields with key fields NotificationCatalog, NotificationCodeGroup, Language.

Data Sources (1)

SourceAliasJoin Type
qpgt qpgt from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName INOTIFCDGRTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey NotificationCodeGroup view
EndUserText.label Notification Code Group Text view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY NotificationCatalog katalogart
KEY NotificationCodeGroup codegruppe
KEY Language sprache
NotificationCodeGroupText kurztext
_NotificationCatalog _NotificationCatalog
_NotificationCodeGroup _NotificationCodeGroup
_Language _Language
@AbapCatalog.sqlViewName: 'INOTIFCDGRTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE 
@VDM: {
    viewType:#BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}

@ObjectModel:{
    usageType:{
        dataClass: #CUSTOMIZING,
        serviceQuality: #A,
        sizeCategory: #S
    },
    dataCategory: #TEXT,
    representativeKey: 'NotificationCodeGroup'
}
@EndUserText.label: 'Notification Code Group Text'
@Metadata.ignorePropagatedAnnotations: true
define view I_NotificationCodeGroupText as select from qpgt 

    association[1..1] to I_NotificationCatalog as _NotificationCatalog on $projection.NotificationCatalog = _NotificationCatalog.NotificationCatalog
    association[1..1] to I_NotificationCodeGroup as _NotificationCodeGroup on  $projection.NotificationCatalog = _NotificationCodeGroup.NotificationCatalog and
                                                                               $projection.NotificationCodeGroup =  _NotificationCodeGroup.NotificationCodeGroup
    association[1..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_NotificationCatalog'
    key katalogart as NotificationCatalog,
    @ObjectModel:{
        foreignKey.association: '_NotificationCodeGroup',
        text.element: ['NotificationCodeGroupText']
    }
    key codegruppe as NotificationCodeGroup,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key sprache as Language,
    
    @Semantics.text: true
    kurztext as NotificationCodeGroupText,
       
    _NotificationCatalog,
    _NotificationCodeGroup,
    _Language
    
}