topic Re: List problem when run in background in Application Development and Automation Discussions

List problem when run in background

Former Member — Wed, 15 Mar 2006 07:13:33 GMT

Hello,

have developed a report which is fetching data from cluster table & taking long time to execute. So that report is run in background. My problem is that only first few columns are displayed. How to overcme this problem?

Regards,

Dilip

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 07:16:27 GMT

Hi Diliip,

How is your report created? Using ALV or common list technique? How did you define the line-size in your report?

Regards,

John.

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 07:19:20 GMT

Hai dilip

you can better use ALV to display output.

when the output of a report contains columns extending more than 255 characters in length. In such cases ALV functions can help choose selected columns and arrange the different columns from a report output and also save different variants for report display. This is a very efficient tool for dynamically sorting and arranging the columns from a report output. The report output can contain upto 90 columns in the display with the wide array of display options.

regards

praba

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 07:26:34 GMT

Hello,

Yes I am using REUSE_ALV_LIST_DISPLAY to display the report. But when the report is run in backgrund it is displaying only a few columns. What parameters are necessary to display all comumns when it is run in background?

Following is function call in my program.

Regards,

Dilip

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

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER =
I_BUFFER_ACTIVE = ' '

I_CALLBACK_PROGRAM = PROGRAM"'ZKBL_FI_REPORTS'"

I_CALLBACK_PF_STATUS_SET = ' '
I_CALLBACK_USER_COMMAND = ' '
I_STRUCTURE_NAME =

IS_LAYOUT = fld_lay

IT_FIELDCAT = FLD_CAT

IT_EXCLUDING =
IT_SPECIAL_GROUPS =
IT_SORT =
IT_FILTER =
IS_SEL_HIDE =
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT =

IT_EVENTS = xt_event

IT_EVENT_EXIT =
IS_PRINT =
IS_REPREP_ID =
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
IMPORTING
E_EXIT_CAUSED_BY_CALLER =
ES_EXIT_CAUSED_BY_USER =

TABLES

T_OUTTAB = SALES_ITAB

EXCEPTIONS
PROGRAM_ERROR = 1
OTHERS = 2

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 07:33:35 GMT

Hi dilip,

didi you build the field catalogue using FM or on your own.. hope if you use FM REUSE_ALV_FIELDCATALOG_MERGE

your problem shud be solved..

regards

satesh

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 07:48:52 GMT

Hi Diliip,

As stated in earlier reply, define a line-size large enough to hold all your columns.

REPORT ...... LINE-SIZE < >.

John.

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 09:05:19 GMT

yes I have set line-size as 600 previously but no result.

Re: List problem when run in background

venkata_ramisetti — Wed, 15 Mar 2006 09:17:35 GMT

HI Dilip,

YOu have to make chages in the LASYOUT structure that you pas as import parameter(IS_LAYOUT) in the function module REUSE_ALV_LIST_DISPLAY. Check the function module documentation also. It has very detailed documentation.

See the below SAP documentation about IS_LAYOUT structure.

Text

List layout specifications

Description

Output list description structure.

The parameters are described under the following headers:

Display options

Exceptions

Totals

Interaction

Detail screen

Display variants (only for hierarchical-sequential lists)

Color

Other

Note the section 'Default'.

Display options

colwidth_optimize

value set: SPACE, 'X'

'X' = optimzes the column width so that all contents are displayed completely.

no_colhead

value set: SPACE, 'X'

'X' = column headers are not output

zebra

value set: SPACE, 'X'

'X' = striped pattern (e.g. for wide lists)

no_vline

value set: SPACE, 'X'

not relevant for: hierarchical-sequential lists and

multiple-line lists.

'X' = columns separated by SPACE

no_min_linesize

value set: SPACE, 'X'

not relevant for block lists

'X' = line size depends on list width

' ' = line size is set to 80 or MIN_LINESIZE (if > 0) .

min_linesize

value set: 0, 10 - 250

minimum width of the list (to change default of 80)

If the list is wider, the format uses the list width (maximum 250 or MAX_LINESIZE (if > 0)).

prerequisite: no_min_linesize = ' '.

max_linesize

value set: 0, 80 - 1020

maximum list width (to change the default of 250)

interactively-definable maximum list width setting.

Caution: wide lists are difficult to read and to print.

Thanks,

Ramakrishna

Re: List problem when run in background

Former Member — Wed, 15 Mar 2006 09:20:51 GMT

Hi Dilip,

specifying line-size in REPORT shud not be a problem...

whether or not you specify .. you'll get the fields

if the problem occurs only in running it in background..

does it execute well directly..

regards

satesh

Re: List problem when run in background

Former Member — Mon, 15 Jun 2009 02:49:22 GMT

Hi,

I know my reply is very very late. I encountered the same problem and managed to resolve it by using the following method.

Go to transaction: SPAD

Go to the menu "Settings" -> "Spool System"

Go to "Other" tab.

Enable the option "SP01: Number of Columns for List Display from Format".

Re: List problem when run in background

Former Member — Mon, 15 Jun 2009 05:16:26 GMT

(Go to SP01.Give selection on screen and press execute,)

(go to SM37, execute for given date selection, select the request and press the 'SPOOL' button)

After the Spool list is displayed, double click on the the given request.

And change the format to the required one using F4 help. For e.g. X_65_255 here 65 is Rows and 255 is columns, so try the one using more columns.

Re: List problem when run in background

praveen_hannu — Mon, 15 Jun 2009 07:26:20 GMT

Change the settings of your spool display, by default it would be 10 pages only, you can change it according to your requirment.