R_SrcgProjAwardingScenNoteTP

DDL: R_SRCGPROJAWARDINGSCENNOTETP Type: view_entity TRANSACTIONAL

Note for Awarding Scenario – TP

R_SrcgProjAwardingScenNoteTP is a Transactional CDS View that provides data about "Note for Awarding Scenario – 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 Awarding Scenario – 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
SrcgProjAwardingScenarioUUID
NoteBasicLanguage NoteBasicLanguage
NoteBasicObjectNodeType NoteBasicObjectNodeType
NoteBasicType NoteBasicType
NoteBasicTitle NoteBasicTitle
NoteBasicMIMEType NoteBasicMIMEType
NoteBasicCreatedByUser NoteBasicCreatedByUser
NoteBasicCreationDateTime NoteBasicCreationDateTime
NoteBasicChangedByUser NoteBasicChangedByUser
NoteBasicChangeDateTime NoteBasicChangeDateTime
NoteBasicContent NoteBasicContent
SrcPrjNoteTypeIsInternal
_SrcgProjAwardingScenario _SrcgProjAwardingScenario 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Note for Awarding Scenario – 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_SrcgProjAwardingScenNoteTP
  as select from P_PurgDocNote
  association to parent R_SrcgProjAwardingScenarioTP as _SrcgProjAwardingScenario on $projection.SrcgProjAwardingScenarioUUID = _SrcgProjAwardingScenario.SrcgProjAwardingScenarioUUID
{

  key NoteBasicUUID,
      cast( NoteBasicObjectUUID as  mm_pur_spawd_uuid   ) as SrcgProjAwardingScenarioUUID,
      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,
      _SrcgProjAwardingScenario

}
where NoteBasicObjectNodeType = 'SrcgProjectAwardingScenario'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURGDOCNOTE"
],
"ASSOCIATED":
[
"R_SRCGPROJAWARDINGSCENARIOTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More