‎2007 May 16 4:37 PM
Code to create Report to display a list of Purchase Requisitions with details like MRP Controller, Release Date.
‎2007 May 17 4:28 AM
Hi Lalith,
Just copy paste this program and execute it.
REPORT zeassdn_05 .
TABLES : eban.
TYPES : BEGIN OF fieldst,
banfn LIKE eban-banfn, "Purchase Requisition number
dispo LIKE eban-dispo, "MRP Controller.
frgdt LIKE eban-frgdt, "Release Date.
END OF fieldst.
DATA itab TYPE TABLE OF fieldst WITH HEADER LINE.
START-OF-SELECTION.
SELECT banfn dispo frgdt FROM eban
INTO CORRESPONDING FIELDS OF TABLE itab.
LOOP AT itab.
WRITE :/02 itab-banfn, 24 itab-dispo, 35 itab-frgdt.
ENDLOOP.
TOP-OF-PAGE.
WRITE :/01 'PUR REQ NUM', 17 'MRP CONTROLLER', 34 'RELEASE DATE'.
END-OF-PAGE.
<b>Reward if it useful.</b>
‎2007 May 17 3:40 AM
hi lalitha,
u can get the purchse requestion details by using the EBAN table in that table
u can see the MRP controller and release data fields etc
reward points if useful,
regards,
srinivas.
‎2007 May 17 4:28 AM
Hi Lalith,
Just copy paste this program and execute it.
REPORT zeassdn_05 .
TABLES : eban.
TYPES : BEGIN OF fieldst,
banfn LIKE eban-banfn, "Purchase Requisition number
dispo LIKE eban-dispo, "MRP Controller.
frgdt LIKE eban-frgdt, "Release Date.
END OF fieldst.
DATA itab TYPE TABLE OF fieldst WITH HEADER LINE.
START-OF-SELECTION.
SELECT banfn dispo frgdt FROM eban
INTO CORRESPONDING FIELDS OF TABLE itab.
LOOP AT itab.
WRITE :/02 itab-banfn, 24 itab-dispo, 35 itab-frgdt.
ENDLOOP.
TOP-OF-PAGE.
WRITE :/01 'PUR REQ NUM', 17 'MRP CONTROLLER', 34 'RELEASE DATE'.
END-OF-PAGE.
<b>Reward if it useful.</b>