topic Re: How to compare substring in two tables fields in Application Development and Automation Discussions

How to compare substring in two tables fields

Former Member — Fri, 22 Feb 2008 22:57:33 GMT

Hi ABAP expert,

When I want to select database two tables, we just want to compare two table substring. For Example, both fields have yyyymmdd. But I have interested yyyymm. In the Oracle database and SQL server database, I can easily to use substr to achieve those goals. How in the ABAP program to archive those goals.

Thanks in advance,

Cliff Fan

Re: How to compare substring in two tables fields

Former Member — Sat, 23 Feb 2008 01:20:05 GMT

Hi you can access substrings in ABAP the following way:

 
data: s type string value 'yyyymmdd'. 

write: / s(6). "yyyymm 
write: / s+4(4). "mmdd

so the number after '+' determines the position in the string and the number in parenthesis () determines the length of the substring.

Now you can just loop over both of your tables and perform the necessary comparison in the nested loop.

Re: How to compare substring in two tables fields

Former Member — Mon, 25 Feb 2008 17:26:55 GMT

Hi Daniel,

Thanks for your input. I really like to use SQL statement to solve this problem. I understand that we can use internal table to get results. May be I will need to use EXE SQL to get my results.

Cliff

Re: How to compare substring in two tables fields

Former Member — Mon, 25 Feb 2008 17:30:46 GMT

Hi Cliff

if you wan't/need to use SQL for your comparison, then you have to use native SQL since Open SQL does not offer this possibility. Keep in mind that you loose the database independcy though.

For what reason do you wan't to use SQL rather then ABAP logic?