topic Re: internal table without headerline in Application Development and Automation Discussions

internal table without headerline

Former Member — Sat, 14 May 2005 18:06:36 GMT

hi,

I just started learning ABAP. I was struck up with this problem.

DATA : BEGIN OF str_mara,

Matnr LIKE MARA-MATNR,

END OF str_mara.

DATA : i_tab TYPE TABLE OF str_mara.

i declared internal table without headerline like this. now how can i write select query to fetch data from mara table and how can i display it??

plz help me,

thanks,

Re: internal table without headerline

Former Member — Sat, 14 May 2005 19:25:34 GMT

Hello,

you can loop at the table.

DATA wa_tab type str_mara.

loop at i_tab into wa_tab where log expresion

write wa_typ-plz.

endloop.

read table i_tab.

more about loop or read you find at sap docu.

Re: internal table without headerline

ssimsekler — Sat, 14 May 2005 19:42:27 GMT

Hi Ravindra

Firstly, I recommend a structural study like the standard SAP course BC 400, or from the book <a href="http://www.sap-press.com/product.cfm?account=&product=H958">"The Official ABAP Reference Book"</a> by Horst Keller and Joachim Jacobitz.

About your question:

1. To retrieve data from the DB table mara, you can use the SELECT statement.

e.g.

SELECT matnr FROM mara
       INTO TABLE i_tab
       WHERE cdate GE sy-datum .

2. To iterate in i_tab you need a work area since you declared your internal table without a header line. You can use str_mara which you have already declared.

e.g.

LOOP AT i_tab INTO str_mara .
  WRITE:/ sy-tabix, str_mara-matnr .
ENDLOOP .

However, these examples may just demonstrate some primitive functionality. For more options, you can use the F1 help feature of the SAP system or the resources I mentioned above.

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Re: internal table without headerline

Former Member — Sun, 15 May 2005 03:42:10 GMT

Hi~

If you didn't declare headerline explicitly, the headerline is made with same name as internal table by system, implicitly.

look at your code

DATA : BEGIN OF str_mara,
       Matnr LIKE MARA-MATNR,
END OF str_mara.

DATA : i_tab TYPE TABLE OF str_mara.

you declared a structure, an internal table.

like this

structure : str_mara 
 
internal table : i_tab

   header line ++++++++++++++++++++++++
               i_tab     
   body        ++++++++++++++++++++++++
               ....
               ++++++++++++++++++++++++

if you want to select query to fetch data from mara table

and display it, refer next code snippet.

1) select 
   SELECT matnr FROM mara   
      INTO TABLE i_tab 
     WHERE log expression.
2) display
   loop at i_tab.
      WRITE:/ sy-tabix, i_tab-matnr.
   endloop.

Even though you didn't declare header line, The header line is declared implicitly.

I mean,

   loop at i_tab.
      WRITE:/ sy-tabix, i_tab-matnr.
   endloop.

equals.

   loop at i_tab (into i_tab).
      WRITE:/ sy-tabix, i_tab-matnr.
   endloop.

the first i_tab means internal table, and the second one means headerline.

But SAP recommend you define header line, internal table

explicitly.

I wish I could you help.

Regards

Kyung Woo

Re: internal table without headerline

eyal_alsheikh — Sun, 15 May 2005 07:44:53 GMT

Hi RAVINDRA,

Maybe this book will help you

http://cma.zdnet.com/book/abap/

Eyal.

Re: internal table without headerline

athavanraja — Sun, 15 May 2005 07:50:05 GMT

data: wa_mara like line of i_tab .

select * from mara into table i_tab .

loop at i_tab into wa_mara .

write:/wa_mara .

endloop .

Regards

Raja