module pool

[Former Member]

Hi to all,

I am a ABAP learner..

i have done with table wizard ...table mara...i have got the output of some mara fields...but i wanted make matnr as a select option...what is the syntex and also if i wanted get data from two table in table wizard can i do it any join between these tables....

give me some basic sample codes in table controls..

raju

[Former Member]

hi,

for select option you can use:

SELECT-OPTIONS: URART FOR mara-matnr.

to get data from two tables into a table control simply define a internal table in your program and fill it using both the tables.

you can use this internal table in your table control using table control wizard to display data.

regards,

Hemendra

[Former Member]

To make Matnr as a select option.

tables: mara.

select-options: s_matnr for mara-matnr.

to get data using joins, the syntax is something like this,

select mara~matnr

makt~maktx

from mara inner join makt on mara-matnr = makt-matnr

into table t_itab

where matnr in s_matnr

use the internal table t_itab in the table control you have created, using the wizard.(Use get from program option in the screen painter)

Ravi

Message was edited by: Ravi Kanth Talagana

Message was edited by: Ravi Kanth Talagana