Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ALV GRID DISPLAY - error when downloading to local button clicked

Former Member

‎08-12-2009 9:24 AM

0 Kudos

I am using reuse_alv_grid_display to display alv report..

I am having around 90 fields to display.. some fields are large ..When i click

export-->local file.. dump error occurs..

It saying field symbol has not yet been assigned..

The termination occurred in the ABAP program "SAPLKKBL" in "GEN_FIELD_OUT2"

But When download it with few fields it's not showing error..

How can this be solved..

12 REPLIES 12

Former Member

‎08-12-2009 9:31 AM

0 Kudos

Hi

Generally a dump like yours occurs if the catalog table is not filled in right way for every field.

Max

Pawan_Kesari
Active Contributor

‎08-12-2009 9:34 AM

0 Kudos

I think you might have misspelled column name in fieldcatelog.

Just after the shortdump check the values of variables in form gen_field_out2, try to look what is the column name it is trying to resolve.

Former Member

‎08-12-2009 9:36 AM

0 Kudos

Hi Riky,

IF u r not able to download the ALV issue is with the Field catalog, u can view the dump, carefuly where it will show for which filed field catalog was not defined properly probably there would be a number which indicated the column no. of the alv of which field catalog was defined wrong take close review of ur field catalog.

If u fail to review ur feildcatlog then manually u have to check each and every column entry of feild catalog.

If Alv displays fine and issue is with download alv i.e export, Problem is always with the Field Catalog.

Hope this resolves ur issue,

Regards,

Akash Rana

Former Member

‎08-12-2009 10:54 AM

0 Kudos

Hi,

You can check the detailed information about the dump from

TCode ST22.

This error can be of field catalog not properly getting generated,

try giving column numbers not hardcoded in the program but

getting its incremented dynamically , please check the sample code below:

data lv_count type i value 0.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'KUNNR'.

wa_field-tabname = 'IT_FINAL'.

wa_field-outputlen = 10.

wa_field-ddic_outputlen = 10.

wa_field-seltext_l = 'CUSTOMER NO'.

append wa_field to it_field.

clear wa_field.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'NAME2'.

wa_field-tabname = 'IT_FINAL'.

wa_field-ddic_outputlen = 35.

wa_field-seltext_l = 'CUSTOMER NAME'.

append wa_field to it_field.

clear wa_field.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'VKORG'.

wa_field-tabname = 'IT_FINAL'.

wa_field-ddic_outputlen = 4.

wa_field-seltext_l = 'SALES ORG'.

append wa_field to it_field.

clear wa_field.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'VTWEG'.

wa_field-tabname = 'IT_FINAL'.

wa_field-ddic_outputlen = 5.

wa_field-seltext_l = 'DISTRIBUTION CHANNEL'.

append wa_field to it_field.

clear wa_field.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'SPART'.

wa_field-tabname = 'IT_FINAL'.

wa_field-ddic_outputlen = 2.

wa_field-seltext_l = 'DIVISION'.

append wa_field to it_field.

clear wa_field.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'KUNN2'.

wa_field-tabname = 'IT_FINAL'.

wa_field-ddic_outputlen = 10.

wa_field-seltext_l = 'SALES PERSON NO'.

append wa_field to it_field.

clear wa_field.

lv_count = lv_count + 1.

wa_field-col_pos = lv_count.

wa_field-fieldname = 'NAME1'.

wa_field-tabname = 'IT_FINAL'.

wa_field-ddic_outputlen = 35.

wa_field-seltext_l = 'SALES PERSON NAME'.

append wa_field to it_field.

clear wa_field.

You can create the field catalog like this for your 90 fields.

Hope it help,

Regards

Mansi

Edited by: MANSI ASNANI on Aug 12, 2009 11:54 AM

Former Member

‎08-12-2009 1:10 PM

0 Kudos

I'm able to see the report output correctly in GRID, so can there be a chance for field catalog bieng wrong.

When i click the 'Save to local' button it dumps.

Former Member
In response to Former Member

‎08-12-2009 1:23 PM

0 Kudos

Hi

U should post the code where u fill catalog table

Max

Former Member
In response to Former Member

‎08-12-2009 1:58 PM

0 Kudos

Hi Riky,

I believe you are not having authorizations to download data to local file. Actually clients like financial firms & banks wont allow to down load data to local file. Even I have faced the same situation, you can contact the basis person for this, he will guide you

Rgds,

Sripal

Former Member
In response to Former Member

‎08-12-2009 2:04 PM

0 Kudos

Hi Ricky,

One solution is there. It is simple but bit time consuming.

Just copy all fields ffrom field catalog somewhere in the notepad file and

try adding one by one in the catalog.

Test everytime executing the report and taking download untill unless that dump appears.

On whichever field it appears, just modify that field catalog accordingly.

Job seems to be bit useless, but i hope it works for you.

Regds,

Anil

Former Member

‎08-14-2009 9:07 AM

0 Kudos

I tried checking the fieldcatalog, its correctly building up...

Will there be any limit to the list size (width), In my case the width of 1 line (row) comes to around 2200 .. so will this be a concern.. But i 'm getting the output in the grid correctly. Only when i click 'save to local' it errors out.. dumps..

Former Member
In response to Former Member

‎08-14-2009 10:07 AM

0 Kudos

Hi ,

As max mentioned , please check the catalog .

We had a similar issue and the reason was that the data type specified in the catalog and the data type of the field in the table were different.

Regards

Arun

Former Member
In response to Former Member

‎08-14-2009 11:09 AM

0 Kudos

Hi,

I too encoutered the same problem recently. There might me some wrong reference for the fileds in the field catalogue . Just cross check the reference fields & tables for the Amount and quantity fields in your field catalogue.

Former Member

‎08-17-2009 11:47 AM

0 Kudos

Hi Ricky,

I too had faced a similiar issue earlier on. Such a dump error can occur if :-

1. As mentioned above, if the field catalog is not correctly populated. There could be a mismatch of your data with the ref_fieldname and ref_tabname entries.

2. Such an error also occurs if u use small case to populate the field catalog... For eg,

If the field catalog is filled like shown below, this error can occur...

WA_FIELDCAT-FIELDNAME = 'matnr'. --> Small Case

WA_FIELDCAT-TABNAME = 'it_finaltab'.

WA_FIELDCAT-REF_FIELDNAME = 'matnr'.

WA_FIELDCAT-REF_TABNAME = 'mara'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

Instead try filling your field catalog using upper case only...It worked for me when I had faced the issue..Something like this,

WA_FIELDCAT-FIELDNAME = 'MATNR'. -->Uppercased

WA_FIELDCAT-TABNAME = 'IT_FINALTAB'.

WA_FIELDCAT-REF_FIELDNAME = 'MATNR'.

WA_FIELDCAT-REF_TABNAME = 'MARA'.

APPEND WA_FIELDCAT TO IT_FIELDCAT.

CLEAR WA_FIELDCAT.

Hope this helps...

Regards...Jaison