08-10-2007 11:44 AM
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.
08-10-2007 11:46 AM
08-10-2007 11:50 AM
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.
08-10-2007 12:01 PM
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>