HOW TO FIX WARNING "SELECT QUERY"

[anilkumar_raina]

TABLES:FEBEP.

the query is

select kukey esnum kwbtr partn pablz from FEBEP into corresponding fields of FEBEP.

CODE INSPECTOR GIVES ME ERROR LARGE TABLE SPECIFY WHERE CLAUSE.BUT I CAN'T SPECIFY WHERE CLAUSE.

[Former Member]

TABLES:FEBEP.

select kukey esnum kwbtr partn pablz from FEBEP into corresponding fields of FEBEP

WHERE key1 = c1

AND key2 = c2

...

[anilkumar_raina]

BUT MY PROBLEM IS THAT I CANNOT GIVE ANY KEY IN WHERE CLAUSE

[Former Member]

Hi

Your error message suggests that you are trying to select too much data, so a couple of questions first:

1. Why can you not specify a Where clause?

2. How many records are held in FEBEP on your system?

You are also selecting ALL of the fields from this table - I am sure you do not need ALL of them for your needs so I would suggest trying to create an itab based on a just those fields that you are actually going to use, for example:

TYPES:
  BEGIN OF ty_febep,
    kukey LIKE febep-kukey,
    esnum LIKE febep-esnum,
  END OF ty_febep.

DATA:
  i_febep TYPE STANDARD TABLE OF ty_febep.

SELECT kukey esnum
INTO TABLE i_febep
FROM febep.

This might help but I suspect it is more to do with not having a Where condition.

Let me know how you get on.

Kind regards

Andy

[Former Member]

Hi Anil,

(You can hide the message using "#EC *).

Reward if this helps.

Manish

[Former Member]

hi

good

it might be you r selecting and puttiong the dta in the same table.

thanks

mrutyun^

[Former Member]

Hi,

Instead of using Single select query, use Select....Endselect.

Select ............. into work_area....

Append itab from work_area

endselect.

If it works, please reward.

Thanks

Prem

[former_member772250]

Hello All,

Is anyone help me about "SAP AutoBank" tool ? have few questions on this sujbect

Thank you very much for your help and support

Thanks

Parandham