Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG CDS view performance Annotation for CDS view performance

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
765
Tepki puanı
5
Just want to share few interesting points on the CDS view performance Annotation for CDS view performance. SAP has released some guidelines to improve the performance of CDS views.

The best way to learn these guidelines is to learn from standard CDS views and apply in our custom views.



In most of the standard CDS views, we have seen below 3 annotations being used by SAP in order to improve performance. But I have seen we are not using it in our custom views which might impact performance while fetching data. Hence it would be good practice to use these annotations properly and benefit with performance.



  1. @ObjectModel.usageType.serviceQuality
  2. @ObjectModel.usageType.sizeCategory
  3. @ObjectModel.usageType.dataClass



( Note : In case where we want to see list of CDS view doesn’t have these annotations, SAP has provided a standard table : DDHEADANNO. This table will have information of all the annotations being used in CDS views present in the system. So you can create a report program on this table where we can find out CDS views which doesn’t have above annotations with %usagetype% keyword. )



Valid values for serviceQuality: #A, #B, #C, #D, #X, #P



Valid values for sizeCategory: #S, #M, #L, #XL, #XXL



Valid values for dataClass: #TRANSACTIONAL, #MASTER, #ORGANIZATIONAL, #CUSTOMIZING, #META, #MIXED



Now will see below charts where we will see in what cases we should use these annotations :















Combination of Characteristics to be used for annotations in CDS views





Test Results :







Conclusion :



  1. Keep CDS views simple (in particular service-Quality A and B = #BASIC views)
  2. Amount of data persisted in S4 CDS views should not exceed 20% of the overall data volume of the system.
  3. In transactional processing, only use simple CDS views accessed via CDS key
  4. Expose only required fields –define associations to reach additional fields when requested

Okumaya devam et...
 
Üst