Skip to Content
Former Member
Oct 24, 2010 at 03:46 AM

Reg Data type NUMC problem when query data between mbew and ckmlcr


Hi Friends,

I have problem when query data between mbew and ckmlcr..

select ckmlcrpoper mbewlfmon into table it from ckmlcr join mbew on (ckmlcrkalnr eq mbewkaln1 and ckmlcrpoper eq mbewlfmon ).

This query return subrc 4(no record found).But if I remove ckmlcrpoper eq mbewlfmon then subrc = 0 and get records.

But problem is I can see same values for ckmlcrpoper and mbewlfmon.But only think is poper is numc(3) and lfmon is numc(2).I can see poper = u2018010u2019 and lfmon = u201810u2019.

I donu2019t know how to solve this issue.Please help me <removed by moderator>

Thanks all...



Edited by: Thomas Zloch on Oct 24, 2010 8:53 PM