Skip to Content
0
Former Member
Apr 06, 2010 at 06:34 AM

ALV fields coem dynamicaly in header

28 Views

Hi all,

I desperately need your help in making ALV report.

TYPE-POOLS: SLIS.

DATA: ls_fcat TYPE slis_fieldcat_alv,

ls_layout TYPE SLIS_LAYOUT_ALV,

gt_fcat TYPE slis_t_fieldcat_alv.

data : gt_fieldcat type slis_t_fieldcat_alv, "catalog for alv

gt_heading type slis_t_listheader, "list for header1

gt_sort type slis_t_sortinfo_alv, "Sorting of the

gt_event type slis_t_event,

gt_selfield type slis_selfield,

gv_alv_event type slis_alv_event,

gv_repname type sy-repid,

gs_layout type slis_layout_alv,

gv_save type c.

constants gc_forname_top_of_page type slis_formname value

'TOP-OF-PAGE'.

REFRESH gt_fcat.

TABLES: vbrk.

data: begin of it_vbrk occurs 10,

vbeln type vbeln,

end of it_vbrk.

data: begin of it_vbrp occurs 10,

vbeln type vbeln,

ntgew type vbrp-ntgew,

matnr type vbrp-matnr,

end of it_vbrp.

data: begin of it_final occurs 10,

vbeln type vbeln,

ntgew type vbrp-ntgew,

matnr type vbrp-matnr,

end of it_final.

SELECT-OPTIONS: PERIOD for VBRK-FKDAT no-extension.

SELECT VBELN

FROM VBRK INTO CORRESPONDING FIELDS OF TABLE IT_VBRK

WHERE FKDAT IN PERIOD.

SELECT VBELN

NTGEW "Net weight

MATNR

FROM VBRP INTO CORRESPONDING FIELDS OF TABLE IT_VBRP

FOR ALL ENTRIES IN IT_vbrk

WHERE VBELN = IT_vbrk-VBELN.

loop at it_vbrp.

move it_vbrp-vbeln to it_final-vbeln .

move it_vbrp-matnr to it_final-matnr .

move it_vbrp-ntgew to it_final-ntgew .

append it_final.

endloop.

ls_fcat-col_pos = 1.

ls_fcat-fieldname = 'VBELN'.

ls_fcat-seltext_l = 'VBELN'.

ls_fcat-outputlen = 10 .

APPEND ls_fcat TO gt_fcat.

DATA: G_REPID TYPE SY-REPID.

g_repid = sy-repid.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = g_repid

I_CALLBACK_PF_STATUS_SET = 'PF_STATUS'

i_callback_top_of_page = 'TOP_OF_PAGE'

IS_LAYOUT = ls_LAYOUT

it_fieldcat = gt_fcat

I_SAVE = 'X'

TABLES

t_outtab = IT_FINAL.

My problem is that i want material number in col_pos 2, 3,4... and so on..

and corresponding weight of that material number comes under that matnr.

Waiting for ur reply.

Thanx a ton,

Puneet