I_PurchaseOrderItemNoteTP

DDL: I_PURCHASEORDERITEMNOTETP SQL: IPURORDITMNT Type: view TRANSACTIONAL

Notes for Purchase Order Item

I_PurchaseOrderItemNoteTP is a Transactional CDS View that provides data about "Notes for Purchase Order Item" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItemNote) and exposes 14 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, PurchaseOrder. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderItemNote Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderTP _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
[1..1] I_PurchaseOrderItemTP _PurchaseOrderItem _PurchaseOrderItem.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderItem.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IPURORDITMNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Notes for Purchase Order Item view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence PURORDITMNOTE_D view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Language R_PurchaseOrderItemNote Language
KEY DocumentText R_PurchaseOrderItemNote DocumentText
KEY TechnicalObjectType R_PurchaseOrderItemNote TechnicalObjectType
KEY ArchObjectNumber R_PurchaseOrderItemNote ArchitecturalObjectNumber
KEY PurchaseOrder R_PurchaseOrderItemNote PurchaseOrder
KEY PurchaseOrderItem R_PurchaseOrderItemNote PurchaseOrderItem
ArchObjectNumberForEdit R_PurchaseOrderItemNote ArchitecturalObjectNumber
TechnicalObjectTypeForEdit R_PurchaseOrderItemNote TechnicalObjectType
DocumentTextForEdit R_PurchaseOrderItemNote DocumentText
LanguageForEdit R_PurchaseOrderItemNote Language
NoteDescription R_PurchaseOrderItemNote NoteDescription
FixedIndicator R_PurchaseOrderItemNote FixedIndicator
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrder _PurchaseOrder 
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'IPURORDITMNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Notes for Purchase Order Item'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.usageType.serviceQuality: #C  
@ObjectModel.usageType.sizeCategory: #L  
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

//@ObjectModel.entityChangeStateId: 'LastChangeDateTime'  


@AccessControl.personalData.blocking: #NOT_REQUIRED  

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: ['PurchaseOrder', 'PurchaseOrderItem', 'ArchObjectNumberForEdit']
@ObjectModel.writeDraftPersistence: 'PURORDITMNOTE_D'
//@ObjectModel.dataCategory: #TEXT



define view I_PurchaseOrderItemNoteTP as select from R_PurchaseOrderItemNote as Document

 association [1..1] to I_PurchaseOrderTP            as _PurchaseOrder   on  _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
 association [1..1] to I_PurchaseOrderItemTP        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 Document.PurchaseOrder,
  key Document.PurchaseOrderItem,
 
    
      Document.ArchitecturalObjectNumber as ArchObjectNumberForEdit,
      
      Document.TechnicalObjectType as TechnicalObjectTypeForEdit,  

      Document.DocumentText as DocumentTextForEdit,
      
      Document.Language as LanguageForEdit,

      Document.NoteDescription,
      Document.FixedIndicator,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _PurchaseOrderItem,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _PurchaseOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_PURCHASEORDERITEMNOTE"
],
"ASSOCIATED":
[
"I_PURCHASEORDERITEMTP",
"I_PURCHASEORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More