LDB: Provide query err

[vallamuthu_madheswaran2]

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

[Former Member]

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.

<b>provide</b> prfno

pernr

rnr01

repto

asgsd

rolld FROM p9035

between pnp-begda and pnp-endda.

<b>endprovide.</b>

• Now assign the values to workarea

WA_XYZ-field1 = p9035-prfno

WA_XYZ-field2 = p9035-pernr

-

-assign all fields like this

<b>append WA_XYZ to IT_XYZ</b>.

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

you might have to modify it according to your requirement.

Regards,

Sonal

<b>Reward points if helpful</b>

Message was edited by:

sonal sharda