topic Re: Dynamic WHERE in READ TABLE in Application Development and Automation Discussions

Dynamic WHERE in READ TABLE

Former Member — Thu, 18 Nov 2010 15:21:09 GMT

it is possible to do dynamic condition READ TABLE WITH KEY (dynamic),

or maybe in LOOP WHERE (dynamic)?

Re: Dynamic WHERE in READ TABLE

Former Member — Thu, 18 Nov 2010 15:24:18 GMT

Did you try this?

Did you read the documentation??

Rob

Re: Dynamic WHERE in READ TABLE

Former Member — Thu, 18 Nov 2010 15:33:05 GMT

In documentation there aren't what I need

Re: Dynamic WHERE in READ TABLE

Former Member — Thu, 18 Nov 2010 15:46:07 GMT

So what does that tell you?

Rob

Re: Dynamic WHERE in READ TABLE

Former Member — Thu, 18 Nov 2010 16:48:52 GMT

Is not possible.

Do you have use

loop at itab into wa_itab where x = y

and z1 > z2.

your code ....

endloop.

Re: Dynamic WHERE in READ TABLE

kesavadas_thekkillath — Thu, 18 Nov 2010 17:14:15 GMT


READ TABLE ALL_CUSTOMERS
WITH KEY (KEY1) = VALUE1
(KEY2) = VALUE2.

Loop with dynamic where clauses are supported in higher versions of SAP.

Re: Dynamic WHERE in READ TABLE

Former Member — Fri, 19 Nov 2010 08:29:41 GMT

Unfortunelly I don't know number of keys in CONDITION it must be dynamic.

Re: Dynamic WHERE in READ TABLE

Former Member — Fri, 19 Nov 2010 08:46:27 GMT

Unfortunelly I don't know number of keys in CONDITION it must be dynamic.

That means you have to consider another solution:

let's to know what you need to do, perhaps we can give you an alternative one

Max

Re: Dynamic WHERE in READ TABLE

Former Member — Fri, 19 Nov 2010 10:01:19 GMT

Using call function RH_DYNAMIC_WHERE_BUILD u create dynamic where

Edited by: Krupaji on Nov 19, 2010 11:01 AM

Re: Dynamic WHERE in READ TABLE

Former Member — Fri, 19 Nov 2010 11:31:06 GMT

HI friend,

Yes it is possibel we can read the dynamic values using field symbols also or other wise we can use

string operation like CONCATENAT the fieldnames.

FIELD-SYMBOLS:<FIELDNAME1> TYPE ANY,

<FIELDNAME1> = 'LIFNR'.

READ TABLE ITAB INTO WA WITH KEY <FIELDNAME1> = VALUE.

LOOP AT ITAB INTO WA WHERE <FIELDNAME1> = VALUE.

if it is not possible u can use FIELD SYMBOLS then u can get the fields dynamcially.

Re: Dynamic WHERE in READ TABLE

Former Member — Mon, 22 Nov 2010 09:39:41 GMT

Good resolve but have only one weakness, I can't use in this case dynamic numbers of keys