topic Re: Problem with report in Application Development and Automation Discussions

Problem with report

Former Member — Fri, 31 Oct 2014 13:25:47 GMT

Hi All,

I am trying to run the report which is develop in EN logon system. Now this report has to run in ZH logon system. I have got the output but is displaying in English actually it has two display in Chinese. and my logon system is unicode.

Re: Problem with report

Former Member — Fri, 31 Oct 2014 15:55:15 GMT

Did you maintain the translations?

In your report goto->text elements->selection texts. now again Goto->translation.

Give language ZH and see if texts and messages are translated. you may also use SE63.

Re: Problem with report

Former Member — Mon, 03 Nov 2014 07:29:19 GMT

Hi kartik,

my data is in internal table. So i need to translate the entire internal table.

Re: Problem with report

Danish — Mon, 03 Nov 2014 07:44:31 GMT

This message was moderated.

Re: Problem with report

Former Member — Mon, 03 Nov 2014 07:45:44 GMT

Can you post your code?

Re: Problem with report

Former Member — Mon, 03 Nov 2014 09:28:39 GMT

Hi Danishh,

Suppose my internal table contains data of material description which is in English language.

Now the end user will logon to system with "ZH"(Chinese) language. the data in the internal table which is in English language should converted into the Chinese language.

The link which you mentioned above for picking data from the database on language bases mine requirement is different as mentioned above.

Re: Problem with report

Former Member — Mon, 03 Nov 2014 09:31:05 GMT

Hi Kartik,

Suppose my internal table contains data of material description which is in English language.

Now the end user will logon to system with "ZH"(Chinese) language. the data in the internal table which is in English language should converted into the Chinese language.

Re: Problem with report

Danish — Mon, 03 Nov 2014 09:32:49 GMT

Hi Quddus,

For the above scenario what ill do is :

Go to table MAKTX and select the maktx field by passing SPRAS = ZH.

Cordially,

Danish

Re: Problem with report

Former Member — Mon, 03 Nov 2014 09:37:33 GMT

Hi Danish,

What is the use of it. It will only pick the data of ZH language. My task is to pick all the data and convert it into ZH language.

Re: Problem with report

Danish — Mon, 03 Nov 2014 09:46:25 GMT

Hi Quddus,

You can pass sy-langu to the same query it will pick the data for the User's logon language.

Cordially,

Danish

Re: Problem with report

Former Member — Mon, 03 Nov 2014 09:47:26 GMT

You'll pass the key as SY-LANGU.

For example - SELECT * from MAKTX where MATNR = 'xyz' and SPRAS = sy-langu, now when the user will execute the report by logging in from ZH, then MAKTX will give ZH descriptions if user is logged in using FR login then he'll get FR descriptions, isnt this what you want?

Re: Problem with report

Former Member — Mon, 03 Nov 2014 10:04:27 GMT

Hi Kartik,

Irrespective of sy-langu. my select query will pick the data from makt table. now depending upon logon system the data has convert into particular language.

Re: Problem with report

Former Member — Mon, 03 Nov 2014 10:07:45 GMT

Hi Danish,

You are not getting my point. I will pick all the data from makt and put it in the internal table usually the material description will be in English language. Now depending upon logon system language the material disc should be converted like french, chinese ect.

Re: Problem with report

Danish — Mon, 03 Nov 2014 10:13:31 GMT

thats exactly what my code will do. select the fields using SY-LANGU it will display the data in what ever language the user will log on.

pass SPRAS = SY-LANGU, it will solve your problem

Re: Problem with report

former_member249399 — Mon, 03 Nov 2014 10:19:20 GMT

Hi ,

Karthik is saying right , You need to

translated the text in required Language like ZH so use SE63, maintain your translation in ZH , and write code like SELECT * from MAKTX where MATNR = 'xyz' and SPRAS = sy-langu.

Thanks.

Re: Problem with report

Former Member — Mon, 03 Nov 2014 10:29:52 GMT

Hi all,

I dont think so. If you are specifying sy-langu in where condition it will pick only the records of logon language. My task is pick all the records irrespective of language i.e, english, chinese, spain, de ect.

after picking it i should convert the language english-chinese, chinese-chinese, spain--chinese, de-chinese.

Re: Problem with report

former_member249399 — Mon, 03 Nov 2014 10:39:17 GMT

Hi Mahammed,

In this case I think you should have maintain entries in ZH langauge also in the table..

Thanks.

Re: Problem with report

Former Member — Mon, 03 Nov 2014 11:13:53 GMT

If you are expecting your program to "translate" it will not happen, SAP by design has added SPRAS to all text tables and if there is any custom table created it has to be based on same design.

The translations will be maintained in DB and your program has to fetch based on SY-LANGU, if want to fetch all languages, you may skip passing SPRAS to where and all languages will be retrieved(though there will no use of that), but translations will be picked up from DB only.

If you need further help you'll have to elaborate your requirement since I believe, there's a mistake in the design, but I'm pretty sure program will not translate languages.

Re: Problem with report

Former Member — Tue, 04 Nov 2014 09:39:25 GMT

Why would you want to do that?

SAP has built in the SPRAS domain to handle text translations.

If you want texts in a certain language then you pass that as part of your Select - Select * from MAKT Where SPRAS EQ 'EN' or 'ZH' - so you'd get all entries in EN or ZH.
If you want the texts in the logon language you'd pas SY-LANGU to the Select
If you want to show all texts, don't specific SPRAS in the where condition

I think you need to try and explain your requirement properly, rather than what you think the solution is so that we can help you better.

Cheers,