topic Re: Condition on selection screen parameters in Application Development and Automation Discussions

Condition on selection screen parameters

Former Member — Tue, 14 Apr 2009 14:07:22 GMT

Hi friends,

I have an ABAP query. Here , I have a date field (ISEG_ZLDAT - Cycle count date ) in the selection screen which is a parameter (not a select option). I have to write a condition for the report to pull all the materials which have a cycle count date less than the value entered on the selection screen.

How do I give this condition in the code ? Is there a way to do it without using select options ?

Please help.

Thanks,

Dikshitha

Re: Condition on selection screen parameters

venkatesan_nagiah — Tue, 14 Apr 2009 14:12:46 GMT

If you run the query and double click on the, it will display option for how the selection should take place.

in that select "<=" option then put whatever number, the query will select less than or equal value automatically

Re: Condition on selection screen parameters

Former Member — Tue, 14 Apr 2009 14:13:42 GMT

Hi,

1. Use the LE condition in your SELECT or

2. Use a RANGE and transfer the content of your parameter to your range.

Issa

Re: Condition on selection screen parameters

jcutinho — Tue, 14 Apr 2009 14:15:10 GMT

Can you provide me with the table to find the Material cycle time.

The syntax is as follows

SELECT fields

into workarea or internal table

from tablename

where ZLDAT < p_date.

Here p_date is the entered date as parameter on the screen. Hope this helps you.

Re: Condition on selection screen parameters

awin_prabhu — Tue, 14 Apr 2009 14:32:53 GMT

Use like below.

REPORT ztest

TABLES: iseg.

DATA: BEGIN OF itab OCCURS 0,

matnr TYPE matnr,

END OF itab.

PARAMETERS: p_zldat TYPE iseg-zldat.

SELECT matnr FROM iseg INTO TABLE itab

WHERE zldat < p_zldat.

Thanks.

Re: Condition on selection screen parameters

Former Member — Tue, 14 Apr 2009 14:44:45 GMT

Hi Dikshitha,

as also said by others try it this way:

Parameters:
  p_ZLDAT type ISEG-ZLDAT.

Data:
  t_ISEG like standard table of ISEG.

select * from ISEG into table t_ISEG where ZLDAT lt p_ZLDAT.

if sy-subrc ne 0.
endif.

With luck,

Pritam.

Re: Condition on selection screen parameters

Former Member — Tue, 14 Apr 2009 15:09:56 GMT

Hi Folks,

Thanks for your reply.

What I have is an abap query. It has 9 input fields and 11 output fields and it uses join conditions.

In this scenario how do I write the condition for the above mentioned scenario ?

Thanks,

Dikshitha

Re: Condition on selection screen parameters

awin_prabhu — Tue, 14 Apr 2009 15:15:39 GMT

Just add the condition,

'WHERE zldat < p_zldat' at the end of your select query.

Ex:

SELECT a_{matnr b}werks b_{dispo c}maktx INTO CORRESPONDING FIELDS OF TABLE itab

FROM mara AS a INNER JOIN marc AS b ON a_{matnr = b}matnr

INNER JOIN makt AS c ON a_{matnr = c}matnr

INNER JOIN iseg as d ON a_{matnr = d}matnr

WHERE a_{matnr IN s_matnr AND b}werks IN s_werks AND b~dispo IN s_dispo

AND d~zldat < p_zldat. <---- ADD LIKE THIS

Edited by: Sap Fan on Apr 14, 2009 5:21 PM