Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Purchase Requisition report

Former Member

‎2007 Jul 21 6:12 AM

0 Kudos
102

HI Experts,

I am making Purschase Requisition (PR) report. User enters PR no. (EBAN-BANFN) and in output i want to show Details of PR, Sales transfer order (STO) datails by PR refrenes and Delivery details by STO refreance. I get PR details and STO details in EBAN table. But I am unable to get Delivery details with refrence to STO. Is there any table where I find this and have link with EBAN. Its urgent. Thanks alot.

Khan

3 REPLIES 3

Former Member

‎2007 Jul 21 7:21 AM

0 Kudos
52

Hi

use the EBAN table for the PR details

using the STO number check the Table EKPO for the Delivery number(reference document) and then with that delivery goto LIKP and LIPS and fetch the data and use

If you won't get from EKPO pass that STO number to EKKN table and take the VBELn and POSNR fields which are sales order No and item no and pass these fields to LIPS-VGBEL and LIPS-VGPOS fields and take the data from LIPS

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member
In response to Former Member

‎2007 Jul 21 7:42 AM

0 Kudos
52

HI Anji,

I didnt find the delivery No. ( Refrence doc.) in EKPO table and in EKKN there is no row corespond to STO no. Plz help. me...where else I find.

Thanks.

Khan

former_member235056
Active Contributor

‎2007 Jul 21 8:18 AM

0 Kudos
52

Hi,

Have a link at this link it is sure shot solution to ur problem:

<a href="http://mitvma.mit.edu/sapweb/detail.html">http://mitvma.mit.edu/sapweb/detail.html</a>

Pls reward points.

Regards,

Ameet