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.

How to add value help for parameter in ABAP CDS Analytical Query

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,032
Tepki puanı
6
Hi, in this post I would like to share trick for adding value help to parameter in analytical query.

Parameters in ABAP CDS view could be used as mandatory, single value variable, which could be used when split of calculation logic required. By default parameters don’t have value help, like filtration option based on fields at consumption level.

Step-by-step:

I. Create ABAP CDS view for dictionary based on table or some dummy table (like in this blog).

1-45.png


1-46.png


II. Create ABAP CDS cube with required logic.

1-47.png


Notes:

  • For demo I use just select form T000 table.
  • There is parameter p_par used in logic.
  • This parameter is not linked to any of fields in ABAP CDS view.

III. Create ABAP CDS analytical query with required logic.

1-48.png


Notes:

  • Usually all needed associations are created at cube level, but at this case I suppose it is possible to make exception
  • Don’t forget to code name of field in association
  • Don’t forget to add consumption view type
  • Now I couldn’t make texts visible for value help, but to have value help for key values is much more better compared to free field option for parameter
  • User can manually enter value not from value help, restriction is not guaranteed

IV. Result query in Analysis for Excel. Value help button exist.

1-49.png


For simple parameter dictionaries this approach could be useful.



Thank you for attention!

Okumaya devam et...
 
Üst