topic Re: Table fields as screen parameters?? in Application Development and Automation Discussions

Table fields as screen parameters??

former_member209920 — Fri, 22 Jul 2011 04:07:05 GMT

I have a table ZTCUST. I need to display the table fields as screen parameters so that when new fields are added to the table, it automatically get displayed on selection screen. I don't know how to create such screen. Please help.

Re: Table fields as screen parameters??

Former Member — Fri, 22 Jul 2011 04:41:14 GMT

Hi,

I think its not possible. Automatically we cant display the new field in the selection screen via program. once you define the selection screen what are the input field you given that only it will display. suppose you add any field in the table you should add to your selection screen also. we cant write the code for automatically add the input field.

suppose you want to display the output as the ztable value means :

while creating t.code its self call the se16 and skip the first screen and give the table name then it will directly call the se16. after that you have to go se16 give the table name and choose the menu settings->field for selection

give the all field name in the table and run the t.code.

suppose you add any field means you should add the field in se16 the menu settings->field for selection give the new field also.

Regards,

Dhina..

Re: Table fields as screen parameters??

lijisusan_mathews — Fri, 22 Jul 2011 04:41:44 GMT

what is your requirement? Are you trying to create a screen to enter values into this table? If so, you should probably create a table maintenance view and recreate/edit it each time you add new fields to the table along with adjusting the table. New fields will now be added and you can fill in values.

Re: Table fields as screen parameters??

former_member209920 — Fri, 22 Jul 2011 06:58:01 GMT

My requirement is that I have a table ZTCUST having fields say F1, F2, F3 and F4. I need to create a selection screen with these fields i.e. F1, F2, F3 and F4 as parameter (or select option).

Later on, if some fields are added in ZTCUST say F5, F6, then these new fields should also be displayed in that screen automatically.

Re: Table fields as screen parameters??

lijisusan_mathews — Fri, 22 Jul 2011 07:06:33 GMT

You will have to create Dynamic selection screens.

Get the fields of your table using field symbols ( to get the name ) and then include them in your dynamic selection screen.

Re: Table fields as screen parameters??

former_member209920 — Fri, 22 Jul 2011 07:26:16 GMT

Can you please explain a little?

Re: Table fields as screen parameters??

former_member209920 — Fri, 22 Jul 2011 07:49:13 GMT

But how can I get the enter values in selection screen (created using SE16)?

Re: Table fields as screen parameters??

koolspy_ultimate — Fri, 22 Jul 2011 08:22:15 GMT

i think you need to display f4 functionality in selection screen.

i.e if you click on that f4 functionality then it wil display the values present in that table for that particular field.


SELECT-OPTIONS: s_matnr for mara-matnr.

after executing the report you wil get selection screen then one f4 functionalty wil be displaying beside the empty box,

just click f4 or press on that button , then you can see the values present in that table and select your desired values.

Re: Table fields as screen parameters??

Former Member — Fri, 22 Jul 2011 10:15:48 GMT

Hi Manu,

I solved my problem with table control.I created a screen.Implemented a table control with two columns.

first colum is name of the field ( non-editable ), second column is empty ( editable ).

when i run the transaction first i went to dictionary ( DD03L ) and read fields of my table.I filled internal table line by line with my table fields ( with texts DD03T).

For example i have 10 fields in my database table,

i will get a table control with 10 lines.First column is the field name ( or definition ), second column is empty ( ready for user entries ).

when user runs this screen,

i read all lines one by one and create a dynamic query using field-symbols.

Hope it helps.

Burak