topic dynamic SELECT in Application Development and Automation Discussions

dynamic SELECT

Former Member — Wed, 18 Apr 2007 14:50:32 GMT

Hello experts,

I have a dynamic SELECT with different fields in the WHERE-clause. But in some tables on which the SELECT operates, the field mentioned in the WHERE-clause is not part of it and a DUMP is the result.

So is there a way to check, if all fields of the WHERE-clause are part of the table, before execute the SELECT-statement?

thx

Re: dynamic SELECT

RichHeilman — Wed, 18 Apr 2007 14:55:07 GMT

Sure, you can come up with some logic and check the field names using the table DD03L. This table will give you the field names for the database table.

Regards,

Rich HEilman

Re: dynamic SELECT

RichHeilman — Wed, 18 Apr 2007 14:58:46 GMT

Or you could use the RTTS services to retreive the names of the fields of a table.



report zrich_0001 .

type-pools: abap.

data : idetails type abap_compdescr_tab,
       xdetails type abap_compdescr.

data : ref_descr type ref to cl_abap_structdescr.

selection-screen begin of block b1 with frame title text .
parameters: p_table(30) type c.
selection-screen end of block b1.


* Get the structure of the table.
ref_descr ?= cl_abap_typedescr=>describe_by_name( p_table ).
idetails[] = ref_descr->components[].

loop at idetails into xdetails.
  write:/ xdetails-name.
endloop.

Regards,

Rich Heilman