topic Re: Data Selection in Application Development and Automation Discussions

Data Selection

Former Member — Thu, 09 Nov 2006 20:55:45 GMT

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

Re: Data Selection

suresh_datti — Thu, 09 Nov 2006 20:56:12 GMT

use the following..

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

~Suresh

Re: Data Selection

Former Member — Thu, 09 Nov 2006 20:57:32 GMT

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

Re: Data Selection

Former Member — Thu, 09 Nov 2006 20:58:43 GMT

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

Re: Data Selection

Former Member — Thu, 09 Nov 2006 21:02:43 GMT

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

Re: Data Selection

suresh_datti — Thu, 09 Nov 2006 21:04:52 GMT


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

~Suresh

Re: Data Selection

Former Member — Thu, 09 Nov 2006 21:10:45 GMT

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

Re: Data Selection

Former Member — Thu, 09 Nov 2006 21:20:01 GMT

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

Re: Data Selection

suresh_datti — Fri, 10 Nov 2006 02:48:22 GMT

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