topic Re: sql query in Application Development and Automation Discussions

sql query

Former Member — Thu, 17 Jul 2008 08:57:35 GMT

hi experts

i have this query:

date like ausp-atflv.

SELECT SINGLE ausp~atflv

FROM ausp

INTO date

WHERE ausp~objek = e_cekko-lifnr

AND ausp~atinn = 'TODG'

AND ausp~klart = '010'.

and it doesn't returns any result although i checked the query with the same parameters with se16 and there it returns one row as it supposed to be.

whats wrong here

thanks

Amit

Re: sql query

Former Member — Thu, 17 Jul 2008 08:58:50 GMT

change the query as follows

SELECT SINGLE ausp~atflv

FROM ausp

INTO date

for all entries in e_cekko

WHERE ausp~objek = e_cekko-lifnr

AND ausp~atinn = 'TODG'

AND ausp~klart = '010'.

//Kothand

Re: sql query

Former Member — Thu, 17 Jul 2008 09:01:27 GMT

Hi Amit,

try the following:

date like ausp-atflv.

SELECT SINGLE atflv

FROM ausp

INTO date

FOR ALL ENTRIES IN e_cekko

WHERE objek = e_cekko-lifnr

AND atinn = 'TODG'

AND klart = '010'.

I dont think there is a need of ~ operator when you are not joining two tables.

Hope this helps you.

Regards,

Chandra Sekhar

Re: sql query

former_member125931 — Thu, 17 Jul 2008 09:02:28 GMT

Use forall entries before where condition.

Re: sql query

Former Member — Thu, 17 Jul 2008 09:05:44 GMT

Hi,

try this...

SELECT SINGLE atflv

FROM ausp

INTO date

WHERE objek = e_cekko-lifnr

AND atinn = 'TODG'

AND klart = '010'.

Re: sql query

Former Member — Thu, 17 Jul 2008 09:06:52 GMT

Hi amit walden,

Refer the following Code,that will surely.

data : date like ausp-atflv.

Loop at e_cekko.

SELECT SINGLE atflv

FROM ausp

INTO date

WHERE objek = e_cekko-lifnr

AND atinn = 'TODG'

AND klart = '010'.

Endloop.

Hope it is helps.

Regards,

T.Durai murugan.

Re: sql query

Former Member — Thu, 17 Jul 2008 09:10:43 GMT

hi Kothand

my problem is that e_cekko is structure and not a table and it gives me an error when i do what you said.

another problem is that you can't use for all entrys with select single

thanks

Amit

Re: sql query

Former Member — Thu, 17 Jul 2008 09:12:16 GMT

hi,

if e_cekko is the work area....see if e_cekko-lifnr is populated before the select.

and see the sy-subrc.

regards,

madhu

Re: sql query

Former Member — Thu, 17 Jul 2008 09:14:57 GMT

Hi Amit,

Yup i forget the SINGLE

Try this way

if e_cekko-lifnr ne space.

SELECT SINGLE atflv

FROM ausp

INTO ( date )

WHERE objek = e_cekko-lifnr

AND atinn = 'TODG'

AND klart = '010'.

endif.

maybe this will work.

//Kothand