Split a field into 3 columns for a report - Shoud be done in R/3 or BW

[Former Member]

Hi all,

I have to split a Text Description (TXTMD) into 3 columns for reporting.

This description is available in R/3 table and in BW InfoObject.

What is the best way to accomplish this task ?

Should I enhance the Extract structure and fill those 3 new ZZ fields on R/3?

Should I do it on BW side ? How, please ???

Thanks in advance.

Regards,

Venkat.

[Former Member]

If the purpose of splitting is to overcome the limitation of Infoobject, I would recommend doing that in BW side for a couple reasons: You don't need worry about having R/3 transport and also if you are working on LO extractors you don't need to worry about setup tables. Secondly, it is easy to manage the fields in BW side than R/3, because you will be sending fewer fields.

thanks.

Wond

[Former Member]

Hi Wond,

Basically, I want to split the Text Description (TXTMD) of <b>0EVALGROUP3</b> InfoObject.

What is the best way to do it in BW, PLEASE?

Thanks,

Venkat.

[Former Member]

Do it in the transfer Rule in BW instead of R/3.

thanks.

Wond