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