Hi All,
I want to display 10 PO Numbers with items.
.......code
SELECT aebeln aaedat absart alifnr awaers aknumv
bebelp bmatnr btxz01 bmatkl bwerks bmenge bnetpr beffwr
b~mwskz INTO TABLE it_ekko UP TO 10 ROWS
FROM ekko AS a INNER JOIN ekpo AS b ON aebeln = bebeln
WHERE b~matnr = p_matnr and
b~werks = p_werks
ORDER BY a~aedat DESCENDING .
By writing this code i am getting only 10 records
for exmple....
one PO has 4 items,other PO has 6 items
its getting 10 records of 2 PO's with items
But i want 10 PO number and items.
thanks
mars