topic Regarding Dynamic selection in Application Development and Automation Discussions

Regarding Dynamic selection

Former Member — Tue, 13 Nov 2007 05:16:27 GMT

Can any one let me know how to use <b>dynamic selection</b> <b>with out using a LDB.</b>

Regads,

siva

Re: Regarding Dynamic selection

Former Member — Tue, 13 Nov 2007 05:19:16 GMT

try this.

Syntax Diagram

MODIFY SCREEN

Syntax

MODIFY SCREEN [FROM wa].

Effect

This statement can be used in the statement block after LOOP AT SCREEN only and makes sense only during PBO processing. If FROM is not specified, MODIFY SCREEN modifies the attributes of the current screen element with the values from the predefined screen work area. If a wa work area is specified, its contents are used for the modification.

The wa work area must have the same data type as screen. The name component must contain the name of the current screen element, otherwise the statement is not executed. nweisung nicht ausgefhrt. Up to the group1 to group4 and length components, all remaining components of screen and wa must contain either the value 0 or 1. The value 0 deactivates the corresponding field attribute, and 1 activates it.

If MODIFY SCREEN is executed during PBO processing, the modified attributes for the display of the screen affect the current dynpro after PBO processing. The attributes of the screen element of the dynpro are reset to their static attributes at the start of each PBO processing, so that the execution of MODIFY SCREEN during PAI processing does not effect the display of the following screen.

The active component

The active component is used to set the input, output and invisible components at once. At the start of PBO processing, the active component always has the value 1. If active is set to 0 with MODIFY SCREEN, input and output are automatically set to 0 and invisible is set to 1. Other values in input, output and invisible are ignored. Conversely, setting input and output to 0 and invisible to 1 automatically sets active to 0 and a different value in active is ignored.

Modifications in Table Controls and Step Loops

During processing of a table control or a step loop, the changes affect the current line of the table control or the current step loop group. Before the processing of a table control, the change to the attributes of a screen element that is part of a line in the table control does not effect the table control, since the values are transferred from the structure created using CONTROLS. Before a step loop is processed, the change to the attributes of a screen elements that is part of a step loop group affects all groups in the step loop.

Modifications to Tabstrip Controls

If the active component for a tab title of a tabstrip control is set to 0, the whole tabstrip page is hidden.

Example

In the following PBO module, an input field called val is made mandatory and converted to display in the foreground.

MODULE modify_0100 OUTPUT.

LOOP AT SCREEN.

IF screen-name = 'VAL'.

screen-required = '1'.

screen-intensified = '1'.

MODIFY SCREEN.

ENDIF.

ENDLOOP.

ENDMODULE.

Re: Regarding Dynamic selection

Former Member — Tue, 13 Nov 2007 05:26:58 GMT

Try to execute this.

----

Program Details *

----

report z_vik_dynamic_ss line-size 80

line-count 64

message-id zz

no standard page heading.

----

Tables *

----

tables : sscrfields, "Fields on selection screens

dd03l. "Table Fields

----

Type Pools *

----

type-pools:rsds.

----

Selection Screen *

----

selection-screen : begin of block b1 with frame title text-001,

skip,

begin of line,

comment 1(5) text-002.

parameters : p_tab like dd03l-tabname obligatory. "Table name

selection-screen : pushbutton 45(8) p_btn user-command clk,

"Select-options

end of line,

end of block b1.

----

Types *

----

types: begin of t_dd03l,

tabname like dd03l-tabname, "Table Name

fieldname like dd03l-fieldname, "Field Name

keyflag like dd03l-keyflag, "Key Flag

rollname like dd03l-rollname, "Roll Name

position like dd03l-position, "Position

ddtext(30), "Description

end of t_dd03l,

begin of t_fields.

include structure dd03l.

types: end of t_fields.

types : begin of t_tabs.

"To hold the table names

include structure rsdstabs.

types : end of t_tabs.

types : begin of t_flds.

"To hold the field names

include structure rsdsfields.

types : end of t_flds.

types : begin of t_fname,

"To hold the field names

fld like dd03l-fieldname,

end of t_fname.

----

Internal Tables *

----

data : it_dd03l type table of t_dd03l, "To hold the field names

it_tabs type table of t_tabs, "To hold the table names

it_flds type table of t_flds, "To hold the field names

it_temp type table of t_flds,

"Temp. table to hold field names

it_fields type table of t_fields, "To hold the field names

it_cat type table of lvc_s_fcat,"To hold Field Catalog

it_fname type table of t_fname.

----

Work areas *

----

data: d_ref type ref to data , "Data reference

wa_dd03l like line of it_dd03l, "Workarea for IT_DD03L

wa_tabs like line of it_tabs, "Workarea for IT_TABS

wa_flds like line of it_flds, "Workarea for IT_FLDS

wa_temp like line of it_temp, "Workarea for IT_TEMP

wa_fields like line of it_fields, "Workarea for IT_FIELDS

wa_cat like line of it_cat , "Workarea for IT_CAT

wa_fname like line of it_fname. "Workarea for IT_FNAME

----

Field Symbols *

----

field-symbols : <f_fs> type table.

"FieldSymbol for holding fields

----

Variables *

----

data: gx_texpr type rsds_texpr,

"Variable to hold Expression

gx_twhere type rsds_twhere,

"Variable to hold Where Clause

gv_selid like rsdynsel-selid, "Variable to hold Selid

gv_actnum like sy-tfill,

"Variable to hold no of fields

gv_title like sy-title, "Variable to hold Title

gv_where_cl(100) type c,

"Variable to hold Where clause

gv_tbname like dd03l-tabname,

gv_temp.

select-options:

s_fld for dd03l-fieldname no-display, "To hold fields selected

s_selop for dd03l-fieldname no-display,

"To hold fields for creating dyn. select-options

s_where for gv_where_cl no-display. "To hold where condition

parameters: gv_t_old like dd03l-tabname no-display.

"Earlier Table name

data : gt_grid type ref to cl_gui_alv_grid,

gt_cust type ref to cl_gui_custom_container, "Custom Container

cust type scrfname value 'CC_OUTPUT'.

"Custom controller

----

Constants *

----

constants: gc_i type c value 'I',

gc_eq(2) type c value 'EQ'.

----

Initialization *

----

initialization.

**--Initialize values

perform initialize.

----

At Selection Screen *

----

at selection-screen.

**--Select the fields of the input table

perform select_flds.

----

Start Of Selection *

----

start-of-selection.

**--Fetch data to display output

perform fetch_data.

----

End Of Selection *

----

end-of-selection.

call screen '0300'.

----

At User Command *

----

at user-command.

case sy-ucomm.

when 'OK'.

refresh it_temp.

clear it_temp.

move 'S' to wa_temp-type.

move gv_tbname to wa_temp-tablename.

do.

read line sy-index field value gv_temp into gv_temp.

if sy-subrc ne 0.

exit.

endif.

if gv_temp eq 'X'.

sy-index = sy-index - 1.

read table it_dd03l into wa_dd03l index sy-index.

if sy-subrc = 0.

move wa_dd03l-fieldname to wa_temp-fieldname.

append wa_temp to it_temp.

clear gv_temp.

endif.

enddo.

describe table it_temp.

if sy-tfill gt 70.

**--More than 70 fields can not be selected

message i001 with 'Cannot select more than 70 Parameters'(006).

refresh it_temp[]. clear it_temp.

else.

leave list-processing.

endif.

when 'CANCEL'.

leave list-processing.

when 'SELALL'.

**--Select all fields

clear wa_dd03l-fieldname.

do.

read line sy-index.

if sy-subrc eq 0 and

wa_dd03l-fieldname ne space.

gv_temp = 'X'.

modify line sy-index index 0 field value gv_temp.

hide gv_temp.

clear wa_dd03l-fieldname.

elseif sy-subrc ne 0.

exit.

endif.

enddo.

when 'DSELALL'.

**--Deselect all fields

clear gv_temp.

do.

read line sy-index.

if sy-subrc eq 0.

clear gv_temp.

modify line sy-index index 0 field value gv_temp from gv_temp.

hide gv_temp.

elseif sy-subrc ne 0.

exit.

endif.

enddo.

endcase.

sy-lsind = 0.

&----

*& Form INITIALIZE

&----

Initialize values on selection-screen

----

form initialize .

p_btn = 'Options'(003).

endform. " INITIALIZE

&----

*& Form SELECT_FLDS

&----

Select fields from the table

----

form select_flds .

case sscrfields-ucomm.

when 'CLK'.

**--Display Screen with the list of fields

perform genr_scr.

endcase.

endform. " SELECT_FLDS

&----

*& Form genr_scr

&----

Display a screen with list of fields

----

form genr_scr.

**--If table in the parameter is not the same as the old table and

**--old table is not blank, then initialise all the variables associated

if p_tab ne gv_t_old and gv_t_old is not initial.

refresh: it_tabs, it_flds,

gx_texpr, gx_twhere,

s_where, s_selop.

clear: gv_selid.

**--Pass current table parameter value to Old table parameter

gv_t_old = p_tab.

endif.

**--Pass the current table name to old table variable

if gv_t_old eq space.

gv_t_old = p_tab.

endif.

**--Check if table name is given before clicking the button

if p_tab is initial.

message e001 with 'Enter the Table name'(004).

endif.

**--Get the list of fields of a given table

perform get_selections.

**--If none of the fields, provide the list of fields for selecting

if it_flds[] is initial.

clear gv_selid.

perform select_fieldlist.

endif.

**--Show message if none of the fields are selected

if it_flds[] is initial.

message s001 with 'No parameters selected'(005).

exit.

endif.

**--Generate dynamic select-options

refresh it_tabs.

clear : it_tabs, wa_tabs.

wa_tabs-prim_tab = p_tab.

append wa_tabs to it_tabs.

perform set_values.

**--Generate Expression from Where clause

call function 'FREE_SELECTIONS_WHERE_2_EX'

exporting

where_clauses = gx_twhere

importing

expressions = gx_texpr

exceptions

incorrect_expression = 1

others = 2.

if sy-subrc ne 0.

message i001 with 'Error in Dynamic screen generation'(009).

exit.

endif.

if gx_texpr is not initial.

**--Populate values to select-options from expression

perform set_values.

endif.

**--Display screen with the fields listed

if gv_selid is not initial.

perform call_screen.

endif.

endform. " genr_scr

&----

*& Form GET_SELECTIONS

&----

Fetch the fields in the table given

----

form get_selections.

data : wa_where like line of gx_twhere.

refresh: it_flds, gx_twhere.

clear : wa_flds.

wa_flds-tablename = p_tab.

wa_flds-type = 'S'.

loop at s_selop.

**--Populate all the fields selected that are previously selected

wa_flds-fieldname = s_selop-low.

append wa_flds to it_flds.

endloop.

if s_where[] is not initial.

**--Populate values to where condition if any data is previously given

**--to the dynamic select-options

wa_where-tablename = p_tab.

loop at s_where.

append s_where-low to wa_where-where_tab.

endloop.

append wa_where to gx_twhere.

endif.

endform. " GET_SELECTIONS

&----

*& Form SELECT_FIELDLIST

&----

Display the list of fields

----

form select_fieldlist.

clear: it_dd03l[], it_dd03l,

gv_tbname.

**--Get field names for given table

select tabname

fieldname

keyflag

rollname

position

from dd03l

into table it_dd03l

where tabname eq p_tab

and fieldname ne 'MANDT'.

if sy-subrc = 0.

sort it_dd03l by position.

delete it_dd03l where fieldname cp '.INCLU*'.

endif.

**--Get the description of the fields

loop at it_dd03l into wa_dd03l.

if not wa_dd03l-rollname is initial.

select single ddtext

from dd04t

into wa_dd03l-ddtext

where rollname eq wa_dd03l-rollname

and ddlanguage = sy-langu

and as4local = 'A'.

modify it_dd03l from wa_dd03l.

else.

select single ddtext

from dd03t

into wa_dd03l-ddtext

where tabname eq wa_dd03l-tabname

and ddlanguage = sy-langu

and as4local = 'A'

and fieldname = wa_dd03l-fieldname.

modify it_dd03l from wa_dd03l.

endif.

endloop.

gv_tbname = p_tab.

**--Display screen with the fields listed for the given table

call screen 200 starting at 10 2

ending at 70 22.

**--Clear all the fields selected

clear : it_flds, it_flds[], gv_tbname.

**--Populate the newly selected fields

it_flds[] = it_temp[].

**--Clear temporary table with the fields selected

clear : it_temp, it_temp[].

endform. " SELECT_FIELDLIST

&----

*& Form INITIALIZE_SCREEN

&----

text

----

form initialize_screen.

call function 'FREE_SELECTIONS_INIT'

exporting

kind = 'T'

expressions = gx_texpr

importing

selection_id = gv_selid

number_of_active_fields = gv_actnum

tables

tables_tab = it_tabs

fields_tab = it_flds

exceptions

fields_incomplete = 01

fields_no_join = 02

field_not_found = 03

no_tables = 04

table_not_found = 05

expression_not_supported = 06

incorrect_expression = 07

illegal_kind = 08

area_not_found = 09

inconsistent_area = 10

kind_f_no_fields_left = 11

kind_f_no_fields = 12

too_many_fields = 13.

endform. " INITIALIZE_SCREEN

&----

*& Form SET_VALUES

&----

Set the values to the select-options

----

form set_values.

call function 'FREE_SELECTIONS_INIT'

exporting

kind = 'T'

expressions = gx_texpr

importing

selection_id = gv_selid

number_of_active_fields = gv_actnum

tables

tables_tab = it_tabs

fields_tab = it_flds

exceptions

fields_incomplete = 01

fields_no_join = 02

field_not_found = 03

no_tables = 04

table_not_found = 05

expression_not_supported = 06

incorrect_expression = 07

illegal_kind = 08

area_not_found = 09

inconsistent_area = 10

kind_f_no_fields_left = 11

kind_f_no_fields = 12

too_many_fields = 13.

endform. " SET_VALUES

&----

*& Form CALL_SCREEN

&----

Call the screen to display the fields

----

form call_screen.

data : wa_where like line of gx_twhere,

lv_txt type string.

lv_txt = 'Dynamic Selections Parameters for'(007).

concatenate lv_txt p_tab

into gv_title separated by space.

call function 'FREE_SELECTIONS_DIALOG'

exporting

selection_id = gv_selid

title = gv_title

tree_visible = ' '

importing

where_clauses = gx_twhere

expressions = gx_texpr

number_of_active_fields = gv_actnum

tables

fields_tab = it_flds

exceptions

internal_error = 01

no_action = 02

no_fields_selected = 03

no_tables_selected = 04

selid_not_found = 05.

if sy-subrc eq 0.

refresh: s_where, s_selop.

**--Populate the Where clause with selected values

s_where-sign = gc_i.

s_where-option = gc_eq.

clear wa_where.

read table gx_twhere index 1 into wa_where.

loop at wa_where-where_tab into s_where-low.

append s_where.

endloop.

**--Populate all the fields

s_selop-sign = gc_i.

s_selop-option = gc_eq.

clear : wa_flds.

loop at it_flds into wa_flds.

s_selop-low = wa_flds-fieldname.

append s_selop.

endloop.

endif.

endform. " CALL_SCREEN

&----

*& Module STATUS_0200 OUTPUT

&----

Display screen with select-options

----

module status_0200 output.

data: lv_txt type string.

lv_txt = 'Selection Paramters List'(008).

set pf-status 'DIALOG'.

leave to list-processing and return to screen 0.

suppress dialog.

move lv_txt to sy-title.

**--display list of fields that can be selected for creating dynamic

*select-options

loop at it_dd03l into wa_dd03l.

at first.

write: (60) sy-uline.

endat.

read table it_flds into wa_flds with key fieldname =

wa_dd03l-fieldname.

if sy-subrc ne 0.

clear gv_temp.

else.

gv_temp = 'X'.

endif.

write:/ '|' ,gv_temp as checkbox.

write: (20) wa_dd03l-fieldname,'|', wa_dd03l-ddtext, at 60 '|'.

hide: gv_temp, wa_dd03l-fieldname, wa_dd03l-keyflag.

at last.

write: (60) sy-uline.

endat.

endloop.

endmodule. " STATUS_0200 OUTPUT

&----

*& Form FETCH_DATA

&----

Fetch data from table

----

form fetch_data .

data: lv_where type string,

lv_cnt type i.

**--Check for the existance of the table

select *

from dd03l

into table it_fields

where tabname = p_tab.

sort it_fields by position.

**--Delete the fields starting with .INCLU

delete it_fields where fieldname cp '.INCLU*'.

**--Display the first 150 fields of the table

loop at it_fields into wa_fields to 150.

lv_cnt = lv_cnt + 1.

wa_cat-tabname = p_tab.

wa_cat-fieldname = wa_fields-fieldname.

wa_cat-col_pos = lv_cnt.

wa_cat-inttype = wa_fields-inttype.

wa_cat-datatype = wa_fields-datatype.

wa_cat-intlen = wa_fields-intlen.

wa_cat-seltext = wa_fields-fieldname.

wa_cat-decimals = wa_fields-decimals.

wa_cat-ref_field = wa_fields-fieldname.

wa_cat-ref_table = p_tab.

append wa_cat to it_cat.

clear wa_cat.

wa_fname-fld = wa_fields-fieldname.

append wa_fname to it_fname.

clear wa_fname.

endloop.

**--Create a dynamic internal table with the 150 fields

call method cl_alv_table_create=>create_dynamic_table

exporting

it_fieldcatalog = it_cat

importing

ep_table = d_ref.

assign d_ref->* to <f_fs>.

**--Populate the Where clause as a string

loop at s_where.

concatenate lv_where s_where-low into lv_where separated by space.

endloop.

**--Select the data from the table given as input and populate

**--it into the dynamic internal table created based on the where

*condition

select (it_fname)

from (p_tab)

into corresponding fields of table <f_fs>

where (lv_where).

**--If no entries are found that satisfies the selection criteria

if sy-subrc <> 0.

message i000(zz) with 'No data found'(010).

endif.

endform. " FETCH_DATA

&----

*& Form DISPLAY_DATA

&----

Display data in the grid control

----

form display_data .

if gt_cust is initial.

create object gt_cust

exporting

container_name = cust .

create object gt_grid

exporting

i_parent = gt_cust.

**--Display the data in the grid control

call method gt_grid->set_table_for_first_display

exporting

i_buffer_active = 'X'

i_bypassing_buffer = ' '

I_CONSISTENCY_CHECK =
I_STRUCTURE_NAME =
IS_VARIANT =
I_SAVE =
I_DEFAULT = 'X'
IS_LAYOUT =
IS_PRINT =
IT_SPECIAL_GROUPS =
IT_TOOLBAR_EXCLUDING =
IT_HYPERLINK =
IT_ALV_GRAPHICS =
IT_EXCEPT_QINFO =
IR_SALV_ADAPTER =

changing

it_outtab = <f_fs>

it_fieldcatalog = it_cat

IT_SORT =
IT_FILTER =

exceptions

invalid_parameter_combination = 1

program_error = 2

too_many_lines = 3

others = 4

if sy-subrc <> 0.

endif.

endform. " DISPLAY_DATA

&----

*& Module DISPLAY_DATA OUTPUT

&----

Dispaly data in the output

----

module display_data output.

perform display_data.

endmodule. " DISPLAY_DATA OUTPUT

&----

*& Module STATUS_0300 OUTPUT

&----

Pf-status for the screen

----

module status_0300 output.

set pf-status '13317'.

endmodule. " STATUS_0300 OUTPUT

&----

*& Module USER_COMMAND_0300 INPUT

&----

Handling the button clicks

----

module user_command_0300 input.

case sy-ucomm.

**--Go to the previous screen

when 'BACK'.

leave to screen 0.

**--Come out of the program

when 'EXIT'.

leave program.

endcase.

endmodule. " USER_COMMAND_0300 INPUT

AT SELECTION-SCREEN OUTPUT (In this event)

(Screen table stores the current selection screen contents temporarily when the selection screen is loaded and before it is displayed)

example.

LOOP AT SCREEN.

if <screen-field> is space.

if screen-name = <screen-field>.

screen-required = 1.

modify screen.

endif.

The above is an example code to make a field obligatory dynamically.

check out in se11 the fields in the structure screen. u can manipulate the selection screen dynamically using those fields.

Re: Regarding Dynamic selection

Former Member — Tue, 13 Nov 2007 05:34:58 GMT

HI,

see this simple example.

data:var1(10) value 'MATNR',var2(10) value 'MARA',

var3(20) value 'MATNR LIKE ''C%''',

matnr like mara-matnr.

select (var1) into matnr from (var2)

where (var3).

write:/ matnr.

endselect.

rgds,

bharat.