sudhir kumar


{ City } jodhpur
< Country > india
* Profession *
User No # 93587
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 0
Questions / { sudhir kumar }
Questions Answers Category Views Company eMail




Answers / { sudhir kumar }

Question { Wipro, 17649 }

HOW MANY WAYS TO DEFINE INTERNAL TABLES.


Answer

Basically there are 3 methods of creating the internal table which are used frequently, are as following:

1) for ex.

data: it_mara type table of mara.

note: after type table of, always a structure is used.
hence, here we call it structure mara not table mara.
and one thing more, here we can use like table of . but
it is not recommend. it is mostly used method.

2) for ex.

data: it_mara type mara occurs 0.

it means it_mara is a internal table of type mara.if we
write:

data: it_mara type mara occurs o with headerline.

it means there will be a internal table and a workarea
with the same name i.e. it_mara. hence it will little
confusing.

3) tables mara.
data: it_mara like mara occurs 0.

here, with the help of first statement, a workarea will be created with the name of mara and second statement will crate internal table with the name of it_mara. This is also little confusing because we mara is also of database table name and here it is also name of work area.

for exe.

select *
from mara
into mara.

hence, first method is most suitable and it should be used.

Is This Answer Correct ?    4 Yes 0 No