topic Re: SAP ABAP Select Statement/ Queries in Application Development and Automation Discussions

SAP ABAP Select Statement/ Queries

Former Member — Mon, 14 Aug 2006 18:57:31 GMT

Hi.

select * from mver where matnr= itab-matnr

and werks = itab-bwkey

and perkz = 'P'

and gjahr = gjahr1.

there are option like 'P' and 'M' i need to select both of them like 'P/M'.

how can u do tht.

both "m" and "P" period buckets shd be populated with data and need to be added together to pull the zm001127.

Former Member — Mon, 14 Aug 2006 19:01:19 GMT

RANGES: r_perkz FOR mver-perkz.

r_perkz-option = 'EQ'.

r_perkz-sign = 'I'.

r_perkz-low = 'P'.

append r_perkz.

r_perkz-low = 'M'.

append r_perkz.

select * from mver where matnr= itab-matnr

and werks = itab-bwkey

and perkz IN r_perkz

and gjahr = gjahr1.

Former Member — Mon, 14 Aug 2006 19:01:47 GMT

Hi,

Create a range and then append both the value 'P' and 'M' to the internal table and use the range in the where clause.

data: r_range type range of mver-perkz with header line.

r_range-sign = 'I'.

r_range-option = 'EQ'.

r_range-low = 'P'.

APPEND R_RANGE.

r_range-sign = 'I'.

r_range-option = 'EQ'.

r_range-low = 'M'.

APPEND R_RANGE.

select * from mver where matnr= itab-matnr

and werks = itab-bwkey

and perkz IN R_RANGE

and gjahr = gjahr1.

RichHeilman — Mon, 14 Aug 2006 19:02:16 GMT

You can do this to get both values.





where matnr= itab-matnr
  and werks = itab-bwkey
<b>  and perkz in ('P', 'M')</b>
  and gjahr = gjahr1.

Regards,

Rich Heilman