topic Re: Reg Data type NUMC problem when query data between mbew and ckmlcr in Application Development and Automation Discussions

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

Former Member — Sun, 24 Oct 2010 03:46:24 GMT

Hi Friends,

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

select ckmlcr_{poper mbew}lfmon into table it from ckmlcr join mbew on (ckmlcr_{kalnr eq mbew}kaln1 and ckmlcr_{poper eq mbew}lfmon ).

This query return subrc 4(no record found).But if I remove ckmlcr_{poper eq mbew}lfmon then subrc = 0 and get records.

But problem is I can see same values for ckmlcr_{poper and mbew}lfmon.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...

Regards,

Kumar

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

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

Sandeep_Panghal — Sun, 24 Oct 2010 15:09:44 GMT

This query return subrc 4(no record found).But if I remove ckmlcr_{poper eq mbew}lfmon then subrc = 0 and get records.-> use this condition for selection and then reove the unwanbted records using loop.

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

Clemenss — Sun, 24 Oct 2010 17:02:34 GMT

Hi,

saving memory without loosing performance you can use

SELECT ... INTO CORRESPONDING FIELDS OF <structure> ...
CHECK <structure>-poper+1 eq <structure>-lfmon ).
APPEND <structure> to <table>.
ENDSELECT.

Regards,

Clemens

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

Former Member — Tue, 26 Oct 2010 15:02:00 GMT

Hi Friends,

Thanks for your reply.Due to deadline,I changed program logic and move all related data into different internal table and by compare/modify internal table data,I solved this issue.Thanks again.

Regards

Kumaran

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

Former Member — Tue, 26 Oct 2010 15:23:57 GMT

Moderator message - Please assign po1nts to helpful answers and mark your question as solved Rob

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

Former Member — Fri, 29 Oct 2010 09:59:08 GMT

Hi Friends,

I spilit queries into simple queries and moved to many internal tables and finaly filter internal table based on my requirement.Thank you...

Regards,

Kumaran..