‎2008 Feb 02 7:14 AM
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.
‎2008 Feb 02 7:22 AM
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.