R_SOURCINGPROJECTNOTETP

CDS View

Note for Sourcing Project - TP

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_SourcingProjectNote view_entity projection CONSUMPTION Note 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Note for 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_SourcingProjectNoteTP as  select from P_PurgDocNote                     
association to parent R_SourcingProjectTP as _SourcingProject on $projection.SourcingProjectUUID = _SourcingProject.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 NoteBasicUUID ,
cast( NoteBasicObjectUUID as vdm_sourcingprojectuuid ) as SourcingProjectUUID,
NoteBasicLanguage,
NoteBasicObjectNodeType,
NoteBasicType,
NoteBasicTitle,
NoteBasicMIMEType,
NoteBasicCreatedByUser,
NoteBasicCreationDateTime,
NoteBasicChangedByUser,
NoteBasicChangeDateTime,
NoteBasicContent,
// moved to calculation field in A_SourcingProjectNote due to issue with hextobin function and Attribute association

cast('' as mm_pur_sp_notetype_is_internal )  as SrcPrjNoteTypeIsInternal,
//cast ( _notebasicattribute.NoteBasicAttributeValue as mm_pur_sp_notetype_is_internal )  as SrcPrjNoteTypeIsInternal,


_SourcingProject 

}
where NoteBasicObjectNodeType = 'SourcingProject'

Learn More