P_PurgDocNoteBasic

DDL: P_PURGDOCNOTEBASIC Type: view_entity COMPOSITE

P_PurgDocNoteBasic is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_NOTEBASIC) and exposes 13 fields with key field NoteBasicUUID.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_NOTEBASIC I_NOTEBASIC from

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY NoteBasicUUID NoteBasicUUID
NoteBasicObjectNodeType NoteBasicObjectNodeType
NoteBasicObject
NoteBasicType NoteBasicType
NoteBasicLanguage NoteBasicLanguage
NoteBasicTitle NoteBasicTitle
NoteBasicMIMEType NoteBasicMIMEType
NoteBasicLength NoteBasicLength
NoteBasicCreatedByUser NoteBasicCreatedByUser
NoteBasicCreationDateTime NoteBasicCreationDateTime
NoteBasicChangedByUser NoteBasicChangedByUser
NoteBasicChangeDateTime NoteBasicChangeDateTime
NoteBasicContent NoteBasicContent 
@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_PurgDocNoteBasic as select from I_NOTEBASIC {
    key NoteBasicUUID,
    NoteBasicObjectNodeType,
    cast(NoteBasicObject as abap.char(32) ) as NoteBasicObject  ,
    NoteBasicType,
    NoteBasicLanguage,
    NoteBasicTitle,
    NoteBasicMIMEType,
    NoteBasicLength,
    NoteBasicCreatedByUser,
    NoteBasicCreationDateTime,
    NoteBasicChangedByUser,
    NoteBasicChangeDateTime,
    NoteBasicContent,
    /* Associations */
    _notebasicattribute
}
where 
  NoteBasicObjectNodeType = 'SourcingProjectQuotation'
  or 
  NoteBasicObjectNodeType = 'SourcingProject'
  or 
  NoteBasicObjectNodeType = 'SourcingProjectItem'
  or 
  NoteBasicObjectNodeType = 'SrcgProjectAwardingScenario'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NOTEBASIC"
],
"ASSOCIATED":
[
"I_NOTEBASICATTRIBUTE"
],
"BASE":
[
"I_NOTEBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More