R_SRCGPROJQTNNOTETP

CDS View

Note for Sourcing Project Quotation - TP

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_SrcgProjQtnNote view_entity projection CONSUMPTION Note 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Note for Sourcing Project Quotation - 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_SrcgProjQtnNoteTP
  as select from P_PurgDocNote
  association        to parent R_SourcingProjectQuotationTP as _SourcingProjectQuotation on  $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID

  // 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_srcgprojquotationuuid ) as SourcingProjectQuotationUUID,
      NoteBasicLanguage,
      NoteBasicObjectNodeType,
      NoteBasicType,
      NoteBasicTitle,
      NoteBasicMIMEType,
      NoteBasicCreatedByUser,
      NoteBasicCreationDateTime,
      NoteBasicChangedByUser,
      NoteBasicChangeDateTime,
      NoteBasicContent,
      cast('' as mm_pur_sp_notetype_is_internal )  as SrcgProjQtnNoteTypeIsInternal, 
     // cast ( _notebasicattribute.NoteBasicAttributeValue  as mm_pur_sp_notetype_is_internal ) as SrcgProjQtnNoteTypeIsInternal,

      

      _SourcingProjectQuotation

}
where
  NoteBasicObjectNodeType = 'SourcingProjectQuotation'

Learn More