I wanted to know whether we cann add leading zeros in the join condition
or use offset in the join condition.
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.