I_Sgbt_Nte_Cds_Demotp

DDL: I_SGBT_NTE_CDS_DEMOTP SQL: VINTECDSDEMOTP Type: view TRANSACTIONAL
7 Fields 1 Data Sources

Demo:Notizen am Anwendungsobjekt - Draft

I_Sgbt_Nte_Cds_Demotp is a Transactional CDS View that provides data about "Demo:Notizen am Anwendungsobjekt - Draft" in SAP S/4HANA. It reads from 1 data source (sgbt_nte_demo) and exposes 7 fields with key field objectid.

Data Sources (1)

SourceAliasJoin Type
sgbt_nte_demo demo from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VINTECDSDEMOTP view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Demo:Notizen am Anwendungsobjekt - Draft view
VDM.viewType #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence SGBT_NTE_DEMO_D view
ObjectModel.entityChangeStateId changed view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY objectid sgbt_nte_demo objectid Object Value
supp_ntypes sgbt_nte_demo supp_ntypes Note Types
descr sgbt_nte_demo descr WSS Profile
creator sgbt_nte_demo creator User ID
created sgbt_nte_demo created UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
changer sgbt_nte_demo changer Last Changed By
changed sgbt_nte_demo changed Time Stamp

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_Sgbt_Nte_Cds_Demotp.
-- 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: VINTECDSDEMOTP

CREATE VIEW I_Sgbt_Nte_Cds_Demotp AS
SELECT
  demo.objectid AS objectid,
  demo.supp_ntypes AS supp_ntypes,
  demo.descr AS descr,
  demo.creator AS creator,
  demo.created AS created,
  demo.changer AS changer,
  demo.changed AS changed
FROM sgbt_nte_demo AS demo
;

Learn More