topic Re: ALV Report doesn't display correct data in Application Development and Automation Discussions

ALV Report doesn't display correct data

former_member295881 — Sun, 20 Oct 2013 06:43:31 GMT

Hello Experts,

I'm working with ALV report and trying to display data but for some weird reason last two columns have same values as third last column. Here is the table which I use to display ALV.

I use this table (LT_OUTPUT) in FM 'REUSE_ALV_GRID_DISPLAY' but I don't know why last three columns displays the same value. Here is the output of ALV.

Can anybody point out my mistake and suggest how to rectify this issue.

Many thanks in advance.

Re: ALV Report doesn't display correct data

former_member188827 — Sun, 20 Oct 2013 06:46:23 GMT

Please check the fieldcatalog, the field name of internal table provided in fieldcatalog might be incorrect. If possible, paste declaration of lt_output and code where you are building the fieldcatalog.

Regards

Re: ALV Report doesn't display correct data

former_member295881 — Sun, 20 Oct 2013 06:52:07 GMT

Many thanks for your reply netweaver. Not sure if this is the issue but here is how I've filled my fieldcatalog.

============================================================

   fieldcatalog-fieldname   = 'ZRERATE'.
   fieldcatalog-seltext_m   = 'Re-rating Number'.
   fieldcatalog-col_pos     = 0.
   fieldcatalog-outputlen   = 15.
   fieldcatalog-emphasize   = 'X'.
   fieldcatalog-key         = 'X'.
* fieldcatalog-do_sum      = 'X'.
* fieldcatalog-no_zero     = 'X'.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'KUNRG'.
   fieldcatalog-seltext_m   = 'Payer'.
   fieldcatalog-col_pos     = 1.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'AUART'.
   fieldcatalog-seltext_m   = 'Document Type'.
   fieldcatalog-col_pos     = 2.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'INITIATOR'.
   fieldcatalog-seltext_m   = 'Initiator'.
   fieldcatalog-col_pos     = 3.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'NEW_AMT'.
   fieldcatalog-seltext_m   = 'Invoice Amount'.
   fieldcatalog-col_pos     = 4.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'WAERK'.
   fieldcatalog-seltext_m   = 'Document Currency'.
   fieldcatalog-col_pos     = 5.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'ERDAT'.
   fieldcatalog-seltext_m   = 'Date re-rate invoice created'.
   fieldcatalog-col_pos     = 6.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'IDOC'.
   fieldcatalog-seltext_m   = 'IDOC Number'.
   fieldcatalog-col_pos     = 7.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'IDOC ERROR'.
   fieldcatalog-seltext_m   = 'IDOC Error Details'.
   fieldcatalog-col_pos     = 8.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

=======================================================

and here is the structure of the internal table lt_output

BEGIN OF t_output,
         zrerate   type zrerate,
         kunrg     type kunrg,
         auart     type auart,
         initiator type zrerate_initiator,
         new_amt   type znew_amt,
         waerk     type waerk,
         erdat     type zrerate_date,
         idocnum   type edidc-docnum,
         idocerror type edi_help-error_flag,
END OF t_output.

Re: ALV Report doesn't display correct data

former_member188827 — Sun, 20 Oct 2013 06:57:38 GMT

Please replace IDOC with IDOCNUM.

fieldcatalog-fieldname = 'IDOCNUM'.

fieldcatalog-seltext_m = 'IDOC Number'.

fieldcatalog-col_pos = 7.

append fieldcatalog to fieldcatalog.

clear fieldcatalog.

Regards

Re: ALV Report doesn't display correct data

former_member188827 — Sun, 20 Oct 2013 06:59:47 GMT

Also, remove space between 'IDOC ERROR'.

fieldcatalog-fieldname = 'IDOCERROR'.

Regards

Re: ALV Report doesn't display correct data

Former Member — Sun, 20 Oct 2013 07:11:12 GMT

Hi,

This happened because the name of the field in the output table and field catalog are not the same. Make it same. Your issue will be solved.

fieldcatalog-fieldname   = 'IDOCNUM'.
   fieldcatalog-seltext_m   = 'IDOC Number'.
   fieldcatalog-col_pos     = 7.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

   fieldcatalog-fieldname   = 'IDOCERROR'.
   fieldcatalog-seltext_m   = 'IDOC Error Details'.
   fieldcatalog-col_pos     = 8.
   append fieldcatalog to fieldcatalog.
   clear fieldcatalog.

Re: ALV Report doesn't display correct data

former_member295881 — Sun, 20 Oct 2013 07:11:13 GMT

Many thanks netweaver your suggestions resolved my issue and also learned something new today.

Re: ALV Report doesn't display correct data

former_member295881 — Sun, 20 Oct 2013 07:11:58 GMT

Thanks for your help Susmitha.

Re: ALV Report doesn't display correct data

rosenberg_eitan — Sun, 20 Oct 2013 08:18:27 GMT

Hi ,

I try to replicate the problem but I got short dump .

Eventually I mange to do some damage...

Then I use "The Consistency Check"
http://help.sap.com/saphelp_nw73/helpdata/en/d6/23253963143e6ae10000000a11402f/content.htm

And we have :

Regards.