I_NotifActivityCodeText

DDL: I_NOTIFACTIVITYCODETEXT SQL: INOTIFACTCDTXT Type: view BASIC

Notification Activity Code Text

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

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
qpct qpct from

Annotations (14)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY NotifActivityCatalog katalogart
KEY NotifActivityCodeGroup codegruppe
KEY NotifActivityCode code
KEY Language sprache
NotifActivityCodeText kurztext
_NotifActivityCatalog _NotifActivityCatalog
_NotifActivityCodeGroup _NotifActivityCodeGroup
_NotifActivityCode _NotifActivityCode
_Language _Language 
@AbapCatalog.sqlViewName: 'INOTIFACTCDTXT'
@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: 'NotifActivityCode'
}
@EndUserText.label: 'Notification Activity Code Text'
@Metadata.ignorePropagatedAnnotations: true
define view I_NotifActivityCodeText as select from qpct 

    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_NotifActivityCode        as _NotifActivityCode   on  $projection.NotifActivityCatalog = _NotifActivityCode.NotifActivityCatalog and
                                                                                $projection.NotifActivityCodeGroup = _NotifActivityCode.NotifActivityCodeGroup and
                                                                                $projection.NotifActivityCode = _NotifActivityCode.NotifActivityCode
    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'
    key codegruppe  as NotifActivityCodeGroup,
    @ObjectModel:{
        foreignKey.association: '_NotifActivityCode'
    }
    key code        as NotifActivityCode,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key sprache     as Language,
    
    @Semantics.text: true
    kurztext        as NotifActivityCodeText,
    
    _NotifActivityCatalog,
    _NotifActivityCodeGroup,
    _NotifActivityCode,
    _Language
    
} where qpct.version = '000001'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QPCT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_NOTIFACTIVITYCATALOG",
"I_NOTIFACTIVITYCODE",
"I_NOTIFACTIVITYCODEGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More