topic SAP Query- default condition in Application Development and Automation Discussions

SAP Query- default condition

Former Member — Fri, 13 Mar 2009 14:17:45 GMT

Hi all,

is it possible to give a default condition with in an infoset ?

e.g. : I link mara with matkl (for the description). There are several descriptions for the same material (other language key), but I want the system to take always the english description, so I want to put SPRAS = 'E'...

Is this possible ?

Thanks !!

Re: SAP Query- default condition

Former Member — Tue, 17 Mar 2009 01:11:54 GMT

yeah u can put conditions , u will get the option while selecting input/output fields.

regards

Prabhu

Re: SAP Query- default condition

Former Member — Tue, 17 Mar 2009 02:07:14 GMT

Hello,

This may be done in two ways: (1) As mentioned above, use SPRAS in the selection screen and create a default variant with SPRAS = 'E'. (2) In SQ02 (Info Set), you can define a code snippet to check SPRAS = 'E'.

Thanks,

Venu

Re: SAP Query- default condition

Former Member — Tue, 17 Mar 2009 09:52:35 GMT

Hi,

At the time of JOIN condition itself you can define the Criteria for Language as well.

where you give table names as MARA and MAKT.

there define the Language condition as well.

Hope it helps.

Vishal