topic Module pool programming in Application Development and Automation Discussions

Module pool programming

Former Member — Fri, 11 May 2007 09:40:40 GMT

Hi,

I had created two screens in module pool, second screen has table control

in that i want to two tables data print.By using of join statement i had written the select statement but the data was not printed.

plz tell me how to print two tables data in the table.

send me code.

reguards

raji

Former Member — Fri, 11 May 2007 09:47:45 GMT

Hi Rajyalakshmi,

SELECT a_{matnr a}mEINS A_{MTART D}MAKTx b_{werks c}lgort c~labst INTO CORRESPONDING FIELDS OF TABLE I_ab

FROM mara AS a

INNER JOIN MAKT AS D on a_{matnr = d}matnr

inner join marc AS b

ON a_{matnr = b}matnr

inner join MARD as c

ON B_{MATNR = C}MATNR AND B_{WERKS = C}WERKS

where A_{MATNR IN S_MATNR and b}werks in s_werks.

loop at i_tab with control tab_cntrl .

READ TABLE i_tab1 INDEX tab_cntrl-current_line.

endloop.

Reward points if helpful.

Regards,

Hemant

Former Member — Fri, 11 May 2007 09:49:54 GMT

Hi,

In the PAI event of the first screen,,u can fetch the data into Internal table...

In the PBO of second screen...

u need to use

loop at itab with control Tc cursor current-line.

endloop..

In the PAI of second scrren u have to use an empty loop statement...

then the data will apper in ur table control..

For clear understanding go through sap library....

Cheers,

ravi