C_PurOrderItemFactSheetNote

DDL: C_PURORDERITEMFACTSHEETNOTE SQL: CPURORDITMFSN Type: view CONSUMPTION Package: ODATA_MM_PUR_ORDER_FS

Item Notes for Purchase Order

C_PurOrderItemFactSheetNote is a Consumption CDS View that provides data about "Item Notes for Purchase Order" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItemNote) and exposes 12 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, DraftUUID. It has 1 association to related views. Part of development package ODATA_MM_PUR_ORDER_FS.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderItemNote Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_PurOrdItemEnh _PurchaseOrderItem _PurchaseOrderItem.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderItem.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPURORDITMFSN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Item 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 (12)

KeyFieldSource TableSource FieldDescription
KEY Language R_PurchaseOrderItemNote Language
KEY DocumentText R_PurchaseOrderItemNote DocumentText
KEY TechnicalObjectType R_PurchaseOrderItemNote TechnicalObjectType
KEY ArchObjectNumber R_PurchaseOrderItemNote ArchitecturalObjectNumber
KEY DraftUUID
KEY IsActiveEntity
PurchaseOrder R_PurchaseOrderItemNote PurchaseOrder
PurchaseOrderItem R_PurchaseOrderItemNote PurchaseOrderItem
NoteDescription R_PurchaseOrderItemNote NoteDescription
FixedIndicator R_PurchaseOrderItemNote FixedIndicator
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrder _PurchaseOrder 
@AbapCatalog.sqlViewName: 'CPURORDITMFSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Item 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_PurOrderItemFactSheetNote
  as select from R_PurchaseOrderItemNote as Document
  association [1..1] to C_PurOrdItemEnh as _PurchaseOrderItem on  _PurchaseOrderItem.PurchaseOrder     = $projection.PurchaseOrder
                                                              and _PurchaseOrderItem.PurchaseOrderItem = $projection.PurchaseOrderItem
{

  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.PurchaseOrderItem,
      Document.NoteDescription,
      Document.FixedIndicator,
      _PurchaseOrderItem,
      _PurchaseOrder

}

Learn More