Skip to Content
avatar image
Former Member

Mass language translation of BI Objects via Excel

Hallo Experts,

is there a way to do mass language translation of BI Objects via Excel upload?

I have gone through the "how to" document in the link http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30a65c3a-2ad5-2910-a4be-88412392cfe5?QuickLink=index&… but this part is not covered in there.

i am looking for a way where I can upload the translation texts in source and the target language via excel and process it.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 14, 2015 at 06:55 PM

    I must admit I've never used the method in the document, although it is interesting (thanks for sharing BTW).

    What I would normally do is to log on to BW in the destination language and change the description of the objects there.

    I recently had a requirement to change description for multiple objects. I used the "script recording & playback" functionality to automate this from an excel spreadsheet. Here's what looks to be a recent guide on how to do this:

    Script Recording & Playback for Dummies

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 15, 2015 at 11:41 PM

    Hi,

    To my knowledge the standard translation functionality does not support any upload functionality.

    I suggest to evaluate if LSMW can be helpful. Here you can record a particular transaction using batch input (e.g. RSD1), specify an input file, map source and target fields, etc. In the end you can create and process a batch input map.

    I use LSMW quite often and I think it's a great tool. Please try it.

    Best regards,
    Sander

    Add comment
    10|10000 characters needed characters exceeded