Data Selection

[Former Member]

Hello,

How do I select applicable P0000 record where date entered on the selection screen equals P0000-AEDTM. Date is not a parameter.It is a select-option..

Thanks

Vicky

[suresh_datti]

use the following..

select * from pa0000 into table i_pa0000
         where aedtm in s_aedtm.

~Suresh

[Former Member]

Hi Vicky,

data itab type table of p0000.

select * from pa0000 into corresponding fields of table itab where aedtm in so_aedtm.

hope this helps.

Sajan.

Message was edited by: Sajan Joseph

[Former Member]

Hi,

use the IN operator..

EX.

SELECT-OPTIONS SO_DATE FOR SY-DATUM.

DATA: T_VBAK TYPE STANDARD TABLE OF VBAK.

SELECT * FROM VBAK

WHERE <b>ERDAT IN SO_DATE</b>.

Thanks,

Naren

[Former Member]

I used get pernr.So I also need to include condition for pernr. How do I do this?

[suresh_datti]

get pernr.
loop at p0000 where ( aedtm le s_aedtm-high and a
                      aedtm ge s_aedtm-low ).
*
endloop.

~Suresh

[Former Member]

Thanks Suresh for the reply..Now the thing is I need to pull the applicable records from P0001 P0002 P0007 using P0000-begda..How do i use this?

Thanks

VIcky

[Former Member]

Thanks Suresh for the reply..Now the thing is I need to pull the applicable records from P0001 P0002 P0007 using P0000-begda..How do i use this?

Thanks

[suresh_datti]

try this..

tables:pernr.
infotypes:0000,0001,0002,0007.
get pernr.
loop at p0000 where ( aedtm le s_aedtm-high and a
                      aedtm ge s_aedtm-low ).

rp-provide-from-last p0001 space p0000-begda p0000-begda.
if pnp-sw-found eq 1.
*p0001 will have the reqd record
endif.
rp-provide-from-last p0002 space p0000-begda p0000-begda.
if pnp-sw-found eq 1.
*p0002 will have the reqd record
endif.
rp-provide-from-last p0007 space p0000-begda p0000-begda.
if pnp-sw-found eq 1.
*p0007 will have the reqd record
endif.


endloop.
 
 
end-of-selection.

~Suresh