topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 31 Aug 2006 20:32:23 GMT

Hi all,

The following is a piece of code i have in a program.

But I cant see any data is getting fetched into itab "i_vbak" although there is data for this.

I ran it in debug mode to see.

Anybody please suggest me what went wrong with this.

tables: vbak,

vbap.

parameters: p_matnr like vbap-matnr obligatory,

p_charg like vbap-charg obligatory,

p_kunnr like vbak-kunnr.

select-options: s_audat FOR vbak-audat.

data: begin of i_vbak occurs 0,

vbeln like vbak-vbeln,

bstnk like vbak-bstnk,

end of i_vbak.

select vbak_{vbeln vbak}bstnk

into table i_vbak

from vbak inner join

vbap

on vbak_{vbeln = vbap}vbeln

where vbap~matnr = p_matnr

and vbap~charg = p_charg

and vbak~kunnr = p_kunnr

and vbak~audat IN s_audat.

Thanks a lot,

Message was edited by: sam jose

Re: select statement

Former Member — Thu, 31 Aug 2006 20:35:41 GMT

Hi,

If the parameters are not mandatory..Then it will blank values in the table VBAP..

Use SELECT-OPTIONS p_matnr NO-EXTENSION NO INTERVALS..

This way it will allow only single value..

And modify the your query to

vbap~matnr IN p_matnr instead of "="

Thanks,

Naren

Re: select statement

Former Member — Thu, 31 Aug 2006 20:35:59 GMT

There does not seem anything wrong with the query just check if there are records for the particular selection in your vbak/vbap table.

Secondly, the problem can be related to format of the fields(basically the data content like leading zeroes etc).

Regards

Anurag

Re: select statement

suresh_datti — Thu, 31 Aug 2006 20:37:52 GMT

change the select to


select a~vbeln a~bstnk
into table i_vbak
from vbak as a
inner join  vbap as b
on a~vbeln = b~vbeln
where b~matnr = p_matnr
and b~charg = p_charg
and a~kunnr = p_kunnr
and a~audat IN s_audat.

~Suresh

Re: select statement

Former Member — Thu, 31 Aug 2006 20:38:59 GMT

Narendran,

The "matnr" and "charg" are mandatory.

Thnx.

Re: select statement

Former Member — Thu, 31 Aug 2006 20:39:55 GMT

Anurag,

I have even checked it with the correct format of the data for selection-screen.

Thnx.

Re: select statement

Former Member — Thu, 31 Aug 2006 20:42:47 GMT

Sam,

Hmm..interesting, as there is nothing wrong with the querry. I would suggest to check with one where condition at a time and see if it is fetching data..by that you would be able to find the cause !!

I mean just use matnr first and if it does fetch data try with matnr and charg ...etc. I presume that you are feeling all your parameters as if you leave it blank it will try and check for blank data.

Message was edited by: Anurag Bankley

Re: select statement

Former Member — Thu, 31 Aug 2006 20:43:38 GMT

Hi,

How about customer..

p_kunnr like vbak-kunnr

Is customer also mandatory..

Thanks,

Naren

Re: select statement

Former Member — Thu, 31 Aug 2006 20:46:40 GMT

Nope.

P_kunnr and s_audat are not mandatory.

Thnx.

Re: select statement

Former Member — Thu, 31 Aug 2006 20:47:43 GMT

Hi Sam,

1) I doubt have you specified START-OF-SELECTION in your report.

If not have START-OF-SELECTION before your SELECT query.

2) Did you leave KUNNR field empty while running the report. If so, it wont fetch any data.Specify some value to KUNNR field.

Thanks,

Vinay

Re: select statement

Former Member — Thu, 31 Aug 2006 20:49:24 GMT

Hi,

That is the reason why you are not getting any records..

Since the customer is blank..it will look for records with blank values..

Instead use select-options for the customer as I mentioned above..

Please reward the points if it is helpful..

Thanks,

Naren

Re: select statement

Former Member — Thu, 31 Aug 2006 20:57:02 GMT

I hve specified "Start-of-selection" also in code.

Narendran,

Thanks for the response.

The user wants to get the data based on "MATNR" and "CHARG". He also wants to see the data by "KUNNR" sometimes. That's the reason I have the "P_KUNNR" on the selection-screen.

In that case how should design the selection-screen.

Plz advise.

Thnx.

Re: select statement

Former Member — Thu, 31 Aug 2006 20:58:13 GMT

Hi,

Use SELECT-OPTIONS p_KUNNR for vbak-kunnr NO INTERVALS NO-EXTENSION ..

And change the query to IN P_KUNNR instead of = P_KUNNR..

Thanks,

Naren

Re: select statement

Former Member — Thu, 31 Aug 2006 20:59:25 GMT

The best is to define it as a select-option with no intervals.

and in select query use vbak~kunnr in s_kunnr.

Define a range for customer

Range : r_kunnr for vbak~kunnr.

if p_kunnr ne space.

r_kunnr-low = p_kunnr.

r_kunnr-sign = 'I'

r_kunnr-option = 'EQ'.

append r_kunnr.

endif.

SELECT ...

where..

vbak~kunnr in r_kunnr.

Regards

Anurag

Message was edited by: Anurag Bankley