Logical system population in SAP BW7.5

[former_member592144]

Good day, gurus

Can some one explain me one thing: When you activate standard content in SAP BW 7.5 on hana (corporate memory level) we have 0GN_R3_SSY field to populate on order to define the source system. Now this is a reference character of 0SOURSYSTEM, which has a conversion routine, which is written in ABAP.

So basically when we try to populate 0GN_R3_SSY an ABAP programm is carried out which automatically means this transformation can't be carried out in HANA DB but on the application level. How do we populate this field apart from creating a Z one and fill it with constant value?

Tnx in advance

[former_member186399]

Hi,

You can delete the transfer routine using the Transfer Routine Maintenance . But only risk is that you will have to maintain the logic at the transformation level (wherever its getting used) using a select statement from Table RSSOURSYSTEM. The select can be done using SQL method so that it runs in DB.

Regards

Gajesh

[former_member592144]

The point is that i would have to do it in every transformation that isnt convenient at all. I was think of a way to run conversion routine in SQL Script but i think there is no such a way.