R_SrcgProjQtnNoteTP

DDL: R_SRCGPROJQTNNOTETP Type: view_entity TRANSACTIONAL

Note for Sourcing Project Quotation - TP

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

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
P_PurgDocNote P_PurgDocNote from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_NOTEBASICATTRIBUTE _notebasicattribute _notebasicattribute.NoteBasicUUID = $projection.NoteBasicUUID and _notebasicattribute.NoteBasicAttributePosition = '1'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Note for Sourcing Project Quotation - 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
SourcingProjectQuotationUUID
NoteBasicLanguage NoteBasicLanguage
NoteBasicObjectNodeType NoteBasicObjectNodeType
NoteBasicType NoteBasicType
NoteBasicTitle NoteBasicTitle
NoteBasicMIMEType NoteBasicMIMEType
NoteBasicCreatedByUser NoteBasicCreatedByUser
NoteBasicCreationDateTime NoteBasicCreationDateTime
NoteBasicChangedByUser NoteBasicChangedByUser
NoteBasicChangeDateTime NoteBasicChangeDateTime
NoteBasicContent NoteBasicContent
SrcgProjQtnNoteTypeIsInternal
_SourcingProjectQuotation _SourcingProjectQuotation 
@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