Hi SAP Gurus,
i have created a Formatted Search for Business Partner. below is the code.
select top 1 LEFT(cardcode,2)+ RIGHT(CAST(000 + (10001+ right(cardcode,4)) AS varchar(5)), 4)
where CardType = $[OCRD.CARDTYPE] -- 's'
and CardCode LIKE $[%OCRD.CARDCODE.CHAR(1)%]
order by CardCode desc
the out put of the query should be : 'VU0010'
but bad luck its not working.. does any one know the proper query ..?
i appreciate your help.
Thanks and Regards,