topic Re: Dynamic Select Statement in Application Development and Automation Discussions

Dynamic Select Statement

Former Member — Fri, 18 Jul 2008 14:45:47 GMT

Dear All,

i got a problem with dynamic select statement.i.e i written a select statement in that i included a where condition.the code for the where condition is as fallows.

DATA : STR_LINE TYPE EDPLINE,

STR_WHERE TYPE TABLE OF EDPLINE.

AND in STR_LINE i appended the condition values like as fallows

" industry = 'telecom' and apparea = 'r/3' and ....."

like above i've total 8 values. So Based on my requirement i may give all the 8 values or some of them.

my problem is iam able to get the where condition upto 72 char only ,cause edpline holds only 72 chars.So after i got the values into str_line iam appending that value into STR_WHERE,but when i used STR_WHERE condition in select statement it gives a dump error like in correct format of where condition.

And i tried STR_LINE type as STRING and also STR_WHERE as String and at that time also iam getting same kind of error.

MY WHERE CONDITION HOLDS APPROX., OF 200 CHAR OF LENGTH pls remeber this .

can u people pls give the solution for this,

Thanks in advance to u all,

Ajay Kumar K,

9908979994.

Re: Dynamic Select Statement

Former Member — Fri, 18 Jul 2008 14:52:26 GMT

Hi,

I believe the error is not related to the length of the string...if you have an internal table for which the each row of length 72...that should be good enough...

It is related to building the where clause....put a break-point before the SQL...and then check what exactly is the value in the internal table ...you might be missing..some operators like AND...

Thanks

Naren

Re: Dynamic Select Statement

Former Member — Fri, 18 Jul 2008 14:53:15 GMT

Hi Ajay,

Check this links for dynamic select statements,

http://www.itp-consulting.com/dynamic%20SQL%20in%20SAP.pdf

http://help.sap.com/saphelp_nw70/helpdata/en/67/93b80914a911d2953c0000e8353423/content.htm

Regards

Adil

Re: Dynamic Select Statement

Former Member — Fri, 18 Jul 2008 14:54:44 GMT

You need to put the conditions in ( ) as follows:



TABLES: zlmlead.
DATA : STR_LINE TYPE EDPLINE,
       STR_WHERE TYPE TABLE OF EDPLINE.


START-OF-SELECTION.


  STR_LINE = 'leadid eq 1'. append STR_LINE to str_where.

  SELECT SINGLE * FROM zlmlead
    WHERE (str_where).  "<== note where you need to change

  BREAK-POINT.

Re: Dynamic Select Statement

former_member217544 — Fri, 18 Jul 2008 14:58:43 GMT

Hi,

Actually it is a bit confusing. Can you provide us with your select statement and what you are trying to do actually.I think we can solve the problem.

Regards,

Swarna Munukoti.