P_SGBT_NTE_CDS_APITP

DDL: P_SGBT_NTE_CDS_APITP SQL: PSGBTNTECDSAPITP Type: view CONSUMPTION Package: ODATA_MM_PUR_CCTRMASS_UPDATE
17 Fields 1 Data Sources 2 Associations

Private View for Notes

P_SGBT_NTE_CDS_APITP is a Consumption CDS View that provides data about "Private View for Notes" in SAP S/4HANA. It reads from 1 data source (Sgbt_Nte_Cds_Cont) and exposes 17 fields with key field NoteID. It has 2 associations to related views. Part of development package ODATA_MM_PUR_CCTRMASS_UPDATE.

Data Sources (1)

SourceAliasJoin Type
Sgbt_Nte_Cds_Cont NoteContent from

Associations (2)

CardinalityTargetAliasCondition
[1..1] Sgbt_Nte_Cds_Ntype NoteTypeDef $projection.NoteType = NoteTypeDef.Name
[1..1] Sgbt_Nte_Cds_Langu LanguageDef $projection.Language = LanguageDef.LanguageISOCode

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSGBTNTECDSAPITP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Private View for Notes view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY NoteID Sgbt_Nte_Cds_Cont noteid Unique ID
ObjectNodeType Sgbt_Nte_Cds_Cont objectnodetype SAP Obj Node Type
ObjectID Sgbt_Nte_Cds_Cont objectid Object Value
NoteType Sgbt_Nte_Cds_Cont notetype Topic
NoteTypeDef NoteTypeDef
Language Sgbt_Nte_Cds_Cont langu Primary lang.
LanguageCode LanguageDef LanguageCode Language Key
LanguageDef LanguageDef
Title Sgbt_Nte_Cds_Cont title View Title
MimeType Sgbt_Nte_Cds_Cont mimetype MIMETYPE
Length Sgbt_Nte_Cds_Cont length Text Length
Creator Sgbt_Nte_Cds_Cont creator User ID
Created Sgbt_Nte_Cds_Cont created UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
LastChanger Sgbt_Nte_Cds_Cont changer Last Changed By
LastChanged Sgbt_Nte_Cds_Cont changed Time Stamp
Content Sgbt_Nte_Cds_Cont content Trusted Site Content
Profile NoteTypeDef Profile WBS sched. prof

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 P_SGBT_NTE_CDS_APITP.
-- 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: PSGBTNTECDSAPITP

CREATE VIEW P_SGBT_NTE_CDS_APITP AS
SELECT
  NoteContent.noteid AS NoteID,
  NoteContent.objectnodetype AS ObjectNodeType,
  NoteContent.objectid AS ObjectID,
  NoteContent.notetype AS NoteType,
  NoteTypeDef,
  NoteContent.langu AS Language,
  LanguageDef.LanguageCode AS LanguageCode,
  LanguageDef,
  NoteContent.title AS Title,
  NoteContent.mimetype AS MimeType,
  NoteContent.length AS Length,
  NoteContent.creator AS Creator,
  NoteContent.created AS Created,
  NoteContent.changer AS LastChanger,
  NoteContent.changed AS LastChanged,
  NoteContent.content AS Content,
  NoteTypeDef.Profile AS Profile
FROM Sgbt_Nte_Cds_Cont AS NoteContent
LEFT OUTER JOIN Sgbt_Nte_Cds_Ntype AS NoteTypeDef ON NoteType = NoteTypeDef.Name  -- association [1..1]
LEFT OUTER JOIN Sgbt_Nte_Cds_Langu AS LanguageDef ON Language = LanguageDef.LanguageISOCode  -- association [1..1]
;

Learn More