Skip to Content
0
Former Member
Feb 13, 2006 at 08:12 AM

Difference between provide and select

20 Views

Hi,

Here iam giving two queries.I want to know what kind of infotypes can be given in 'PROVIDE' statement and in 'SELECT'.

infotypes : p0002.

-


SELECT SINGLE atext

FROM t522t

INTO wa_output-anredtxt

WHERE anred EQ p0002-anred .

This query is working.

-


Provide atext from t522t

between pn-begda and pn-endda

where sprsl eq sy-langu and

anred eq p0002-anred.

endprovide.

-


This query is not working.Is it necessary to delcare the table t522t.If so, how shld i declare it.Pls help me.Iam new to SAP.