Sgbt_Nte_Cds_Cont

DDL: SGBT_NTE_CDS_CONT SQL: V_NTE_CDS_CONT Type: view BASIC
13 Fields 1 Data Sources 1 Associations

CDS View für Notizen am Anwendungsobjekt

Sgbt_Nte_Cds_Cont is a Basic CDS View that provides data about "CDS View für Notizen am Anwendungsobjekt" in SAP S/4HANA. It reads from 1 data source (sgbt_nte_cont) and exposes 13 fields with key field noteid. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
sgbt_nte_cont NoteContent from

Associations (1)

CardinalityTargetAliasCondition
[0..*] sgbt_nte_cds_attr _attr $projection.noteid = _attr.Noteid

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_NTE_CDS_CONT view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View für Notizen am Anwendungsobjekt view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY noteid sgbt_nte_cont noteid Unique ID
objectid sgbt_nte_cont objectid Object Value
notetype sgbt_nte_cont notetype Topic
langu sgbt_nte_cont langu Primary lang.
title sgbt_nte_cont title View Title
mimetype sgbt_nte_cont mimetype MIMETYPE
length sgbt_nte_cont length Text Length
creator sgbt_nte_cont creator User ID
created sgbt_nte_cont created UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
changer sgbt_nte_cont changer Last Changed By
changed sgbt_nte_cont changed Time Stamp
content sgbt_nte_cont content Trusted Site Content
_attr _attr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view Sgbt_Nte_Cds_Cont.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: V_NTE_CDS_CONT

CREATE VIEW Sgbt_Nte_Cds_Cont AS
SELECT
  NoteContent.noteid AS noteid,
  NoteContent.objectid AS objectid,
  NoteContent.notetype AS notetype,
  NoteContent.langu AS langu,
  NoteContent.title AS title,
  NoteContent.mimetype AS mimetype,
  NoteContent.length AS length,
  NoteContent.creator AS creator,
  NoteContent.created AS created,
  NoteContent.changer AS changer,
  NoteContent.changed AS changed,
  NoteContent.content AS content
FROM sgbt_nte_cont AS NoteContent
LEFT OUTER JOIN sgbt_nte_cds_attr AS _attr ON noteid = _attr.Noteid  -- association [0..*]
;

Learn More