SAP Query- default condition

[Former Member]

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 !!

[Former Member]

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

regards

Prabhu

[Former Member]

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

[Former Member]

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