topic Re: pls help on oops in Application Development and Automation Discussions

pls help on oops

Former Member — Thu, 28 Dec 2006 06:32:26 GMT

hi every body

i had declared the internal table as

DATA: k_oib TYPE table of roib_def_index_gm.

DATA:k_oib TYPE table of oib_defaults_display.

***and selected like this

SELECT single * FROM oib_def_index_gm

INTO table k_oib

WHERE matnr = l_material

AND werks = i_plant

AND lgort = '0001'.

and used read

read table k_oib index 1.

i am error in select statement that table is not defined and it giving error in read table also it is not working.

pls give solutions.

Re: pls help on oops

Sandeep_Panghal — Thu, 28 Dec 2006 06:34:35 GMT

Hi,

I think ur data declaration is not correct .

Check for roib_def_index_gm , it doesnt look like a table.

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:34:58 GMT

Where have you declared the tables and where is the select? Are they both in the same class?

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:35:56 GMT

yes they in same class and same method

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:39:33 GMT

roib_def_index_gm is a structure

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:40:28 GMT

Hi ,

You have declared table k_oib twice and u require a workarea for readig internal table

Re: pls help on oops

jayanthi_jayaraman — Thu, 28 Dec 2006 06:40:55 GMT

Hi,

You are selecting from oib_def_index_gm table but declaration on

DATA: k_oib TYPE table of roib_def_index_gm.

DATA:k_oib TYPE table of oib_defaults_display.

Replace the lines by

DATA: k_oib TYPE table of oib_def_index_gm .

Before that check oib_def_index_gm is existing in dictionary.

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:44:22 GMT

oib_def_index_gm is tranperant table

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:45:28 GMT

first check if table oib_def_index_gm. exists in dictionary as i m not able to find this table and if it exists then write follwoing code -

DATA: k_oib TYPE table of oib_def_index_gm.

***and selected like this

SELECT single * FROM oib_def_index_gm

INTO table k_oib

WHERE matnr = l_material

AND werks = i_plant

AND lgort = '0001'.

and used read

read table k_oib index 1.

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:49:19 GMT

all tables exits in db.

it giving an error as

read dbtab is not supported in oo context

Re: pls help on oops

jayanthi_jayaraman — Thu, 28 Dec 2006 06:54:30 GMT

Hi,

Just copy paste this code and comment the previous code and check whether it is working.

<b>DATA: k_oib TYPE table of oib_def_index_gm ,

w_oib type oib_def_index_gm .</b>

SELECT single * FROM oib_def_index_gm

INTO table k_oib

WHERE matnr = l_material

AND werks = i_plant

AND lgort = '0001'.

and used read

read table k_oib <b>into w_oib</b> index 1.

Re: pls help on oops

Former Member — Thu, 28 Dec 2006 06:54:48 GMT

Hi,

Try declaring a workarea:

data: wa_oib type roib_def_index_gm.

Then try using the read statement as:

read table k_oib into wa_oib index 1.

Regards,

Kalpana