Difference between provide and select

[Former Member]

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.

[Former Member]

Hello,

You should go to the abap forum for his.

Regards,

Frédéric