I_NOTEBASIC

DDL: I_NOTEBASIC SQL: VINOTEBASIC Type: view BASIC

Notiz zum zugeordneten Objekt

I_NOTEBASIC is a Basic CDS View that provides data about "Notiz zum zugeordneten Objekt" in SAP S/4HANA. It reads from 1 data source (sgbt_nte_cont) and exposes 13 fields with key field NoteBasicUUID. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
sgbt_nte_cont sgbt_nte_cont from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_NOTEBASICATTRIBUTE _notebasicattribute _notebasicattribute.NoteBasicUUID = $projection.NoteBasicUUID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VINOTEBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Notiz zum zugeordneten Objekt view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY NoteBasicUUID noteid
NoteBasicObjectNodeType objectnodetype
NoteBasicObject objectid
NoteBasicType notetype
NoteBasicLanguage langu
NoteBasicTitle title
NoteBasicMIMEType mimetype
NoteBasicLength length
NoteBasicCreatedByUser creator
NoteBasicCreationDateTime created
NoteBasicChangedByUser changer
NoteBasicChangeDateTime changed
NoteBasicContent content 
@AbapCatalog.sqlViewName: 'VINOTEBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Notiz zum zugeordneten Objekt'
@VDM.viewType: #BASIC
define view I_NOTEBASIC
  as select from sgbt_nte_cont
  association [1..*] to I_NOTEBASICATTRIBUTE as _notebasicattribute on _notebasicattribute.NoteBasicUUID = $projection.NoteBasicUUID
{
  key noteid         as NoteBasicUUID,
      objectnodetype as NoteBasicObjectNodeType,
      objectid       as NoteBasicObject,
      notetype       as NoteBasicType,
      langu          as NoteBasicLanguage,
      title          as NoteBasicTitle,
      mimetype       as NoteBasicMIMEType,
      length         as NoteBasicLength,
      creator        as NoteBasicCreatedByUser,
      created        as NoteBasicCreationDateTime,
      changer        as NoteBasicChangedByUser,
      changed        as NoteBasicChangeDateTime,
      content        as NoteBasicContent,
      _notebasicattribute
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SGBT_NTE_CONT"
],
"ASSOCIATED":
[
"I_NOTEBASICATTRIBUTE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More