Solved: ALV Report background sceduling issue with column

Former Member · ‎2010 Oct 07

Hi,

I am facing below issue for my report,kindly suggest.

1. Its alv grid display report and having 30 columns.

2. When I run this report its runs perfectly but when I schedule it for background job in sm 37 spool generated

is showing all columns.Few columns are over lapped and not showing. Kindly suggest some solution.

Regards,

Shekhar

Former Member · ‎2010 Oct 11

Fill the LT_EVENTS table of this funtion module with the event type and a form name.

name = 'TOP_OF_PAGE'.

form = 'FORM_TOP'.

You then need to create a form in your program using the above name FORM_TOP.

and write you code in this form which needs to be displayed .

Former Member · ‎2010 Oct 07

Hi chandra shekhar dubey,

That will happen when there is a problem in the fieldcatalog. Check your fieldcatalog. You should give FLDCAT-TABNAME as your internal table name.

Thanks & Regards,

Rock.

Former Member · ‎2010 Oct 07

Hi Rock,

Can u elaborate ur point.

I am sending u below code for reference.

REPORT zsd_foc_track NO STANDARD PAGE HEADING

LINE-COUNT 90

LINE-SIZE 1000.

&----

*& Report ZSD_FOC_TRACK *

*& *

&----

Description : FOC tracking report *

&----

TYPE-POOLS : slis.

TABLES : vbak,vbap,likp,lips,eban,ekpo,tvm2t.

DATA : fieldcatalog TYPE slis_t_fieldcat_alv WITH HEADER LINE,

gd_tab_group TYPE slis_t_sp_group_alv,

gd_layout TYPE slis_layout_alv,

gd_repid LIKE sy-repid,

gt_events TYPE slis_t_event,

gd_prntparams TYPE slis_print_alv,

gv_save,

status(40) TYPE c.

DATA : BEGIN OF gt_vbak OCCURS 0,

vbeln LIKE vbak-vbeln,

auart LIKE vbak-auart,

audat LIKE vbak-audat,

bstnk LIKE vbak-bstnk,

bstdk LIKE vbak-bstdk,

ernam LIKE vbak-ernam,

kunnr LIKE vbak-kunnr,

augru LIKE vbak-augru,

END OF gt_vbak.

DATA : BEGIN OF gt_vbap OCCURS 0,

vbeln LIKE vbap-vbeln,

posnr LIKE vbap-posnr,

arktx LIKE vbap-arktx,

matnr LIKE vbap-matnr,

vrkme LIKE vbap-vrkme,

werks LIKE vbap-werks,

kwmeng LIKE vbap-kwmeng,

pstyv LIKE vbap-pstyv,

vkaus LIKE vbap-vkaus,

mvgr2 LIKE vbap-mvgr2,

END OF gt_vbap.

DATA : BEGIN OF itab OCCURS 0,

vbeln LIKE vbak-vbeln,

auart LIKE vbak-auart,

audat LIKE vbak-audat,

bstnk LIKE vbak-bstnk,

bstdk LIKE vbak-bstdk,

ernam LIKE vbak-ernam,

kunnr LIKE vbak-kunnr,

augru LIKE vbak-augru,

posnr LIKE vbap-posnr,

arktx LIKE vbap-arktx,

matnr LIKE vbap-matnr,

vrkme LIKE vbap-vrkme,

werks LIKE vbap-werks,

kwmeng LIKE vbap-kwmeng,

pstyv LIKE vbap-pstyv,

vkaus LIKE vbap-vkaus,

mvgr2 LIKE vbap-mvgr2,

END OF itab.

DATA : BEGIN OF gt_tvm2t OCCURS 0,

spras TYPE spras,

mvgr2 TYPE mvgr2,

bezei TYPE bezei,

END OF gt_tvm2t.

DATA : BEGIN OF gt_vbpa OCCURS 0,

vbeln TYPE vbpa-vbeln,

parvw TYPE vbpa-parvw,

adrnr TYPE vbpa-adrnr,

kunnr TYPE vbpa-kunnr,

END OF gt_vbpa.

DATA : BEGIN OF gt_adrc OCCURS 0,

addrnumber TYPE adrc-addrnumber,

name1 TYPE adrc-name1,

END OF gt_adrc.

DATA : BEGIN OF gt_kna1 OCCURS 0,

kunnr LIKE kna1-kunnr,

name1 LIKE kna1-name1,

END OF gt_kna1.

DATA : BEGIN OF gt_tvaut OCCURS 0,

augru LIKE tvaut-augru,

bezei LIKE tvaut-bezei,

spras LIKE tvaut-spras,

END OF gt_tvaut.

DATA : BEGIN OF gt_tvlvt OCCURS 0,

abrvw LIKE tvlvt-abrvw,

bezei LIKE tvlvt-bezei,

spras LIKE tvlvt-spras,

END OF gt_tvlvt.

DATA : BEGIN OF gt_eban OCCURS 0,

banfn LIKE eban-banfn,

bnfpo LIKE eban-bnfpo,

matnr LIKE eban-matnr,

bednr LIKE eban-bednr,

badat LIKE eban-badat,

frgdt LIKE eban-frgdt,

END OF gt_eban.

DATA : BEGIN OF gt_ekpo OCCURS 0,

ebeln LIKE ekpo-ebeln,

ebelp LIKE ekpo-ebelp,

banfn LIKE ekpo-banfn,

bnfpo LIKE ekpo-bnfpo,

END OF gt_ekpo.

DATA : BEGIN OF gt_ekko OCCURS 0,

ebeln LIKE ekko-ebeln,

bedat LIKE ekko-bedat,

END OF gt_ekko.

DATA : BEGIN OF gt_ekbe OCCURS 0,

ebeln LIKE ekbe-ebeln,

ebelp LIKE ekbe-ebelp,

belnr LIKE ekbe-belnr,

budat LIKE ekbe-budat,

END OF gt_ekbe.

DATA : BEGIN OF gt_lips OCCURS 0,

vbeln LIKE lips-vbeln,

posnr LIKE lips-posnr,

lfimg LIKE lips-lfimg,

vgbel LIKE lips-vgbel,

vgpos LIKE lips-vgpos,

END OF gt_lips.

DATA : BEGIN OF gt_likp OCCURS 0,

vbeln LIKE likp-vbeln,

bldat LIKE likp-bldat,

END OF gt_likp.

DATA : net_qty(15) TYPE p DECIMALS 3.

DATA : BEGIN OF gt_output OCCURS 0,

vbeln like vbak-vbeln,

vbeln(10) TYPE c,

posnr LIKE vbap-posnr,

arktx LIKE vbap-arktx,

auart LIKE vbak-auart,

audat LIKE vbak-audat,

bstnk LIKE vbak-bstnk,

ernam LIKE vbak-ernam,

name1 LIKE kna1-name1,

name2 LIKE adrc-name1,

bezei2 LIKE tvm2t-bezei,

adrnr LIKE vbpa-adrnr,

matnr LIKE vbap-matnr,

vrkme LIKE vbap-vrkme,

werks LIKE vbap-werks,

kwmeng LIKE vbap-kwmeng,

lfimg LIKE lips-lfimg,

net_qty LIKE lips-lfimg,

pstyv LIKE vbap-pstyv,

bezei1 LIKE tvaut-bezei,

bezei LIKE tvlvt-bezei,

banfn like eban-banfn,

banfn(10) TYPE c,

badat LIKE eban-badat,

bnfpo LIKE eban-bnfpo,

frgdt LIKE eban-frgdt,

relprst TYPE fkztx,

ebeln like ekpo-ebeln,

ebeln(10) TYPE c,

bedat LIKE ekko-bedat,

relpodt TYPE cddatum,

relpote TYPE cduzeit,

relpost TYPE fkztx,

ebelp LIKE ekpo-ebelp,

belnr LIKE ekbe-belnr,

budat LIKE ekbe-budat,

vbeln1 like lips-vbeln,

vbeln1(10) TYPE c,

bldat LIKE likp-bldat,

kunnr1 LIKE kna1-kunnr,

kunnr2 LIKE kna1-kunnr,

name111(60) TYPE c,

name222(60) TYPE c,

mvgr2 LIKE vbap-mvgr2,

status(40) TYPE c,

END OF gt_output.

SELECTION-SCREEN : BEGIN OF BLOCK blk1 WITH FRAME.

SELECT-OPTIONS : s_vbeln FOR vbak-vbeln,

s_audat FOR vbak-audat ,

s_ernam FOR vbak-ernam,

s_auart FOR vbak-auart,

s_augru FOR vbak-augru,

s_kunnr FOR vbak-kunnr,

s_pstyv FOR vbap-pstyv,

s_werks for vbap-werks obligatory,

s_matnr FOR vbap-matnr,

s_vkaus FOR vbap-vkaus.

PARAMETERS : s_werks TYPE vbap-werks OBLIGATORY.

SELECTION-SCREEN SKIP.

PARAMETERS: pr1 RADIOBUTTON GROUP r1,

pr2 RADIOBUTTON GROUP r1.

SELECTION-SCREEN : END OF BLOCK blk1.

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

*********************************************************test********

DATA : wa_color TYPE lvc_s_scol.

DATA : it_color TYPE TABLE OF lvc_s_scol.

itab for input enabling.

DATA: lt_celltab TYPE lvc_t_styl. "

***********************************************************endtest***

START-OF-SELECTION.

PERFORM get_data.

PERFORM build_fieldcatalog.

PERFORM build_layout.

PERFORM build_events.

PERFORM build_print_params.

PERFORM display_alv_report.

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

*&----

**& Form BUILD_FIELDCATALOG

*&----

*

* Build Fieldcatalog for ALV Report

*

*----

FORM build_fieldcatalog.

DEFINE m_fieldcat.

add 1 to ls_fieldcat-col_pos.

ls_fieldcat-fieldname = &1.

ls_fieldcat-ref_tabname = &2.

append ls_fieldcat to lt_fieldcat.

END-OF-DEFINITION.

fieldcatalog-fieldname = 'VBELN'.

fieldcatalog-seltext_m = 'SO No'.

fieldcatalog-col_pos = 0.

* fieldcatalog-outputlen = 10.

fieldcatalog-hotspot = 'X'.

fieldcatalog-key = 'X'.