topic Re: SQ01 Purchasing Report in Application Development and Automation Discussions

SQ01 Purchasing Report

Former Member — Mon, 26 Jul 2010 13:57:44 GMT

Hi Experts

This is an excellent forum and has helped me immensely.

Although i am stuck with SQ01.

What im trying to achieve is a report which tells me

date PO raised

By Whom

Vendor Name

Vendor No.

District

Postcode

ABC Indicator

PO Line value

Cost centre

Order number

WBS Element

G/L Code

Material Group no.

Material Group name

Short text

Goods Receipt No.

Date goods receipted

Invoice No.

Date Invoice paid

Invoice Amount Paid

Am i asking too much for this from one report? if so do any of you kind folk know of an alternative report which shows me PO's raised with cost allocation? ME80FN is almost there but it has no cost centre etc.

Many thanks

Andrew

Re: SQ01 Purchasing Report

andreas_mann3 — Mon, 26 Jul 2010 14:11:32 GMT

try tcode ME2K

or use an infoset with logical database EKM

or write your own abap-program (I have created such a program years ago :.)

- it has an abap list with all yor required fields except ABC-indicator)

grx

Andreas

Edited by: Andreas Mann on Jul 26, 2010 4:12 PM

Re: SQ01 Purchasing Report

Former Member — Mon, 26 Jul 2010 14:16:11 GMT

Welcome to SDN.

You can achieve all of this by creating the infoset in SQ01. No, you are not expecting too much from a query.

The tables you will have to use are EKKO, EKPO and EKKN.

Go and experiment with SQ01. If you need basic help on creating an infoset --> google with keywords 'sap query tutorial'.

Come back when you have a specific question.

Re: SQ01 Purchasing Report

Former Member — Mon, 26 Jul 2010 15:35:40 GMT

Hi Both

Thanks for the time you have both taken to get back to me.

I have built the table join using EKKO, EKPO, EKKN, LFM1, LFA1 which pulls through most of what i need.

The issue im having now is that for an example a PO is spread over a number of line with different cost centres allocated to the seperate lines, Where the individual lines should show how much each line costs, each line is showing the overall value of the PO.

Pyeski

Re: SQ01 Purchasing Report

Former Member — Tue, 27 Jul 2010 07:26:57 GMT

Perhaps you have the wrong field on display? The value you seek can be found in EKPO-NETPR.

Re: SQ01 Purchasing Report

Former Member — Tue, 27 Jul 2010 08:00:13 GMT

Thanks for the suggestion. I tried that and the two lines of the PO are still showing the total.

I.e the PO is valued at £100 with each of the two lines of the PO being £50 each.

On the report, it shows each line being £100 therefore not reflecting the cost distribution.

Pyeski

Re: SQ01 Purchasing Report

Former Member — Tue, 27 Jul 2010 08:15:41 GMT

I have found what the issue was.

It was one of the joins between EKKO EKPO i deleted the EBELP join and this has worked.

Thanks for all your help on this. I really appreciate it.

I now know where to come for the font of all knowlege!

Pyeski