Skip to Content
0
Former Member
Sep 01, 2007 at 08:47 AM

report -very urgent

19 Views

Hi gurus,

Can any one check the code .Iam not getting the output correctly .some garbage values it is taking .Kindly check and reply me it is very urgent for me.

REPORT Z_MARPOSS.

TABLES : EKPO ,

EKET.

DATA : BEGIN OF ITAB OCCURS 2,

EBELN LIKE EKET-EBELN,

END OF ITAB .

DATA : BEGIN OF ITAB1 OCCURS 2,

MATNR LIKE EKPO-MATNR,

TXZ01 LIKE EKPO-TXZ01,

MENGE LIKE EKET-MENGE,

WEMNG LIKE EKET-WEMNG,

MOBMNG LIKE EKET-MENGE,

END OF ITAB1.

SELECT-OPTIONS MEINDT FOR EKET-EINDT.

SELECT EBELN INTO TABLE ITAB FROM EKET WHERE EINDT IN MEINDT.

LOOP AT ITAB.

clear itab1-matnr.

clear itab1-txz01.

SELECT MATNR TXZ01 INTO CORRESPONDING FIELDS OF ITAB1 FROM EKPO WHERE EBELN = ITAB-EBELN.

APPEND ITAB1.

ENDSELECT.

ENDLOOP.

LOOP AT ITAB.

CLEAR ITAB1-MENGE .

CLEAR ITAB1-WEMNG .

SELECT MENGE WEMNG INTO CORRESPONDING FIELDS OF ITAB1 FROM EKET WHERE EBELN = ITAB-EBELN.

APPEND ITAB1.

ENDSELECT.

ENDLOOP.

top-of-page .

write : 50 'REPORT FOR STOCK OF PURCHASING MATERIALS' .

uline .

write : /2 'MATERIAL.' , 13 sy-vline , 14 'DESCRIPTION', 60 sy-vline , 61 'TOTAL QUANTITY' , 78 SY-VLINE , 79 'DEL QTY' , 95 SY-VLINE , 96 'REM QTY'.

uline .

END-OF-SELECTION.

LOOP AT ITAB1.

ITAB1-MOBMNG = ITAB1-MENGE - ITAB1-WEMNG.

MODIFY ITAB1. "Update the Record

WRITE : / ITAB1-MATNR UNDER 'MATERIAL' ,

ITAB1-TXZ01 UNDER 'DESCRIPTION' ,

ITAB1-MENGE UNDER 'TOTAL QUANTITY' ,

ITAB1-WEMNG UNDER 'DEL QTY' ,

ITAB1-MOBMNG UNDER 'REM QTY'.

ENDLOOP.

thx & Regards,

sunder