topic Re: selection query problem in Application Development and Automation Discussions

selection query problem

Former Member — Fri, 03 Oct 2008 08:47:34 GMT

hi all.....

i want to setct some data from table vbrp ,vbrk and vbfa .

on selection screen i have vbrk-vbeln and vbfa-erdat i hav written one code for tht but thts not working can nybdy plz help me in this..

parameter : p_vbeln type vbrk-vbeln ,

p_erdat type vbfa-erdat .

*--start of selection events

start-of-selection.

*--SELECTING THE DATA FROM DATABASE INTO INTERNAL TABLE

SELECT v1~vbeln AS vbeln

v1~kunag AS kunag

v1~vkorg AS vkorg

v1~netwr AS netwr

v2~ntgew AS ntgew

v2~matnr AS matnr

v3~erdat AS erdat

INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v1_{vbeln = v3}vbeln

WHERE v1~vbeln eq p_vbeln .

loop at it_data1 into wa_data where erdat ne p_erdat.

delete it_data1 from wa_data.

endloop.

end-of-selection.

thanks in advance.....

Re: selection query problem

Former Member — Fri, 03 Oct 2008 08:50:10 GMT

Use this,

SELECT v1~vbeln

v1~kuna

v1~vkorg

v1~netwr

v2~ntgew

v2~matnr

v3~erdat

INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v1_{vbeln = v3}vbeln

WHERE v1~vbeln eq p_vbeln

Regards,

Midhun Abraham

Edited by: Midhun Abraham on Oct 3, 2008 10:51 AM

Re: selection query problem

Former Member — Fri, 03 Oct 2008 08:50:57 GMT

Pls check in VBFA table, whether it is available in VBELN or VBELV

Regards

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:07:57 GMT

hi madhan....

yes its in vbelv i hav changed tht but the thing is data is not coming through ...

what is the problem in the select query....

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:12:30 GMT

Hi,

have u checked in debugging , by setting a break point at select statement.

bcoz it may happens, u r deleting the data from internal table

delete it_data1 from wa_data.

revert back if any issues,

regards

Naveen

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:23:59 GMT

hi naveen,

yes i hav tried debugging tht query but i m not able to understand y its not selecting ny data.....

i hav commented tht deleting part then too no data is being selected...

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:24:00 GMT

I am not sure if this help, you may try this:

WHERE v1~vbeln IN p_vbeln .

If your vbeln is in range (i.e. you see two boxes with for that parameters in the selection screens), you need to use IN to check value instead of eq

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:26:45 GMT

Pls let me know, how the select querry looks like, after modification

Regards

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:30:32 GMT

WHERE v1~vbeln eq p_vbeln .

change to

WHERE v1~vbeln like p_vbeln and see, whether it works

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:34:29 GMT

Hi,

I have tried ur program in my system.

select querry is working fine i.e i can see the data in the interrnal table.

i am sure that the data is being deleted by the delete statement.

moreover check whether the data u entered in the selection screen exits in the database.

Revert back...

regards,

Naveen

Re: selection query problem

Former Member — Fri, 03 Oct 2008 09:44:53 GMT

How have you defined your itab ?

You query looks perfectly ok , even if you use vbeln or vbelv it wont matter , it depends on the requirement.

So have you defined your itab correctly ?

for example :


data : begin of itab occurs 0,
         vbeln like vbrk-vbeln,
         kunag like vbrk-kunag,
         netwr like vbrk-netwr,
         ntgew like vbrp-ntgew,
         matnr like vbrp-matnr,
         erdat like vbfa-erdat,
         end of itab.

regards,

Advait