topic Re: Dynamic Subselect? in Application Development and Automation Discussions

Dynamic Subselect?

ortwin_cramer — Fri, 29 May 2009 09:00:14 GMT

Hi,

i got an error that the format of the statement isn't correct. How can i solve this problem using dynamic select AND subselect?

data: column_stmt type string,
        from_stmt type string,
        where_stmt type string.

column_stmt = 'ko~aufnr ko~plnbez po~psmng po~amein po~wemng ko~gstri ko~gsuzi ko~gstrs ko~gltrs kt~maktx'.

from_stmt = 'afko AS ko'
            & ' INNER JOIN afpo AS po ON ko~aufnr = po~aufnr'
            & ' INNER JOIN aufk AS fk ON ko~aufnr = fk~aufnr'
            & ' INNER JOIN makt AS kt ON ko~plnbez = kt~matnr'.


where_stmt  = 'kt~spras = sy-langu'
              & 'AND po~posnr = ('
              & '   SELECT MIN( posnr ) FROM afpo'
              & '   WHERE aufnr = ko~aufnr'
              & ')'.

SELECT (column_stmt)
  FROM (from_stmt)
  INTO CORRESPONDING FIELDS OF TABLE re_results
  WHERE (where_stmt)

Thanks for help,

O. Cramer

Re: Dynamic Subselect?

Former Member — Fri, 29 May 2009 09:02:57 GMT

data: column_stmt type string,
        from_stmt type string,
        where_stmt type string.
 
column_stmt = 'ko~aufnr ko~plnbez po~psmng po~amein po~wemng ko~gstri ko~gsuzi ko~gstrs ko~gltrs kt~maktx'.
 
from_stmt = 'afko AS ko'
            & ' INNER JOIN afpo AS po ON ko~aufnr = po~aufnr'
            & ' INNER JOIN aufk AS fk ON ko~aufnr = fk~aufnr'
            & ' INNER JOIN makt AS kt ON ko~plnbez = kt~matnr'.
 
 
where_stmt  = 'kt~spras = sy-langu'
              & *' AND* po~posnr = *( *'
              & '   SELECT MIN( posnr ) FROM afpo'
              & '   WHERE aufnr = ko~aufnr'
              & ' * )'*.
 
SELECT (column_stmt)
  FROM (from_stmt)
  INTO CORRESPONDING FIELDS OF TABLE re_results
  WHERE (where_stmt)

Re: Dynamic Subselect?

ortwin_cramer — Fri, 29 May 2009 09:15:58 GMT

Sorry but's still not working. Whats the purpose of the * ?

Re: Dynamic Subselect?

Former Member — Fri, 29 May 2009 09:22:29 GMT

where_stmt = 'kt~spras = sy-langu'

& 'AND po~posnr = ('

& ' SELECT MIN( posnr ) FROM afpo'

& ' WHERE aufnr = ko~aufnr'

& ')'.

give space before and after brackets

where_stmt = 'kt~spras = sy-langu'

& ' AND po~posnr = ( '

& ' SELECT MIN( posnr ) FROM afpo'

& ' WHERE aufnr = ko~aufnr'

& ' ) '.

Re: Dynamic Subselect?

ortwin_cramer — Fri, 29 May 2009 09:32:13 GMT

It doesn't helped. Same problem. With a fixed value list in place of subselect it's working. Only the SELECT is leading to an error. Instead of '=' i've tried IN, ANY, EXISTS...

Re: Dynamic Subselect?

Former Member — Fri, 29 May 2009 09:38:57 GMT

give space before and after brackets only at * it will work. i have checked up.

where_stmt = 'kt~spras = sy-langu'

& ' AND po~posnr = *(* '

& ' SELECT MIN( posnr ) FROM afpo'

& ' WHERE aufnr = ko~aufnr'

& ' *)* '.

Edited by: venu gopal on May 29, 2009 11:40 AM

Re: Dynamic Subselect?

ortwin_cramer — Fri, 29 May 2009 09:47:59 GMT

Error message:

A condition specified at runtime has an unexpected format.

where_stmt  = 'kt~spras = sy-langu'
            & ' AND po~posnr = ( '
            & ' SELECT MIN( posnr ) FROM afpo'
            & ' WHERE aufnr = ko~aufnr'
            & ' ) '.

Maybe there is a setting allowing it in your system?