Joining table

[Former Member]

Hi,

I wanted to know whether we cann add leading zeros in the join condition

or use offset in the join condition.

select a~kunnr

a~vkorg

from knvv as inner join zcust

on knvv-kunnr+5(5) = zcust-refid.

will the above statemtnet work?

if not then how do we do it. as the length of knvv-kunnr is 10 and zcust-refid is 5.

i have either add leading zeros or use offset on knvv-kunnr to get the values .

can somebody send me a sample code to do this...

thanks in advance.

[Former Member]

Simply use UNPACK statement

pls don't forget to reward

S@meer

[Former Member]

hi sameer,

thanks for the reply but how do i use the upack statement in the join.

could send me a sample code of doing this in join.

[varma_narayana]

hi..

You can use offset in the SELECT statement in this case.

select a~kunnr

a~vkorg

from knvv as inner join zcust

on knvv-kunnr+5(5) = zcust-refid.

This will work.

<b>Reward if Helpful</b>