topic Ranges problem in Application Development and Automation Discussions

Ranges problem

kesavadas_thekkillath — Thu, 02 Jul 2009 11:55:35 GMT

Hi friends im pasting my code below.

The problem is the select Query is not returning any records when in pass the material input as 'F*' in my function module

Here pi_material holds the material No as F*


*Local internal tables Declaration
data: lr_matnr  TYPE RANGE OF mara-matnr,
      lr_batch  TYPE RANGE OF mch1-charg.

*Local WorkAreas
  DATA: wa_matnr like LINE OF lr_matnr,
        wa_batch like line of lr_batch.


  wa_matnr-sign = wa_batch-sign = zdic_pd_cl_common=>gc_sign_i.

  IF pi_material IS NOT INITIAL.
    MOVE pi_material TO wa_matnr-low.
    IF wa_matnr-low CA '*'.
      wa_matnr-option = zdic_pd_cl_common=>gc_option_cp.
      REPLACE ALL OCCURRENCES OF '*' IN wa_matnr-low WITH '%'.
    ELSE.
      wa_matnr-option = zdic_pd_cl_common=>gc_option_eq.
    ENDIF.
    APPEND wa_matnr TO lr_matnr.
  ENDIF.

  IF pi_batch IS NOT INITIAL.
    MOVE pi_batch TO wa_batch-low.
    IF wa_batch-low CA '*'.
      wa_batch-option = zdic_pd_cl_common=>gc_option_cp.
      REPLACE ALL OCCURRENCES OF '*' IN wa_batch-low WITH '%'.
    ELSE.
      wa_batch-option = zdic_pd_cl_common=>gc_option_eq.
    ENDIF.
    APPEND wa_batch TO lr_batch.
  ENDIF.


*Fetch Batch Data
  SELECT charg INTO TABLE et_batch FROM mch1 WHERE matnr in lr_matnr
                                             AND charg in lr_batch
                                             AND lvorm = space.

Re: Ranges problem

Former Member — Thu, 02 Jul 2009 12:03:16 GMT

may it be you forgot "corresponding fields of", between into and table?

Re: Ranges problem

Former Member — Thu, 02 Jul 2009 12:08:52 GMT

HI,

You have not update the ranges completly.

For a range you must have the following fields to update

SIGN and OPTION

LR_MATNR-SIGN = 'I'.

LR_MATNR-OPTION = 'EQ'.

APPEND LR_MATNR.

LR_BATCH-SIGN = 'I'.

LR_BATCH-OPTION = 'EQ'.

APPEND LR_BATCH.

With the ranges data capturing, you must have to append these values.

After that you can use in your queries.

Regds,

Anil

Re: Ranges problem

Former Member — Thu, 02 Jul 2009 12:12:26 GMT

THE % USED IN LIKE STATMENT NOT IN IN STATEMENT

IF pi_material IS NOT INITIAL.
    MOVE pi_material TO wa_matnr-low.
    IF wa_matnr-low CA '*'.
      wa_matnr-option = zdic_pd_cl_common=>gc_option_cp.
*      REPLACE ALL OCCURRENCES OF '*' IN wa_matnr-low WITH '%'. "COMMENT THIS LINE
    ELSE.
      wa_matnr-option = zdic_pd_cl_common=>gc_option_eq.
    ENDIF.
    APPEND wa_matnr TO lr_matnr.
  ENDIF.
 
  IF pi_batch IS NOT INITIAL.
    MOVE pi_batch TO wa_batch-low.
    IF wa_batch-low CA '*'.
      wa_batch-option = zdic_pd_cl_common=>gc_option_cp.
*      REPLACE ALL OCCURRENCES OF '*' IN wa_batch-low WITH '%'. "COMMENT THIS LINE
    ELSE.
      wa_batch-option = zdic_pd_cl_common=>gc_option_eq.
    ENDIF.
    APPEND wa_batch TO lr_batch.
  ENDIF.

Re: Ranges problem

Former Member — Thu, 02 Jul 2009 12:17:18 GMT

Hey anil he gave thos values, just have a closer look at his code. it is all there.

Re: Ranges problem

Pawan_Kesari — Thu, 02 Jul 2009 12:19:26 GMT

do not replace * with %

Re: Ranges problem

kesavadas_thekkillath — Thu, 02 Jul 2009 12:34:46 GMT

Hi since im passing CP in the ranges i should give '%'.

But Even i tried without it but still no use

Re: Ranges problem

vinod_vemuru2 — Thu, 02 Jul 2009 12:48:34 GMT

Hi,

Check this.

wa_matnr-sign = wa_batch-sign = 'I'.


  IF pi_material IS NOT INITIAL.
    MOVE pi_material TO wa_matnr-low.
    IF wa_matnr-low CA '*'.
      wa_matnr-option = 'CP'.
     ELSE.
      wa_matnr-option = 'EQ'.
    ENDIF.
    APPEND wa_matnr TO lr_matnr.
  ENDIF.
 
  IF pi_batch IS NOT INITIAL.
    MOVE pi_batch TO wa_batch-low.
    IF wa_batch-low CA '*'.
      wa_batch-option = 'CP'.
    ELSE.
      wa_batch-option = 'EQ'.
    ENDIF.
    APPEND wa_batch TO lr_batch.
  ENDIF.

Other way is simply comment above code.

Declare ur parameters as select-options with no intervals and No extention and use IN operator in the select query.

Thanks,

Vinod.

Re: Ranges problem

kesavadas_thekkillath — Thu, 02 Jul 2009 13:28:36 GMT

Hi GTREN the solution was correct but it was due my stupidity ...

there was a wrong view of data comparison with table and data from Query..

Any ways Thanks Guys...