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
Showing results for 
Search instead for 
Did you mean: 

How to Create a report for a particular vendor to get the purchase order...

Former Member
0 Kudos
109

How to Create a report for a particular vendor to get the purchase order details and Goods received for specific purchase order and balance quantity....plz give me detail descriptionto do this....

i.e steps to accomplish it...plz ...

3 REPLIES 3

Former Member
0 Kudos
45

Look in the tables EKKO and EKPO, you will find your data there. You can then go to the screens where the data is displayed, use the F1 Function key to get your technical information for the table and field names.

Former Member
0 Kudos
45

Hi Raja,

first declare a parameter for purchase order no of type dictionary field type....

the go for a select query and select the desirred records by mentioning a where clause where <purchase order number > eq p_parm1(parameter you declared)

If the required entries for you is from two tables the go for FOR ALL ENTRIES addition of select Query..

Hope this would help you.

Regards

Narin Nandivada.

Former Member
0 Kudos
45

Hi,

You want to retreive purshase order details for a particular vendor. So assuming that you will enter a vendor (mandatory parameter) - follow the below procedure

1) Based on the vendor given go to EKKO table. Write a select query to get purchase orders (EKKO-EBELN) based on given vendor (EKKO-LIFNR). Document type would be 'F' for purchase orders.

2) For the purchase order numbers that you have got in the above step go to EKPO table for item details. (Map EKKO-EBELN with EKPO-EBELN).

3) To get the goods received and quantity details go to purchase order history table. Map EKPO-EBELN and EKPO-EBELP with EKBE-EBELN and EKBE-EBELP. You will get the GR and quantity details from EKBE.

Thanks.