R_SOURCINGPROJECTITEMNOTETP

CDS View

Note for Item in Sourcing Project - TP

R_SOURCINGPROJECTITEMNOTETP is a CDS View in S/4HANA. Note for Item in Sourcing Project - TP. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_SourcingProjectItemNote view_entity projection CONSUMPTION Note for Item 
@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'

Learn More