List problem when run in background

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

.

[Former Member]

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

[Former Member]

Hi Diliip,

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

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

John.

[Former Member]

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

[venkata_ramisetti]

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

<b>no_min_linesize</b>

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) .

<b>min_linesize</b>

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 = ' '.

<b>max_linesize</b>

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

[Former Member]

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

[Former Member]

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".

[Former Member]

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

OR

(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.

[praveen_hannu]

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