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. 4 CDS views read from this table.

Used by 4 CDS view(s) 8 fields

CDS Views using this table (4)

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_PurContrItemNotesTP view_entity from TRANSACTIONAL Purchase Contract Item Notes

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ArchitecturalObjectNumber ArchitecturalObjectNumber,ArchObjectNumber,ArchObjectNumberForEdit 4
KEY DocumentText DocumentText,DocumentTextForEdit,TextObjectType 4
KEY Language Language,LanguageForEdit 4
KEY PurchaseContract PurchaseContract,PurchaseContractForEdit 4
KEY PurchaseContractItem PurchaseContractItem,PurchaseContractItemForEdit 4
KEY TechnicalObjectType TechnicalObjectType,TechnicalObjectTypeForEdit 4
FixedIndicator FixedIndicator 3
NoteDescription NoteDescription 4 
@AbapCatalog.sqlViewName: 'IPURCTRITNOTES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label:  'Purchase Contract Item Notes'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
     
define view I_Purctritnotes
  as select from I_Text_Templates

//  inner join I_PurchaseContractItem on I_Text_Templates.ArchitecturalObjectNumber = I_PurchaseContractItem.FormattedPurchaseContractItem

//  inner join I_PurchaseContract on I_PurchaseContractItem.PurchaseContract = I_PurchaseContract.PurchaseContract

  association [1..1] to I_PurchaseContract     as _PurContract     on  _PurContract.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]
        _PurContract,

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

}
where
  TechnicalObjectType = 'EKPO' and
  DocumentText        like 'K%'

Learn More