topic problem in query help me in Application Development and Automation Discussions

problem in query help me

laxman_sankhla3 — Mon, 07 May 2007 12:35:49 GMT

i m having problem in query please help me

here data is not coming

SELECT HBKID FROM PAYR INTO CORRESPONDING FIELDS OF TABLE INT_PAYR WHERE

ZBUKR = P_BUKRS

AND UBHKT IN (P_OHKONT).

loop at int_payr.

OUT_HBKID = int_payr-W_hbkid .

MODIFY INT_PAYR.

endloop.

give me advice.

thanks .

Re: problem in query help me

Former Member — Mon, 07 May 2007 12:38:36 GMT

SELECT HBKID FROM PAYR INTO CORRESPONDING FIELDS OF TABLE INT_PAYR WHERE

ZBUKR = P_BUKRS

AND UBHKT IN (P_OHKONT). Is p_ohkont a parameter or select option. If it is a parameter instead of 'IN' give '=' and also remove the braces.

Regards

Haritha.

Re: problem in query help me

Former Member — Mon, 07 May 2007 12:40:04 GMT

use....

Modify int_patr transporting w_hbkid index sy-tabix..

will work fine..

Regards,

Jyant

Re: problem in query help me

Former Member — Mon, 07 May 2007 12:41:09 GMT

What's your problem?

Where data is not coming?

What is P_OHKONT? is it Ranges or select-options field?

SELECT HBKID FROM PAYR INTO CORRESPONDING FIELDS OF TABLE INT_PAYR WHERE

ZBUKR = P_BUKRS

AND UBHKT IN P_OHKONT.

This is wrong below?

What you are doing.

You got the field value HBKID into INT_PAYR internal table. Where you have to modify this.

Something wrong in the below code. check it.

loop at int_payr.

OUT_HBKID = int_payr-W_hbkid .

MODIFY INT_PAYR.

endloop.

Reward points if useful

Regards

Anji

Re: problem in query help me

Former Member — Mon, 07 May 2007 12:41:39 GMT

Hi,

If P_OHKONT is a parameter

SELECT HBKID FROM PAYR INTO CORRESPONDING FIELDS OF TABLE INT_PAYR WHERE

ZBUKR = P_BUKRS

AND UBHKT = P_OHKONT.

If P_OHKONT is a Select-options then

SELECT HBKID FROM PAYR INTO CORRESPONDING FIELDS OF TABLE INT_PAYR WHERE

ZBUKR = P_BUKRS

AND UBHKT in P_OHKONT.

Regards

Sudheer

Re: problem in query help me

Former Member — Mon, 07 May 2007 12:42:28 GMT

Hi,

I think P_OHKONT is delared as parameter but refered in selection screen as select options.

Try to evalueate contains of P_OHKONT before running select stmt trhrough debugging...

ur loop statement seems to be incorrect: what are u doing here, nothing and modifying int_payr table.

Re: problem in query help me

Former Member — Mon, 07 May 2007 12:49:03 GMT

This example will help you ...

data: begin of i_mara occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

end of i_mara.

data: wa_maktx type maktx.

select matnr into table i_mara from mara where matnr =

'000000000000000001'.

select maktx into wa_maktx from makt

for all entries in i_mara where matnr = i_mara-matnr.

endselect.

loop at i_mara.

i_mara-maktx = wa_maktx.

modify i_mara transporting maktx .

endloop.

Regards,

Jayant

Please award if helpful