topic Re: ABAP coding in Application Development and Automation Discussions

ABAP coding

Shiva_Ram — Tue, 19 Sep 2006 17:22:24 GMT

Hi,

In our ABAP program one of the line is coded with XBLNR LIKE '%MISC%'. How should I interpret this line? The XBLNR value should contain MISC only or it can be like 11111111MISC? What should I note when look for value XBLNR?

Thanks for the clarification.

Re: ABAP coding

Former Member — Tue, 19 Sep 2006 17:23:57 GMT

Hi,

The XBLNR value can be 'ACCMISCAC'..

'MISCAC'

'asdMISC'.

Thanks,

Naren

Re: ABAP coding

Former Member — Tue, 19 Sep 2006 17:26:31 GMT

Comparing Strings

To find out whether the value of a column matches a pattern, use:

SELECT ... WHERE <s> [NOT ] LIKE <f> ...

You can use the following wildcard characters in <f>:

% for a sequence of any characters (including spaces).

_ for a single character.

For example, ABC_EFG% matches the strings ABCxEFGxyz and ABCxEFG, but not ABCEFGxyz. If you want to use the two wildcard characters explicitly in the comparison, use the ESCAPE option. ESCAPE <h> specifies an escape symbol <h>. If preceded by <h>, the wildcards and the escape symbol itself lose their usual function within the pattern <f>. The use of _ and % corresponds to Standard SQL usage. Logical expressions elsewhere in ABAP use other wildcard characters (+ and *).

Regards,

Srikanth

Re: ABAP coding

Former Member — Tue, 19 Sep 2006 17:27:24 GMT

Hi shiva,

the string should contain XBLNR