Missing column values while downloading ALV data i...

Former Member · ‎2013 Nov 20

Hi,

I have developed an ALV report,While i am executing it is coming perfect,but while i have downloading that ALV data into local file one column values replaced with another column values..don't know why..Please help me.

Sample ALV data

Article Article Description MRP HY01(Site) HY02 HY03

100002 Soap 10 0 0 14

Data After downloading into local file

Article Article Description MRP HY01(Site) HY02 HY03

100002 Soap 0 0 14

like this it is coming...means instead of MRP value replacing HY01 etc...

Thanks

FredericGirod · ‎2013 Nov 20

Hi,

did you have check your field catalog ? maybe is a problem of column name

regards

Fred

Former Member · ‎2013 Nov 20

Hi Sai,

Please paste your code. We will test it.

BR.

Former Member · ‎2013 Nov 21

Hi Ankit,

This is my code....

*&---------------------------------------------------------------------*
*& Report ZTEST_DSD1
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT ZTEST_DSD1.

TYPE-POOLS:slis.

* Structure declaration
TYPES:BEGIN OF ty_zdsdlogg,
       werks TYPE zdsdlogg-werks,
       matnr TYPE zdsdlogg-matnr,
       maktx TYPE zdsdlogg-maktx,
       zdemand TYPE zdsdlogg-zdemand,
       END OF ty_zdsdlogg.

TYPES:BEGIN OF ty_t001w,
       werks TYPE t001w-werks,
       regio TYPE t001w-regio,
       END OF ty_t001w.

TYPES:BEGIN OF ty_a521,
       matnr TYPE a521-matnr,
       knumh TYPE a521-knumh,
       END OF ty_a521.

TYPES:BEGIN OF ty_konp,
       knumh TYPE konp-knumh,
       kbetr TYPE konp-kbetr,
       END OF ty_konp.

* Internal table and work area declarations
DATA:it_logg TYPE STANDARD TABLE OF ty_zdsdlogg,
      wa_logg TYPE ty_zdsdlogg,
      wa_logg1 TYPE ty_zdsdlogg.

DATA:it_t001w TYPE STANDARD TABLE OF ty_t001w,
      wa_t001w TYPE ty_t001w.

DATA:it_a521 TYPE STANDARD TABLE OF ty_a521,
      wa_a521 TYPE ty_a521.

DATA:it_konp TYPE STANDARD TABLE OF ty_konp,
      wa_konp TYPE ty_konp.

*Variables declarations
DATA:gv_pos TYPE i,
      fname TYPE string.

DATA : gw_alv_fieldcat     TYPE slis_fieldcat_alv,
        gt_alv_fieldcat     TYPE slis_t_fieldcat_alv.

DATA:lv_pos TYPE i.
DATA qty TYPE zdsdlogg-zdemand.

* Dynamic table declarations
DATA : gt_dyn_table TYPE REF TO data,
        gw_line TYPE REF TO data,
        gw_line1 TYPE REF TO data,
        gw_dyn_fcat TYPE lvc_s_fcat,
        gt_dyn_fcat TYPE lvc_t_fcat.

DATA: gs_layout TYPE slis_layout_alv,
       gt_sort TYPE slis_t_sortinfo_alv,
        gw_sort TYPE slis_sortinfo_alv.

* Field symbols declarations
FIELD-SYMBOLS: <gfs_line>,<gfs_line1>,
                <gfs_dyn_table> TYPE STANDARD TABLE,
                <fs1>.

* Selection screen
SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME.
PARAMETERS : p_lifnr TYPE zdsdlogg-lifnr,
              p_regio TYPE t001w-regio.
SELECTION-SCREEN END OF BLOCK b1.

START-OF-SELECTION.

   SELECT werks
          FROM t001w
          INTO TABLE it_t001w
          WHERE regio = p_regio.

   SELECT werks
          matnr
          maktx
          zdemand
          FROM zdsdlogg
          INTO TABLE it_logg
          FOR ALL ENTRIES IN it_t001w
          WHERE werks = it_t001w-werks
          AND aedat = '20110722' "sy-datum
          AND lifnr = p_lifnr.

     sort it_logg by werks matnr.

   SELECT matnr
          knumh
          FROM a521
          INTO TABLE it_a521
          FOR ALL ENTRIES IN it_logg
          WHERE kschl = 'VKP0'
          AND vtweg = '01'
          AND regio = p_regio
          AND matnr = it_logg-matnr
          AND datbi = '99991231'.

   SELECT knumh
          kbetr
          FROM konp
          INTO TABLE it_konp
          FOR ALL ENTRIES IN it_a521
          WHERE knumh = it_a521-knumh
          AND loevm_ko = ' '.

* This would create structure Article Description CH01 etc.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'MATNR'.
   gw_dyn_fcat-outputlen = 8.
   gw_dyn_fcat-tabname   = 'IT_LOGG '.
   gw_dyn_fcat-coltext   = 'Article'.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-key = 'X'.
   gw_dyn_fcat-key_sel = 'X'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.

   CLEAR gw_dyn_fcat.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'MAKTX'.
   gw_dyn_fcat-outputlen = 40.
   gw_dyn_fcat-tabname   = 'IT_LOGG '.
   gw_dyn_fcat-coltext   = 'Article Description'.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-key = 'X'.
   gw_dyn_fcat-key_sel = 'X'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.

   CLEAR gw_dyn_fcat.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'KBETR'.
   gw_dyn_fcat-outputlen = 11.
   gw_dyn_fcat-tabname   = 'IT_KONP'.
   gw_dyn_fcat-coltext   = 'MRP'.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-key = 'X'.
   gw_dyn_fcat-key_sel = 'X'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.

   CLEAR gw_dyn_fcat.

* Loop through the internal table creating a column for every distinct site in the internal table

   LOOP AT it_logg INTO wa_logg.
     CONCATENATE wa_logg-werks ' ' INTO fname.
     READ TABLE gt_dyn_fcat INTO gw_dyn_fcat WITH KEY fieldname = wa_logg-werks.
     IF sy-subrc NE 0.
       gv_pos = gv_pos + 1.
       gw_dyn_fcat-fieldname = wa_logg-werks.
       gw_dyn_fcat-tabname   = 'IT_LOGG'.
       gw_dyn_fcat-coltext   = fname.
       gw_dyn_fcat-outputlen = 6.
       gw_dyn_fcat-col_pos   = gv_pos.
       gw_dyn_fcat-do_sum = 'X'.
       gw_dyn_fcat-ref_field = 'WESCH'.
       gw_dyn_fcat-ref_table = 'MARA'.
       APPEND gw_dyn_fcat TO gt_dyn_fcat.
     ENDIF.
     CLEAR gw_dyn_fcat.

   ENDLOOP.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'TOTAL'.
   gw_dyn_fcat-tabname   = 'IT_LOGG'.
   gw_dyn_fcat-coltext   = 'GRAND TOTAL'.
   gw_dyn_fcat-outputlen = 13.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-do_sum = 'X'.
   gw_dyn_fcat-ref_field = 'WESCH'.
   gw_dyn_fcat-ref_table = 'MARA'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.
   CLEAR gw_dyn_fcat.

* Create a dynamic internal table with this structure.

   CALL METHOD cl_alv_table_create=>create_dynamic_table
     EXPORTING
       i_style_table             = 'X'
       it_fieldcatalog           = gt_dyn_fcat
     IMPORTING
       ep_table                  = gt_dyn_table
     EXCEPTIONS
       generate_subpool_dir_full = 1
       OTHERS                    = 2.

   IF sy-subrc EQ 0.
* Assign the new table to field symbol

     ASSIGN gt_dyn_table->* TO <gfs_dyn_table>.

* Create dynamic work area for the dynamic table

     CREATE DATA gw_line LIKE LINE OF <gfs_dyn_table>.
     CREATE DATA gw_line1 LIKE LINE OF <gfs_dyn_table>.
     ASSIGN gw_line->* TO <gfs_line>.
     ASSIGN gw_line1->* TO <gfs_line1>.
   ENDIF.

* Populate the dynamic table

   LOOP AT it_logg INTO wa_logg.

* Avoid duplicate entries for key field PART.
     READ TABLE <gfs_dyn_table> INTO <gfs_line1> WITH KEY ('MATNR') = wa_logg-matnr.
     IF sy-subrc = 0.
       CONTINUE.
     ENDIF.

     ASSIGN COMPONENT 'MATNR' OF STRUCTURE <gfs_line> TO <fs1>.

     CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
       EXPORTING
         input = wa_logg-matnr
       IMPORTING
         output = <fs1>.

*    <fs1> = wa_logg-matnr.
     UNASSIGN <fs1>.

     ASSIGN COMPONENT 'MAKTX' OF STRUCTURE <gfs_line> TO <fs1>.
     <fs1> = wa_logg-maktx.
     UNASSIGN <fs1>.

    clear:wa_a521,wa_konp.

     read table it_a521 into wa_a521 with key matnr = wa_logg-matnr.
     if sy-subrc = 0.
       read table it_konp into wa_konp with key knumh = wa_a521-knumh.
       if sy-subrc = 0.
         ASSIGN COMPONENT 'KBETR' OF STRUCTURE <gfs_line> TO <fs1>.
         <fs1> = wa_konp-kbetr.
         UNASSIGN <fs1>.
       endif.
     endif.

     CLEAR qty.
     LOOP AT gt_dyn_fcat INTO gw_dyn_fcat.
       IF gw_dyn_fcat-fieldname = 'MATNR' OR gw_dyn_fcat-fieldname = 'MAKTX' or gw_dyn_fcat-fieldname = 'KBETR'.
         CONTINUE.
       ENDIF.
       READ TABLE it_logg WITH KEY matnr = wa_logg-matnr werks = gw_dyn_fcat-fieldname INTO wa_logg1.
       IF sy-subrc = 0.
         ASSIGN COMPONENT gw_dyn_fcat-fieldname OF STRUCTURE <gfs_line> TO <fs1>.
         <fs1> = wa_logg1-zdemand.
         UNASSIGN <fs1>.
         qty = qty + wa_logg1-zdemand.
       ENDIF.
       CLEAR : wa_logg1.
     ENDLOOP.

     ASSIGN COMPONENT 'TOTAL' OF STRUCTURE <gfs_line> TO <fs1>.
     <fs1> = qty.
     UNASSIGN <fs1>.

     APPEND <gfs_line> TO <gfs_dyn_table>.
     CLEAR: <gfs_line>.
     CLEAR: wa_logg, wa_logg1.
   ENDLOOP.

   LOOP AT gt_dyn_fcat INTO gw_dyn_fcat.
     lv_pos = lv_pos + 1.
     gw_alv_fieldcat-fieldname     = gw_dyn_fcat-fieldname.
     gw_alv_fieldcat-tabname       = gw_dyn_fcat-tabname.
     gw_alv_fieldcat-seltext_l     = gw_dyn_fcat-coltext.
     gw_alv_fieldcat-outputlen     = gw_dyn_fcat-outputlen.
     gw_alv_fieldcat-col_pos       = lv_pos.
     gw_alv_fieldcat-do_sum        = gw_dyn_fcat-do_sum.
     gw_alv_fieldcat-emphasize     = gw_dyn_fcat-emphasize.
     gw_alv_fieldcat-key           = gw_dyn_fcat-key.
     gw_alv_fieldcat-no_out        = gw_dyn_fcat-no_out.
     APPEND gw_alv_fieldcat TO gt_alv_fieldcat.
   ENDLOOP.

*gs_layout-totals_text = 'Grand Total'.

   CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
     EXPORTING
       i_callback_program = sy-repid
       it_fieldcat        = gt_alv_fieldcat
       i_default          = 'X'
       i_save             = 'A'
*      is_layout           = gs_layout
     TABLES
       t_outtab           = <gfs_dyn_table>.

Former Member · ‎2013 Nov 21

Hi Sai,

Unfortunately i cannot execute your report because you have custom tables. Also in your code i do not see any 'GUI_DOWNLOAD' FM so it means you are downloading excel via

Menu Bar : System - List - Save - Local File

or ALV Toolbar : Excel Icon.

For issue with first option i am not aware of any solution, probably some SAP notes might rescue you.

For the second option, solution can be a create a custom PF status which is copy of any of the standard PF statuses shown below -

preferably 'STANDARD' or 'STANDARD_FULLSCREEN' using transaction SE41 and use set the PF status in your program.

BR.

former_member206479 · ‎2013 Nov 20

Hi Ganesh,

How you are downloading your data? I mean is it from Internal table the you will get exact data. And which FM or Methods you are using to download the data?

If you place your code that would be clear to give suggestion for you.

Regards,

Venkat.

Former Member · ‎2013 Nov 21

Hi Venkat,

This is my code...

*&---------------------------------------------------------------------*
*& Report ZTEST_DSD1
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT ZTEST_DSD1.

TYPE-POOLS:slis.

* Structure declaration
TYPES:BEGIN OF ty_zdsdlogg,
       werks TYPE zdsdlogg-werks,
       matnr TYPE zdsdlogg-matnr,
       maktx TYPE zdsdlogg-maktx,
       zdemand TYPE zdsdlogg-zdemand,
       END OF ty_zdsdlogg.

TYPES:BEGIN OF ty_t001w,
       werks TYPE t001w-werks,
       regio TYPE t001w-regio,
       END OF ty_t001w.

TYPES:BEGIN OF ty_a521,
       matnr TYPE a521-matnr,
       knumh TYPE a521-knumh,
       END OF ty_a521.

TYPES:BEGIN OF ty_konp,
       knumh TYPE konp-knumh,
       kbetr TYPE konp-kbetr,
       END OF ty_konp.

* Internal table and work area declarations
DATA:it_logg TYPE STANDARD TABLE OF ty_zdsdlogg,
      wa_logg TYPE ty_zdsdlogg,
      wa_logg1 TYPE ty_zdsdlogg.

DATA:it_t001w TYPE STANDARD TABLE OF ty_t001w,
      wa_t001w TYPE ty_t001w.

DATA:it_a521 TYPE STANDARD TABLE OF ty_a521,
      wa_a521 TYPE ty_a521.

DATA:it_konp TYPE STANDARD TABLE OF ty_konp,
      wa_konp TYPE ty_konp.

*Variables declarations
DATA:gv_pos TYPE i,
      fname TYPE string.

DATA : gw_alv_fieldcat     TYPE slis_fieldcat_alv,
        gt_alv_fieldcat     TYPE slis_t_fieldcat_alv.

DATA:lv_pos TYPE i.
DATA qty TYPE zdsdlogg-zdemand.

* Dynamic table declarations
DATA : gt_dyn_table TYPE REF TO data,
        gw_line TYPE REF TO data,
        gw_line1 TYPE REF TO data,
        gw_dyn_fcat TYPE lvc_s_fcat,
        gt_dyn_fcat TYPE lvc_t_fcat.

DATA: gs_layout TYPE slis_layout_alv,
       gt_sort TYPE slis_t_sortinfo_alv,
        gw_sort TYPE slis_sortinfo_alv.

* Field symbols declarations
FIELD-SYMBOLS: <gfs_line>,<gfs_line1>,
                <gfs_dyn_table> TYPE STANDARD TABLE,
                <fs1>.

* Selection screen
SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME.
PARAMETERS : p_lifnr TYPE zdsdlogg-lifnr,
              p_regio TYPE t001w-regio.
SELECTION-SCREEN END OF BLOCK b1.

START-OF-SELECTION.

   SELECT werks
          FROM t001w
          INTO TABLE it_t001w
          WHERE regio = p_regio.

   SELECT werks
          matnr
          maktx
          zdemand
          FROM zdsdlogg
          INTO TABLE it_logg
          FOR ALL ENTRIES IN it_t001w
          WHERE werks = it_t001w-werks
          AND aedat = '20110722' "sy-datum
          AND lifnr = p_lifnr.

     sort it_logg by werks matnr.

   SELECT matnr
          knumh
          FROM a521
          INTO TABLE it_a521
          FOR ALL ENTRIES IN it_logg
          WHERE kschl = 'VKP0'
          AND vtweg = '01'
          AND regio = p_regio
          AND matnr = it_logg-matnr
          AND datbi = '99991231'.

   SELECT knumh
          kbetr
          FROM konp
          INTO TABLE it_konp
          FOR ALL ENTRIES IN it_a521
          WHERE knumh = it_a521-knumh
          AND loevm_ko = ' '.

* This would create structure Article Description CH01 etc.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'MATNR'.
   gw_dyn_fcat-outputlen = 8.
   gw_dyn_fcat-tabname   = 'IT_LOGG '.
   gw_dyn_fcat-coltext   = 'Article'.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-key = 'X'.
   gw_dyn_fcat-key_sel = 'X'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.

   CLEAR gw_dyn_fcat.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'MAKTX'.
   gw_dyn_fcat-outputlen = 40.
   gw_dyn_fcat-tabname   = 'IT_LOGG '.
   gw_dyn_fcat-coltext   = 'Article Description'.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-key = 'X'.
   gw_dyn_fcat-key_sel = 'X'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.

   CLEAR gw_dyn_fcat.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'KBETR'.
   gw_dyn_fcat-outputlen = 11.
   gw_dyn_fcat-tabname   = 'IT_KONP'.
   gw_dyn_fcat-coltext   = 'MRP'.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-key = 'X'.
   gw_dyn_fcat-key_sel = 'X'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.

   CLEAR gw_dyn_fcat.

* Loop through the internal table creating a column for every distinct site in the internal table

   LOOP AT it_logg INTO wa_logg.
     CONCATENATE wa_logg-werks ' ' INTO fname.
     READ TABLE gt_dyn_fcat INTO gw_dyn_fcat WITH KEY fieldname = wa_logg-werks.
     IF sy-subrc NE 0.
       gv_pos = gv_pos + 1.
       gw_dyn_fcat-fieldname = wa_logg-werks.
       gw_dyn_fcat-tabname   = 'IT_LOGG'.
       gw_dyn_fcat-coltext   = fname.
       gw_dyn_fcat-outputlen = 6.
       gw_dyn_fcat-col_pos   = gv_pos.
       gw_dyn_fcat-do_sum = 'X'.
       gw_dyn_fcat-ref_field = 'WESCH'.
       gw_dyn_fcat-ref_table = 'MARA'.
       APPEND gw_dyn_fcat TO gt_dyn_fcat.
     ENDIF.
     CLEAR gw_dyn_fcat.

   ENDLOOP.

   gv_pos = gv_pos + 1.
   gw_dyn_fcat-fieldname = 'TOTAL'.
   gw_dyn_fcat-tabname   = 'IT_LOGG'.
   gw_dyn_fcat-coltext   = 'GRAND TOTAL'.
   gw_dyn_fcat-outputlen = 13.
   gw_dyn_fcat-col_pos   = gv_pos.
   gw_dyn_fcat-do_sum = 'X'.
   gw_dyn_fcat-ref_field = 'WESCH'.
   gw_dyn_fcat-ref_table = 'MARA'.
   APPEND gw_dyn_fcat TO gt_dyn_fcat.
   CLEAR gw_dyn_fcat.

* Create a dynamic internal table with this structure.

   CALL METHOD cl_alv_table_create=>create_dynamic_table
     EXPORTING
       i_style_table             = 'X'
       it_fieldcatalog           = gt_dyn_fcat
     IMPORTING
       ep_table                  = gt_dyn_table
     EXCEPTIONS
       generate_subpool_dir_full = 1
       OTHERS                    = 2.

   IF sy-subrc EQ 0.
* Assign the new table to field symbol

     ASSIGN gt_dyn_table->* TO <gfs_dyn_table>.

* Create dynamic work area for the dynamic table

     CREATE DATA gw_line LIKE LINE OF <gfs_dyn_table>.
     CREATE DATA gw_line1 LIKE LINE OF <gfs_dyn_table>.
     ASSIGN gw_line->* TO <gfs_line>.
     ASSIGN gw_line1->* TO <gfs_line1>.
   ENDIF.

* Populate the dynamic table

   LOOP AT it_logg INTO wa_logg.

* Avoid duplicate entries for key field PART.
     READ TABLE <gfs_dyn_table> INTO <gfs_line1> WITH KEY ('MATNR') = wa_logg-matnr.
     IF sy-subrc = 0.
       CONTINUE.
     ENDIF.

     ASSIGN COMPONENT 'MATNR' OF STRUCTURE <gfs_line> TO <fs1>.

     CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
       EXPORTING
         input = wa_logg-matnr
       IMPORTING
         output = <fs1>.

*    <fs1> = wa_logg-matnr.
     UNASSIGN <fs1>.

     ASSIGN COMPONENT 'MAKTX' OF STRUCTURE <gfs_line> TO <fs1>.
     <fs1> = wa_logg-maktx.
     UNASSIGN <fs1>.

    clear:wa_a521,wa_konp.

     read table it_a521 into wa_a521 with key matnr = wa_logg-matnr.
     if sy-subrc = 0.
       read table it_konp into wa_konp with key knumh = wa_a521-knumh.
       if sy-subrc = 0.
         ASSIGN COMPONENT 'KBETR' OF STRUCTURE <gfs_line> TO <fs1>.
         <fs1> = wa_konp-kbetr.
         UNASSIGN <fs1>.
       endif.
     endif.

     CLEAR qty.
     LOOP AT gt_dyn_fcat INTO gw_dyn_fcat.
       IF gw_dyn_fcat-fieldname = 'MATNR' OR gw_dyn_fcat-fieldname = 'MAKTX' or gw_dyn_fcat-fieldname = 'KBETR'.
         CONTINUE.
       ENDIF.
       READ TABLE it_logg WITH KEY matnr = wa_logg-matnr werks = gw_dyn_fcat-fieldname INTO wa_logg1.
       IF sy-subrc = 0.
         ASSIGN COMPONENT gw_dyn_fcat-fieldname OF STRUCTURE <gfs_line> TO <fs1>.
         <fs1> = wa_logg1-zdemand.
         UNASSIGN <fs1>.
         qty = qty + wa_logg1-zdemand.
       ENDIF.
       CLEAR : wa_logg1.
     ENDLOOP.

     ASSIGN COMPONENT 'TOTAL' OF STRUCTURE <gfs_line> TO <fs1>.
     <fs1> = qty.
     UNASSIGN <fs1>.

     APPEND <gfs_line> TO <gfs_dyn_table>.
     CLEAR: <gfs_line>.
     CLEAR: wa_logg, wa_logg1.
   ENDLOOP.

   LOOP AT gt_dyn_fcat INTO gw_dyn_fcat.
     lv_pos = lv_pos + 1.
     gw_alv_fieldcat-fieldname     = gw_dyn_fcat-fieldname.
     gw_alv_fieldcat-tabname       = gw_dyn_fcat-tabname.
     gw_alv_fieldcat-seltext_l     = gw_dyn_fcat-coltext.
     gw_alv_fieldcat-outputlen     = gw_dyn_fcat-outputlen.
     gw_alv_fieldcat-col_pos       = lv_pos.
     gw_alv_fieldcat-do_sum        = gw_dyn_fcat-do_sum.
     gw_alv_fieldcat-emphasize     = gw_dyn_fcat-emphasize.
     gw_alv_fieldcat-key           = gw_dyn_fcat-key.
     gw_alv_fieldcat-no_out        = gw_dyn_fcat-no_out.
     APPEND gw_alv_fieldcat TO gt_alv_fieldcat.
   ENDLOOP.

*gs_layout-totals_text = 'Grand Total'.

   CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
     EXPORTING
       i_callback_program = sy-repid
       it_fieldcat        = gt_alv_fieldcat
       i_default          = 'X'
       i_save             = 'A'
*      is_layout           = gs_layout
     TABLES
       t_outtab           = <gfs_dyn_table>.

nabheetscn · ‎2013 Nov 21

Hi Sai

It usually happens because of incorrect field catalog. take for example in your case mentioned below you are passing plant but the REF_FIELD and REF_TABLE is of quantity. it should of MARC-WERKS or T001w-WERKS. Same type as data. Please correct this. Similarly check for others.

LOOP AT it_logg INTO wa_logg.

CONCATENATE wa_logg-werks ' ' INTO fname.

READ TABLE gt_dyn_fcat INTO gw_dyn_fcat WITH KEY fieldname = wa_logg-werks.

IF sy-subrc NE 0.

gv_pos = gv_pos + 1.

gw_dyn_fcat-fieldname = wa_logg-werks.

gw_dyn_fcat-tabname = 'IT_LOGG'.

gw_dyn_fcat-coltext = fname.

gw_dyn_fcat-outputlen = 6.

gw_dyn_fcat-col_pos = gv_pos.

gw_dyn_fcat-do_sum = 'X'.

gw_dyn_fcat-ref_field = 'WESCH'.

gw_dyn_fcat-ref_table = 'MARA'.

APPEND gw_dyn_fcat TO gt_dyn_fcat.

ENDIF.

CLEAR gw_dyn_fcat.

ENDLOOP.

Former Member · ‎2013 Nov 21

Hi,

Instead of adding col position with +1 just specify the values as 1, 2, 3 and so on..and please check it..

Regards

Kusuma

former_member191728 · ‎2013 Nov 21

Hi

Please check the special characheters in material description text

i couldn't recollect the exact special which creates the problem

if any material description has ',' or '-' then while downloading into excel file

the remaining records will filled in a single cell

i also faced the same issue

hope this answer helps you

Thanks

Pawan Akella

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My SAP Profile

My SAP Profile

Missing column values while downloading ALV data into Local file (Excel)