topic Using where condition with dynamic internal table in Application Development and Automation Discussions

Using where condition with dynamic internal table

Former Member — Tue, 16 May 2006 07:34:57 GMT

Hi Friends.

How to use where condition with dynamic internal table ?

Regards,

Amit Raut

Re: Using where condition with dynamic internal table

Former Member — Tue, 16 May 2006 07:36:51 GMT

Take a look at this thread

Regards,

Re: Using where condition with dynamic internal table

Former Member — Tue, 16 May 2006 07:38:09 GMT

Hai Amit

REPORT ZDYNAMIC_SELECT .

TABLES: VBAK.

DATA: CONDITION TYPE STRING.

DATA: BEGIN OF ITAB OCCURS 0,

VBELN LIKE VBAK-VBELN,

POSNR LIKE VBAP-POSNR,

END OF ITAB.

SELECT-OPTIONS: S_VBELN FOR VBAK-VBELN.

CONCATENATE 'VBELN' 'IN' 'S_VBELN.'

INTO CONDITION SEPARATED BY SPACE.

SELECT VBELN POSNR FROM VBAP INTO TABLE ITAB

WHERE (CONDITION).

LOOP AT ITAB.

WRITE 'hello'.

ENDLOOP.

Thanks & Regards

Sreenivasulu P

Re: Using where condition with dynamic internal table

Former Member — Tue, 16 May 2006 07:44:59 GMT

Hi Amit,

is the above thread is not sufficient for you, take a string variable and concatenate your where your where clause to that string and pasas it to where clause.

Regards

vijay

Re: Using where condition with dynamic internal table

athavanraja — Tue, 16 May 2006 08:47:21 GMT

you cannot use where calss with dynamic internal table.

somethid like below is not possible.

loop at <ltable> assigning <l_line> where field1 eq 'ABC' .

endloop .

youhave to live with a if statement within the loop .

Regards

Raja

i hope i understand the question - where condition with dynamic internal table and not DYNAMIC WHERE CONDITION