Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

help to find occurrence

hi,

i need to do a select and i wont in the select find the occurrence of

string like if the user put part of string in waers i get in table all the waers

that similar to it .

i give example

if waers = US

i wont to get in curr_tab

US

USD

USD

...

    SELECT waers
      FROM tcurc
      INTO TABLE curr_tab
      WHERE waers = waers." here 

maybe i can do that in other way ?

Regards

Tags:
Former Member
replied

Hi...

Check this .. U will get the Solution.

PARAMETERS: P_STR(10) DEFAULT 'US'.

DATA : V_PATTERN(20).

START-OF-SELECTION.

CONCATENATE '%' P_STR '%' TO V_PATTERN.

SELECT waers

FROM tcurc

INTO TABLE curr_tab

WHERE waers LIKE V_PATTERN. "Returns the values that contain the Pattern like US

<b>REWARD IF HELPFUL. </b>

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question