C_NoteBasicTP

DDL: C_NOTEBASICTP Type: view_entity CONSUMPTION Package: S_GBT_NTE_REUSE_RAP

Konsumenten-View für die Notizen

C_NoteBasicTP is a Consumption CDS View that provides data about "Konsumenten-View für die Notizen" in SAP S/4HANA. It reads from 1 data source (I_NoteBasicTP) and exposes 21 fields with key field NoteBasicUUID. It is exposed through 27 OData services (/DCO/UI_ACCOUNTING_DOCUMENT, /DCO/UI_ACTIVITY_MANAGE, /DCO/UI_DISPUTE_MANAGE, ...). Part of development package S_GBT_NTE_REUSE_RAP.

Data Sources (1)

SourceAliasJoin Type
I_NoteBasicTP I_NoteBasicTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Konsumenten-View für die Notizen view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.sapObjectNodeType.name NoteBasic view
Metadata.allowExtensions true view
OData.containment.accessByNavigationOnly true view

OData Services (27)

ServiceBindingVersionContractRelease
/DCO/UI_ACCOUNTING_DOCUMENT /DCO/UI_ACCOUNTING_DOCUMENT V4 C1 NOT_RELEASED
/DCO/UI_ACTIVITY_MANAGE /DCO/UI_ACTIVITY_MANAGE V4 C1 NOT_RELEASED
/DCO/UI_DISPUTE_MANAGE /DCO/UI_DISPUTE_MANAGE V4 C1 NOT_RELEASED
/DCO/UI_PROMISE_TO_PAY_MANAGE /DCO/UI_PROMISE_TO_PAY_MANAGE V4 C1 NOT_RELEASED
/DCO/UI_TASK_MANAGE /DCO/UI_TASK_MANAGE V4 C1 NOT_RELEASED
ASQL_F3883A ASQL_F3883A C2 NOT_RELEASED
ASQL_F5039 ASQL_F5039 C2 NOT_RELEASED
ASQL_F5474A ASQL_F5474A C2 NOT_RELEASED
ASQL_F5587A ASQL_F5587A C2 NOT_RELEASED
ASQL_F6634 ASQL_F6634 C2 NOT_RELEASED
ASQL_F7276 ASQL_F7276 C2 NOT_RELEASED
ASQL_F7353 ASQL_F7353 C2 NOT_RELEASED
ASQL_F7876 ASQL_F7876 C2 NOT_RELEASED
ASQL_F7877 ASQL_F7877 C2 NOT_RELEASED
ASQL_F8608 ASQL_F8608 C2 NOT_RELEASED
ASQL_F8609 ASQL_F8609 C2 NOT_RELEASED
ASQL_F8610 ASQL_F8610 C2 NOT_RELEASED
ASQL_F8623 ASQL_F8623 C2 NOT_RELEASED
MMPUR_CNTRLSUPPLCONF_SD MMPUR_CNTRLSUPPLCNF_V4_SB V4 C1 NOT_RELEASED
MMPUR_SUPPLIERCONFIRMATION_SD MMPUR_SUPPLCONF_V4_SB V4 C1 NOT_RELEASED
UI_CONTRACTACCOUNT_MANAGE_2 UI_CONTRACTACCOUNT_MANAGE_2 V4 C1 NOT_RELEASED
UI_CREDITDECISIONDOCUMENT_2 UI_CREDITDECISIONDOCUMENT_2 V4 C1 NOT_RELEASED
UI_EHSINVESTIGATION_MANAGE UI_EHSINVESTIGATION_MANAGE V4 C1 NOT_RELEASED
UI_MANAGEREVENUECONTRACTS_V4 UI_MANAGEREVENUECONTRACTS_V4 V4 C1 NOT_RELEASED
UI_ORDERBILLOFFMATERIAL UI_ORDERBILLOFMATERIAL_V4 V4 C1 NOT_RELEASED
UI_WBSBILLOFMATERIAL_MAINTAIN UI_WBSBILLOFMATERIAL_MAINTAIN V4 C1 NOT_RELEASED
VASCOMBINATION VASCOMBINATION V4 C1 NOT_RELEASED

Fields (21)

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
NoteBasicTypeHideTitle _NoteBasicType NoteBasicTypeHideTitle
NoteBasicTypeLanguageDependent _NoteBasicType NoteBasicTypeLanguageDependent
NoteBasicTypeMaximumLength _NoteBasicType NoteBasicTypeMaximumLength
NoteBasicTypeMultipleNotes _NoteBasicType NoteBasicTypeMultipleNotes
NoteBasicTypeTextPlain _NoteBasicType NoteBasicTypeTextPlain
LanguageNameasLanguageNamelocalized
LastChangedByUserDescription _LastChangedByUser UserDescription Full Name
CreatedByUserDescription _CreatedByUser UserDescription Full Name

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 C_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 C_NoteBasicTP AS
SELECT
  NoteBasicUUID,
  NoteBasicObjectNodeType,
  NoteBasicObject,
  NoteBasicType,
  NoteBasicLanguage,
  NoteBasicTitle,
  NoteBasicMIMEType,
  NoteBasicLength,
  NoteBasicCreatedByUser,
  NoteBasicCreationDateTime,
  NoteBasicLastChangedByUser,
  NoteBasicLastChangeDateTime,
  NoteBasicContent,
  _NoteBasicType.NoteBasicTypeHideTitle AS NoteBasicTypeHideTitle,
  _NoteBasicType.NoteBasicTypeLanguageDependent AS NoteBasicTypeLanguageDependent,
  _NoteBasicType.NoteBasicTypeMaximumLength AS NoteBasicTypeMaximumLength,
  _NoteBasicType.NoteBasicTypeMultipleNotes AS NoteBasicTypeMultipleNotes,
  _NoteBasicType.NoteBasicTypeTextPlain AS NoteBasicTypeTextPlain,
  _Language._Text.LanguageName as LanguageName :localized AS LanguageNameasLanguageNamelocalized,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  _CreatedByUser.UserDescription AS CreatedByUserDescription
FROM I_NoteBasicTP
;