how to write the where clause base on the user entered input on dynamic ss

[Former Member]

Hi experts,

The report is using dynamic selection screen, here the user is asked to enter the parameters and they are collected in one intenal table say i_to_cond,in the program.

now my problem is, this report retrives the data from the BW cube,the select stmt is already there (now i have to get the data from this BW cube based on the user entered parameters) which the present select stmt id not doing.

can any one please help me in writing the "where clause" for the select stmt

regards,

vara

[Former Member]

Hi

Please check the below code and write your own logic as per your requirment.

DATA: where_clause TYPE string.

• Get whear clause

CLEAR where_clause.

CONCATENATE 'KAPPL = P_KAPPL AND'

'KSCHL = P_KSCHL'

INTO where_clause

SEPARATED BY space.

LOOP AT it_vakey_fields.

*Get whear clause

CONCATENATE where_clause 'AND'

INTO where_clause

SEPARATED BY space.

• Getting the table and field name.

text1+0(it_vakey_fields-fieldlen) =

it_data-vakey+it_vakey_fields-offset(it_vakey_fields-fieldlen).

• Getting the table and field name.

CONCATENATE single_quote

text1+0(it_vakey_fields-fieldlen)

single_quote

INTO text2.

• Get where clause

CONCATENATE where_clause

it_vakey_fields-fieldname

'='

text2

INTO where_clause

SEPARATED BY space.

ENDLOOP.

• Dynamic select with dynamic where clause

CLEAR cond_rec_exists.

SELECT SINGLE kappl

INTO kappl_temp

FROM (v_cond_table)

WHERE (where_clause).

Regards

Lakshmikanth.T.V

[Former Member]

hi this my select stmt, now tell me how to write a where clause base on the user entered parameters on the dynamic selection screen. please

SELECT s5~/bic/zobjct

s7~/bic/zfield

s8~/bic/zvon

s6~/bic/zbis

s2~/bic/zsecasgnd

s1~/bic/zrpdesc

s4~/bic/zsingpro

s3~/bic/zsimdesc

s9~/bic/zability

s10~/bic/zsecuname

s11~/BIC/ZSYSIDNT "

**FROM

FROM /bic/fzability4 AS f

JOIN /bic/dzability42 AS d2

ON f_{key_zability42 EQ d2}dimid

JOIN /bic/szrpdesc AS s1

ON d2_{sid_zrpdesc EQ s1}sid

JOIN /bic/szsecasgnd AS s2

ON d2_{sid_zsecasgnd EQ s2}sid

JOIN /bic/dzability43 AS d3

ON f_{key_zability43 EQ d3}dimid

JOIN /bic/szsimdesc AS s3

ON d3_{sid_zsimdesc EQ s3}sid

JOIN /bic/szsingpro AS s4

ON d3_{sid_zsingpro EQ s4}sid

JOIN /bic/dzability44 AS d4

ON f_{key_zability44 EQ d4}dimid

JOIN /bic/szobjct AS s5

ON d4_{sid_zobjct EQ s5}sid

JOIN /bic/dzability45 AS d5

ON f_{key_zability45 EQ d5}dimid

JOIN /bic/szbis AS s6

ON d5_{sid_zbis EQ s6}sid

JOIN /bic/szfield AS s7

ON d5_{sid_zfield EQ s7}sid

JOIN /bic/szvon AS s8

ON d5_{sid_zvon EQ s8}sid

JOIN /bic/dzability4p AS dp

ON f_{key_zability4p EQ dp}dimid

JOIN /bic/dzability47 AS d7

ON f_{key_zability47 EQ d7}dimid

JOIN /bic/szability AS s9

ON d7_{sid_zability EQ s9}sid

JOIN /bic/dzability41 AS d1

ON f_{key_zability41 EQ d1}dimid

JOIN /bic/szsecuname AS s10

ON d1_{sid_zsecuname EQ s10}sid

JOIN /bic/dzability46 AS d6

ON f_{key_zability46 EQ d6}dimid

JOIN /bic/szsysidnt AS s11

ON d6_{sid_zsysidnt EQ s11}sid

APPENDING TABLE i_profile

**WHERE

WHERE dp~sid_0recordtp EQ 0

• AND s9~/bic/zability IN w_ability------- Commented by vara24052007.

***************start of Addition .

AND s9~/bic/zability IN w_ability2

AND ( ( s8~/bic/zvon like i_to_cond-low )

OR ( s6~/bic/zbis like i_to_cond-low )

OR ( s8~/bic/zvon EQ c_asteriks )

OR ( s6~/bic/zbis EQ c_asteriks )

OR ( s8~/bic/zvon LE i_to_cond-low

AND s6~/bic/zbis GE i_to_cond-low ) )

******************End of Addition .

AND s10~/bic/zsecuname IN w_tnumber

AND s11~/bic/zsysidnt EQ w_sosy

**GROUP BY

GROUP BY

s1~/bic/zrpdesc

s2~/bic/zsecasgnd

s3~/bic/zsimdesc

s4~/bic/zsingpro

s5~/bic/zobjct

s6~/bic/zbis

s7~/bic/zfield

s8~/bic/zvon

s9~/bic/zability

s10~/bic/zsecuname

s11~/BIC/ZSYSIDNT.