topic Re: Dynamic Selection based on checkbox - FBL5N t-code customization in Application Development and Automation Discussions

Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 06:23:17 GMT

Hi Experts!

Kindly help me out with the following:

We are creating a customized report by copying the t-code FBL5N functionality. On the selection screen we have Dynamic Selections (Shift+F4) which gives a new selection screen which consists of some fields under Customer Master, Company code and Documents.

Now our requirement is that, we have our own checkbox on the selection screen. Now when this checkbox is checked, we need to get some specified values (based on our own data) into the field Document Type which is present under Documents in the dynamic selection.

Is this any way possible? If yes, please help me with the way or some ideas. Kindly go through the standard program once.

Thanks a lot.

Regards,

Seenu

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 06:27:03 GMT

what is the problem?

wont a if block will help you?

if p_chkbox = 'X'.

select xyz from abc into table it_abc where xyz = lmn.

endif.

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 06:33:41 GMT

Hi Sowmya,

The first problem is, selecting a checkbox won't take the control to at selection-screen output, so that it can be filled and shown and the other problem is that it has become so confusing to find which field is meant for Document Type, so that I can fill it. I thought that this functionality is not possible, but just wanted to check before confirming on something.

Hope I am clear.

Thanks,

Seenu

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 06:36:24 GMT

hi srini,

first thing is checkbox responds to at selection screen out put.

PARAMETERS : p1 as CHECKBOX USER-COMMAND abc.

second things is document type can be fetched from mhnd table

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 06:36:32 GMT

Hi,

This is a dynamic select-option which is coming from the LDB being used you can try like below in the copied program at event


at selection-screen output.
 if checkbox = 'X'.
  %%DYN009-LOW = 'VALUE'.
  %%DYN009-sign = 'I'.
  %%DYN009-option = 'EQ'.
  append %%DYN009.
endif.

Himanshu

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 06:59:54 GMT

Hi,

Thanks for the replies. Let me try these and get back to you if I face any problems. Thanks a lot.

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 07:18:35 GMT

Hi,

I am sorry to say that i couldn't understand how this Logical Database works. Can anybody help me with this? How can I know the field name that is being used for Document Type? Please help me out.

Thanks a lot.

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 07:22:24 GMT

srini,

have you tried the method i suggested?

PARAMETERS : p1 as CHECKBOX USER-COMMAND u1.

at selection-screen output.
loop at screen  
  if p1 = 'X'.
     ....
     ....
     ....
   modify screen.
  endif.
endloop.

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 07:39:04 GMT

Hi Soumya,

I tried this and hence got the control once I selected the checkbox. This doubt is solved for sure. Now my doubt is on how the Document Type should be updated with the values.

Can somebody please help me out?

Thanks,

Seenu

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 07:54:37 GMT

Hi,

Based on the declarations in LDB it would create dynamic selection screen based on user selection. So you can try to fill the select-options at selection-screen output event only just append the entries to the range and that should do it.

Regards,

Himanshu

Re: Dynamic Selection based on checkbox - FBL5N t-code customization

Former Member — Wed, 12 Aug 2009 09:19:37 GMT

parameters: doc_type type BLART modif id m1.
at selection-screen output.
  loop at screen.
   if screen-group1 = 'M1'.
     if p_chk <> 'X' and 
           screen-active = 0.
     else.
          screen-active = 1.
     endif.
     modify screen.
    endif.
   endloop.

this will make the document type field active, when you tick the chk box. and pass the values to the document type as you need