topic Re: Problem with select statement in Application Development and Automation Discussions

Problem with select statement

Former Member — Wed, 22 Apr 2009 10:39:16 GMT

Hi,

I have a problem with a select statement.

I need to retrieve data from S889 table. I have written a select statement as follows. But it is not working.

Please let me know my mistake.

SELECT SSOUR

VRSIO

SPMON

SPTAG

SPWOC

SPBUP

BZIRK

KDGRP

VTWEG

SPART

HIEZU04

MVGR1

ZZPRODH1

MATNR

WERKS

ABSAT

LFIMG

OAUME

ZZSALES_12

ZZSALES_24

FROM S889

INTO TABLE T_S889

WHERE VRSIO = '000'

AND SPMON = P_MONTH

AND BZIRK = P_SADIS

AND KDGRP = P_CUGRP

AND VTWEG = P_SADCH

AND SPART = P_SADIV

AND HIEZU04 = P_CUPAR

AND MVGR1 = P_MAGRP

AND ZZPRODH1 = P_PRHIE

AND MATNR IN S_MATNR

AND WERKS = P_PLANT.

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 10:43:59 GMT

Please tell us in brief what error u r getting exactly, there are many possibilities.

1) Open the table with se16 and see if any entry exist in this table

2) See if this table is activated

Thank You,

Ganesh

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 10:45:58 GMT

Hi Rajani,

Please check whether the internal table T_S889 is having all the fileds which you have mentioned in the select query. And also all the fields are of type that are in the table S889.

Regards

vachana

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 10:48:04 GMT

Hi,

code

first try with the following code and see whether the data is getting populated in the internal table.

use 'OR' instead of 'AND' in the WHERE condition.

mention only the Key fields in WHERE condition.

data:
   t_ S889 type standard table of S889,
  fs_s889 like line of t_S889.


select <fields>
    from s889
into table t_s889
WHERE VRSIO eq '000'.

thanks

ravi

Re: Problem with select statement

Jay71 — Wed, 22 Apr 2009 10:51:14 GMT

Hi,

Ur select query is correct.

explain if ur getting any error or dump.

if you are not getting data it means ur condition has filtered the data

so change the condition or maintain data as per the condition.

close the thread if you found ur solution

Regards,

Jayaram

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 10:51:56 GMT

HI,

Check the data exists in the table S889 for the consdition given as in the Where clause of select statement.

Make VRSIO = '000' as VRSIO is initial and Try.

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 11:08:19 GMT

Hi Rajani,

1. I Was unable to find the table S889 in my system. Is the table name is correct ?

2. When you need data of 1/3 of the fields of a database table then you can write


select * from S889 into table t_s889
           where ......

Regards

Kumar M

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 11:27:34 GMT

Check if you have provided values in the parameters P_MONTH, P_CUGRP, P_SADCH, P_SADIV, P_CUPAR, P_MAGRP, P_PRHIE, P_PLANT. If any of these selection parameters do not contain a value, it takes up initial value which is compared while fetching data from the table and may result into zero entries being fetched.

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 11:39:12 GMT

Hi,

I don't find any problem in ur query.

could u tell me the error that you are getting.

chek ur data base table from se16 and pass all the data that u are passing in ur select query during the time of fillteration.

Thanks

Arun

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 11:45:01 GMT

Hi,

The table S889 is not there. There is a table with name s009. Check ur query once.

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 12:08:09 GMT

Hello,

I couldn't find this table either. Perhaps a customizing-generated table. Do you get any short dump when executing this statement?

Anyway, I recommend you to check the following on your statement:

(1) Check the name of the fields. One wrong fieldname can result in short dump.

(2) You are using INTO TABLE. Using this clause in a SELECT statement, you have to be sure that the order of the fields in your SELECT statement is in the same order you declared your internal table. This is very important. In case you don't want to worry about this, use INTO CORRESPONDING FIELDS OF TABLE instead of INTO TABLE (this is not recommended when you're thinking about performance).

(3) Check the types as well as the values you expect to have on your parameters used on WHERE clause. Wrong types/values can lead to unexpected results.

Regards,

Eduardo

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 12:24:14 GMT

well dudes Sxxx tables where xxx = numeric stand for Infostructure tables.

Sxxx tables with xxx >= 600 are own customer infoistructures, so dont be afaid he got this table and you not.

now to your Select. I just had a short look at it, but as far as i can see it, you are missing the statement 'corresponding fields of* between INTO and TABLE.

Re: Problem with select statement

Former Member — Wed, 22 Apr 2009 12:30:49 GMT

Hi Rajani,

When u r using both select-options and parameters in where clause you should provide data for all the parameters in selection screen, otherwise it will take value blank for parameters and it will search the records in data base with value blank, where as if u do not give value in select-options it will fetch all the data.

Hope it will work now.

Vinod

Re: Problem with select statement

Former Member — Thu, 23 Apr 2009 08:46:12 GMT

Hi Arun,

Thank you for response.

I am not getting the data at all with this selection statement.

But I do have proper in my system. only problem is with that select statement.

I also put the OR condition. But the session is getting terminated. Because all the data is being retrieved.

Re: Problem with select statement

Former Member — Thu, 23 Apr 2009 08:51:05 GMT

Hi,

Your internal table should have all

the fields which you are fetching from

your select query and they should

be present in the internal table in the

same order in which they are being

fetched from the select query.

Hope it helps

Regards

Mansi

Re: Problem with select statement

Former Member — Thu, 23 Apr 2009 08:51:25 GMT

HI,

Are you passing values to all the parameter fields ...if any of these parameter are blank then check the DM table with the same combination.

WHERE VRSIO = '000'

AND SPMON = P_MONTH

AND BZIRK = P_SADIS

AND KDGRP = P_CUGRP

AND VTWEG = P_SADCH

AND SPART = P_SADIV

AND HIEZU04 = P_CUPAR

AND MVGR1 = P_MAGRP

AND ZZPRODH1 = P_PRHIE

AND MATNR IN S_MATNR

AND WERKS = P_PLANT.

Re: Problem with select statement

SuhaSaha — Thu, 23 Apr 2009 08:52:59 GMT

Hello Rajani,

May be you have to check the values in the WHERE conditions parameters. Is there any data against these values in S889?

May be you can have a look into "Conversion Exits" against the fields used in the WHERE clause. If so you have to use them, else the SELECt may fail.

Hope this helps.

BR,

Suhas

Re: Problem with select statement

former_member195383 — Thu, 23 Apr 2009 08:53:23 GMT

change

WHERE VRSIO = '000' and

WHERE ( VRSIO = '000' or

VRSIO eq space ) and

Also input all the values that u are having in the where condition,(which u can check in debugging) to the table in SE16 . check if there is any entry. If its there..your select query should not fail.

Re: Problem with select statement

Former Member — Thu, 23 Apr 2009 09:07:29 GMT

Hi,

Kindly check the where clause of query weather the table possess that entry that u have applied in where clause.

Check your query by using your where condition one by one.

Otherwise your query is correct . Apply the above and watch for sy-subrc = 0 , if it is 4 than that where clause creating problem.

Regards,

Himanshu

Re: Problem with select statement

Former Member — Thu, 23 Apr 2009 09:08:56 GMT

Put MATNR IN S_MATNR in last.