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

[Former Member]

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

[Sandeep_Panghal]

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.

[Clemenss]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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..