R_SourcingProjectItemNoteTP

DDL: R_SOURCINGPROJECTITEMNOTETP Type: view_entity TRANSACTIONAL
16 Fields 2 Data Sources 1 Associations

Note for Item in Sourcing Project - TP

R_SourcingProjectItemNoteTP is a Transactional CDS View that provides data about "Note for Item in Sourcing Project - TP" in SAP S/4HANA. It reads from 2 data sources (R_SourcingProjectItem, P_PurgDocNote) and exposes 16 fields with key field NoteBasicUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
R_SourcingProjectItem _SrcgProjItem inner
P_PurgDocNote SourcingProjectItemNote from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SourcingProjectTP _SourcingProject _SourcingProject.SourcingProjectUUID = $projection.SourcingProjectUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Note for Item in Sourcing Project - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY NoteBasicUUID P_PurgDocNote NoteBasicUUID Note ID
SourcingProjectItemUUID P_PurgDocNote NoteBasicObjectUUID
NoteBasicObjectNodeType P_PurgDocNote NoteBasicObjectNodeType SAP Object Type
NoteBasicType P_PurgDocNote NoteBasicType Name
NoteBasicLanguage P_PurgDocNote NoteBasicLanguage Lang.
NoteBasicTitle P_PurgDocNote NoteBasicTitle Title
NoteBasicMIMEType P_PurgDocNote NoteBasicMIMEType MIME Type
NoteBasicCreatedByUser P_PurgDocNote NoteBasicCreatedByUser Created By
NoteBasicCreationDateTime P_PurgDocNote NoteBasicCreationDateTime Created At
NoteBasicChangedByUser P_PurgDocNote NoteBasicChangedByUser Last Changed By
NoteBasicChangeDateTime P_PurgDocNote NoteBasicChangeDateTime Last Changed at
NoteBasicContent P_PurgDocNote NoteBasicContent Content of note
SourcingProjectUUID R_SourcingProjectItem SourcingProjectUUID Sourcing Project UUID
SrcPrjItemNoteTypeIsInternal
_SourcingProjectItem _SourcingProjectItem
_SourcingProject _SourcingProject

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 R_SourcingProjectItemNoteTP.
-- 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 R_SourcingProjectItemNoteTP AS
SELECT
  SourcingProjectItemNote.NoteBasicUUID AS NoteBasicUUID,
  SourcingProjectItemNote.NoteBasicObjectUUID AS SourcingProjectItemUUID,
  SourcingProjectItemNote.NoteBasicObjectNodeType AS NoteBasicObjectNodeType,
  SourcingProjectItemNote.NoteBasicType AS NoteBasicType,
  SourcingProjectItemNote.NoteBasicLanguage AS NoteBasicLanguage,
  SourcingProjectItemNote.NoteBasicTitle AS NoteBasicTitle,
  SourcingProjectItemNote.NoteBasicMIMEType AS NoteBasicMIMEType,
  SourcingProjectItemNote.NoteBasicCreatedByUser AS NoteBasicCreatedByUser,
  SourcingProjectItemNote.NoteBasicCreationDateTime AS NoteBasicCreationDateTime,
  SourcingProjectItemNote.NoteBasicChangedByUser AS NoteBasicChangedByUser,
  SourcingProjectItemNote.NoteBasicChangeDateTime AS NoteBasicChangeDateTime,
  SourcingProjectItemNote.NoteBasicContent AS NoteBasicContent,
  _SrcgProjItem.SourcingProjectUUID AS SourcingProjectUUID,
  cast ( '' as mm_pur_sp_notetype_is_internal ) AS SrcPrjItemNoteTypeIsInternal
FROM P_PurgDocNote AS SourcingProjectItemNote
INNER JOIN R_SourcingProjectItem AS _SrcgProjItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SourcingProjectTP AS _SourcingProject ON _SourcingProject.SourcingProjectUUID = SourcingProjectUUID  -- association [1..1]
;

Learn More