topic Re: screen based on a table in Application Development and Automation Discussions

screen based on a table

Former Member — Mon, 04 Aug 2008 12:30:10 GMT

i have created a screen based on a table and unter the part process before output in module status_2001 i want to add a selection into the fileds in the screen i created which are in the same names as in the table

i wrote:

module status_2001 output.

select single *

from (table name)

into corresponding fileds of (?????).

endmodule,

what do i need to write insted of '????' that it will show on the screen.

ami .

Re: screen based on a table

Former Member — Mon, 04 Aug 2008 12:38:43 GMT

Try this:

in top include define a "tables" statement.

tables: <table name>.

select single *

from <table name>

into <table name>.

Regards,

JOy.

Re: screen based on a table

naveen_inuganti2 — Mon, 04 Aug 2008 12:39:24 GMT

Hi....Ami...

Make clear that your screen contains table control or not....!

If not.... as you know we can display one entry in the fields at a time.... so which entry o fthe table you wnat to display in your screen...

Thanks,

Naveen Inuganti.

Re: screen based on a table

Former Member — Mon, 04 Aug 2008 12:39:45 GMT

hi,

Mention the variables which you have defined in the layout.

Re: screen based on a table

Former Member — Mon, 04 Aug 2008 12:39:52 GMT

R u using a table control. if yes u link the fields of table control with the dictionary fields

Re: screen based on a table

Former Member — Mon, 04 Aug 2008 12:42:04 GMT

Joy,

tables: <table name>.

select single *
from <table name>
into <table name>.

it is same as

tables: <table name
select single *
from <table name>."no into cluse

Re: screen based on a table

Former Member — Mon, 04 Aug 2008 12:48:19 GMT

Yes u r right ..I have to give endselect here like:

tables: mara.

select * from mara

into mara

where matnr = '000000000000000001'.

endselect.

Regards,

Joy.

Edited by: Joyjit Ghosh on Aug 4, 2008 2:54 PM

Re: screen based on a table

Former Member — Mon, 04 Aug 2008 12:56:09 GMT

Yup ;-0