R_SourcingProjectNoteTP

DDL: R_SOURCINGPROJECTNOTETP Type: view_entity TRANSACTIONAL

Note for Sourcing Project - TP

R_SourcingProjectNoteTP is a Transactional CDS View that provides data about "Note for Sourcing Project - TP" in SAP S/4HANA. It reads from 1 data source (P_PurgDocNote) and exposes 14 fields with key field NoteBasicUUID.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
P_PurgDocNote P_PurgDocNote from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Note for 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 (14)

KeyFieldSource TableSource FieldDescription
KEY NoteBasicUUID NoteBasicUUID
SourcingProjectUUID
NoteBasicLanguage NoteBasicLanguage
NoteBasicObjectNodeType NoteBasicObjectNodeType
NoteBasicType NoteBasicType
NoteBasicTitle NoteBasicTitle
NoteBasicMIMEType NoteBasicMIMEType
NoteBasicCreatedByUser NoteBasicCreatedByUser
NoteBasicCreationDateTime NoteBasicCreationDateTime
NoteBasicChangedByUser NoteBasicChangedByUser
NoteBasicChangeDateTime NoteBasicChangeDateTime
NoteBasicContent NoteBasicContent
SrcPrjNoteTypeIsInternal
_SourcingProject _SourcingProject 
@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