topic Re: Getting checked record data in Application Development and Automation Discussions

Getting checked record data

Former Member — Tue, 17 Jul 2007 21:36:35 GMT

Hi,

I have a report with ALV output and it has a column check box. I want to capture all the records which were checked . I tried this way, but nothing is coming it to GS_ZPRICE .And also after the Create Cmemo button is pressed and getting the data of checked records, I want to call the function to create the CM Request only for the material(material can be different) with same customer, same sales org, distribution channel and Division. How can I put this condition before calling the Fuction module.

CASE i_ucom.

WHEN 'CMEMO'.

LOOP AT gt_zprice INTO gs_zprice WHERE chbox = 'X'.

Please help me.

Thanks,

Neelu

Re: Getting checked record data

Former Member — Tue, 17 Jul 2007 21:47:30 GMT

HI,

well, what alv method are you using? This way is for the F.M. REUSE_ALV_GRID_DISPLAY_LVC.

First of all, you must declare, in your internal table declaration, a field called f.e. "mark".

data: begin of ti.... occurs...

mark,

bukrs like ...

...

end of ti...

Then, in the ALV layout structure, must specify this field.

layout-box_fname = 'MARK'.

And you must specify too, the selection mode of the ALV.

layout-sel_mode = 'A'.

Later, in the USER_COMMAND form, you can catch the lines marked of the ALV:

form user_command using f_ucomm like sy-ucomm

i_selfield type slis_selfield.

loop at TI_ALV where MARK = 'X'.

here you catch all the lines marked in the ALV, and you can fill another internal table with the new data.

endloop.

Thanks,

Mahesh

Re: Getting checked record data

Former Member — Tue, 17 Jul 2007 21:57:57 GMT

Hi Mahesh,

I used the FUNCTION 'REUSE_ALV_GRID_DISPLAY', I have a field called CHBOX in my custom table and in ALV layout structure I specified it as

ls_fieldcat-fieldname = 'CHBOX'.

ls_fieldcat-checkbox = 'X'.

ls_fieldcat-input = 'X'.

ls_fieldcat-edit = 'X'.

ls_fieldcat-seltext_s = 'BOX'.

ls_fieldcat-seltext_l = 'BOX'.

APPEND ls_fieldcat TO it_alv_field_cat.

CLEAR ls_fieldcat.

I am not getting any data from the checked records. Am I doing anything wrong?

Thanks,

Neelu.

Re: Getting checked record data

Former Member — Tue, 17 Jul 2007 22:01:28 GMT

Did you check the internal table at the LOOP statement to see if the checkbox field has the value 'X'?

Re: Getting checked record data

Former Member — Tue, 17 Jul 2007 22:11:10 GMT

Hi Neelu,

check this one correctly. did u mark the filed in the layout ..

<b>Then, in the ALV layout structure, must specify this field.

layout-box_fname = 'MARK'.

And you must specify too, the selection mode of the ALV.

layout-sel_mode = 'A'.</b>

This should work... this is the only thing that u have to do and the rest is taken care..

Thanks

Mahesh

Re: Getting checked record data

Former Member — Tue, 17 Jul 2007 22:50:47 GMT

Hi Mahesh,

I just cheched it and CHBOX does not have any value.

Hi Mahesh,

I included the code

layout-box_fname = 'MARK'.

layout-sel_mode = 'A'.

FORM alv_layout.

Enable striped output display if user wants

s_alv_layout_cat-zebra = 'X'.

Optimize column width if user wants

s_alv_layout_cat-colwidth_optimize = 'X'.

s_alv_layout_cat-box_fieldname = 'CHBOX'.

s_alv_layout_cat-no_input = 'X'.

s_alv_layout_cat-sel_mode = 'A'.

ENDFORM. " alv_layout

The data object "S_ALV_LAYOUT_CAT" has no component called "SEL_MODE", but there is a component called "EDIT_MODE".

Should I use "EDIT_MODE"?

Please guide me.

Thanks,

Neelu.

Re: Getting checked record data

Former Member — Wed, 18 Jul 2007 14:25:05 GMT

Hi Neelu,

Here is the complete program for your refrence... I think these are the two lines that need to be set at ur end.....

<b>fieldlayout-box_fieldname = 'CHKBOX'.

fieldlayout-edit_mode = 'X'.</b>

REPORT ZTESTPRG .

************************************************************************

TABLES AND DATA DECLARATION.

************************************************************************

*TABLES: mara,makt.",marc.

data syrepid like sy-repid.

data sydatum(10). " LIKE sy-datum.

data sypagno(3) type n.

WHEN USING MORE THAN ONE TABLE IN ALV WE NEEED TO DECLARE THE TYPE
GROUP (TYPE-POOLS--------->SLIS)

type-pools : slis.

************************************************************************

INTERNAL TABLE DECLARATION.

************************************************************************

INTERNAL TABLE TO HOLD THE VALUES FROM THE MARA TABLE

data: begin of t_mara occurs 0,

matnr like mara-matnr,

meins like mara-meins,

mtart like mara-mtart,

matkl like mara-matkl,

end of t_mara.

INTERNAL TABLE TO HOLD THE CONTENTS FROM THE EKKO TABLE

data : begin of t_marc occurs 0,

matnr like mara-matnr,

werks like marc-werks,

minbe like marc-minbe.

data: end of t_marc.

INTERNAL TABLE TO HOLD THE VALUES FROM MAKT TABLE.

data : begin of t_makt occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

spras like makt-spras,

end of t_makt.

INTERNAL TABLE WHICH ACTUALLY MERGES ALL THE OTHER INTERNAL TABLES.

data: begin of itab1 occurs 0,

chkbox(1) type c,

matnr like mara-matnr,

meins like mara-meins,

maktx like makt-maktx,

spras like makt-spras,

werks like marc-werks,

minbe like marc-minbe,

end of itab1.

THE FOLLOWING DECLARATION IS USED FOR DEFINING THE FIELDCAT
AND THE LAYOUT FOR THE ALV.
HERE AS slis_t_fieldcat_alv IS A INTERNAL TABLE WITHOUT A HEADER LINE
WE EXPLICITELY DEFINE AN INTERNAL TABLE OF THE SAME STRUCTURE AS THAT
OF slis_t_fieldcat_alv BUT WITH A HEADER LINE IN THE DEFINITION.
THIS IS DONE TO MAKE THE CODE SIMPLER.
OTHERWISE WE MAY HAVE TO DEFINE THE STRUCTURE AS IN THE NORMAL SAP
PROGRAMS.
IN THE FIELDCATALOG TABLE WE ACTUALLY PASS THE FIELDS FROM ONE OR
MORE TABLES AND CREATE A STRUCTURE
IN THE LAYOUT STRUCTURE WE BASICALLY DEFINE THE FORMATTING OPTIONS
LIKE DISPLAY IN THE ZEBRA PATTERN ,THE HOTSPOT OPTIONS ETC.

data: fieldcatalog type slis_t_fieldcat_alv with header line,

fieldlayout type slis_layout_alv.

DECLARING THE EVENTTABLE INTERNL TABLE FOR USING EVENTS LIKE
TOP-OF-PAGE ETC.

data : eventstab type slis_t_event with header line.

DECLARING AN INTERNAL TABLE TO HOLD THE DATA FOR THE TOP-OF-PAGE

data : heading type slis_t_listheader with header line.

data : heading1 type slis_t_listheader with header line.

data : heading2 type slis_t_listheader with header line.

data : heading3 type slis_t_listheader with header line.

data : heading4 type slis_t_listheader with header line.

data : heading5 type slis_t_listheader with header line.

data : heading6 type slis_t_listheader with header line.

data : heading7 type slis_t_listheader with header line.

data : heading8 type slis_t_listheader with header line.

STRUCTURE TO PASS THE COLOR ATTRIBUTES FOR DISPLAY.

data : colorstruct type slis_coltypes.

************************************************************************

INITIALIZATION. *

************************************************************************

initialization.

syrepid = sy-repid.

sypagno = sy-pagno.

clear fieldcatalog.

************************************************************************

START-OF-SELECTION. *

************************************************************************

start-of-selection.

SUBROUTINE TO POPULATE THE COLORSTRUCT

perform fill_colorstruct using colorstruct.

SUBROUTINE TO POPULATE THE FIELDS OF THE FIELD CATALOGUE

perform populate_fieldcatalog.

SUBROUTINE TO SELECT DATA FROM VARIOUS TABLES AND POPULATE IT IN THE
INTERNAL TABLE.

perform selectdata_and_sort.

SUBROUTINE TO POPULATE THE LAYOUT STRUCTURE.

perform populate_layout using fieldlayout.

SUBROUTINE TO CALL THE FUNCTION MERGE TO ENSURE PROPER DISPLAY.

perform merge_fieldcatalog.

SUBROUTINE TO POPULATE THE EVENTSTAB.

perform fill_eventstab tables eventstab.

SUBROUTINE TO POPULATE THE HEADING TABLES.

perform fill_headingtable tables heading using 'HEADING'.

perform fill_headingtable tables heading1 using 'HEADING1'.

perform fill_headingtable tables heading2 using 'HEADING2'.

perform fill_headingtable tables heading3 using 'HEADING3'.

perform fill_headingtable tables heading4 using 'HEADING4'.

perform fill_headingtable tables heading5 using 'HEADING5'.

perform fill_headingtable tables heading6 using 'HEADING6'.

perform fill_headingtable tables heading7 using 'HEADING7'.

perform fill_headingtable tables heading8 using 'HEADING8'.

SUBROUTINE TO DISPLAY THE LIST.

perform display_alv_list.

************************************************************************

FORMS

************************************************************************

IN THIS SUBROUTINE WE POPULATE THE FIELDCATALOG TABLE WITH THE NAMES
OF THE TABLE,FIELDNAME,WHETHER IT IS KEY FIELD OR NOT,HEADING AND
COLUMN JUSTIFICATION.

form populate_fieldcatalog.