topic Re: Table Control in Application Development and Automation Discussions

Table Control

Former Member — Wed, 20 Aug 2008 15:30:39 GMT

Hi all,

i had got a table control with 4 fields,,

orderno item material quantity

when i click the button 'DISPALY' it dispalys all the record from ztable , that is fine , but my requirement is when the user enters say orderno ' 5 ', in the input/output field .

Then it should show only the records of that particular orderno.

how should i approach for this kind of scenario.

this is my select query , it gives me the records of entire ztable..

this should not happen, it should depend on the user.

also tell me how to get the values of that orderno in text button.

when 'DISPLAY'.

select orderno

posnr

matnr

zmeng

into table it_test

from ztest2.

regards,

Pawan

Re: Table Control

Former Member — Wed, 20 Aug 2008 16:02:59 GMT

Hello,

I think what you can do is to restrict your SELECT Query based on the Order Number. You can use the WHERE Clause to compare the Order Number and then your Internal Table will be filled with only those fields matching the Input / Output Field Value.

Hope it was clear.

Thanks and Regards,

Venkat Phani Prasad Konduri

Re: Table Control

Former Member — Wed, 20 Aug 2008 17:09:58 GMT

hi,

this is my select query with where clause

select orderno

posnr

matnr

zmeng

into table it_test

from ztest2

where orderno = ztest2-orderno.

append wa_test to it_test

but it shows me the default order number ie the first record, but i want when the user enters orderno . it shows me the record of that ordernumber in table control.

name of i/o field :- number

regarsd,

Pawan.

Re: Table Control

Former Member — Wed, 20 Aug 2008 17:28:47 GMT

This is a very basic question. I don't know if it will help because I think I'm not understanding your problem.

If the i/o field is called "number" the select needs to look like


select orderno
posnr
matnr
zmeng
into table it_test
from ztest2
where orderno = number.