topic collect problem in Application Development and Automation Discussions

collect problem

Former Member — Sat, 02 Feb 2008 07:14:38 GMT

Dear friends,

in my porogram it is not collecting poperly,

here iam snding the code, pls givethe answer my problem

TABLES : mard.

SELECT-OPTIONS : s_matnr FOR mard-matnr,

s_werks FOR mard-werks.

DATA : BEGIN OF itab OCCURS 0,

matnr LIKE mard-matnr,

werks LIKE mard-werks,

labst LIKE mard-labst,

umlme LIKE mard-umlme,

insme LIKE mard-insme,

END OF itab.

SELECT matnr

werks

labst

umlme

insme

FROM mard INTO TABLE itab

WHERE matnr IN s_matnr AND werks IN s_werks.

ULINE.

FORMAT COLOR COL_HEADING.

WRITE:/ sy-vline ,'MATERIAL NUMBER ', sy-vline, 'PLANT', sy-vline,'UNRESTRICTED QTY', sy-vline,'QUNTITY IN TRANSIT', sy-vline,' QUALITY INSPECTION', sy-vline..

ULINE.

FORMAT COLOR COL_HEADING OFF.

LOOP AT itab.

cOLLECT itab.

ENDLOOP.

LOOP AT itab.

SKIP 2.

WRITE: / sy-vline, itab-matnr,

sy-vline, itab-werks,

sy-vline, itab-labst,

sy-vline, itab-umlme,

sy-vline, itab-insme, sy-vline.

SKIP 2.

ENDLOOP.

TOP-OF-PAGE.

FORMAT COLOR 5 INTENSIFIED OFF .

WRITE:/ 'MATERIAL DETAILS WITH STOCKS'.

FORMAT COLOR 5 INTENSIFIED OFF.

Re: collect problem

Former Member — Sat, 02 Feb 2008 07:22:58 GMT

TABLES : mard.

DATA : BEGIN OF itab OCCURS 0,

matnr LIKE mard-matnr,

werks LIKE mard-werks,

labst LIKE mard-labst,

umlme LIKE mard-umlme,

insme LIKE mard-insme,

END OF itab.

SELECT-OPTIONS : s_matnr FOR mard-matnr,

s_werks FOR mard-werks.

start-of-selection.

LOOP AT itab.

SELECT matnr

werks

labst

umlme

insme

FROM mard INTO TABLE itab

WHERE matnr IN s_matnr AND werks IN s_werks.

cOLLECT itab.

ENDLOOP.

ULINE.

end-of-selection.

FORMAT COLOR COL_HEADING.

WRITE:/ sy-vline ,'MATERIAL NUMBER ', sy-vline, 'PLANT', sy-vline,'UNRESTRICTED QTY', sy-vline,'QUNTITY IN TRANSIT', sy-vline,' QUALITY INSPECTION', sy-vline..

ULINE.

FORMAT COLOR COL_HEADING OFF.

LOOP AT itab.

SKIP 2.

WRITE: / sy-vline, itab-matnr,

sy-vline, itab-werks,

sy-vline, itab-labst,

sy-vline, itab-umlme,

sy-vline, itab-insme, sy-vline.

SKIP 2.

ENDLOOP.

TOP-OF-PAGE.

FORMAT COLOR 5 INTENSIFIED OFF .

WRITE:/ 'MATERIAL DETAILS WITH STOCKS'.

FORMAT COLOR 5 INTENSIFIED OFF.