I_SchedgAgrmtHeaderNotes

DDL: I_SCHEDGAGRMTHEADERNOTES SQL: ISCHAGRHDRNOTES Type: view BASIC Package: VDM_MM_PUR_SCHD

Scheduling Agreement Header Notes

I_SchedgAgrmtHeaderNotes is a Basic CDS View that provides data about "Scheduling Agreement Header Notes" in SAP S/4HANA. It reads from 2 data sources (I_Schedgagrmthdr, I_Text_Templates) and exposes 13 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, SchedulingAgreement. Part of development package VDM_MM_PUR_SCHD.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_Schedgagrmthdr I_Schedgagrmthdr inner
I_Text_Templates I_Text_Templates from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISCHAGRHDRNOTES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Scheduling Agreement Header Notes view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Language I_Text_Templates Language
KEY DocumentText I_Text_Templates DocumentText
KEY TechnicalObjectType I_Text_Templates TechnicalObjectType
KEY ArchObjectNumber I_Text_Templates ArchitecturalObjectNumber
KEY SchedulingAgreement I_Schedgagrmthdr SchedulingAgreement
NoteDescription I_Text_Templates NoteDescription
FixedIndicator I_Text_Templates FixedIndicator
DisplayModeOfTextTypeInPurg I_Text_Templates DisplayModeOfTextTypeInPurg
TextIsAdoptedFromReference I_Text_Templates TextIsAdoptedFromReference
PurchasingDocumentType I_Schedgagrmthdr PurchasingDocumentType
PurchasingOrganization I_Schedgagrmthdr PurchasingOrganization
PurchasingGroup I_Schedgagrmthdr PurchasingGroup
PurchasingDocumentTypeName I_Schedgagrmthdr PurchasingDocumentTypeName 
@AbapCatalog.sqlViewName: 'ISCHAGRHDRNOTES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Scheduling Agreement Header Notes'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_SchedgAgrmtHeaderNotes
  as select from I_Text_Templates inner join I_Schedgagrmthdr 
      on I_Text_Templates.ArchitecturalObjectNumber = I_Schedgagrmthdr.SchedulingAgreement 
{
      
  key I_Text_Templates.Language,
  key I_Text_Templates.DocumentText,
  key I_Text_Templates.TechnicalObjectType,
  key I_Text_Templates.ArchitecturalObjectNumber                                     as ArchObjectNumber,
      @ObjectModel.text.element: [ 'PurchasingDocumentTypeName' ]
  key I_Schedgagrmthdr.SchedulingAgreement,
      I_Text_Templates.NoteDescription,
      I_Text_Templates.FixedIndicator,
      I_Text_Templates.DisplayModeOfTextTypeInPurg,
      I_Text_Templates.TextIsAdoptedFromReference,
      
      I_Schedgagrmthdr.PurchasingDocumentType,
      I_Schedgagrmthdr.PurchasingOrganization,
      I_Schedgagrmthdr.PurchasingGroup,
      @Semantics.text: true
      I_Schedgagrmthdr.PurchasingDocumentTypeName
//      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]

//      _Schedgagrmthdr


}
where
  I_Text_Templates.TechnicalObjectType = 'EKKO'

Learn More