2008 Jul 27 4:11 PM
Hi all,
I want to fetch the purchase order from EKKO table on PO typewise.
For example, If I want to fetch only third - party PO (which is item category BANC / BANS).
how can I achieve that ?
thnks in advance,
raghul
Hi all,
I want to fetch the purchase order from EKKO table on PO typewise.
For example, If I want to fetch only third - party PO (which is item category BANC / BANS).
how can I achieve that ?
thnks in advance,
raghul
2008 Jul 27 4:23 PM
you can use EKPO-PSTYP in where conditon.
and JOIN EKKO and EKPO
REPORT ZTEST_PO.
data: begin of it_po occurs 0,
eblen type ebeln,
end of it_po.
select ekko~ebeln
from ekko
join ekpo
on ekko~ebeln = ekpo~ebeln
into table it_po
where ekpo~pstyp = 5.
break-point.
2008 Jul 30 2:52 AM
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |