Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Single quotes to be stored

kesavadas_thekkillath
Active Contributor
0 Kudos

I buliding a where clause.....

something like

' where werks = '1001' '.

here its not allowing me to pass the quotation mark..

i know that there is some method to do this..... can any body help

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

write like this.

data:cond(40) value 'matnr = ''1000'''.

two immediate single quotations will give you the single quotation in run time.

so check ' where werks = ''1001'''.

rgds,

bharat.

3 REPLIES 3

Former Member
0 Kudos

Hi,

write like this.

data:cond(40) value 'matnr = ''1000'''.

two immediate single quotations will give you the single quotation in run time.

so check ' where werks = ''1001'''.

rgds,

bharat.

0 Kudos

its still going to dump.

Error: A comparison value is missing from the dynamic WHERE condition.

it_where-where =

'mandt = sy-mandt and paramid = "ZPP_LINE_STP" and param1 = "RESP CD"'.

APPEND it_where.

SELECT param2 paramdesn INTO TABLE it_desc FROM zpp03parameter

CLIENT SPECIFIED WHERE (p_where).

IF sy-subrc = 0.

SORT it_desc ASCENDING BY param2.

ENDIF.

0 Kudos

Hi,

here u are using double quotation symbol(").u have to use two single quotations symbols(two ' ).

example:

TABLES:MARA.

data:cond(40) value 'matnr = ''1000'''.

SELECT * from mara where (cond).

write:/ mara-matnr,mara-ernam.

ENDSELECT.

rgds,

bharat.