condition based on selection screen.

aris_hidalgo — Fri, 03 Mar 2006 06:31:15 GMT

Hello experts,

I have been trying to analyze this problem for quite some time. my boss wants me to modify a certain report where in when a user enters a material number with or w/o a date in the selection screen the first select statement would not be used and instead a second one would be used which I can't figure out how to do it. in the first select statement, the material no that the user enters is retrieved from COOI table but my boss wants me to use instead EBAN table for the comparison of matnr. Also, in the 2nd select statement I would get ebeln. And what i'm thinking is that the whole report would be affected. I have posted below the code guys. So please bear with me as I new to ABAP. Thanks you so much!

**here is the selection screen**

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

PARAMETERS: pa_bukrs LIKE t001-bukrs OBLIGATORY DEFAULT 'GLOB'.

SELECT-OPTIONS: so_psphi FOR prps-psphi,

so_ebeln FOR ekko-ebeln,

so_lifnr FOR ekko-lifnr,

so_matnr FOR ekpo-matnr.

so_augdt FOR bseg-augdt.

PARAMETERS: pa_augdt LIKE bseg-augdt.

SELECTION-SCREEN END OF BLOCK b1.

**here is the select statement I am trying to modify**

SELECT a_{psphi b}refbn b~lifnr

FROM prps AS a INNER JOIN cooi AS b

ON a_{objnr = b}objnr

INTO CORRESPONDING FIELDS OF it_hdr

WHERE a~psphi IN so_psphi

AND a~pbukr = pa_bukrs

AND a~erdat LE v_budat

AND a~erdat in so_augdt

AND b~refbn IN so_ebeln

AND b~lifnr IN so_lifnr

AND b~matnr IN so_matnr

AND b~rfart = 'P'

OR b~rfart EQ space.

SELECT SINGLE name1 FROM lfa1 INTO it_hdr-name1

WHERE lifnr = it_hdr-lifnr.

IF NOT pa_augdt IS INITIAL.

IF NOT so_augdt[] IS INITIAL.

CLEAR ekko.

SELECT SINGLE * FROM ekko

WHERE ebeln = it_hdr-refbn

AND bedat IN so_augdt.

AND bedat LE pa_augdt.

IF sy-subrc EQ 0.

APPEND it_hdr.

CLEAR it_hdr.

ENDIF.

ELSE.

APPEND it_hdr.

CLEAR it_hdr.

ENDIF.

ENDSELECT.

Re: condition based on selection screen.

hymavathi_oruganti — Fri, 03 Mar 2006 06:35:11 GMT

let so_matnr be the select option for matnr.

u can do like below.

if so_matnr is initial.

use first select statement.

else.

use the second select

Re: condition based on selection screen.

Former Member — Fri, 03 Mar 2006 06:38:40 GMT

Hi viraylab

for the first probelm

if so_matnr is initial.

else

<then execute the second statement>.

endif.

Re: condition based on selection screen.

Former Member — Fri, 03 Mar 2006 06:48:19 GMT

Hi,

In Start-of-selection event,

check select option for material.

If it is initial, use second select statement,

otherwise use the first one.

It wont affect the whole report.

Hope this helps...

Regards,

Shashank

topic Re: condition based on selection screen. in Application Development and Automation Discussions

condition based on selection screen.

Re: condition based on selection screen.

Re: condition based on selection screen.

Re: condition based on selection screen.