hi,
i had made dis report for displaying changes made to a purticular material in a purticular month.
d poblem is dis when i check a materail in MM04 which use to display a change made to a single material and when i check further that what changes had made it shows 4 changes but when i check my report it shows only 2 changes had been made.
plzz help me out as help will be definately rewarded.
last time i asked in dis forum not much help was provided.
here is d code:-
REPORT ZNEW01 no standard page heading LINE-SIZE 310.
TABLES: CDHDR,CDPOS.
DATA: BEGIN OF ITAB OCCURS 0,
OBJECTCLAS LIKE CDHDR-OBJECTCLAS,
OBJECTID LIKE CDHDR-OBJECTID,
USERNAME LIKE CDHDR-USERNAME,
UDATE LIKE CDHDR-UDATE,
UTIME LIKE CDHDR-UTIME,
TCODE LIKE CDHDR-TCODE,
CHANGE_IND LIKE CDHDR-CHANGE_IND,
END OF ITAB.
DATA: BEGIN OF ITAB1 OCCURS 0,
OBJECTCLAS LIKE CDPOS-OBJECTCLAS,
OBJECTID LIKE CDPOS-OBJECTID,
FNAME LIKE CDPOS-FNAME,
CHNGIND LIKE CDPOS-CHNGIND,
VALUE_OLD LIKE CDPOS-VALUE_OLD,
VALUE_NEW LIKE CDPOS-VALUE_NEW,
END OF ITAB1.
SELECT-OPTIONS: M_DATE FOR CDHDR-UDATE,
U_ID FOR CDHDR-CHANGE_IND.
SELECT BOBJECTCLAS BOBJECTID BUSERNAME BUDATE BUTIME BTCODE B~CHANGE_IND INTO
TABLE ITAB
FROM CDHDR AS B WHERE B~OBJECTCLAS = 'MATERIAL' AND UDATE IN M_DATE AND CHANGE_IND IN U_ID.
Check not itab[] is initial.
SELECT OBJECTCLAS OBJECTID FNAME CHNGIND VALUE_OLD VALUE_NEW INTO TABLE
ITAB1 FROM CDPOS
FOR ALL ENTRIES IN ITAB WHERE OBJECTID = itab-objectid and objectclas = ITAB-OBJECTCLAS .
*SELECT OBJECTCLAS OBJECTID FNAME CHNGIND VALUE_OLD VALUE_NEW INTO TABLE
*ITAB1 FROM CDPOS
*WHERE OBJECTID = itab-objectid and objectclas = ITAB-OBJECTCLAS .
*
ULINE.
LOOP AT ITAB.
WRITE:/ ITAB-OBJECTID,22 ITAB-USERNAME,ITAB-UDATE,ITAB-UTIME,ITAB-TCODE.
LOOP AT ITAB1 WHERE OBJECTCLAS = ITAB-OBJECTCLAS AND OBJECTID = ITAB-OBJECTID.
WRITE: 60 ITAB1-FNAME,ITAB1-CHNGIND,ITAB1-VALUE_OLD(40),ITAB1-VALUE_NEW(40).
ENDLOOP.
ENDLOOP.
Bluesky
