topic Where Condition dynamically? in Application Development and Automation Discussions

Where Condition dynamically?

Former Member — Fri, 18 Apr 2014 12:34:36 GMT

hi,

How to pass where condition values Dynamically

Re: Where Condition dynamically?

former_member225134 — Fri, 18 Apr 2014 12:52:02 GMT

Hi,

use this function module RH_DYNAMIC_WHERE_BUILD

Re: Where Condition dynamically?

former_member194739 — Fri, 18 Apr 2014 13:04:29 GMT

Dear Naresh,

see the link: http://scn.sap.com/thread/1895732

Regards,

Abbas.

Re: Where Condition dynamically?

Former Member — Sat, 19 Apr 2014 04:14:27 GMT

i write like this:

IF NOT vbeln IS INITIAL.

APPEND 'a~vbeln = vbeln' TO l_where.

ENDIF.

IF NOT erdat IS INITIAL.

IF NOT l_where[] IS INITIAL.

APPEND ' AND ' TO l_where.

ENDIF.

APPEND 'a~erdat GE ERDAT' TO l_where.

ENDIF.

IF NOT auart IS INITIAL.

IF NOT l_where[] IS INITIAL.

APPEND ' AND ' TO l_where.

ENDIF.

APPEND 'a~AUART = AUART' TO l_where.

ENDIF.

IF NOT kunnr IS INITIAL.

IF NOT l_where[] IS INITIAL.

APPEND ' AND ' TO l_where.

ENDIF.

APPEND 'A~KUNNR = KUNNR' TO l_where.

ENDIF.

IF NOT werks IS INITIAL.

IF NOT l_where[] IS INITIAL.

APPEND ' AND ' TO l_where.

ENDIF.

APPEND 'B~WERKS = WERKS' TO l_where.

ENDIF.

IF NOT matnr IS INITIAL.

IF NOT l_where[] IS INITIAL.

APPEND ' AND ' TO l_where.

ENDIF.

APPEND 'B~MATNR = MATNR' TO l_where.

ENDIF.

IF NOT l_where[] IS INITIAL.

APPEND ' AND ' TO l_where.

ENDIF.

APPEND 'C~GBSTA NE ''C''' TO l_where.

* IF NOT werks IS INITIAL.

SELECT a~kunnr

a~audat

a~auart

b~vbeln

b~posnr

b~matnr

b~kwmeng

b~werks

c~gbsta

FROM vbak AS a INNER JOIN vbap AS b

ON a~vbeln = b~vbeln

INNER JOIN vbup AS c

ON b~vbeln = c~vbeln

AND b~posnr = c~posnr

INTO TABLE t_vbak1

WHERE (l_where).

but we are facing Performance issue.

please give explain detains to reduce performance.

thanks in advance .

Re: Where Condition dynamically?

Former Member — Sat, 19 Apr 2014 04:48:34 GMT

Make vbeln mandatory.

Re: Where Condition dynamically?

Former Member — Sat, 19 Apr 2014 07:06:31 GMT

some times VBELN is initial that time we are not getting any data

Re: Where Condition dynamically?

former_member228804 — Sat, 19 Apr 2014 09:12:37 GMT

What exactly is your requirement sir? Just one sentence doesn't suffice to make people understand the requirement.

Re: Where Condition dynamically?

Former Member — Sat, 19 Apr 2014 12:00:48 GMT

see my second post sir...