topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Thu, 05 Jun 2008 14:17:42 GMT

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.

Re: SAP Query

Former Member — Thu, 05 Jun 2008 14:36:10 GMT

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

Re: SAP Query

Former Member — Thu, 05 Jun 2008 14:47:06 GMT

Hi,

Thanks for your reply. But in SAP query does not allows to write the code right?

Thanks.

Re: SAP Query

Former Member — Thu, 05 Jun 2008 14:53:01 GMT

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.

Re: SAP Query

Former Member — Thu, 05 Jun 2008 14:54:19 GMT

you can certainly add your own code under additional fields, but that will not help your issue.