I_PURCTRITNOTES

CDS View

Purchase Contract Item Notes

I_PURCTRITNOTES is a CDS View in S/4HANA. Purchase Contract Item Notes. It contains 8 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 8 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_PurchaseContractItemNotes view from COMPOSITE Item Notes
C_ContractFactSheetItemText view from CONSUMPTION Contract FactSheet Item Notes - Text
I_PurctritnotesWD view from TRANSACTIONAL Purchase Contract Item Notes with Draft
R_PPS_PurContractItemNoteTP view_entity from TRANSACTIONAL Purchase Contract Item Notes
R_PurContrItemNotesTP view_entity from TRANSACTIONAL Purchase Contract Item Notes

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ArchitecturalObjectNumber ArchitecturalObjectNumber,ArchObjectNumber,ArchObjectNumberForEdit 3
KEY DocumentText DocumentText,DocumentTextForEdit,TextObjectType 3
KEY Language Language,LanguageForEdit 3
KEY PurchaseContract PurchaseContract,PurchaseContractForEdit 3
KEY PurchaseContractItem PurchaseContractItem,PurchaseContractItemForEdit 3
KEY TechnicalObjectType TechnicalObjectType,TechnicalObjectTypeForEdit 3
FixedIndicator FixedIndicator 2
NoteDescription NoteDescription 3 
@AbapCatalog.sqlViewName: 'IPURCTRITNOTES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label:  'Purchase Contract Item Notes'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
     
define view I_Purctritnotes
  as select from I_Text_Templates

  association [1..1] to I_PurchaseContract     as _PurchaseContract     on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract

  association [1..1] to I_PurchaseContractItem as _PurchaseContractItem on  _PurchaseContractItem.FormattedPurchaseContractItem = $projection.ArchitecturalObjectNumber
                                                                        and _PurchaseContractItem.PurchaseContract              = $projection.PurchaseContract
                                                                        and _PurchaseContractItem.PurchaseContractItem          = $projection.PurchaseContractItem

{
  key   ArchitecturalObjectNumber                         as ArchitecturalObjectNumber,
  
  key   TechnicalObjectType,

  key   DocumentText,

  key   Language,

  key   substring(ArchitecturalObjectNumber, 1, 10)                       as PurchaseContract,

  key   cast ( substring(ArchitecturalObjectNumber, 11, 5) as ebelp)       as PurchaseContractItem,

        NoteDescription,   
        
        FixedIndicator,
      
        @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT]
        _PurchaseContract,

        @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
        _PurchaseContractItem

}
where
  TechnicalObjectType = 'EKPO'

Learn More