SQ01 Purchasing Report

[Former Member]

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

[Former Member]

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.

[andreas_mann3]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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