topic Using substring in table joins. in Application Development and Automation Discussions

Using substring in table joins.

aneel_munawar — Sat, 12 Apr 2014 05:02:08 GMT

Looking for the help about using substring option in the join columns.

Table1.Filed = substring (Table2.Field,1,10)

Thanks

Aneel

Re: Using substring in table joins.

former_member228804 — Sat, 12 Apr 2014 05:17:34 GMT

Hello Aneel,

Can you please elaborate what exactly is your requirement?

Regards,

Dnyanesh.

Re: Using substring in table joins.

aneel_munawar — Sat, 12 Apr 2014 07:09:31 GMT

Hi Dnyanesh,

Actually I want to compare the two tables columns in the join condition.

First table's column data matches second table's column data with first 10 characters of column.

One column has 20 length and 2nd table column has 10 characters length.

1000000006BM22BMC2 = one column value

1000000006 = second column value.

i want to compare in the join only first 10 charecters.

Re: Using substring in table joins.

former_member228804 — Sat, 12 Apr 2014 07:23:27 GMT

Hi Aneel,

In that case you can follow the below approach.

Create an internal table of the same TYPE as your first internal table. Call it i_itab_dummy.

Data: lv_colval TYPE char10.

LOOP AT i_itab1 into w_itab1.

lv_colval = w_itab1-colvalue+0(10).

w_itab_dummy-colvallue = lv_colval.

APPEND w_itab_dummy TO i_itab_dummy.

ENDLOOP.

Populate all the data into the dummy internal table in the above fashion. Now you will have the required values, i.e. first 10 characters of the field you want in the dummy internal table.

Now you can use this dummy internal table in your query for INNER JOIN.

Regards,

Dnyanesh.

Re: Using substring in table joins.

aneel_munawar — Mon, 14 Apr 2014 08:29:12 GMT

Hi,

It solved my problem. Thanks Dnyanesh.

Re: Using substring in table joins.

former_member228804 — Mon, 14 Apr 2014 08:48:32 GMT

Please mark the answers that solve your problems as correct.