Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

month wise purchase orders

Former Member
0 Likes
1,202

hi experts,

im working on a report, which displays the output as month wise purchase order details ( no.of po's in a month) ...ie, like

Aprial 20(po's) 2,00,000.00(AMT)

may 40 50,000.00

june 12 5,000.00

like that .....

but , here i have a problem with the code , ive selected all the pos from ekpo,

how to get the single ebeln ( if there a po no . it has ebelp of 20 that means it consist of 2 item data so how to merge these two into the single ebeln and shows only header data). can anybody give me an idea OR logic in the code to merge them.

points may be reqarded.....

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
894

Hi

Create a new_itab with two fields

EBELN and AMT

Loop at old_itab.

new_itab-ebeln = old_itab-ebeln.

new_itab-amt = old_itab-amt.

collect new_itab

endloop.

Regards

Madhan

hi experts,

im working on a report, which displays the output as month wise purchase order details ( no.of po's in a month) ...ie, like

Aprial 20(po's) 2,00,000.00(AMT)

may 40 50,000.00

june 12 5,000.00

like that .....

but , here i have a problem with the code , ive selected all the pos from ekpo,

how to get the single ebeln ( if there a po no . it has ebelp of 20 that means it consist of 2 item data so how to merge these two into the single ebeln and shows only header data). can anybody give me an idea OR logic in the code to merge them.

points may be reqarded.....

1 REPLY 1
Read only

Former Member
0 Likes
895

Hi

Create a new_itab with two fields

EBELN and AMT

Loop at old_itab.

new_itab-ebeln = old_itab-ebeln.

new_itab-amt = old_itab-amt.

collect new_itab

endloop.

Regards

Madhan