HowdoIgetfromPOtochecknumber,orchecknumTheuserswouldliketoenteraPOnumberandhavethechecknumber(s)returned,andviceversa.They'dlikeareportsotheydon'thavetodrilldownindividually.I'vebeentoldthatthepathisPayr

Question

How do I get from PO to check number, or check num
The users would like to enter a PO number and have the check number(s) returned, and vice versa. They'd like a report so they don't have to drill down individually.I've been told that the path is Payr -> bsak -> bkpf -> ekbe, but I can't find the link between bkpf and ekbe. It's supposed to be bkpf-awkey to ekbe-belnr.payr-vblnr -> bsak-belnr -> bkpf-belnr, then bkpf-awkey -> ekbe-belnr to get ekbe-eblen.Why would I need bsak if you could use payr-vblnr to match bkpf-belnr?Thanks for your help and your time!

Answer 1

Hi there,it seems for me,that u can make the following relations between tables...payr bkpf ekbe----- ------ ------zbukr - bukrs gjahr - gjahrvblnr - belnr awtyp awkey - belnr & gjahrif u are developing your report in ABAP,then no problem so far...the field bkpf-awkey contains the fields ekbe-belnr and ekbe-gjahr together,but still can be used to get the PO number.I hope this help solve your query.regards 查看原帖>>