topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Mon, 28 Jul 2008 05:24:14 GMT

Hi,

Can anybody tel me what is wrong with following code:

data: itab_tbtco type TBTCO occurs 0.

data: wa type itab_tbtco.

select * into table itab_tbtco from tbtco where jobname = p_jname

and authcknam = p_uname

and strttime in s_time.

loop at itab_tbtco into wa.

write:/ wa-jobname, itab-authcknam, itab-strttime.

endloop.

bcz internal is not get fill by using above query.

if any thing is wrong tel me correct one.

thanks in advance

Re: internal table

Former Member — Mon, 28 Jul 2008 05:30:48 GMT

Hi,

Instead of


data: itab_tbtco type TBTCO occurs 0.

Write-



data:itab_tbtco type table of TBTCO occurs 0.

Regards,

Sujit

Re: internal table

former_member787646 — Mon, 28 Jul 2008 05:32:11 GMT

the problem is here in the loop. As the Internal table doesn't have a header line you have to access the components using a work area. Please try the following code and check.

loop at itab_tbtco into wa.

write:/ wa-jobname, wa-authcknam, wa-strttime.

endloop.

Hope it helps.

Murthy

Re: internal table

Former Member — Mon, 28 Jul 2008 05:40:38 GMT

hi,

Declare the work area as follows

DATA: WA type TBTCO. Rest of the code is correct.

Thanks!!

rahul

Re: internal table

former_member787646 — Mon, 28 Jul 2008 06:23:37 GMT

Hi ,

As Rahul said above,

Declare the WA as follows and do the change in the LOOP.

Data: WA like line of itab_tbtco. (or)

Data: WA type tbtco.

loop at itab_tbtco into wa.

write:/ wa-jobname, wa-authcknam, wa-strttime.

endloop.

Re: internal table

Former Member — Mon, 28 Jul 2008 06:49:44 GMT

Priya,

There have been several complaints that you do not follow up on your questions.

Please do that, and indicate which answer you found to be helpfull or correct.

My advice to others is, simply ignore the question.

Cheers,

Julius

PS: If the rules are broken in the question already, the whole thread thread is deleted and points are removed anyway...

Re: internal table

Former Member — Mon, 28 Jul 2008 10:11:48 GMT

Hi,

I think you dont need to declare a work area here.I hope the below code will help you.

data: itab_tbtco type TBTCO occurs 0.

*data: wa like line of itab_tbtco.

select * into table itab_tbtco from tbtco where jobname = p_jname

and authcknam = p_uname

and strttime in s_time.

loop at itab_tbtco.

write:/ itab_tbtco-jobname, itab_tbtco-authcknam, itab_tbtco-strttime.

endloop.

Thanks,

Khushbu.

Re: internal table

Former Member — Mon, 28 Jul 2008 11:05:24 GMT

Use following code....

DATA: itab_tbtco TYPE STANDARD TABLE OF tbtco .

DATA: wa TYPE tbtco.

SELECT * INTO TABLE itab_tbtco FROM tbtco WHERE jobname = p_jname
AND authcknam = p_uname
AND strttime IN s_time.


LOOP AT itab_tbtco INTO wa.

  WRITE:/ wa-jobname, WA-authcknam, WA-strttime.

ENDLOOP.

Re: internal table

Former Member — Mon, 28 Jul 2008 11:16:37 GMT

hi,

DATA: itab_tbtco TYPE STANDARD TABLE OF tbtco ,

wa TYPE tbtco.

SELECT * INTO TABLE itab_tbtco FROM tbtco WHERE jobname = p_jname

AND authcknam = p_uname

AND strttime IN s_time.

LOOP AT itab_tbtco INTO wa.

WRITE:/ wa-jobname, WA-authcknam, WA-strttime.

ENDLOOP.

ur using occurs that is good, but dont use '0' , use any number instead of '0', for performence issue

Re: internal table

Former Member — Mon, 28 Jul 2008 11:18:26 GMT

hi Priya ,

instead of writing

data: itab_tbtco type TBTCO occurs 0.

u can use

data: itab_tbtco type standard table of TBTCO .

Regards

Amit

Re: internal table

Former Member — Tue, 29 Jul 2008 07:20:05 GMT

Hi,

You can changed your code like this:


TABLES : tbtco.

"Define internal table itab_tbtco
DATA : itab_tbtco TYPE STANDARD TABLE OF tbtco.

"Define work area wa of internal table itab_tbtco
DATA : wa LIKE LINE OF itab_tbtco.

SELECTION-SCREEN BEGIN OF BLOCK b1.
PARAMETERS : p_jname TYPE tbtco-jobname,
             p_uname TYPE tbtco-authcknam.
SELECT-OPTIONS : s_time FOR tbtco-strttime.
SELECTION-SCREEN END OF BLOCK b1.

SELECT *
  INTO TABLE itab_tbtco
  FROM tbtco
  WHERE jobname = p_jname
  AND authcknam = p_uname
  AND strttime IN s_time.

LOOP AT itab_tbtco INTO wa.

  WRITE:/ wa-jobname, wa-authcknam, wa-strttime.

ENDLOOP.

A little suggestion:

The syntax of "DATA-OCCURS" has exactly the same function as the following DATA statement for the declaration of a standard table and is replace by this also:

DATA itab { {TYPE STANDARD TABLE OF [REF TO] type}

| {LIKE STANDARD TABLE OF [REF TO] dobj} }

WITH NON-UNIQUE DEFAULT KEY

INITIAL SIZE n.

[WITH HEADER LINE].

So it is better not to use "OCCURS 0" in the program.

Besides that, "WITH HEADER LINE" is also not recommended, the best way is to define an internal table, and then an extra work area of that internal table.

Hope it will help.

Best Regards,

Stephanie

Re: internal table

Former Member — Tue, 29 Jul 2008 07:57:01 GMT

Since the select is done as an array fetch ,(as selection is directly been done in the internal table from the database table) so the internal table is being filled in a loop , so end the select statement with endselect.

Thanks and Regards ,

Debojyoti Chanda.

Re: internal table

Former Member — Tue, 29 Jul 2008 07:57:58 GMT

Thanks and Regards ,

Debojyoti Chanda.

Re: internal table

Former Member — Tue, 29 Jul 2008 14:19:04 GMT

you can rewrite the code like this,

DATA : wa type itab_tbtco.

select *

into WA

from tbtco where jobname = p_jname

and authcknam = p_uname

and strttime in s_time.

write:/ wa-jobname, wa-authcknam, wa-strttime.

ENDSELECT.

and occurs 0 is an obsolete statement.

Regards

Jose

Edited by: Jijo Jose on Jul 29, 2008 7:49 PM

Re: internal table

Former Member — Thu, 31 Jul 2008 07:29:13 GMT

Hi Priya,

you can do the same thing in the following way:

data: itab_tbtco type table of TBTCO occurs 0.

(above statement will create an internal table of type TBTCO)

data: wa like line of itab_tbtco.

(above statement will create a work area for itab_tbtco)

select * into table itab_tbtco from tbtco where

jobname = p_jname

and authcknam = p_uname

and strttime in s_time.

loop at itab_tbtco into wa.

write:/ wa-jobname, wa-authcknam, wa-strttime.

endloop.

i hope this will help u...

Thanks & Regards

Ashu Singh