2016 Sep 03 3:53 PM
Hello All,
I am working on a BW transformation where we are updating few standard objects through abap routine. The issue is that the standard objects are all ALPHA conversion enabled in BW and incoming values from R/3 are not so i.e few of the custom table fields have the ALPHA conversion set up and few don't. We cannot go and change the tables in R/3 as the business doesn't approve any modifications in R/3 . In BW, the target is a standard info object.
I am aware of calling the ALPA conversion function module but just curious if there is any better way as we are in ABAP 7.4. Is it possible to set up this check in the READ statement something like
Read table gt_val into data(wa_val1) with key to_vchar(rgptp) = cs_package_line-rgptp.
The above statement is just an example. There are too many read statements that I need to validate and it will be a big problem if the leading zeroes cannot be adhered effectively. Can you guys suggest a good and easy solution?
Thanks,
Venkat
2016 Sep 03 4:25 PM
If the fields contents are always numeric, you can define them TYPE N. All missing leading zeros are supplied automatically when moving char type numer to field.
Regards Clemens
2016 Sep 04 7:37 AM
Maybe I misunderstand what you are trying to do, but why have you not simply set for alpha conversion on the fields tab of the DataSource in BW?