topic Re: Short dump:The current statement only supports character-type data objects. in Application Development and Automation Discussions

Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 09:00:16 GMT

Hi Experts,

I am calling a zreport inside my user exit. This zprogram is wirtten to show a dialog box screen having an ALV.

If I am executing the zprogram seperately thenits working fine, but if I am executing it by subit statemmt form the user exit then at this METHOD it thorws an error somewhere indie:- CALL METHOD ->set_table_for_first_display.

Kindly tell what might be the possible reason. CAlling is like:-

CALL METHOD grid->set_table_for_first_display

EXPORTING

i_save = 'A'
I_STRUCTURE_NAME = 'ZPPM_OPERATION'

is_lAYOUT = GS_LAYOUT

CHANGING

IT_OUTTAB = IT_ZCP_DEMAND_SYS1

IT_FIELDCATALOG = I_FIELDCAT.

Re: Short dump:The current statement only supports character-type data objects.

former_member212005 — Fri, 08 Jan 2010 09:12:50 GMT

<copy&paste_removed_by_moderator>

Edited by: Julius Bussche on Jan 8, 2010 9:43 PM

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 09:16:16 GMT

You should have post [ the link |http://sap.ittoolbox.com/groups/technical-functional/sap-dev/alv-grid-in-background-737708]from where you pasted the answer.

Re: Short dump:The current statement only supports character-type data objects.

former_member212005 — Fri, 08 Jan 2010 09:20:31 GMT

Agreed Amit.....but some times the moderator blocks the reply for pasting a different site's link....

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 09:23:07 GMT

Hi Vin,

As i mentioned the ALV is working fine and so the Zreport if I am executing it directly(not by submit Zreport inside exit). So, Will this be a =n issue?

Re: Short dump:The current statement only supports character-type data objects.

former_member212005 — Fri, 08 Jan 2010 09:24:45 GMT

Udit...check the link which AMIT has given.....it had a similar kind of issue (but in background).....

Try it...

Re: Short dump:The current statement only supports character-type data objects.

caner_genis — Fri, 08 Jan 2010 09:37:51 GMT

Hi Udit.

Can you use FM "REUSE_ALV_GRID_DISPLAY" instead of class ALV.

I advise to not use SUBMIT command. You can create a FM in SE37 and you can use it in the user-exit.

Regards.

Caner.

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 10:15:13 GMT

Hi,

I did not get the idea what I need to do, in the link. Please help me understanding the concept.

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 11:05:31 GMT

Do this:

When preparing the field catalog

Give reference table and reference field .

This will surely solve your problem

Re: Short dump:The current statement only supports character-type data objects.

Clemenss — Fri, 08 Jan 2010 11:31:04 GMT

Hi,

my general solution is:

1) create dictionary structure or at least use only fields with dictionary types with domain.

2) use SALV (CL_SALV_TABLE)

Then all your problems have gone.

Regards,

Clemens

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 12:17:51 GMT

Thanx Abishek,

I implemented ref_fieldname and ref_tablename in fieldcatalog but now i am getting dump CNTL_ERROR.

pls help

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 12:32:15 GMT

Can you tell where are you getting this dump.

And elaborate what message are you getting .

Re: Short dump:The current statement only supports character-type data objects.

Clemenss — Fri, 08 Jan 2010 15:44:07 GMT

at least create a dictionary structure for the alv display table, pass the name with ...first_display. Also make sure that any special fields i.e. for cell color or style that you reference in the layout structure exist in the table structure.

You will not get a dump if you follow this.

Regards,

Clemens

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Fri, 08 Jan 2010 20:46:42 GMT

> Agreed Amit.....but some times the moderator blocks the reply for pasting a different site's link....

ittoolbox is not blocked because they have not spammed us with plagiarised information and link-farms.

Posting a link on it's own is anyway questionable -> the person could have found it themselves if they had used the search.

If you can answer by simply going a search, then rather tell the person to search as well....

Cheers,

Julius

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Mon, 11 Jan 2010 05:53:23 GMT

Hi Abhishek,

The new error messgae now I am getting is :-Exception condition "CNTL_ERROR" raised.

The palce is somewhere in standard code:-

check handle

IF ME->H_CONTROL IS INITIAL.

RAISE CNTL_ERROR.

ENDIF.

Kindly tell if something else is required after implementing those two things you told.

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Mon, 11 Jan 2010 05:58:17 GMT

i mean are you getting this dump for field catalog itself or something else.

Can you paste the code here or atleast tell for which fields you are

trying to make a field catalog so that we can help.

It may be possibly due to incorrect assignment or same

assignment related statement for the grid.

Edited by: AbhisheksinghTomar on Jan 11, 2010 11:31 AM

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Mon, 11 Jan 2010 09:46:36 GMT

Hi Experts,

I am using method set_table_for_first_display, CNTL->ERROR is coming because of passing fieldcatalog to the method,

If i comment fieldcatalog in method grid is displayed but without fieldcatalog.

Pls note: This code(for ALV) is written in a Zreport, and this Zreport is called inside a user-exit.

data: lt_celltab TYPE lvc_t_styl,

l_index TYPE i.

CLEAR :I_FIELDCAT,I_FIELDCAT[],WA_FIELDCAT.

WA_FIELDCAT-col_pos = 1.

WA_FIELDCAT-FIELDNAME = 'ZC_SUPPLIER'.

WA_FIELDCAT-REF_FIELD = 'ZC_SUPPLIER'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-reptext = 'SUPPLIER'.

WA_FIELDCAT-QUANTITY = 'X'.
WA_FIELDCAT-seltext = 'OPERATION'.

WA_FIELDCAT-outputlen = '9'.

WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

WA_FIELDCAT-col_pos = 2.

WA_FIELDCAT-fieldname = 'ZC_CUSTOMER'.

WA_FIELDCAT-REF_FIELD = 'ZC_CUSTOMER'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-reptext = 'CUSTOMER'.

WA_FIELDCAT-seltext = 'OPERATION DESCRIPTION'.

WA_FIELDCAT-LOWERCASE = 'X'.

WA_FIELDCAT-outputlen = '10'.

*WA_FIELDCAT-QUANTITY = ` 'X'.

WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

WA_FIELDCAT-col_pos = 3.

WA_FIELDCAT-fieldname = 'ZC_PO'.

WA_FIELDCAT-REF_FIELD = 'ZC_PO'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-QUANTITY = 'X'.

WA_FIELDCAT-reptext = 'PO'.

WA_FIELDCAT-seltext = 'ACTIVITY'.

WA_FIELDCAT-LOWERCASE = 'X'.

WA_FIELDCAT-outputlen = '10'.

WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

WA_FIELDCAT-col_pos = 4.

WA_FIELDCAT-fieldname = 'ZC_PO_TYPE'.

WA_FIELDCAT-REF_FIELD = 'ZC_PO_TYPE'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-QUANTITY = 'X'.

WA_FIELDCAT-reptext = 'PO_TYPE'.

WA_FIELDCAT-seltext = 'ACTIVITY DESCRIPTION'.

WA_FIELDCAT-LOWERCASE = 'X'.

WA_FIELDCAT-outputlen = '10'.

WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

WA_FIELDCAT-col_pos = 5.

WA_FIELDCAT-fieldname = 'ZC_PART'.

WA_FIELDCAT-REF_FIELD = 'ZC_PART'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-QUANTITY = 'X'.

WA_FIELDCAT-reptext = 'PART'.

WA_FIELDCAT-seltext = 'LOCATION'.

WA_FIELDCAT-outputlen = '10'.

WA_FIELDCAT-LOWERCASE = 'X'.

WA_FIELDCAT-F4AVAILABL = 'X'.

**WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

WA_FIELDCAT-col_pos = 6.

WA_FIELDCAT-fieldname = 'ZC_SCH_DATE'.

WA_FIELDCAT-REF_FIELD = 'ZC_SCH_DATE'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-QUANTITY = 'X'.

WA_FIELDCAT-REPtext = 'SCH_DATE'.

WA_FIELDCAT-seltext = 'RESOURCE'.

WA_FIELDCAT-LOWERCASE = 'X'.

WA_FIELDCAT-outputlen = '10'.

WA_FIELDCAT-F4AVAILABL = 'X'.

*WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

WA_FIELDCAT-col_pos = 7.

WA_FIELDCAT-fieldname = 'ZC_QTY_PO'.

WA_FIELDCAT-REF_FIELD = 'ZC_QTY_PO'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-QUANTITY = 'NOS'.

WA_FIELDCAT-REPtext = 'QTY_PO'.

WA_FIELDCAT-seltext = 'BUCKET CONSUMPTION'.

WA_FIELDCAT-outputlen = '7'.

WA_FIELDCAT-DATATYPE = 'X'.
WA_FIELDCAT-F4AVAILABL = ' '.
WA_FIELDCAT-EDIT = ' '.

APPEND WA_FIELDCAT to I_FIELDCAT.

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

WA_FIELDCAT-col_pos = 8.

WA_FIELDCAT-fieldname = 'ZC_QTY_PLN'.

WA_FIELDCAT-REF_FIELD = 'ZC_QTY_PLN'.

WA_FIELDCAT-REF_TABLE = 'ZCP_DEMAND_SYS'.

WA_FIELDCAT-QUANTITY = 'NOS'.

WA_FIELDCAT-REPtext = 'QTY_PLN'.

WA_FIELDCAT-seltext = 'BUCKET CONSUMPTION'.

WA_FIELDCAT-outputlen = '7'.

WA_FIELDCAT-DATATYPE = 'X'.

WA_FIELDCAT-F4AVAILABL = ' '.

*WA_FIELDCAT-EDIT = 'X'.

APPEND WA_FIELDCAT to I_FIELDCAT.

CALL METHOD grid->set_table_for_first_display

EXPORTING

i_save = 'A'
I_STRUCTURE_NAME = 'ZCP_DEMAND_SYS'

is_lAYOUT = GS_LAYOUT

CHANGING

IT_OUTTAB = IT_ZCP_DEMAND_SYS1

IT_FIELDCATALOG = I_FIELDCAT.

Re: Short dump:The current statement only supports character-type data objects.

Clemenss — Mon, 11 Jan 2010 09:58:13 GMT

Hi Udit,

please search for How to post code

Regards,

Clemens

Re: Short dump:The current statement only supports character-type data objects.

Clemenss — Mon, 11 Jan 2010 10:01:06 GMT

... and if you just do not follow that:

Your trouble will not end too soon. The solution is ready within 15 minutes.

Regards,

Clemens

Re: Short dump:The current statement only supports character-type data objects.

Former Member — Mon, 11 Jan 2010 10:38:38 GMT

Hi Clemens,

Thanx for your response. I am not able to follow what you mean to say, can you please elaborate it with an example, as how I need to implement your suggestion.

Thanks in advance.