topic Re: module pool in Application Development and Automation Discussions

module pool

Former Member — Thu, 03 Nov 2005 10:42:54 GMT

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

Re: module pool

Former Member — Thu, 03 Nov 2005 10:48:21 GMT

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

Re: module pool

Former Member — Thu, 03 Nov 2005 10:50:55 GMT

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