R_SourcingProjectItemNoteTP

DDL: R_SOURCINGPROJECTITEMNOTETP Type: view_entity TRANSACTIONAL

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.

2 data source(s) 16 fields

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
SourcingProjectItemUUID P_PurgDocNote NoteBasicObjectUUID
NoteBasicObjectNodeType P_PurgDocNote NoteBasicObjectNodeType
NoteBasicType P_PurgDocNote NoteBasicType
NoteBasicLanguage P_PurgDocNote NoteBasicLanguage
NoteBasicTitle P_PurgDocNote NoteBasicTitle
NoteBasicMIMEType P_PurgDocNote NoteBasicMIMEType
NoteBasicCreatedByUser P_PurgDocNote NoteBasicCreatedByUser
NoteBasicCreationDateTime P_PurgDocNote NoteBasicCreationDateTime
NoteBasicChangedByUser P_PurgDocNote NoteBasicChangedByUser
NoteBasicChangeDateTime P_PurgDocNote NoteBasicChangeDateTime
NoteBasicContent P_PurgDocNote NoteBasicContent
SourcingProjectUUID R_SourcingProjectItem SourcingProjectUUID
SrcPrjItemNoteTypeIsInternal
_SourcingProjectItem _SourcingProjectItem
_SourcingProject _SourcingProject 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Note for Item in Sourcing Project - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

define view entity R_SourcingProjectItemNoteTP as select from P_PurgDocNote as SourcingProjectItemNote
inner join R_SourcingProjectItem as  _SrcgProjItem  on  SourcingProjectItemNote.NoteBasicObjectUUID = _SrcgProjItem.SourcingProjectItemUUID
                             
association to parent R_SourcingProjectItemTP as _SourcingProjectItem on _SourcingProjectItem.SourcingProjectItemUUID = $projection.SourcingProjectItemUUID

                     //R_SourcingProject

association [1..1] to  R_SourcingProjectTP as _SourcingProject on _SourcingProject.SourcingProjectUUID = $projection.SourcingProjectUUID

// first attribute is internal/external which is denormalized and kept in parent entity itself

//association [1..1] to I_NOTEBASICATTRIBUTE as _notebasicattribute on 

                       //           _notebasicattribute.NoteBasicUUID = $projection.NoteBasicUUID and 

                       //           _notebasicattribute.NoteBasicAttributePosition = '1' 

{
    
key SourcingProjectItemNote.NoteBasicUUID,
SourcingProjectItemNote.NoteBasicObjectUUID as SourcingProjectItemUUID,
SourcingProjectItemNote.NoteBasicObjectNodeType,
SourcingProjectItemNote.NoteBasicType,
SourcingProjectItemNote.NoteBasicLanguage,
SourcingProjectItemNote.NoteBasicTitle,
SourcingProjectItemNote.NoteBasicMIMEType,
SourcingProjectItemNote.NoteBasicCreatedByUser,
SourcingProjectItemNote.NoteBasicCreationDateTime,
SourcingProjectItemNote.NoteBasicChangedByUser,
SourcingProjectItemNote.NoteBasicChangeDateTime,
SourcingProjectItemNote.NoteBasicContent,
_SrcgProjItem.SourcingProjectUUID as SourcingProjectUUID,
cast ( '' as mm_pur_sp_notetype_is_internal ) as SrcPrjItemNoteTypeIsInternal,
//cast ( _notebasicattribute.NoteBasicAttributeValue as mm_pur_sp_notetype_is_internal ) as SrcPrjItemNoteTypeIsInternal,

//cast ( _notebasicattribute.NoteBasicAttributeValue as nte_attr_value ) as SrcPrjItemNoteTypeIsInternal,


_SourcingProjectItem,
_SourcingProject
    
}
where SourcingProjectItemNote.NoteBasicObjectNodeType = 'SourcingProjectItem'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURGDOCNOTE",
"R_SOURCINGPROJECTITEM"
],
"ASSOCIATED":
[
"R_SOURCINGPROJECTITEMTP",
"R_SOURCINGPROJECTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More