Table control in report selection screen

[Former Member]

Hi Guru's

I have a selection screen with Cost bucket fields ( Morethan 30 fields). Now, below these fields, I need a table control in which i will have input parameters with 3 fields so that i can enter data in combinations and use the same while executing the report like an internal table.

1. I should be able to save it as a Variants.

2. I should be able to schedule a background job.

Edited by: Syed Irfan Ali on Aug 26, 2011 11:40 AM

[Former Member]

This may help [|]

And regarding the variants matter, I once faced this issue and i came up with a reasonable solution since there's no standard option to store/retrieve the TC values in it.

What you can do is to declare as many Select-Options as columns your TC has, and hide them, so they will not show up. Then the only thing you gotta do is: when the user saves the variant, you have to load your TC data into these Select-Options, so they wil be filled with the data and stored in the variant along with the rest of the parameters.

Then when the user picks an existing variant, do the opposite: loop at the select-options and populate their data into your TC.

If anyone has a better idea, please post.

Regards

Edited by: Jose Maria Otero on Aug 26, 2011 1:18 PM

[former_member209703]

This may help [|]

And regarding the variants matter, I once faced this issue and i came up with a reasonable solution since there's no standard option to store/retrieve the TC values in it.

What you can do is to declare as many Select-Options as columns your TC has, and hide them, so they will not show up. Then the only thing you gotta do is: when the user saves the variant, you have to load your TC data into these Select-Options, so they wil be filled with the data and stored in the variant along with the rest of the parameters.

Then when the user picks an existing variant, do the opposite: loop at the select-options and populate their data into your TC.

If anyone has a better idea, please post.

Regards

Edited by: Jose Maria Otero on Aug 26, 2011 1:18 PM

[Former Member]

Hi Jose,

Thanks for Quick response.

Can you give sample code?

[Former Member]

Hi,

Screen should have Sub-screen with selection fields and bottom will have table control.

In the table control,Place the function code 'Variant'.

When ever the function code is triggered , call the new popup screen with input varaint name and description and save the table control data in the in the custom table.

Place one layout parameter in the main screen. so that you can can select the variant. and display the same data in table control.

and by this you can save selection fields and layout as main variant to the report.. based on this variant you can schedule the back ground job.

hope this will be helpful.

Regards

Aravind.

[Former Member]

Hi,

Thanks for your reply.i got some better idea..

Could you have any sample code ?

Thanks

[RaymondGiuseppi]

You cannot add a table control to a selection-screen, so you will have to do everything yourself, and insert your selection screen in a dynpro containing a table control, which is allowed.

Create a screen dynpro (not a selection-screen) with

- a subscreen area

- a table control

Create a [selection-screen as a subscreen|http://help.sap.com/saphelp_nw70/helpdata/en/e7/deb237b9a9a968e10000009b38f8cf/frameset.htm], put the standard parameters, and an hidden parameter in which you will copy the full internal table managed in the dynpro.

Then in PBO/PAI you will have to manage yourself the variants (select, save, etc) with FM of function group SVAR (RS_CREATE_VARIANT, etc.)

Regards,

Raymond