LDB: Provide query err

vallamuthu_madheswaran2 — Tue, 28 Aug 2007 11:03:50 GMT

Hi,

kindly correct the the error in the PROVIDE stament.

provide prfno pernr rnr01 repto asgsd rolld FROM p9035

INTO (gi_prj_allc-hrd_ref, gi_prj_allc-emp_no, gi_prj_allc-prj_role,

gi_prj_allc-rept_to, gi_prj_allc-date_allc,gi_prj_allc-date_relv)

between p0000-begda and p0000-endda.

Thankz & Regards,

vallamuthu.M

Re: LDB: Provide query err

Former Member — Tue, 28 Aug 2007 11:14:27 GMT

Hi there,

In PROVIDE/ ENDPROVIDE you can not assign variables like that.

instead follow this logic:

give PNP as the logical database.

Create an internal table IT_XYZ have the reqd fields, and create a corresponding work area WA_XYZ.

provide prfno

pernr

rnr01

repto

asgsd

rolld FROM p9035

between pnp-begda and pnp-endda.

endprovide.

WA_XYZ-field1 = p9035-prfno

WA_XYZ-field2 = p9035-pernr

-assign all fields like this

append WA_XYZ to IT_XYZ.

This will populate the internal table IT_XYZ with the desired values.

you might have to modify it according to your requirement.

Regards,

Sonal

Reward points if helpful

Message was edited by:

sonal sharda