Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reg: I want to display 10 PO Numbers with items

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

Tags:
Not what you were looking for? View more on this topic or Ask a question