C_PurchaseOrderFactSheetNote

DDL: C_PURCHASEORDERFACTSHEETNOTE SQL: CPURORDFSNOTE Type: view CONSUMPTION

Notes for Purchase Order

C_PurchaseOrderFactSheetNote is a Consumption CDS View that provides data about "Notes for Purchase Order" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderNote) and exposes 10 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, DraftUUID. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderNote Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_PurchaseOrderFs _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPURORDFSNOTE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Notes for Purchase Order view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Note view
UI.headerInfo.typeNamePlural Notes view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Language R_PurchaseOrderNote Language
KEY DocumentText R_PurchaseOrderNote DocumentText
KEY TechnicalObjectType R_PurchaseOrderNote TechnicalObjectType
KEY ArchObjectNumber R_PurchaseOrderNote ArchitecturalObjectNumber
KEY DraftUUID
KEY IsActiveEntity
PurchaseOrder R_PurchaseOrderNote PurchaseOrder
NoteDescription R_PurchaseOrderNote NoteDescription
FixedIndicator R_PurchaseOrderNote FixedIndicator
_PurchaseOrder _PurchaseOrder 
@AbapCatalog.sqlViewName: 'CPURORDFSNOTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Notes for Purchase Order'
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.preserveKey:true


@VDM.viewType: #CONSUMPTION
//@ObjectModel.type: #CONSUMPTION 

@UI.headerInfo: {
      typeName        : 'Note',
      typeNamePlural  : 'Notes'
  //    title           : {value: 'PurchaseOrder'}

}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED


define view C_PurchaseOrderFactSheetNote as select from R_PurchaseOrderNote as Document 
    association [1..1] to C_PurchaseOrderFs as _PurchaseOrder
       on _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
   
  {
   
    key Document.Language, 
    key Document.DocumentText, 
    key Document.TechnicalObjectType, 
    key Document.ArchitecturalObjectNumber                                   as ArchObjectNumber,
    key cast ( hextobin( '00000000000000000000000000000000' ) as sysuuid_x ) as DraftUUID,
    key cast ( 'X' as boolean )                                              as IsActiveEntity,
        Document.PurchaseOrder,
        Document.NoteDescription, 
        Document.FixedIndicator,
        
        /* Associations */
     
        _PurchaseOrder  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASEORDERNOTE"
],
"ASSOCIATED":
[
"C_PURCHASEORDERFS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More