topic Re: Validation in QM. in Application Development and Automation Discussions

Validation in QM.

Former Member — Wed, 18 May 2011 11:26:13 GMT

Hi,

I hav a requirement in QM module where in,I need to compare the upper limit value and lower limit value from qamv table with the original value in qamr table.

Actually the original value should be with in the upper limit and lower limit value.

i took upper and lower limit value in one internal table and iam selecting original value from qamr table into internal table for all entries of the characteristic values in first internal table.but now i need to check if this original value is in between the upper and lower limit.this iam unable to incorporate in forall entries as it doesnot allow 'between'.

Kindly,guide me how can i check this validation in the code.

Thanks in advance.

Jiyaaaa

Re: Validation in QM.

Former Member — Wed, 18 May 2011 11:34:45 GMT

Hi,

If you are referring to a select option (upper and lower limit value) then you can directly write in the where condition

instead of taking into an internal table ..

Say for Ex: select * from QAMR into table i_QAMR

where PRUEFLOS in s_PRUEFLOS.

Regards,

Srini.

Re: Validation in QM.

Former Member — Wed, 18 May 2011 11:40:55 GMT

Hi Srinivas,

Iam not using a select-options.

the upper and lower limit are coming from other table.

Re: Validation in QM.

Former Member — Wed, 18 May 2011 11:42:29 GMT

Hi Jiyaa,

better do this in Loop...Endloop after selection from QAMV and QAMR.

Loop at QAMV.

Read table QAMR with key (your condition)

value ge QAMV-lower

value le QAMV-upper.

if sy-subrc ne 0.

delete QAMR index sy-tabix.

endif.

Endloop.

Regards,

Goutam

Edited by: Goutam Sahoo on May 18, 2011 1:43 PM

Re: Validation in QM.

Former Member — Wed, 18 May 2011 12:22:36 GMT

Hi gowtham,

Iam unable to use logical operators in read table.

kindly,provide me with other way to do this validation.

Re: Validation in QM.

Former Member — Wed, 18 May 2011 12:29:24 GMT

Hi Jiyaa,

better you can sort the qamv internal table based on the field we will get the lower value of the field and do the same thing

to ascending order we will get the upper limit value. then do the coding.

s_op-sign = 'I'.

s_op-option = 'BT'.

s_op-low = "passthe lower limit

s_op-high = "pass the uper limit

and do the select query.

select * from QAMR into table i_QAMR

where PRUEFLOS in s_op.

Regards,

DHina..

Re: Validation in QM.

Former Member — Wed, 18 May 2011 12:43:52 GMT

Hi Jiyaa,

Plz go through that if getting right

Loop at first_internal_table Into wa_internal_table.

Select middle_amt From QAMR into wa_internal_table-middle_amt

Where middle_amt IN Between wa_internal_table-lower_amt AND wa_internal_table-upper_amt.

if sy-subrc eq 0.

modify first_internal_table from wa_internal_table.

endif.

clear: wa_internal_table.

endloop.

So using only one internal table, u get all three amt in each line item.

regards

Dhiraj Dangore

Re: Validation in QM.

Former Member — Thu, 19 May 2011 11:37:18 GMT

Hi Jiyaa,

I think u've taken care some commen field in this 2 table like prueflos, vorglfnr, marknr.

Loop at QAMV.

Read table QAMR with key (your condition like prueflos, vorglfnr, marknr).

if qamr-value ge QAMV-lower

and qamr-value le QAMV-upper.

continue.

else.

delete QAMR index sy-tabix.

endif.

Endloop.

Regards,

Goutam

Re: Validation in QM.

Former Member — Tue, 24 May 2011 06:05:26 GMT

Hi Gowtham,

Thanks for the guidance.

It worked.

Thanks,

Jiyaaaa