I_NoteBasicTP

DDL: I_NOTEBASICTP Type: view_entity TRANSACTIONAL Package: S_GBT_NTE_REUSE_RAP

Interface-View für die Notizen

I_NoteBasicTP is a Transactional CDS View that provides data about "Interface-View für die Notizen" in SAP S/4HANA. It reads from 1 data source (R_NoteBasicTP) and exposes 18 fields with key field NoteBasicUUID. Part of development package S_GBT_NTE_REUSE_RAP.

Data Sources (1)

SourceAliasJoin Type
R_NoteBasicTP R_NoteBasicTP projection

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface-View für die Notizen view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
ObjectModel.sapObjectNodeType.name NoteBasic view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY NoteBasicUUID NoteBasicUUID Note ID
NoteBasicObjectNodeType NoteBasicObjectNodeType SAP Object Type
NoteBasicObject NoteBasicObject Object ID
NoteBasicType NoteBasicType Name
NoteBasicLanguage NoteBasicLanguage Lang.
NoteBasicTitle NoteBasicTitle Title
NoteBasicMIMEType NoteBasicMIMEType MIME Type
NoteBasicLength NoteBasicLength Length
NoteBasicCreatedByUser NoteBasicCreatedByUser Created By
NoteBasicCreationDateTime NoteBasicCreationDateTime Created At
NoteBasicLastChangedByUser NoteBasicLastChangedByUser Last Changed By
NoteBasicLastChangeDateTime NoteBasicLastChangeDateTime Last Changed at
NoteBasicContent NoteBasicContent Content of note
NoteBasicObjectNodeTypeUpper NoteBasicObjectNodeTypeUpper
_Language _Language
_LastChangedByUser _LastChangedByUser
_CreatedByUser _CreatedByUser
_NoteBasicType _NoteBasicType

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 I_NoteBasicTP.
-- 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.

CREATE VIEW I_NoteBasicTP AS
SELECT
  NoteBasicUUID,
  NoteBasicObjectNodeType,
  NoteBasicObject,
  NoteBasicType,
  NoteBasicLanguage,
  NoteBasicTitle,
  NoteBasicMIMEType,
  NoteBasicLength,
  NoteBasicCreatedByUser,
  NoteBasicCreationDateTime,
  NoteBasicLastChangedByUser,
  NoteBasicLastChangeDateTime,
  NoteBasicContent,
  NoteBasicObjectNodeTypeUpper
FROM R_NoteBasicTP
;