P_PURGDOCNOTE
P_PURGDOCNOTE is a CDS View in S/4HANA. It contains 12 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_SourcingProjectItemNoteTP | view_entity | from | TRANSACTIONAL | Note for Item in Sourcing Project - TP |
| R_SourcingProjectNoteTP | view_entity | from | TRANSACTIONAL | Note for Sourcing Project - TP |
| R_SrcgProjAwardingScenNoteTP | view_entity | from | TRANSACTIONAL | Note for Awarding Scenario – TP |
| R_SrcgProjQtnNoteTP | view_entity | from | TRANSACTIONAL | Note for Sourcing Project Quotation - TP |
Fields (12)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | NoteBasicUUID | NoteBasicUUID | 1 |
| NoteBasicChangeDateTime | NoteBasicChangeDateTime | 1 | |
| NoteBasicChangedByUser | NoteBasicChangedByUser | 1 | |
| NoteBasicContent | NoteBasicContent | 1 | |
| NoteBasicCreatedByUser | NoteBasicCreatedByUser | 1 | |
| NoteBasicCreationDateTime | NoteBasicCreationDateTime | 1 | |
| NoteBasicLanguage | NoteBasicLanguage | 1 | |
| NoteBasicMIMEType | NoteBasicMIMEType | 1 | |
| NoteBasicObjectNodeType | NoteBasicObjectNodeType | 1 | |
| NoteBasicObjectUUID | SourcingProjectItemUUID | 1 | |
| NoteBasicTitle | NoteBasicTitle | 1 | |
| NoteBasicType | NoteBasicType | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_PurgDocNote as select from P_PurgDocNoteBasic {
key NoteBasicUUID,
NoteBasicObjectNodeType,
hextobin(NoteBasicObject) as NoteBasicObjectUUID ,
NoteBasicType,
NoteBasicLanguage,
NoteBasicTitle,
NoteBasicMIMEType,
NoteBasicLength,
NoteBasicCreatedByUser,
NoteBasicCreationDateTime,
NoteBasicChangedByUser,
NoteBasicChangeDateTime,
NoteBasicContent,
/* Associations */
_notebasicattribute
}
where
NoteBasicObjectNodeType = 'SourcingProjectQuotation'
or
NoteBasicObjectNodeType = 'SourcingProject'
or
NoteBasicObjectNodeType = 'SourcingProjectItem'
or
NoteBasicObjectNodeType = 'SrcgProjectAwardingScenario'