I_NotifActivityCodeGroupText

DDL: I_NOTIFACTIVITYCODEGROUPTEXT SQL: INOTIFACTCDGRTXT Type: view BASIC

Notification Activity Code Group Text

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

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
qpgt qpgt from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName INOTIFACTCDGRTXT 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 NotifActivityCodeGroup view
EndUserText.label Notification Activity Code Group Text view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY NotifActivityCatalog katalogart
KEY NotifActivityCodeGroup codegruppe
KEY Language sprache
NotifActivityCodeGroupText kurztext
_NotifActivityCatalog _NotifActivityCatalog
_NotifActivityCodeGroup _NotifActivityCodeGroup
_Language _Language 
@AbapCatalog.sqlViewName: 'INOTIFACTCDGRTXT'
@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: 'NotifActivityCodeGroup'
}
@EndUserText.label: 'Notification Activity Code Group Text'
@Metadata.ignorePropagatedAnnotations: true
define view I_NotifActivityCodeGroupText as select from qpgt 

    association[1..1] to I_NotifActivityCatalog     as _NotifActivityCatalog on $projection.NotifActivityCatalog = _NotifActivityCatalog.NotifActivityCatalog
    association[1..1] to I_NotifActivityCodeGroup   as _NotifActivityCodeGroup on   $projection.NotifActivityCatalog    = _NotifActivityCodeGroup.NotifActivityCatalog and
                                                                                    $projection.NotifActivityCodeGroup  =  _NotifActivityCodeGroup.NotifActivityCodeGroup
    association[1..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_NotifActivityCatalog'
    key katalogart as NotifActivityCatalog,
    @ObjectModel:{
        foreignKey.association: '_NotifActivityCodeGroup',
        text.element: ['NotifActivityCodeGroupText']
    }
    key codegruppe as NotifActivityCodeGroup,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key sprache as Language,
    
    @Semantics.text: true
    kurztext as NotifActivityCodeGroupText,
    
    _NotifActivityCatalog,
    _NotifActivityCodeGroup,
    _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QPGT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_NOTIFACTIVITYCATALOG",
"I_NOTIFACTIVITYCODEGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More