topic Pattern search with an internal table in select in Application Development and Automation Discussions

Pattern search with an internal table in select

Former Member — Mon, 12 Feb 2007 10:56:12 GMT

Hi Experts,

I am facing error the following code, when I tried to user like %.

SELECT OBJNR "Object Number

LMVRG "Confirmed Qty.

XMVRG "Scrapped Qty.

AGRND "Reason Code

BLDAT "Document date

VORNE "Reporting Point

FROM CEZP

INTO TABLE TCEZP

for all entries in tmdks

WHERE objnr like %tmdks-aufnr

and PLNKN <> '99999999'

AND WERKS IN S_WERKS

AND BLDAT IN S_BUDAT

AND STFLG = SPACE " Identifier for reversal document

AND STOKZ = SPACE. " Identifier for "document was reversed

Please advise.

Thanks in advance,

Viven

Re: Pattern search with an internal table in select

Former Member — Mon, 12 Feb 2007 10:59:46 GMT

Put the entries from table tmdks into a range using the option value of 'CP'. You will also need the wildcard symbol on the values in the range table.

Ranges r_aufnr for tmdks-aufnr.

r_aufnr-option = 'CP'.

r_aufnr-sign = 'I'.

loop at tmdks.

concatenate '' tmdks-aufnr '' into r_aufnr-low.

append r_aufnr.

endloop.

Message was edited by:

Martin Shinks

Re: Pattern search with an internal table in select

Former Member — Mon, 12 Feb 2007 11:00:29 GMT

take this inot a variable as follows -

d_var = tmdks-aufnr.

concatenate % d_var into d_var.

then write ur select query liek this -

SELECT OBJNR "Object Number

LMVRG "Confirmed Qty.

XMVRG "Scrapped Qty.

AGRND "Reason Code

BLDAT "Document date

VORNE "Reporting Point

FROM CEZP

INTO TABLE TCEZP

for all entries in tmdks

WHERE objnr like d_var

and PLNKN <> '99999999'

AND WERKS IN S_WERKS

AND BLDAT IN S_BUDAT

AND STFLG = SPACE " Identifier for reversal document

AND STOKZ = SPACE. " Identifier for "document was reversed

Re: Pattern search with an internal table in select

Former Member — Mon, 12 Feb 2007 11:01:28 GMT

Hello Chander,

Do like this.

DATA: RA_OBJNR TYPE RANGE OF OBJNR WITH HEADER LINE.

DATA: LV_OBJNR(10).

LOOP AT TMDKS.

RA_OBJNR-SIGN = 'I'.

RA_OBJNR-OPTION = 'CP'.

CONCATENATE TMDKS-AUFNR '*' INTO V_OBJNR.

RA_OBJNR-LOW = LV_OBJNR.

APPEND RA_OBJNR.

CLEAR RA_OBJNR.

ENDLOOP.

IF NOT RA_OBJNR[] IS INITIAL.

SELECT OBJNR "Object Number

LMVRG "Confirmed Qty.

XMVRG "Scrapped Qty.

AGRND "Reason Code

BLDAT "Document date

VORNE "Reporting Point

FROM CEZP

INTO TABLE TCEZP

WHERE objnr in RA_OBJNR

and PLNKN <> '99999999'

AND WERKS IN S_WERKS

AND BLDAT IN S_BUDAT

AND STFLG = SPACE " Identifier for reversal document

AND STOKZ = SPACE. " Identifier for "document was reversed

ENDIF.

Vasanth

Re: Pattern search with an internal table in select

Former Member — Mon, 12 Feb 2007 11:03:22 GMT

WHERE objnr like '%tmdks-aufnr'

regards

shiba dutta