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 Remove invalid charters form in your BW transformation

SAP Blog

Kayıtlı Üye
22 Ara 2017
Tepki puanı
If you have in your BW regular flat-file data load in your BW system, you probably afflict issues with wrong data provided by the user. The scenario of this issue can be very simple. It’s enough than user provides invalid unsupported charter and during activation, you will get similar issue:

Or other issues like:

  • Value ‘#’ (hex. ‘2300’) of characteristic contains invalid characters
  • Error when assigning SID: Action VAL_SID_CONVERT InfoObject
  • (hex. ‘500072007A0065006C006500770020006E0061002000720061’) of characteristic contains inva

This issue also affects me in the last time, and during my research and found several options for removal. Most of them were based on a simple check like is your charter on the list:


And this is, of course, true and corresponds to the note 173241. But what if you additionally want to check charters provided in the transaction RSKC?

The best way to achieve this is the usage of good FM RSKC_CHAVL_OF_IOBJ_CHECK, which checks charter correctness according to info object. But by default, this is not a dynamic development. I want to have some dynamic code, which I can paste in every transformation after Datasource and make necessary checks. That’s why I decided to write my own implementation which can handle this issue.

My implementation

Now all I need to do is add following code like below to the end routine ( consider a move of reference declaration to proper place ):

DATA(lr_tab) = REF #( result_package ).

DATA(lobj_check) = NEW zcl_bw_validate_special( ir_ref = lr_tab ).

it_tab = result_package
it_monitor = monitor
et_tab = result_package
et_monitor = monitor

Now any unsupported charter will be simply replaced by nothing.


You can test this by yourself by getting code from my GitHub page:


Of course please feel free to contribute and create pull requests, or open issues if needed. In the case of AMDP routine, consider usage Removing invalid and non-printable characters in HANA based BW transformation | SAP Blogs.

Thanks for your time and have a great day.

Okumaya devam et...