06-05-2008 3:17 PM
Hi Experts,
using Transaction SQVI i tried to join two tables PA0006 and T591S. PA0006 contains of address details of the employee and the T591S contains of Sub type Descriptions.
I joined the two tables and it shows the report fine. But in report it comes with multiple language Data's. I need datas only from langauage "EN". For that in slection field i slected lang is a parameter. But user dont wants the Language field in slection screen.
So I want to define a static variable for "Lang" field with in a query. Its should not displayed in the slection screen.
How can achieve this?
Any one help me on this issue.
Thanks,
Helps wil be appreciated.
06-05-2008 3:36 PM
hi,
in select statement where clause write as fallows
where makt-spras = 'EN'.
'makt-spras' means language field in makt.
(or)
check ur table weather is there any language field .
if found write as follows
where <table_name> - <language_field_name > = 'EN'.
<REMOVED BY MODERATOR>
Edited by: Alvaro Tejada Galindo on Jun 5, 2008 10:57 AM
06-05-2008 3:47 PM
Hi,
Thanks for your reply. But in SAP query does not allows to write the code right?
Thanks.
06-05-2008 3:53 PM
doak,
In some cases you have to stand up to the users. I don't think there is a way around it in SAP Query when you are not writing your own select statements (maybe try parameter id SPR = E).
something as insignificant as an extra parameter on the screen shouldn't be wasting much of your time. They save variants, I'm sure, so just have them make Language = 'EN' (or whatever) as part of their variant.
06-05-2008 3:54 PM
you can certainly add your own code under additional fields, but that will not help your issue.